what is relation between vbap table and konp table

[former_member418237]

.i want pick the condition value from konp table aganist condition type on the sales order

[Former Member]

Ramana -

If you are looking for Query option then use SAP standard Logical Database VAV in your Query .It is join of VBAK, VBAP and KONV table.You just have to Put Sales order number and it will display all conditions used in your sales order.

Regards

Amit

[former_member184080]

Hi Ramana,

I request you to put some efforts before posting it. If you want to get condition type values, you have take VBAK- KNUMV and use same at KONV table, you will get list of condition types being used in that sales order with values.

Regards, Sai Krishna.