SAPTable Extract
With this extract, data can be read from SAP Data Dictionary tables. You can access any Transparent Table as well as Database View and Projection View table types. Note that Maintenance View and Help View are not supported.
Settings
Connection | The connection name. | ||||||||||||||||||
SAP table | The name of the SAP Data Dictionary table has to be specified. | ||||||||||||||||||
Filter | The table can be filtered on any component field of the SAP table. | ||||||||||||||||||
Field | Field name | ||||||||||||||||||
Filter type | Options are accept or deny. With deny, the condition is negated. | ||||||||||||||||||
Operator |
|
||||||||||||||||||
Value | Filter value | ||||||||||||||||||
Bear in mind that the length of the filter value must not exceed the doubled length of the SAP field.
Fields in SAP Tables with datatype "string" cannot be read with SAPTable extract and will result in an error. This is a limitation of SAP: "The built-in type STRING is mapped to the ABAP type string and also handled like a text string (CLOB) in ABAP Dictionary and by database tables. Table fields of this type cannot be used as key fields or index fields in database tables or in any positions in Open SQL statements. " To extract a CDS View, you must specify its generated DDL SQL View, which can be displayed in SAP with the Dictionary View Editor (transaction SE11). |
Export data fields |
The output structure consists of fields of the SAP Data Dictionary table, which have to be specified in the extract definition. An alias name of the field and a default value in case of empty or null values can be optionally assigned. Due to internal limitations of SAP modules, total combined output length of all specified fields must not exceed 4000 bytes. |
Bulk size | Size of blocks for extraction. |
Use caching | Memory, disk, or none (default). See Caching in Extracts. |
Sorting of output rows
The output rows are automatically sorted on all primary keys of the table or view as defined in the SAP ABAP Dictionary.
Note: it is possible to extract from Hana CDS Views by using the generated table of the view (as seen in SAP Data Dictionary), but this is restricted to CDS Views without input parameters.
Updated September 27, 2024