cancel
Showing results for 
Search instead for 
Did you mean: 

Mass Data Loads into SNP Key figures

Former Member
0 Kudos

Hi All,

Does anyone have any knowledge of doing mass data uploads agains key figures (e.g. Safety Stock Planned). There is a transaction /SAPAPO/TSKEYFMAIN - Mass maintenace of Time Series Key figures, but this does not give me the option of loading thousands of materials at one time. Any thoughts would be appreciated.

Rumi

Accepted Solutions (0)

Answers (2)

Answers (2)

aparna_ranganathan
Active Contributor
0 Kudos

Rumi

As Kaushik has mentioned you can upload data from info cube to planning book for time series key figures and you can read data maintained in excel and upload it to your info cube.

But i have a question. Why cant you maintain safety stock in APO product master for the material branch and using macro read data from product master and populate safety stock key figure ? Acutally you can maintain the safety stock in R/3 and as soon as you CIF material to APO the safety stock field in product master will get populated and you can read that using a macro .

Thanks

Aparna

Edited by: Aparna.Ranganathan on Dec 9, 2010 6:17 PM

Former Member
0 Kudos

Apama,

We are using the time-based safety stock method (MB) and there are often times when the Safety Stock - PLanned key figure with change from week to week. Therefore it would not make sense to automate this process via a macro. It really needs to a process that allows the planners to maintain the data in a file and then upload into SNP.

Make sense?

Rumi

Former Member
0 Kudos

Hi,

The transaction mentioned by you is only for time series key figure updation but most of the SNP key figures are order series.Hence the program will not work.

Now it depends on the which keyfigure but overall you can fill the info cube with data from excel file and then upload the same data to planning area and release to snp planning area.This is basically for forecast but once this is done you can see the data in forecast keyfigure and use a macro to copy the same data from forecast key figure to any other keyfigure.

This is a work around process.Hope this will help.

Regards,

kaushik