Calculate Cumulative Quantities

The “Calculate Cumulative Quantities” can be reached via the main menu:

Sales-A/R - Automotive - Demands - Calculate Cumulative Quantities

The following window allows for a recalculation of the cumulative quantities (CQ). The calculation can encompasse all of the partner sales orders of one customer or just the ones selected by the user. However, at least one partner sales order has to be selected. Otherwise the calculation will not have any results.

• Load The available partner sales orders for the selected customer (Business partner code) are shown in the list. They are selected from the start, but can be un- or reselected at any time.
• All Each available partner sales order is selected.
• None The selected partner sales orders are unselected.
• Calculate The CQ calculation is executed for the selected partner sales orders.
• Cancel Used to leave the “CQ calculation”.

The feature “Calculate CQ” for a partner sales order is invoked out of the most diverse features. It is invoked every time a parameter used in the feature changes.
The feature “Calculate CQ” computes the following fields in the Partner sales order / Demands:

The following fields (mostly marked in yellow) are computed based on the graphic below:

For the 1st allocation:
Total demands (IAG_RAT3.U_Wgfefz)(1) = CQR + Residue (IAG_RAT0.U_Rst) + Instant demand (IAG_RAT0.U_Sst) + Call quantity (IAG_RAT3.U_Etlmng)(1)

For all other allocations:
Total demands (IAG_RAT3.U_Wgfefz)(n) = Total demands (IAG_RAT3.U_Wgfefz)(n-1) + Call quantity (IAG_RAT3.U_Etlmng)(n)

Quantity to be delivered (IAG_RAT3.U_Etldis)(n) = Total demands (IAG_RAT3.U_Wgfefz)(n) – CQD (IAG_RAT0.U_Vfz) + Open goods issue (IAG_RAT0.U_Ofnwas)

!The calculation changes if the allocation depicts a single demand. That means at least one of the following fields is occupied:
> Customer reference number (IAG_RAT3.U_Refnrk) (in tab “Demands”) > Chassis No. (IAG_RAT3.U_Frgnr) (in tab “Demands”) > Material handlings code (IAG_RAT3.U_Mhdcod) (in tab “Demands”) > PUS-No (IAG_RAT3.U_Pusnr) (in tab “Demands”)
Then: Quantity to be delivered (IAG_RAT3.U_Etldis)(n) = Call quantity (IAG_RAT3.U_Etlmng)(n) – Delivery note quantity (@IAG_RAT3.U_Lsmng)(n)

Display quantity to be delivered (@IAG_RAT3.U_Etldisa)(n) = 0 IF Quantity to be delivered (IAG_RAT3.U_Etldis)(n) < 0 ELSE same value as Quantity to be delivered (IAG_RAT3.U_Etldis)(n)

Additional fields are calculated as follows in the ‘Calculate CQ’

Change total demand (IAG_RAT3.U_Wgfefzd)(n) = Total demands (IAG_RAT3.U_Wgfefz)(n) – Old total demands (IAG_RAT3.U-Wgfefza)(n)

For the 1st allocation
Change (IAG_RAT3.U_Vraend)(1) = Comp. cum. rec. quantity (IAG_RAT0.U_Vrgefz) – Change total demand (IAG_RAT3.U_Wgfefzd)(1)

For all other allocations
Change (@IAG_RAT3.U_Vraend)(n) = Change total demand (IAG_RAT3.U_Wgfefzd)(n) – Change total demand (IAG_RAT3.U_Wgfefzd)(n-1)

Planning date (@IAG_RAT3.U_Plndat)(n) = Call date (IAG_RAT3.U_Etldat)(n) + Plus/Minus days production (IAG_RAT0.U_Pmtprd)

As long as the “Planning quantity” is less than zero, a zero is entered. The result is only entered for the 1st allocation if the “Planning quantity” is greater than zero.
Planning quantity (IAG_RT3.U_Plnmng)(n) = Quantity to be delivered (IAG_RAT3.U_Etldis)(n) + Open goods issue (IAG_RAT0.U_Ofnwas)

For all other allocations
Planning quantity (IAG_RT3.U_Plnmng)(n) = Call quantity (@IAG_RAT3.U_Etlmng)(n)

Furthermore, ‘Calculate CQ’ refreshes the following fields in the tab Update:.

Shipping ending (IAG_RAT0.U_Ztrendv) current date + Shipping period under observation (IAG_RAT0.U_Btztrv)

Production ending (IAG_RAT0.U_Ztrendp) = current date + Production period under observation (IAG_RAT0.U_Btztrp)

Purchasing ending (IAG_RAT0.U_Ztrende) = current date + Purchasing period under observation (IAG_RAT0.U_Btztre)

Shipping total change (IAG_RAT0.U_Gvaztv) = Change total demand (IAG_RAT3.U_Wgfefzd)(of the last allocation before Shipping ending)

Shipping changing point (IAG_RAT0.U_Vaztpv) = Call date (IAG_RAT3.U_Etldat)(the first allocation before Shipping ending where a change happened)

Production total change (IAG_RAT0.U_Gvaztp) = Change total demand (IAG_RAT3.U_Wgfefzd)(of the last allocation before Production ending)

Production changing point (IAG_RAT0.U_Vaztpp) = Call date (IAG_RAT3.U_Etldat)(the first allocation before Production ending und after Shipping ending where a change happened)

Purchasing total change (IAG_RAT0.U_Gvazte) = Change total demand (IAG_RAT3.U_Wgfefzd)(of the last allocation before Purchasing ending)

Purchasing changing point (IAG_RAT0.U_Vaztpe) = Call date (IAG_RAT3.U_Etldat)(the first allocation before Purchasing ending and after Production ending where a change happened)

Finally the Status (IAG_RAT0.U_Ratsts) of the partner sales order is changed as follows:

• If “Shipping total change” is greater than 0, Status (IAG_RAT0.U_Ratsts) = “2 | Change shipping”
• If “Production total change” is greater than 0, Status (IAG_RAT0.U_Ratsts) = “3 | Change production”
• If “Purchasing total change” is greater than 0, Status (IAG_RAT0.U_Ratsts) = “4 | Change purchase”