Extracts the metadata information (field names, offsets, lengths, types) from a specified SAP table.
You can use this node prior to running the Extract ERP Table node to identify the fields that exist in a table if you want to limit the fields that are output.
The Extract ERP Table Metadata and the Extract ERP Table nodes allow you to perform a bulk extract of data working directly with the SAP tables rather than going through the SAP objects.
To configure this node, in the TableName property specify the name of the SAP table from which you want to extract metadata.
This node does not take any inputs and has only one output named Fields. The output includes the following information:
| Field name | Description |
|---|---|
| FIELDNAME | Name of the field. |
| FIELDTEXT | Description of the field. |
| TYPE | ABAP type of the field. |
| OFFSET | Offset of the field when extracted using RFC_READ_TABLE. |
| LENGTH | Length of the field when extracted using RFC_READ_TABLE. |
For an example of using the Extract ERP Table Metadata node, see Extract ERP Table Metadata example.
Properties
TableName
Specify the name of the SAP table from which to extract the field metadata. A value is required for this property.
ConnectionType
Specify the type of connection you are using. If you are not using a load balanced login, then you can connect to a Custom Application Server. Otherwise, you should select Group/Server Selection.
Choose from:
- Custom Application Server - Forms a connection to the specified SAP Application Server without using group load balancing for the logins.
- Group/Server Selection - Load balanced login using the SAP Group/Server mechanism.
A value is required for this property. For more information, see your SAP documentation.
When Custom Application Server is specified, the following properties are required:
- ApplicationServer
- SystemNumber
When Group/Server Selection is specified, the following properties are required:
- MessageServerHost
- Group/Server
- R3Name
In all cases, the following properties are required:
- User
- Password
- ClientNumber
ApplicationServer
Specify the name of the SAP Application server
A value is required if ConnectionType is set to Custom Application Server. Should not be set if ConnectionType is set to Group/Server Selection.
Group/Server
Specify the group of SAP application servers.
A value is required if ConnectionType is set to Group/Server Selection. Should not be set if ConnectionType is set to Custom Application Server.
MessageServerHost
Specify the SAP message server host.
A value is required if ConnectionType is set to Group/Server Selection. Should not be set if ConnectionType is set to Custom Application Server.
MessageServerPort
Specify the SAP message server port.
Optional if ConnectionType is set to Group/Server Selection. Should not be set if ConnectionType is set to Custom Application Server.
SystemNumber
Specify the two-digit system number of the SAP system.
Called the "Instance Number" in the SAP Logon GUI. A value is required if the ConnectionType is set to Custom Application Server.
R3Name
Specify the system ID of the SAP system.
A value is required if the ConnectionType is set to Group/Server Selection.
ClientNumber
Specify the three digit client number for the SAP system.
Called the "SystemID" in the SAP Logon GUI. A value is required for this property.
RouterString
Optionally specify the SAP Router String in the following format:
/H/<IP address where your SAP router is located>/S/<port for your SAP router>/H/<SAP server host ip address>/H/
User
Specify the name of the SAP user.
A value is required for this property.
Password
Specify the password for the specified user on the SAP system.
A value is required for this property.
ConnectionMethod
Optionally specify the method used to connect to the SAP system. Choose from:
- Direct Connection - Connection will be held for the duration of the node run.
- Pooled Connection - Connection will be taken and returned as needed during node execution.
The default value is Pooled Connection.
PeakLimit
Optionally specify the peak limit when using pooled connections to the SAP system (specify an integer value).
The default value is 10.
Inputs and outputs
Inputs: Multiple optional.
Outputs: Fields, multiple optional.