Tables For DP/SNP

[Former Member]

Hello Guru

Am building tool in which I want to see for which material there was no planning and Allocation for past 1 year. Is there any table or FM which I can use for the same.

TIA

Andy

[Former Member]

Hi Andy,

You can extract historical data (1 year) for all SKUs and then just check the SKUs without value for the past year.

Also, you can create a macro in DP to read the "0" or blank value for the last year!

Thanks,

Regards, Marius 

[Former Member]

Andy,

It is unclear exactly what you mean when you say 'no planning' and 'no allocation'.  This means different things to different companies.

The first thing I would do before writing any custom code would be to investigate transaction /SAPAPO/MC62.> Delete obsolete combinations.  It is easy to do, it is supported by SAP, and if it is inadequate to meet your business requirements, you can still write your code.

Best Regards,

DB49

[Former Member]

Sorry if my questions/query is unclear.

Basically I want to delete the SKUs which are not required in APO and one of the condition to filter those SKU is to validate there was no planning (DP) done on that SKU in past one year.

Hope this helps..

[RahulHanda]

HI Andy

Could you share more what you are looking for? If you want to capture whice CVCs doesn't contain any value you can right alerts for the same.

If you want to compare forecasts let's say from previous period then logically this could be easily done in BW by capturing forecast on monthly level and comparison through queries instead of developing custom logic.

So let us know what you are looking for or check above suggestions.

regards

Rahul

[Former Member]

Hey Rahul

My requirement is to get the list of SKUs for which there was no planning done in past one year. So that I can delete those SKU from APO.

Regards

Andy

[RahulHanda]

Hi Andy,

You can generate alert for such combinations where there is no forecast. If value = 0 then generate alert which could be triggered weekly/bi-weekly or monthly. Thereafter you can review the same and delete the CVCs. Go through the below link to understand the alerts in APO.

Alert Monitor - SAP Library

Let me know if it resolved your issue.

Regards

Rahul