Configure a table name override for delta extraction
Configure a table name override for delta extraction
When you configure a SAP Table reader mapping, you can override the selected table name at runtime with the structure name to perform a delta extraction.
When you run an SAP Table reader mapping for delta extraction, the Secure Agent fetches changed records from the SAP table for entries logged for the SAP table name in the Change Document Position (CDPOS) table. If there are entries logged for the SAP table structure in the CDPOS table, you can fetch those records by overriding the table name in the Override Table Name for Delta Extraction field in the SAP Table advanced source properties.
For example, if the table name you specified as the object type in the mapping is
CRMD_ORDERADM_H
, to get the delta records for entries captured in the CDPOS table for the structure name, specify the structure name
CRMA_ORDERADM_H
in the
Override Table Name for Delta Extraction
field. The Secure Agent fetches records from
CRMA_ORDERADM_H
that has change entries logged for the table structure.
If the delta data captured in the CDPOS table does not include the structure name, keep this field blank.