sales doc which used the condition type

[Former Member]

Hi friends,

i want a list of sales document for which a specific condition type? how to go about it?which tables?

regards,

anand

[Former Member · Accepted solution]

There is a procedure to find the Sales order for specific Condition types. It is lengthy and cumbersome, if this practise is regularly followed then better to create a query.

The normal procedure is as below -

Goto SE16 - Table name KONV.

Put the Condtion type in KSCHL

Get the Doc condition number from KNUMV.

Put KONV-KNUMV into VBRK-KNUMV

Get the VBELN from table VBRK

Next goto Table VBFA

Put VBRK-VBELN into VBFA-VBELN

along with VBTYP_N as M and VBTYP_V as C

and get VBFA-VBELV that is the Sales Order.

Thanks.

[Former Member · Accepted solution]

Go to SE16 and table name KONV

Enter Condition type in the selection screen and execute. Note the doc condition number knumv

Copy the document cond. Num and go to table VBAK-KNUMV. Enter the number in VBAK and you'll get the list of sales doc.

[csaba_szommer]

You can create a query in SQVI using data tables VBAK, KONV - they are linked to each other by field "KNUMV".

In KONV-KSCHL you can enter your selection criteria and run the query.

You will get duplicates if your conditon types appear more than once in one sales order but using excel pivot table you can get rid of those duplicates.

Else you can write a short program for this purpose...

Edited by: Csaba Szommer on Jan 11, 2011 11:28 AM