SNP aggregation using PHYS_STOCK_LOCPRODS standard function (or other?)

[Former Member]

Hello,

We are using SNP aggregated planning and have a LOCPROD Hierarchy maintained . It works well to get aggregated planned receipts but we are not yet successfull in getting the initial physical stock.

I have seen that there is a standard function PHYS_STOCK_LOCPRODS that sound well to get it.

I tried it as a default macro in the aggregated Planning Book / Planning view, it did not worked.

So I tried it again by assigning it not as "default macro" but when "aggregating data" . I expected that by this way, it will update the physical stocks when using the standard program run through SE38 /SAPAPO/RMSDPAGG

Could a great expert help ?

Kind regards,

Christine Macaudière and Aurélien Le goff

[aparna_ranganathan · Accepted solution]

Hi

This can be solved very easily. Copy the stock balance macro from the 9ASNPAGGR book (SNPAGGR 1) view and your problem will be solved. You have to specifically copy the stock on hand (projected) calculation from the standard book.

Thanks

Aparna

[Former Member · Accepted solution]

Hi apparna,

Thank for your help, could you help a little more : in the step Stock on Hand (initial) of macro "Stock Balance" in PB 9ASNPAGGR View SNPAGGR(1) of planning area 9ASNP02, the macro uses 2 functions STOCK_CALC and INITIAL_STOCK ,

The function INITIAL_STOCK is has follow: INITIAL_STOCK ( KEYFS_VERSION( Row: Sales Order).))

Does it mean that it only takes stocks assigned to a Sales order ?

Could I replace it by the function PHYSICAL_STOCK that updates the Infobject 9ASTOCK ?

The function STOCK_CALC is used with a syntax not described in SAP Help:

_In Help,_ we have : STOCK_CALC( total demand key figure ; total receipts key figure ; stock level of the previous period ) returns the stock level. the arguments for the key figures can be rows or areas.

*In the template,* after "stock level of the previous period", we have other argument : "; 'AGGR' . Does it mean that the system will read result stored in keyfigure "Quantity stored" Info object 9ASTOCK at detail level to populate "STOCKDAGG" Stock on Hand (aggregated) , or does the function STOCK_CALC , because of 'AGGR' , will rather update the initial column of Stock on Hand (projected) (=> Info object STOCK ) of header location ?

Kinds regards,

Christine Macaudière

[Former Member · Accepted solution]

Hi apparna,

I am now getting the detail of stocks the ATPcategory in /SAPAPO/RRP3 view Tab "Stock" on the product on aggregated location, but I do not get yet the data in the initial column of Stock on Hand (projected) (STOCK), neither Stock on Hand (aggregated) (STOCKDAGG) nor in Quantity stored (9ASTOCK)

Kind regards,

Christine Macaudière

[digambar_narkhede · Accepted solution]

Use following function to get the stock in Stock on hand aggregated KF which is a time series KF. Row: Stock On Hand (Aggregated) ( Frm Initial ) = (Operator ICON )INITIAL_STOCK( ACT_VERSION ; (Operator ICON)ACT_PRODUCT ; ACT_LOCATION ; 'AGGR' )