The current version of the RFM Code Generator contains now two search methods to find a remote enable function module.
By technical name, like RFC* to find e.g. RFC_READ_TABLE
Be description
This is a reverse search via the description of the remote enabled function module. On this way, the RFM can be determined via the descriptive text, the short text of the function module.
With this approach, the search can be extended on another level. Depending on the quality of the description, a business perspective may be considered.
Furthermore I added two additional fields in the selection perspective, the package, aka development class and the function group.
On this way you can open the package in ABAP for Eclipse or the SE80 very fast, to find other function modules.
Great work @StefanSchnell
You are saving SAP - RPA Developers thousands of hours!
I think I told you about my testing and QA background and so of course I tried to break your tool!
Forgive me Muha ha ha
Here is what I did:
I connected with our largest/slowest SAP instance and performed a rather complex search with wildcards and specific language → I know, this was against your recommendation!
While I was doing this, following things came to my mind which I thought would make the tool perfect:
The search took about 20+minutes
→ so I thought a “Cancel Search” button would be awesome
I had to kill the process and after restart, I had to insert connection params again
→ persist connection params would be awesome?
In another search it stopped responding after about 30 minutes
→ Show some progress bar would be awesome to see if it is still active
It seems the search results of “technical names” and “description” is an OR expression? I ended up sometimes with many search results
→ Would it be feasible to set the search results to an AND, OR expression? Maybe this will become very quick very complex?
This is just nice to haves - thank you so much again for this fantastic tool!
Looking forward to our next session!
… 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