Condition record for a Material

[Former Member]

Hi,

I would like to get the list of all condition records created for a material.

From which table and fields would I get this information.

Thanks in advance.

Regards

Naveen

[former_member197616]

Hi,

Though there is no exact table or report which will satisfy you but may be KONP table some what useful.

Regards,

[Former Member]

Hi,

Please let me know the scenario in which you want to have the tables. May be you are looking for a Material/ Vendor wise condition record created in the system or Material wise condition record or Material/ Vendor/ Plant wise condition record. So to answer you i need a clear scenario for which you need tables and for all the case we need to know the condition type and then we will search for you the condition record,

Hope I will solve your problem.

<h6>Note:- kindly give valuable points to encourage contributors to answer your queries</h6>

Best Regards,

Silky

[JL23]

not an easy task.

it often happens that you archive materials and then the condition records still exist.

OSS note 677449 describes a way and has a program to find such condition records.

you may be able to use this a template to create your own program to find the relevant condition tables.

[Former Member]

Hi Jurgen,

Thanks for the reply..

Here, we are trying to get the condition record for the non archived materials.

They input the material in the selection screen.

Regards,

Naveen

[JL23]

>

> Hi Jurgen,
> 
> Thanks for the reply.. 
> 
> Here, we are trying to get the condition record for the non archived materials.
> 
> They input the material in the selection screen.
> 
> Regards,
> Naveen

I understood this request. But there can be hundreds of condition tables, and as condition tables are usually customized tables SAP has not really a report that can help you.

But this report from the OSS note can be tweaked a little (of course by a ABAPer) and will probably give you the expected result.