The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

NicolasArgente's avatar
NicolasArgente
Valued Contributor
2 years ago
Solved

SIC and SAP CreateFunction from ERPConnectStandard20.dll

Hi there! I am using OS v8.1 and SIC with latest ERPConnectStandard20.dll and the other dlls. I can connect to SAP and retrieve data using READTABLE. Now I am trying to use CreateFunction but I...
Connectors
  • NicolasArgente's avatar
    NicolasArgente
    2 years ago

    Problem solved. All my code was fine, the mistake was on the client side. It was missing an error an export field! We had to use ABAP debugger to find out.
    Thanks guys!

  • jwagner's avatar
    jwagner
    1 year ago

    Found the resolution

    Dim r3Conn As R3Connection =  New R3Connection()
r3conn.Protocol = ClientProtocol.NWRFC
r3Conn.Open()

     

NicolasArgente's avatar
NicolasArgente
Valued Contributor
2 years ago

Hi Robb! Yes I tried that too. I believe there is a kind of bug with this new way of doing. FYI, I tried to return all the below : 

'Return r3Func.Imports("MATERIAL_GENERAL_DATA").ParamValue.ToADOTable()
'Return r3Func.Imports("MATERIAL_GENERAL_DATA").ToTable()
'Return r3Func.Tables.Item("MATERIAL_GENERAL_DATA").ToADOTable()
'Return r3Func.Tables("MATERIAL_GENERAL_DATA").ToADOTable()

On the SAP side, we see the call, but the call is extremely fast. And at the end it returns nothing.

If anyone has ever used CreateFunction on OS v8.0 or 8.1. Please share your code of the SIF.

Thanks