SAP Data in .NET C# through SAP Connector

I'm using for this course: Visual Studio (C#), SAP 7.40, SAP Connector 3.x

Create connection data. Check in parallel with your SAP connection and add values for each parameter.

Create the connection and test it. Attach your will have the code written so far.

Testing the function CS_BOM_EXPL_MAT_V2_RFC in SAP, to get BOM of material (multi-level). Next step, use this inside C# application.

Create your own function module. Set the import parameters and the export ones. Test it inside SAP, then move forward to C#.

Having the BOM of the material, directly from the material, is not always the best approach. Sometimes you have to get it from the production order! Find out the function used!

Every movement in SAP generates a material document. You see this list in <mb51> and you will be able, after finishing this lesson, to have this list in C#. Learn about the tables involved in this transaction and what fields are important here.

Play with the list. Learn how to make group on this, add sum on the entry quantities, display data into a grid. Step by step everything.

Get the confirmations made on production orders, by using the dedicated RFC function from SAP, directly from AFRU table. But.... surprise!

Try to use existing structure for date, to have inside your function module. The same usage like in the bapi for good movements. Works in SAP, but not in C#! Solution inside

Use co11n to do the confirmation. Try the same with the BAPI from the system and see what is missing.

You will learn in this lesson how to combine your BAPI call with the commit transaction, in order to have the result in SAP.

Move goods within the plant? Let's do it in SAP first, we the dedicated transactions, check movements and stock, before and after. Then, we use a BAPI to have it done. Next step, C Sharp project!

Create the application which has on the screen:

-plant

-material to be transferred

-storage location source

-storage location destination

-quantity

Check after the user enters the material and the plant, what are the information in table MARD.

You will read all the lines from here, into a variable of type class, that has:

-material

-plant

-storage location

-unrestricted stock

First, the material should exists in the storage location entered. Then, you should have enough quantity for the transfer to be possible. Third, but not the last, the destination storage location should be possible for the material. You have the information already in tour variable of type class (let's say, clMard).

If all the conditions are met, make the transfer with bapi_goodsmvt_create and movement type 311.

On success, show data into a grid.

Here is the final result. In the next lessons, we are going to go through all the steps and complete the task.

Read the storage locations where the material exists, along with the stock.

When the user select the storage location, the stock is displayed and the checking is made to see if there is enough stock for material to be transferred.

Using the BAPI_GOODSMVT_CREATE, we transfer inside our homework application, a material between two storage locations.

Display the movements in the grid, some other small changes made and we have a result!

It is annoying every time to develop a custom made function module to join two tables, because you cannot find a BAPI or a function module from the system. With this function, no need to do this anymore! Just put as input the tables needed, add the conditions and the joining clauses and that's it!

See it in action in SAP!

The application requirements. Find what are batches and what are used for in ERP. Find in this lesson how to check the stock for each batch and how to take the oldest one to be consumed.