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

[Former Member]

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

[JL23]

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

[Former Member]

Hi Jurgen,

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

Cheers!

L

[mohsinabbasi007]

Dear fiera14 ,

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

[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

[former_member511707]

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.

[Former Member]

Thanks! I'm still need to check if the material is already included in a Contract/ Agreement. Any idea?

[former_member511707]

Hi,

If so then use ME3M report on contracts and schedule agreement by materials.

best of luck,

[Prasoon]

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