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

Table lookup from MDM to ERP

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2008 at 01:33 PM

    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 .

    MDM_CLNT_EXTR

    This completes the inbound process.

    Hope this helps,

    + An

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 11, 2008 at 06:54 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 11, 2008 at 08:41 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 30, 2011 at 01:10 PM

    OK

    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.