BW Delta Queue Processing in SAP

1. 1 4 2 3 5 Displayed using SMQ1 or LBWQ Displayed using RSA7 BW Delta Queue Processing in SAP Extraction Queue Collective Batch Job(s) (Run Hourly) BW Delta Queue Delta Update Delta Repetition BW Extract and Load

2. Extraction Queues in SAP used by GDW • Sales Related Data: • MCEX11 (Orders and Open Orders), • MCEX12 (Deliveries), • MCEX13 (Billing documents). • Procurement: • MCEX02 (Item and Schedule)

3. LBWQ / SMQ1 – Extraction Queue Monitor

4. LBWQ / SMQ1 – Extraction Queue Monitor

5. LBWQ / SMQ1 – Displaying Records

6. Delta Queues in SAP used by GDW • Sales Related Data: • 2LIS_11_V_ITM (Open Orders), • 2LIS_11_VAITM (Orders), • 2LIS_12_VCITM (Deliveries), • 2LIS_13_VDITM (Billing documents). • Procurement: • 2LIS_02_ITM (Item) • 2LIS_02_SCL (Schedule).

7. RSA7 – BW Delta Queue Monitor

8. RSA7 – Displaying Delta Update Records

9. RSA7 – Displaying Delta Update Records Delta Update Record Count

10. RSA7 – Displaying Delta Repetition Records

11. RSA7 – Displaying Delta Repetition Records Delta Repetition Record Count

12. SAP Initial Collective Update Run (Conceptual) LBWQ Extraction Queue Records = 257 Collective Update Run RSA7 BW Delta Queue Delta Update Records = 257 Delta Repetition Records = 257

13. SAP BW Delta Queue Behavior For Successful BW Update RSA7 BW Delta Queue Delta Update Records = 257 Delta Repetition Records = 257 Delta Update into BW  Records Received and Updated in BW RSA7 BW Delta Queue 257 Delta Update Records = 0 Delta Repetition Records = 257

14. SAP Second Collective Update Run LBWQ Extraction Queue Records = 274 Collective Update Run RSA7 BW Delta Queue Delta Update Records = 274 Delta Repetition Records = 531 (274 + 257)

15. SAP BW Delta Queue Behavior For Failed BW Update Note: If all records are NOT received into the PSA, the InfoPackage must NOT be set to GREEN. Doing so will result in loss of data. RSA7 BW Delta Queue Delta Update Records = 274 Delta Repetition Records = 531 The 274 records are not successfully updated into BW Delta Update into BW  RSA7 BW Delta Queue State of record counts in queues after a failure needs more investigation The same InfoPackage that failed must be re-run, either manually or by re-running the failed TWS job Delta Update Records = 0 Delta Repetition Records = 274 Delta Repetition Request  RSA7 BW Delta Queue Records Received and Processed Delta Update Records = 0 274 Delta Repetition Records = 274

16. Extraction / Delta Queue Cross Reference