Setting up a SAP S&OP on HANA demo model

[Former Member]

I am tasked with setting up a demo model to show the functionality of S&OP on HANA.

Can I actually do this with S&OP as a 'standalone' system, by manually loading master data (plants, products etc) and transaction data (stocks, sales etc) into S&OP?

Thanks for any advice on this...

[Former Member · Accepted solution]

Hi Bob,

You first of all need to set up the data model in the S&OP tool so that the key figures and characteristics are set up and defined.  This is described in the Model configuration reference guide https://websmp108.sap-ag.de/~sapidb/011000358700000479482013E.

You can now set up files to load the data.  For each data object you need a CSV file where the first row is the name of the table field in S&OP.  Each subsequent row is a line of data corresponding to the sequence of fields in the first row.  You also need to create an XML file that describes the manifest of the data you are loading.  This describes the file path and file name and details of the CSV files to be loaded.  An example is given here:  http://wbhelp.sap.com/saphelp_sop/web_20_sp03/support.html#manifest_file.html

Finally, both the XML file and the CSV files should be put into a single ZIP file.  You load this file from the S&OP web client using the data path "Data Integration > Data Import".

Getting the XML manifest files set up correctly and ensuring that the CSV files have the correct column headings is of course critical for this to work!

Thanks

[Former Member]

Hello Bob,

In my blog I have given details of  master data - Product, BoM, to be integrated using file,

Below is the link of it.

http://scn.sap.com/community/scm/sop/blog/2014/01/01/sop-powered-by-hana--data-integration-with-file...

May be it is useful in your assignment.

Thanks and Regards,

Anjali

[former_member217157]

Hi Bob,

If you want to  demo of S&OP on HANA, you can reserve one of the S&OP demo systems (If you are SAP internal), or most of our Partners have a Partner system which they use to demo S&OP and also do Custom Demos.

Other option is the 3 Day S&OP trail available on Marketplace. http://scn.sap.com/community/scm/sop/blog/2013/08/22/sap-sales-and-operations-planning--free-trial-n...

You can use this to demonstrate the functionality of S&OP on HANA solution.

Hope this helps.

Thanks,

Raghav

[Former Member]

Raghav,

Thanks for your reply.

Yes, we are setting up our own system here.

I really want to demo the functional aspects of the S&OP solution (demand planning, RCCP etc) rather than spending too much time on integration aspects.

So, ideally I want to be able to load master data and transaction data either manually or via flat files.

Can master data such as plants, products be set up manually in S&OP?

Can data such as sales history be loaded via flat files? (maybe akin to loading BW Cubes via flat files) - if so, is there any guidance you can recommend?

Thanks for any further help you can provide...

Regards, Bob,

[Former Member]

Hello Bob

It is my understanding that you can set up S&OP as a "standalone" system in the sense that you do not need to have it connected directly to any other systems.

To do so, the first steps are no different then if you would have SAP ECC or SAP APO directly connected - you defined the  time profile, attributes, planning levels, key figures, planning area etc. Once done, you activate and then can load the time series, master data and transactional data via CSV flat files into S&OP.

I guess you could use your BW system to create those flat files. Also, keep in mind that in order to load those flat files you need to have them packed into a .zip file together with the manifest.

Hope this helps,

Thanks,

Jens

[Former Member]

Jens,

Thanks for this reply.

But now I have some basic questions:

- how do I know the structure of the flat files?

- what do you mean by the 'manifest'?

Is there a key document which describes how this data loading from flat files can work?

Regards,

Bob.

[Former Member]

Hello Bob

In your case, if I understood you correct, you want to build
the system and then load all time periods, master data and key figures via flat
files. To do so, the compressed file of .zip format needs to contain the
manifest and the data file.

The data has to be a .csv file. For master data, you can see
the required headers in the configuration section under “Master Data Types”.
You should include all required attributes as well as all those you want to
load. I believe you should follow the same order.

The time profile file always contains the period ID, start and
end date, period description as well as parent ID. It has to be loaded before
you load the key figure data.

When loading key figures, keep in mind that only store key
figures are loaded at the key fields of their base planning level as well as
the date field.

The manifest is an .xml file. It tells the system how to
handle the data imports, e.g. the .csv file name, the object you are loading, delimiters,
Planning Area, Scenario, etc.

A manifest pretty much represents a batch run.

Lastly, I am afraid but I don’t have a document describing
those steps myself.

The above are my notes from the training class I took.

Hope this helps,

Jens

[Former Member]

Jens,

Thanks for this.

Can you reply with a simple example of a csv file and manifest file for the loading of, for example, a product master record.

Thanks, Bob.

[Former Member]

Hello Bob

I did find some examples for a file to upload product master data (csv) and the corresponding manifest file (xml) and attached them. As you see, it is a simple example but I hope it gives you an idea. Since the product master file had some data I could not share I changed it a little, but you should get the idea.

In my example I have something like a product number for the ProductID but you could have also a more verbal description there, e.g. the same entries for description and ID. Of course he file would be as big as you need it for the data you will have to load. That would be up to your design.

As for the manifest, you could also load multiple master data files using the same manifest, e.g. customer data, etc. I think it is probably best if you keep logical blocks together, e.g. all demand related master data in one manifest and all supply related master data in another. Or even more ganular if, for example you load data from multiple feeds for demand related data, e.g. CRM data, external data, ect.

Regarding the structure of the manifest file, I would start using one you have and adjust it - so maybe you can start out with this one. Should you run into problems or have questions there, I would suggest you open a new post as this would then be better to track. Just a suggestion ... I certainly will keep helpingas much as I can, even though if I am stll learning about manifests myself.

Oh, and don't forget to zip them up prior to loading the data to the system, which I believe still has to be done via the old UI.

Hope this helped?

Best of luck,

Jens

PS:

Uploading a csv file format is not allowed so here is a screenshot of the example.

When you have created your file name, make sure you enter that exact name into the manifest where it says "filename".