Skip to Content

SAP CPIDS/IBP - Aggregation of Quantities for a quarter

Hi Folks,

I have the following requirement:

CRD Qty and Shipped Qty are my 2 quantities field coming from my source. I want to aggregate and store their quantities for a quarter in a field IHCRD Qty.

Suppose right now I'm in Wk-5. So as per the requirement it should aggregate my Qty's from current week(Wk5) till my last week of my quarter(Wk13) for CRD Qty. For Shipped Qty it should aggregate the qty's from the start week(Wk-1) till my current week - 1(Wk-4). Summation of all these Qty's will be stored to IHCRD Qty in my current week(Wk-5).

Eg - Wk5

CRDQty - Sum from WK-5 till Wk- 13 = 490.

Shipped Qty- Sum from Wk-1 till Wk-4 = 40.

IHCRD Qty = CRD Qty + Shipped Qty = 530.

This logic is restricted to particular quarter i.e Summation of a particular week will happen from the start week of that quarter till the end week of that quarter.

Any guidance or suggestions would be highly appreciated.

Regards,

Shubham

capture.png (9.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Aug 04, 2020 at 04:57 AM

    Hi,

    Please explore IBP_CAGGR function for key figure calculation.

    https://help.sap.com/viewer/bf99e931b8d44aafb4e306ec3602cbdd/2008/en-US/12be9d5d821d421388492e343e488135.html?q=IBP_CAGGR

    You can aggregate data of CRDQty in one key figure at Qtr level and bring it at week level. Similarly, you can aggregate data of Shipped Qty. If required, make use of IBP_PERIODSHIFT function to bring last quarter data to current quarter. Finally, aggregate it into IHCRD Qty key figure.

    Hope this helps!

    Regards,

    Piyush

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.