1 / 16

BW Delta Queue Processing in SAP

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. Extraction Queues in SAP used by GDW.

aiko
Download Presentation

BW Delta Queue Processing in SAP

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related