Safety stock days supply from product location master not updating.

[Former Member]

Hi all,

I have product location master where initialy there was a safety stock method and safety days supply populated.

But now we have removed the safety days supply and the method from the product location master.

My issue is that when i see the planning book and data view for the said product and location i am still able to see the previous value of safety days supply in the data view.

How do i get rid of this inconsistency between the data view and product location master.

Thanks & Regards.

Santosh Joshi

[Former Member · Accepted solution]

Hi Safety day's supply in your planning book can come from product master and can be maintained manually also .

If its comign from product master , there should be a macro

to read the value from the Location Product record and assign this to your key figure "Safety days supply" . There is a function MATLOC() to do this.

MATLOC( 'FIELD_NAME' ; <'> ; <'> ; <'> ) returns the content of a numerical field in the location/product master record of the specified product and location.

So you have to check if there is any simliar macro exist for

your book . If it is not there then probably its maintained

through some other way .

you can write a macro like this

Safety days supply

safety days supply : ( 12 Iterations : P 01.2008; P 12.2008 )

Row: safety days supply ( Frm P 01.2008 ) =

MATLOC( 'SVTTY' ; ACT_PRODUCT ; ACT_LOCATION )

[Former Member · Accepted solution]

Hi,

Could you let me know the step by step procedure along with t-code for assiging this to the key figure.

Thanks & regards.

Santosh Joshi

[Former Member · Accepted solution]

Hi :

Go to /n/sapapo/advm

select your planning book , data view & see macro associated with it .

see if there is any macro maintained for safety day's supply

if not the n probably its maintained manually in your planning book so in order to read dataa from product master create a new macro , code would be like this

Safety days supply

Safety days supply : ( 12 Iterations : P 01.2008; P 12.2008 )

Row:

Safety days supply( Frm P 01.2008 ) =

MATLOC( 'SVTTY' ;

ACT_PRODUCT ;

ACT_LOCATION

)

[Former Member · Accepted solution]

Hi,

Thanks for the explanation.

Thanks & Regards.

Santosh Joshi

[Former Member]

can you try running /SAPAPO/MSDP_SB - Safety Stock Planning for this product location??

Also confirm the macro mentioned above is active