BW Delta Queue Processing in SAP Extraction Queue BW Delta Queue

BW Delta Queue Processing in SAP
1
Extraction Queue
Displayed
using SMQ1
or LBWQ
2
Collective Batch Job(s)
(Run Hourly)
BW Delta Queue
Delta Update
Delta Repetition
3
4
5
BW Extract and Load
Displayed
using RSA7
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)
LBWQ / SMQ1 – Extraction Queue Monitor
LBWQ / SMQ1 – Extraction Queue Monitor
LBWQ / SMQ1 – Displaying Records
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).
RSA7 – BW Delta Queue Monitor
RSA7 – Displaying Delta Update Records
RSA7 – Displaying Delta Update Records
Delta Update
Record Count
RSA7 – Displaying Delta Repetition Records
RSA7 – Displaying Delta Repetition Records
Delta Repetition
Record Count
Initial Collective Update Run (Conceptual)
SAP
LBWQ Extraction Queue
Records = 257
Collective Update Run
RSA7 BW Delta Queue
Delta Update Records = 257
Delta Repetition Records = 257
Delta Queue Behavior For Successful BW Update
SAP
RSA7 BW Delta Queue
BW
Delta Update Records = 257
Delta Repetition Records = 257
Delta Update into BW 
RSA7 BW Delta Queue
Delta Update Records = 0
Delta Repetition Records = 257
Records Received and Updated
in BW
257
Second Collective Update Run
SAP
LBWQ Extraction Queue
Records = 274
Collective Update Run
RSA7 BW Delta Queue
Delta Update Records = 274
Delta Repetition Records = 531
(274 + 257)
Delta Queue Behavior For Failed BW Update
SAP
RSA7 BW Delta Queue
Delta Update Records = 274
Delta Repetition Records = 531
Delta Update into BW 
RSA7 BW Delta
Queue
State of record counts in
queues
Delta Update Records
= 0after a failure
needs more investigation
Delta Repetition Records = 274
BW
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.
The 274 records are not
successfully updated into BW
The same InfoPackage that
failed must be re-run, either
manually or by re-running
the failed TWS job
Delta Repetition Request 
RSA7 BW Delta Queue
Records Received and Processed
Delta Update Records = 0
274
Delta Repetition Records = 274
Extraction / Delta Queue Cross Reference
Data
(LBWQ)
Extraction
Queue
(RSA7)
Delta
Queue for
BW
Collective
Batch Pgm
Name
TWS
Schedule /
R3 Job
Name
Run
Frequency /
Time
Item detail
MCEX02
2LIS_02_ITM
RMBWV302
CPRO0019 /
EK-RMBWV302
15 min. past the hr.
/ hourly / SUN-FRI
until 23:15
Schedule detail
MCEX02
2LIS_02_SCL
RMBWV302
CPRO0019 /
EK-RMBWV302
15 min. past the hr.
/ hourly / SUN-FRI
until 23:15
Orders
MCEX11
2LIS_11_VAITM
RMBWV311
COTC0110 /
EK-RMBWV311
30 min. past the hr.
/ hourly / SUN-FRI
until 23:30
Open Orders
MCEX11
2LIS_11_V_ITM
RMBWV311
COTC0110 /
EK-RMBWV311
30 min. past the hr.
/ hourly / SUN-FRI
until 23:30
Deliveries
MCEX12
2LIS_12_VCITM
RMBWV312
COTC0110 /
EK-RMBWV312
30 min. past the hr.
/ hourly / SUN-FRI
until 23:30
Billing documents
MCEX13
2LIS_13_VDITM
RMBWV313
COTC0110 /
EK-RMBWV313
30 min. past the hr.
/ hourly / SUN-FRI
until 23:30