Fetching condition record(knumh)

[Former Member]

Hi All,

I have following fields

sales order

distribution channel

division

customer group

and condiotion type as ZMGD

Based on above fields.. i need to get 'condition record(knumh).

I have checked all the whereused list for knumh.. but could not get correct fetching criteria?

If any body has idea please just tell me which table takes all these and gives unique condition record

[Former Member]

Hi All,

I have following fields

sales order

distribution channel

division

customer group

and condiotion type as ZMGD

Based on above fields.. i need to get 'condition record(knumh).

I have checked all the whereused list for knumh.. but could not get correct fetching criteria?

If any body has idea please just tell me which table takes all these and gives unique condition record

[Former Member]

Hi Shruthi,

Please check the tables VBAK and VBAP. You can write a join condition on these tables with respect to the field VBELN (Sales Document). You find the field KNUMH in VBAP.

Regards,

Swapna.

[Former Member]

Based on sales order, distribution channel, division and customer group we can get knumv from vbak.

all the fields are prersent in VBAK.

based on knumv we can select knumv kposn kbetr kpein kumza kumne from konv table based on knumv and kschl (condition type)

[Former Member]

thank you.It worked

[viquar_iqbal]

Hi

Please check this table A153

It has all the fields you require

Thanks

Viquar Iqbal

[Former Member]

Hi,

KNUMH presents in VBAP table .

Regards,

Manoj Kumar P

[Former Member]

Hi,

Check this way..

VBAK-KNUMV = KONV-KNUMV.

From KONV fetch the KNUMH field.

[Former Member]

Table A118 - if the scales of the prices are only dependent on material number.
For other combinations you need to know the right pricing table (A***)