T code and any other way to upload sales history & inventory into planning table SOP SAP ECC

[Former Member]

Hi Team,

I am new in Sales & operation planning. Actually client want to load sales history and inventory levels by plant/SKU & country each week into planning table into SAP ECC using external file excel or text in S&OP. Please suggest is there any tcode & any other way to do the same.

Please suggest.

Thanks,

Sachin

[claire_yang]

Hi,

There is no transaction to automatically upload data from a excel file to an infostructure of SOP, however, the IDOC SOPGEN01 and message LIP072 are very useful and widely implemented with this purpose by our customers.

You can use transaction WE60 for IDOC documentation and the following note may also be useful:

929410 - Planning: Data transfers using IDOC incorrect

BR