Get table SAP

Get table Version 8 (Net)

Action group: SAP

Description

The action returns data from a table-type element in the SAP application window.

Settings

Property	Description	Type	Filling example	Mandatory field
Parameters
SAP application	SAP application instance that the action works on.	Robin.Sap		Yes
Element	A table type element in the SAP application window. If the specified element is not an element of a table type, then the action will throw an error.	Robin.WinElement		Yes
Heading	If the value is «true», the row with the table header will be highlighted separately and will not be included in the row with the contents of the table.	Robin.Boolean	true	No
Remove duplicate header	If the value is «true», indexes will be added to the same column names in the header of the resulting table. Numbering starts from 1.	Robin.Boolean	true	No
Results
Result	Data Table	Robin.DataTable

Special conditions of use

For the parameter "Heading"

Get the spreadsheet:

With this parameter enabled, the log will show "Columns: 3; rows: 2" because the first row of the taken area has become a header with the column names "No.", "Title", and "Tests". These headers cannot be accessed as a row of data to read, but you can use the column names to access a specific cell or column (by actions from the "Tables" group). If the option is off, the log will show "Columns: 3; rows: 3", the column names in the header will be "1", "2" and "3".

Also, in all of the above actions, add the "Remove duplicate header" checkbox to the input parameters:

When "true" is true, indices will be added to the header of the tabular value that the actions return as a result to the same column names. The numbering starts from 1.
Example No1:
There is a table:

With "Remove duplicate header" = true, and "Heading" = True, the "Take table" action will return a table of 10 rows and 4 columns. The column names of this table will be "No.", "Name", "Tests1", "Tests2".
Example No2:
There is a table:

When "Remove duplicate header" = true, and "Heading" = True, the "Take table" action will return a table of 4 rows and 5 columns. The column names of this table will be:
"Test31", "Test21", "Test22", "Test32", "Test1".

If "false", the column names will remain the same. Actions on net that return/process such tables with duplicated column names will crash with an error, because net cannot have a header with the same column names.
For example, the source table has columns "Test1", "Test" and "Test". If we add indexes only to the current doubles, the names will become "Test1", "Test1" and "Test2", i.e. new doubles with the name "Test1" will appear. Therefore, when renaming a particular column, the action should check if another column already has such a name and if there is such a match, the current column should have the next index. That is, in this case the action will rename the columns as "Test1", "Test2" and "Test3".

Example of use

Task

You need to retrieve a table from SAP and save it in CSV format.

Solution

Use the actions "Connect to session", "Get table", "Save table to CSV".

Implementation

Assemble a robot scheme consisting of the following actions
Set the parameters for the "Connect to session" action.
Set the parameters for the "Get table" action. The "Item" parameter must be retrieved via SAP Spy.
Set the parameters of the "Save table to CSV" action.
Launch the robot by clicking on the "Start" button in the top panel.