Automate

 View Only

  • 1.  Query to show creation date of plant view for Materials

    Posted 13 days ago

    Hi all,

    I want to create a query that will show the creation date of the plant views for the materials that I give in as a criteria. Mainly the information that SAP shows when clicking on the blue "i" in a material in MM03. You can then see when the plant views were created for the relevant plant.

    I was working with tables MSTA and MARC, but for some reason I only get to see the different dates, but I can't find a way to show the concerned fields (like MRP, Accounting etc.). Anyone with more experience that can help to get this in a report?

    Thanks a lot,

    Kind regards,

    Petra Vanhouwelingen
    Akzo Nobel Coatings



    ------------------------------
    Petra Vanhouwelingen
    Akzo Nobel Coatings

    ------------------------------


  • 2.  RE: Query to show creation date of plant view for Materials

    Employee
    Posted 12 days ago

    Hi Petra,

    Not 100% sure I understand what is missing, but I did find a table with the description of the status field

    Simple example attached.

    Hope it helps,

    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------

    Attachment(s)

    xlsx
    MM Statuses.xlsx   6 KB 1 version
    Qsq
    MM Statuses.Qsq   82 KB 1 version
    Original Message