cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos
521

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.

Accepted Solutions (0)

Answers (5)

Answers (5)

0 Kudos

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

0 Kudos

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

rupesh_brahmankar3
Active Contributor
0 Kudos

Hello,

If it is happening before release you need to check the macros. Check system log during the time frame when it happens.

If it working fine for some products then please compare these products setting //MAT1 what difference they have?

Also refer SAP help document on it.

Aggregation and Disaggregation

And SAP consulting note - 410680 - Unexpected disaggregation result

Best Regards,

R.Brahmankar

rupesh_brahmankar3
Active Contributor
0 Kudos

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

0 Kudos

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.

0 Kudos

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.

rupesh_brahmankar3
Active Contributor
0 Kudos

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