Skip to Content
0

Data Migration for Recipes, Reports

Aug 10, 2017 at 11:34 PM

320

avatar image
Former Member

Hello Experts,

My client is on SAP and has existing SAP Materials, Bill of Materials, Master Recipe, Product Specification Reports (which are in form of documents). They are not using SAP Recipe Development or WWI, but want to come on it.

My Questions:

1. I am sure we will create PLM Specifications (with their Property Trees) and link to existing Material Master using some ABAP program. Is there an existing Program to do this ??

2. As far as existing SAP Master Recipes, should we also create corresponding Recipes in Recipe Development. I am assuming this ABAP Program will be very complicated as we will have to create Stages, Operations, Actions..., link Resources, link Ingredients to Stages/Operations/ Etc.....etc..etc.., Is there a existing ABAP Program by which we can do this ??

3. As you know there whole Product Specification Report are in Paper. So should we proceed creating WWI Templates (which mimic the information which is on Paper) and create brand new report output using WWI for the Specifications we migrate.

The whole assumption is in future the above Information (Specifications, Recipes, Reports) can be revised that why its important to migrate all the above.

Please inform if we are on correct path for what I have written above, as far as your experience with your clients existing data ???, Thanks Rakesh

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mark Pfister
Aug 14, 2017 at 12:02 PM
0

Dear Rakesh,
As far as I understood it your client wants to:

  • move from Recipe Management to Recipe Development
  • store the data of the "Product Specification Reports" (now unstructured data in Documents) in the Specification Database (CG02)

This sounds like quite the project you have to tackle.... :)

1. I am sure we will create PLM Specifications (with their Property Trees) and link to existing Material Master using some ABAP program. Is there an existing Program to do this ??

No - there is no ABAP program existing to load specification data. But you can use the SAP tool called OCC (Open Content Connector) - which has the so called "Data Editor" functionality to load all kinds of data into the specification database. I would highly recommend using this tool - and would strongly advice against using custom ABAP reports. You can find plenty of information about OCC here in the EHS forum. If you have more questions regarding data migration for the specification database please use the EHS forum linked above.

3. As you know there whole Product Specification Report are in Paper. So should we proceed creating WWI Templates (which mimic the information which is on Paper) and create brand new report output using WWI for the Specifications we migrate.

Yes - WWI is the best tool to create all kinds of documents for specification data.

Please inform if we are on correct path for what I have written above, as far as your experience with your clients existing data ???

This is a question I can not answer - I would need a lot more detail then a one sentence project outline.

Hope this helps

Mark

Show 5 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Mark. Thanks for the reply, but my Client is Not using Recipe Management or Recipe Development. They are simply on SAP PP-PI. Please inform how to migrate their existing (i) SAP BOM; (ii) SAP Master Recipes (iii) Product Specification Reports (in form of Docs). Also as in future Product Specification Reports will be created using WWI, do the existing reports need to be also migrated in WWI layout and recreated. Assumption is all Objects (whether BOM, Master Recipe, Reports..) can be revised in future. Please throw light on Data Migration Steps for a client who is on SAP PP-PI and wants to move on SAP Recipe Development.. Also thanks for OCC Info. I will explore further. Thanks Rakesh

0

Hi Rakesh,

 (iii) Product Specification Reports (in form of Docs).

Hard to believe that the documents were all hand written without being based on any structured data. But if that is the case there is no other way then manually typing the data into the Specification Database... Another option would be to use HANA Text analysis - maybe even with AI - to extract the data if the data volume is to huge. But the development cost would most likely be to high for such a one time task.

You would first need to decide what information contained in the these document needs to be stored in which properties of the property tree (or other parts of SAP), and define additional properties if needed.

Please throw light on Data Migration Steps for a client who is on SAP PP-PI and wants to move on SAP Recipe Development... 

I have had to less exposure to PP-PI to provide a detailed answer.
However I would think that they might still want to use some parts of PP-PI for example Process Controlling. So you might need to set-up / build an interface RD -> PP-PI after the migration.


Kind Regards

Mark

0
Former Member

Hello Mark, Thanks but your reply, partially answers my question:

Again: (i) Is it normal for clients who is only on SAP PP-PI (Master Recipes), and who wishes to move to SAP

Recipe Development, that they create corresponding Recipe Structures in SAP RD. If yes do they create some standard ABAP programs or use some standard available programs . Or is it normal that they only create structures in RD for new Products only and not worry about existing recipes..what has been your client experience, thanks Rakesh

0

Hi Rakesh,

Sorry I can't help you with this part of your question. I have not done enough PP-PI RM / RD projects. The ones I have done hat RM and PP-PI in place. But this is >10 years ago and I can't recall all the details.


I'm mainly in the EHS Area and therefore tried to answer the questions related to the specification database.

Kind Regards

Mark

0

Hi Rakesh,

SAP PLM Recipe Development is a Webdynpro based application which when implemented comes with a set of standard front end portal pages and also backed webdynpro code. Users access the front end screens to create the necessary Recipes and carry out the transactions activities.

It is standard practice to move the legacy master data like Recipe, Formula, components into new system with SAP provided data migration tools. For that tools can be used you require to cleanse the data and prepare the data into a suitable format. For the new implementation you need to define the required WWI template for product specification reports.

Thanks and Regards

Jayakumar

0
Christoph Bergemann Aug 31, 2017 at 06:51 AM
0

Dear Rakesh

1:) before you start to use "EHS" you should ask yourself: what is the best approach? This approach depends clearly on your needs. And here I am not sure regarding your needs. SAP EHS is used e.g. to create "MSDS", "Label", take care dangerous goods aspects etc.

If you create "chemistry" then services as SERC / SERD might be helpful

Now looking on your specific topics:

Topic 1: 1. I am sure we will create PLM Specifications (with their Property Trees) and link to existing Material Master using some ABAP program. Is there an existing Program to do this ??

To use a "specification" you must prepare "basic EHS customizing". Here the amount of work depends on your needs (e.g. do you need MSDS?). Assuming you need only "primitive" customizing: i am pretty sure that some "chemical" aspects have to be supported. So the use of "SERC" should be checked. At least: you should not try to do EHS set up with out experience to do so.

You would generate e.g. REAL_SUB and this you would then link to Material Master. OCC is one option for load. By standard: this is done in many cases using "EHS standard import". And it depends on your needs. E.g. if we talk about "only" 1000 materials could do the link "manually" wihtout help of ABAP etc.

Topic 2: Recipe Development: you need "good experience" in using Recipe Development. This is a "big tool" You have listed the most crucial topics" Stages, Operations, Actions..., link Resources, link Ingredients to Stages/Operations/ Etc.....etc..etc..,"

There are as blogs here which you should read on "recipüe development". As we are not using this tool: i can not judge what is the best to do "load" (but i assume LSMW etc. options are existing)

Topic 3: If you have the need to create "MSDS", "Label" etc. then WWI is a "must". BUt here once again "SERC" comes in place. EHS is"empty" (no content). Yout ca not cretae a WWI document without content (phrases etc.)

You will find many threads here regarding: "how to start an EHS project" but not that many (may be <10 threads) "how to start with Recipe Development"

C.B.

PS: Check these threads/blogs

https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=447463324

https://wiki.scn.sap.com/wiki/display/PLM/Recipe+Development+Knowledge+Space

https://archive.sap.com/documents/docs/DOC-74772 (A MUST TO READ!)

PSS: keep in mind: SERC or SERD option assumes: you do are using SAP standard data model (e.g. REAL_SUB etc. etc.).

Share
10 |10000 characters needed characters left characters exceeded