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()

     

KKGamer's avatar
KKGamer
New Contributor III
2 years ago

Hi Nicolas, I have build below code for SIF function. The table can be connected and should have data. But when I using another rule to call SIF function there is no data returned. do you know the reason?

 

Public Shared Function RunOperation() As DataTable                                                           
   'Build connection                       
Dim r3Conn = New R3Connection(v_host, v_instanceID, v_username, v_password, "EN", v_client)
           r3Conn.Protocol = ClientProtocol.NWRFC
r3Conn.Open()
Dim r3Table As New ReadTable(r3Conn)
r3Table.TableName = "/BIC/XXXXXXXX"
 
r3table.SetCustomFunctionName("Z_XTRACT_IS_TABLE")
r3Table.Addfield("COMPANY_CODE")
        r3Table.Run()
Return r3Table.result
End Function
  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    2 years ago

    KKGamer It all seems good.
    Just for testing, take away the Addfield. And check with the SAP team on their side. Also If they can trace info in the SAP debugger...