… the data element from a component of a structure is additionally determined now. This is on the one hand interesting to know and on the other hand necessary to know if the structure contains nested tables or structures.
After the global event about SAP API Automation with the help of UiPath I had a lot of discussions about the most common API use case in relation with SAP. It seems to be reading data from tables. Therefore I decided to extend the RFM Code Generator to support this possibility in a simple way.
The current release of the RFM Code Generator contains the possibility to generate code for the RFM RFC_READ_TABLE. In the tab ReadTable it is possible to select an SAP transparent table or an SAP view to get the data from it. Type the table or view name in the search field, wildcards are supported, and select with a double click the object you need.
After the double click you can find the name and available descriptions in the text field. And you see development class or package of the table. Below the list the sum of the length of all fields is displayed and the hint, that the RFM RFC_READ_TABLE return value must not exceed a length of 512 characters. In the list you see the fields of the table with its details.
To generate code to use the table choose the programming language you want to use, C# or VBdotNET. Press the button “Generate Code” and now in the tab Code a code sequence is available.
With this option there is the possibility to create C# or VBdotNET code, for the Invoke Code activity, to read SAP data direct into a data table. On this way, with a few mouse clicks, a code sequence can be generated that reads data from an SAP table which can be used with UiPath.
You can find the link to the RFM Code Generator at the end of the first post of this thread.
The current version of the RFM Code Generator generates now, with the export of an Excel, an additional code frame, to handle the data in the Excel file. With this feature it is now possible to build your own SAP Accelerator fast.
My organization requires signing in to the SAP system via SSO. Is there any example on what parameters that I should include in the Secure Network Communications fields:
Hello @Chang_Jordan,
you can find a detailed description of the parameters in the SAP .NET Connector Programming Guide. E.g. on page 43 the SNC Mode (SNC_MODE), SNC Library Path (SNC_LIB) or SNC My Name (SNC_MYNAME) and on page 45 the SNC SSO (SNC_SSO) etc. Also take a look at the discussion here.
Best regards
Stefan
Hello @dinesh.s1,
if I understand your requirement correctly you want to export data from SAP and save it in Excel so that it can be imported again, in the context of a migration. This code generator creates a program frame for the use of SAP remote enabled function modules. It is not possible to export data with it.
Best regards
Stefan