Stock on Hand: Category Group in SNP Planning Area

[former_member568621]

Experts,

I am exploring a basic SNP solution based on standard SNP planning book

Why do Stock on Hand key fig with tech name STOCKD. ATD issue key fig with tech name 9AATDAB and Stock on hand projected key fig with tech name STOCK. all refer to the same BI field name /BI0/9AATDAB ?

What does it mean?

Isnt Stock on Hand and Stock on Hand projected both calculated using Macros? in standard SNP planning area are these Auxiliary Key Figures? If they are Aux, whey then do they 'refer' to the BI field /BI0/9AATDAB ?

[rupesh_brahmankar3 · Accepted solution]

Hello,

You have asked so many queries in a discussion.

Macro function INITIAL_STOCK will show the aggregated stock value INITIAL_STOCK macro function reads data from stock category group If you did not define anything there by default it reads CC category.

In SNP interactive planning, reading data for keyfigures for 'ATD Receipts' and 'ATD Issues' is considered the category group which is defined in the master data SNP tab, if not then category group defined in the keyfigure.

You can CIF the stock from R/3 to APO . Once the stock is in APO, you can use Physical_stock( ) function to pull the stock to SNP planning book.

Check macro name is "Stock Balance" and "Stock on Hand"

macro Physical_Stock, you can use in way to exclude the block stock etc.

9ASTOCK key figure capacity consumption of the storage resources and the relevant order quantities In SNP capacity view, you are loading the data for a storage resource and the Quantity Stored keyfigure are used The calculations for this Key Figure are determined by the Key Figure Function assigned in the Planning Area.

Please refer this discussion which is for same topic.

capacity in in SNP capacity view

Planning-book-key-figure-and-macro

Best Regards,

R.Brahmankar

[former_member568621]

Thanks a ton Rupesh,

Completely clear.

[rupesh_brahmankar3]

Hello,

Category group assigned to key-figure on aggregate in the planning area customizing (transaction /SAPAPO/MSDP_ADMIN tab "Key Figs"). Stock On Hand values calculated by macros.

In interactive planning, you load data of location products and the value of the keyfigure ATD receipts which extract data with aggregate 9AMALO, and the value of the keyfigure ATD receipts.

In the planning area configuration, you define the category groups against the key figures used. So for Stock on hand key figure you define a category group which has categories like CC and other stock categories.

The stock data under these categories is then reflected in the stock on hand key figure of planning book INITIAL_STOCK macro function reads data from stock category group.

Best Regards,

R.Brahmankar

[former_member568621]

Thanks Rupesh,

A few questions.

How does the INITIAL_STOCK() macro know (or how do I figure) to what Category group does STOCKD - Stock on Hand key figure belong when NO category group is assigned to the same? In fact STOCKD key figure is an Aux Key figure computed by a simple Macro that I understand. It does not exist in the planning area. What I do not understand is what ATP categories are included in this Stock on Hand Key Figure by the INITIAL_STOCK() macro? Can I include / exclude e.g. Block stock, QI Stock, On order stock, scheduled for delivery stock from Stock on Hand and Projected Stock on hand Key figures?

Secondly I still did not fully get why there is the SAME /BI0/9AATDAB field associated with Stock on Hand, Stock on Hand Projected and ATD issues? As seen when I double click the Key figure in the data view definition. Aux. Key fig should have no BI field! or should it?

Thirdly even 9ASTOCK does not have Category group assigned in standard SNP planning area.. Scr shot attached.

Thanks

Amit