Skip to Content
author's profile photo Former Member
Former Member

Setting up a SAP S&OP on HANA demo model

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...

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 02:45 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 27, 2013 at 08:15 PM

    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-now-available

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

    Hope this helps.

    Thanks,

    Raghav

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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".

  • author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2014 at 08:11 AM

    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-files

    May be it is useful in your assignment.

    Thanks and Regards,

    Anjali

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.