SAP BW - Extract a Delta Load from a SAP BW Query

[#1]

This workflow from DVW Analytics uses the Alteryx Connector for SAP (ACS) to demonstrate how to enable the extract of a Delta load from a SAP BW Query into Alteryx.

When data is pushed from a transactional system such as SAP ECC or SAP S/4HANA to a 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.

• Works with: SAP BW
• SAP Read Tools used: SAP BW Read tool, SAP Table Data tool
• SAP Write Tools used: N/A