This workflow provides a template to enable the extract of a Delta load from an SAP BW Query.
When data is pushed from a transactional system such as SAP ECC or SAP S/4HANA to an SAP BW system, a unique Request Number is automatically generated to identify the load of data. The Request Number is stored in SAP BW table, RSREQICODS (Monitor: Saving of the updated IC and ODS per request).
It is possible to use the Request Number (RNR) in table, RSREQICODS to identify the last time an SAP BW InfoProvider was updated. The Request Number can be used as the basis to identify and extract a Delta load from an SAP BW Query by passing the Request Number (RNR) field value to the Request Number (0REQUID) characteristic in a SAP BW Query.
Prerequisites: This approach only works if the SAP BW InfoProvider has NOT been compressed AND the Request Number (0REQUID) has been exposed in the SAP BW Query. If you do have Delta load requirements that are not satisfied by this approach, then please contact the DVW team at acs_support@dvwsolutions.com.
Prerequisites:
KCS SAP Executor
KCS Tools Used:
SAP Table Data and SAP BW Read Tools
Workflow
How To - Extract a Delta Load from an SAP BW Query
External resources
Used extensions & nodes
Created with KNIME Analytics Platform version 4.3.2
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
Legal
By using or downloading the workflow, you agree to our terms and conditions.