Extract data from BAPI_AP_ACC_OPENITEMS

Question

Hello Everyone,
Has anyone done an extract for BAPI "BAPI_AP_ACC_OPENITEMS" using RFC connection from SAP. I have below code, any suggestions here. What will be the Imports if we have to extract 7-10 columns in the extract ?
Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Transformer, ByVal args As ConnectorArgs) As ObjectDim r3Conn As R3ConnectionTry'Create and open the R3 Connectionr3Conn = Me.GetConnection(si, globals, api)r3Conn.Open()
Dim r3Func As RFCFunction = r3Conn.CreateFunction("BAPI_AP_ACC_GETOPENITEMS")
r3Func.Exports("CompanyCode").ParamValue = "1000"
r3Func.Execute()Return r3Func.Imports("").ToTable()
' End SelectCatch ex As ExceptionThrow ErrorHandler.LogWrite(si, New XFException(si, ex))FinallyIf Not r3Conn Is Nothing Then r3Conn.CloseEnd TryEnd Function
&nbsp;

Krishna · Answer

PrithviK&nbsp; - The Below is the example for the imports&nbsp;
Return r3Func.Imports("TB").ParamValue.ToADOTable()&nbsp;
The above Function then will be return to the Data Table in the&nbsp;&nbsp;ConnectorActionTypes.GetData
&nbsp;

PrithviK · Answer

If I add the above line. Replaced TB with LINEITEMS for AP Open Items table.
Return r3Func.Imports("LINEITEMS").ParamValue.ToADOTable(). I am getting below error

Public member 'ToADOTable' on type 'RFCStructure' not found.

Krishna · Answer

PrithviK&nbsp; - Could you please let me know which BR are you using SIC or Extender?

Nikpowar97 · Answer

Hi Prithvi,I assume you are running a SIC Rule, Can you give this a try:
' Define which columns to import
        Dim imports As New RFCStructure()
        imports.AddField("Field1") ' Example: Field1
        imports.AddField("Field2") ' Example: Field2
        ' Add more fields as needed

' Import the specified columns into a table
        Dim dataTable As DataTable = r3Func.Imports("").ToTable(imports)

Replace "Field1", "Field2"&nbsp; with the actual field names you want to extract from the BAPI response. Make sure these fields correspond to the fields available in the BAPI result set. This should allow you to extract the desired columns from the BAPI response.Thanks,Nikhil&nbsp;

&nbsp;

PrithviK · Answer

Hi Krishna - This is version 7 and I am using Connector BR, not yet using SIC for this

Forum Discussion

Extract data from BAPI_AP_ACC_OPENITEMS

Related Content

Extract TB input data

Data management extract to the Server folder

Import Data Extracted via data Management using Extensibility Business Rule

REST API Endpoint to extract data from cube view

Extract full extensible dimension