2 weeks ago
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 Object
Dim r3Conn As R3Connection
Try
'Create and open the R3 Connection
r3Conn = 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 Select
Catch ex As Exception
Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
Finally
If Not r3Conn Is Nothing Then r3Conn.Close
End Try
End Function
a week ago
@PrithviK - The Below is the example for the imports
Return r3Func.Imports("TB").ParamValue.ToADOTable()
The above Function then will be return to the Data Table in the ConnectorActionTypes.GetData
a week ago
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.
a week ago
@PrithviK - Could you please let me know which BR are you using SIC or Extender?
Tuesday
Hi Krishna - This is version 7 and I am using Connector BR, not yet using SIC for this
a week ago
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" 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
Tuesday
Hi Nikhil, this is not SIC, rather am using Connector rule for this export