Skip to Content
avatar image
Former Member

How to identify massively materials without Source List & Contracts at the same time.

Hi All,

I'm currently struggling with my current material portfolio. I have 2000 active materials and some of them are not having their source list and not including in a contract.

1) I was wondering if there is a way that I can massively make a check and identify which materials are missing their SL & Contract instead of check one by one.

2)Furthermore, I receive new materials every week, so sometimes I can't identify a new material. Is there a way to include those new materials in this check as well?

Cheers.

L

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Sep 25, 2017 at 06:25 AM

    Hi,

    Use SE16/SE11

    1. Use EORD table to find out all material with source list, contract.

    2. Use Mara table to check on "create on" date for your new material.

    If those don't meet your requirement, ask ABAPers to do your own custom report and tell them what you need.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 25, 2017 at 11:15 AM

    Dear Former Member ,

    If you want to see the list of material having Source list indicator just then just go to the table Marc and select X in the field KORDB as mentioned in below screen shot.

    For new materials you can run the same report but not put X and give the creation date so that only filter data can be fulfilled.

    If you want to get the detail of those materials whose only Purchasing Source List is created then go to the table of EORD and do as in above screenshot in-case of Source List Indicator of materials.

    Best Regards

    Mohsin Abbasi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank Mohsin!

      Do you know how can I include a second condition to check if the materials are included in a contract/agreement?

      Cheers

  • Sep 25, 2017 at 02:43 PM

    There is no such report in SAP.

    For one time checks simply download your material numbers from MARC table and another download from EORD table (source list) and once again a download from EKKO and EKPO for the contract.

    Then analyse it in Excel using the formula VLOOKUP to see if the MARC material number has a corresponding entry in EORD and EKPO

    Alternative you can create individual queries in SQVI using the left outer join functionality to list all MARC which have no EORD record.

    If you need this weekly then ask your ABAPer to create a Z-report for you with this kind of information.

    If the source list is so important for you then you should certainly set the source list requirement to avoid creation of orders without source list.

    From my point of view are Excel and quickviews rather complicated (but not impossible) as you also need to keep in mind that you may have records in the source list that are no longer valid today. Or contracts that are already completely fulfilled and also outside the current validity period

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Jurgen,

      first of all, thank you so much! I could not agree more. I will try both suggestions.

      Cheers!

      L

  • Sep 23, 2017 at 06:17 PM
    -1

    Hi,

    If you want to display the list of materials with source list, you may check it in ME0M transaction or in EORD table.

    If you want a restriction in purchasing based on source list availability, use the "source list" indicator in purchasing view in material master.

    Regards,

    Prasoon

    Add comment
    10|10000 characters needed characters exceeded