ExtractTable

This activity helps the user to extract the specified table in datatable format in the SAP application. 

Limitation

In SAP GUI 8000 version, extracting data from tables with a large number of rows and columns may take longer. This is due to SAP’s lazy loading mechanism, which loads content only when scrolled, impacting extraction speed.

Properties

INPUT

DelayAfter: It assists the user to add a delay before initiating subsequent activities. The delay duration here is in milliseconds. By default, it is set to “100” milliseconds. When the option is left blank, the delay will not be considered.

DelayBefore: It assists the user in adding a delay before starting the execution of the activities. The delay duration here is in milliseconds. By default, it is set to “200” milliseconds. When the option is left blank, the delay will not be considered.

TableID: *This parameter specifies to provide the “TableID” captured from the scripting against the field where you want to extract the table and it accepts values in the “String” datatype.

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

Datatable: *It helps to view the output of the activity as the extracted table from the provided field in the SAP application and returns value in “Datatable” datatype. 

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean”.
True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow.

How to get the Table ID from the scripting? 

To retrieve the element ID from the specific field in the SAP application, follow the below steps.

1. Open SAPLogon application and follow the further steps here to record the steps. 
2. Now, the VB script will be saved in your local folder, open it.
3. Find where all the inputs are passed as values that are required to perform actions.
4. For instance, the values will be as below,
a. Session.findById(“wnd[0]/usr/ctxt$8A-YEAR”).text=”samplevalue” 
5. Copy the ID that is inside the “Session.findById”, which as “wnd[0]/usr/ctxt$8A-YEAR”. This is the ID from where you need to extract the table using the Extract table activity. 
6. Add this ID in the “Table ID” field in the “Extract Table” activity and execute the activity