Automate

 View Only
Back to discussions
Expand all | Collapse all

Template for reading material determination (material substitution) data from SAP

  • 1.  Template for reading material determination (material substitution) data from SAP

    Posted 10-13-2021 05:34
    Hi WS Community,

    Is there existing script for reading material determination (material substitution) data from SAP? T-codes what we are currently using for checking material determination in SAP are YOLDMATSEARCH, YSDMATDETREPORT and ZREPMATDET. Write script we already have and it's using VB11 to create material substitution chains to SAP. 

    Thanks for your comments!

    ------------------------------
    Liisa Hurula | Replacement Master Data Specialist
    Metso Oy | +358407382293
    ------------------------------


  • 2.  RE: Template for reading material determination (material substitution) data from SAP

    Employee
    Posted 10-13-2021 11:31
    Hi Liisa

    No templates, but if I understand what you need correctly, you can find the tables here:  https://answers.sap.com/questions/8894784/database-table-for-material-determination-records.html

    For me, I had material determination type A001, so I would use tables:
    • KOTD001 with 001 corresponding to A001 - yours may be different as the article above suggests
    • KONDD with the material substitution data
    • MAKT to get the descriptions for the materials - you can join with material entered and then add the table again to join with material substituted

    Hope this helps,
    Sigrid


    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message