cancel
Showing results for 
Search instead for 
Did you mean: 

Table lookup from MDM to ERP

Former Member
0 Kudos

When receiving files of new materials from vendors, the file only contains 6-7 key fields. As we all know the updating of material master in SAP needs updating about 100 fields.

How can customizing tables (material group, product hierarchy, materiall group 1, 2,3 etc.) in SAP ERP be replicated to SAP MDM.

Can anyone tell me how the flow between the systems are according to this?

BR,

Terje

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

OK

Former Member
0 Kudos

Hi Terje

we also had the same scenario and this is how we resolved this.

Let the vendor submit item details via Portal.After he saves the details it will create a record in Item repository and trigger a workflow in MDM. make the record as check out and perfom all validation steps of MDM.add approve step and assign to user who will be providing the remaining details.You can also have assignment step wherein some of the field values are populated based on the assignment expression.

Once the record is updated and approved check in the record.

hope it helped.

regard

Ravi

Former Member
0 Kudos

Hi Terje,

You are correct with the requirement that when receiving new material from vendors only few fields are populated.

The other fields can be Populated using Workflows.

- You need to design your repository in such a way that the main fields from your different material views which are text or numeric fields come under the main table fileds in MDM

- The check table fields become your Lookup table Filed sin MDM such as Material type,Material group 1,2,3,4,Product hierarchy etc.

- These fields can be enriched for the material master rec by specific Roles as defined in MDM Through Workflows

- For this you need to create an MDM workflow defining the entire material master maintainence process flow.

- You will have different data custodians you will enrich these field values for the records.

- The Workflow will move from one role to the another and each one will perform his task.

- We can use Portal to have single sign On.

Another Solution could be to Extract the records with these values already filled and then populate the entire load in MDM and when there are change sin these then we can load the delta.

Hope it helped

Kindly reward points if found useful

Thanks

Simona

Former Member
0 Kudos

Hi Terje,

The Lookup tabels will be filled first.

To extract lookup fields data, you have to use MDMGX transaction.

After that main table needs to be filled.

For that MDM_CLNT_EXTR .

This completes the inbound process.

Hope this helps,

+ An