SBO - Using the SAP supplied AIO_Material_Master template - Extend Material

[Former Member]

Hoping someone can help here.

I am using Using the SAP supplied AIO_Material_Master template. I have read the DataMigration_8_Material_EN_US.doc and could not find anything. How can we extend our Material accross all Plants? What are your suggestions?

Cheers,

[Former Member · Accepted solution]

Hi

I assume you mean in the MARC (Location) segment?

The easiest way is to create a table of your Plants and add it to the Map dataflow for the MARC segment in the Material AIO template. Join your source material table to the Plant table, this will extend your materials to however many Plant rows there are in your Plant table.

[Former Member · Accepted solution]

Not sure if I fully understand as I am new to SBO.

I have created a plant table also within the plant table I have created columns for the different views that would be created under each plant for that Material.

So I am thinking I need to start at the MaterialMasterHeader_E1BPE1MATHEADER_Required.

How should I do this. I was thinking maybe placing everything in a While Loop(???). But not exactly sure how. If I map to this table?? how do I flow through all of the dataflows?

[Former Member · Accepted solution]

Also would I have to update the field Function from 'INS' to something for Update or extending?