topic Re: Extracting data from SE37 using C# in Application Development and Automation Discussions

Extracting data from SE37 using C#

Former Member — Mon, 29 Aug 2016 08:07:21 GMT

I am accessing the BAPI: BAPI_ALM_ORDER_GET_DETAIL using C# through the following code:

public double getActualCost (R3Connection connection, string orderNo)

{

double actualCost = 0;

try

{

connection.Open();

RFCFunction func = connection.CreateFunction("BAPI_ALM_ORDER_GET_DETAIL");

func.Exports["NUMBER"].ParamValue = orderNo;

func.Execute();

RFCTable orderCostsTable = func.Tables["ET_COSTS_DETAILS"];

if (orderCostsTable.RowCount > 0)

{

actualCost = Convert.ToDouble(orderCostsTable.Rows[0][0]);

return actualCost;

}

else

return orderCostsTable.RowCount;

}

catch (Exception e)

{

Console.WriteLine(e.Message);

return 1;

}

The problem is that orderCostsTable.RowCount is always equal to 0. I have tried to access the table ET_COSTS_DETAILS through the SE37 transaction using SAP GUI, however there are 2 selections for this table (Shown in the attached picture). The first one has 0 entries (I suspect that this is the reason orderCostsTable.RowCount is always equal to 0), while the 2nd one has 1 entry (which is the entry I am trying to read from the C# application).

Is there any way to solve this problem?

Re: Extracting data from SE37 using C#

SimoneMilesi — Mon, 29 Aug 2016 08:19:07 GMT

Hi Sylvan,

just a question: how much do you know about ABAP? It seems to me you never tried to run a FM in se37 from what you are saying.

Because the 1st one you are seeing with 0 is the "Input status of the table" before executing the FM while the 2nd one is the "Output status of the table".

To get the correct data, be sure your orderNo here is lenght 12 with not significative 0 filled


func.Exports["NUMBER"].ParamValue = orderNo;

For example: orderNo is 12, you HAVE TO pass 000000000012

Re: Extracting data from SE37 using C#

Former Member — Mon, 29 Aug 2016 08:26:22 GMT

I'm a beginner in ABAP (still a student). I have tried it with orderNo length 12 and it worked. Thanks a lot for your reply

Re: Extracting data from SE37 using C#

SimoneMilesi — Mon, 29 Aug 2016 08:41:22 GMT

Hi Sylvan.

You are welcome but I warmly suggest you to read the docs and check the many and many and many wikis here on scn before jumping right in the deep waters of coding.

I know the urge to write something, but better study (and train) alot before.

Under lean and training space you can find also some free online courses if you need them!