Skip to Content

SAP APO DP Incorrect key figure split during holiday for some products

Dear gurus.-

In tcode /sapapo/sdp94 we have some two months June and July; both months June and July have three weeks with 5 working days and one with with 4 working days because one day is holiday.

The time split for demand key figure is ok for all skus for all the weeks of July, it means week 1, 2 and 3 with five working days have 100 cases, and the week 4 with the holiday and only 4 working days have 80 cases.

But, in June, the week 4 with the holiday and only 4 working days have 100 cases, which is incorrect because it is the same number of cases than the rest of the weeks with 5 working days, the correct number of cases should be 80, like in July.

I checked the time based disaggregation and looks fine /sapapo/msdp_admin that should apply for all the products, but, I found some products showing the right number with 80 cases for the week with 4 working days, showing 100 for the week with 5 working days.

What makes some products behave correct with the split for a week with a holiday and other products do not???

Can you please guide me to what do I have to check?

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Jul 10, 2020 at 12:43 PM

    Dear Gurus,

    In addition to the findings I said in the question, I have found the products that behave correct, have different master data values for SNP demand profile, SNP supply profile and Deployment profile, than those products do not behave correct. Although the "performance assistance - help" does show direct relation to the error so far.

    Can you please help me to understand what could make some products behave correct with the split for a week with a holiday and other products do not???

    Can you please guide me to what do I have to check?

    Thanks in advance.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello,

      Do you have this issue while forecasting or releasing forecast from DP to SNP?

      Factory calendar settings are considered when disaggregating the final consensus sales data from weekly to daily buckets.

      Please refer SAP Note 1902413 Analyze time based disaggregation and check internal disaggregation factors

      Best Regards,

      R.Brahmankar

  • Posted on Jul 13, 2020 at 04:13 PM

    Hello,

    Thanks for your reply. This issue happens before releasing forecast from DP to SNP.

    Indeed, in addition to the checks I made, mentioned in my previous posts, I also verified /SAPAPO/TR32, SCAL and /SAPAPO/CALENDAR, and all of are correct.

    I ran report /SAPAPO/OM_TS_BROWSER recommended in sap note 1902413, and checked all period profiles. The curious thing is time based disaggregation show incorrect values in a specific time buckets for most of the products, but there are some other products behave correct in this same time bucket.

    Is there another technical report or set up to look at?

    I wonder, might be a different reason making some products behave correct?

    Maybe some master data value?

    Thanks and regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 14, 2020 at 06:31 AM

    Hello,

    It means DP to SNP release you have a time period split with holiday in time stream calendar.

    I have no idea if there any technical report to look at, however you can debug during DP to SNP release like /SAPAPO/MC9 or , /SAPAPO/RTSOUTPUT_FCST

    The macros can change the forecast key figure.

    Releasing functionality does not execute any macro, it only reads data from liveCache directly. However planning book / data view macros can change the forecast key figure.

    Please check assigned a time stream calendar with the same time zone as the location's time zone to the location's shipping calendar.

    Best Regards,

    R.Brahmankar

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 14, 2020 at 08:32 PM

    Hello, thanks a lot for your analysis!

    I found time stream calendar, time zone, location's time zone, and location's shipping calendar are all okay and aligned. But, this issue has two important things to consider:

    1) it happens before releasing forecast from DP to SNP

    2) it does not happen to all the products, since there are some products show correct time based disaggegation

    Why some products show correct time based disaggregation?

    Which master data could be?

    Best regards.

    Freddy Gerardo Arneaud

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 16, 2020 at 06:25 PM

    Hello,

    Yes, thank you. Regarding note 410680, our ratio is dissaggregated using pro rata and based in another ratio, which uses, proportional allocation and average at lowest level of detail.

    Days ago I compared master data of skus behaving good versus those behaving bad, and I found they have different SNP Demand, Supply and Deployment Profiles, I also found under SNP 2 tab of MAT1 they have different values in Horizon days, e.g. SNP: Pull Deployment, Production, Trn, etc... but I guess it is more related to SNP than DP. I asked master data people to check but no response yet.

    Since some products do not show the issue but other products show the issue, I still believe it might be related to master data, but yet I have not found a SAP note or a link about specific APO master data impacting time disaggregation that help me to confirm or discard this hypothesis.

    Thanks in advance and best regards,

    F. Arneaud

    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.