Condition record number

[Former Member]

Hi all,

How can i get the condition record number if i know only the material number.

Regards,

Usha

[Former Member · Accepted solution]

Hi,

First go to VBAP,enter MATNR.But here you will get multiple entries.It is advisable to use some specific filteration criteria here.

Anyway for the desired sales order,input sales order number VBELN to VBAK.Get document condition KNUMV.Input this KNUMV to KONV and get the condition details.

Reward points if useful

Regards,

Amrish Purohit

[javed_ihsan]

Hi

If you are looking for conditions records for transaction data then you can get it:

1. Frist get the sales document numbers (sales order, billing documents) for the material form table VBAP/VBRP

2. For those sales documents (sales orders, billing documents) get the condition records from header table (VBAK/VBRK).

3. Then goto KONV to get the details about conditions data.

If you are looking for condition record numbers for your master pricing conditions then you can get it easily from the relevant table (where material code exists)

Hope this is what you are looking for.

Regards

Javed

[Former Member]

Hi Usha,

Can you elobrate the question plz.

Rgds,

Ajinkya

[Former Member]

Hi Ajinkya,

Thank you for the reply.

I need the field SUGRD (SUbstitution reason) which is displayed in VB13 for a perticular material. The inputs are material number, sales org and plant.

Thanks,

Usha

[Former Member]

Hi Usha,

You can view the table KONDD (se16) and enter the desired material for which you want to find the condition record no.

Hope this is what you were looking for.

Reward if it Helps you.

Rgds,

Ajinkya

[Former Member]

HI Ajinkya,

I am aware of this. But this will give me multiple entries. This is the reason i needed the condition record number.

Will all the entries selected have the same substitution reason ?

Thank you,

Usha

[Former Member]

Hi Usha,

This table will give you multiple condition record nos. for a single material with different SUGRD.

Rgds,

Ajinkya