topic Re: Fetching condition record(knumh) in Application Development and Automation Discussions

Fetching condition record(knumh)

Former Member — Thu, 12 Feb 2009 12:48:50 GMT

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

Re: Fetching condition record(knumh)

Former Member — Thu, 12 Feb 2009 12:56:38 GMT

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.

Re: Fetching condition record(knumh)

Former Member — Thu, 12 Feb 2009 13:02:20 GMT

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)

Re: Fetching condition record(knumh)

viquar_iqbal — Thu, 12 Feb 2009 13:02:21 GMT

Please check this table A153

It has all the fields you require

Thanks

Viquar Iqbal

Re: Fetching condition record(knumh)

Former Member — Thu, 12 Feb 2009 13:11:46 GMT

Hi,

KNUMH presents in VBAP table .

Regards,

Manoj Kumar P

Re: Fetching condition record(knumh)

Former Member — Thu, 12 Feb 2009 13:16:22 GMT

Hi,

Check this way..

VBAK-KNUMV = KONV-KNUMV.

From KONV fetch the KNUMH field.

Re: Fetching condition record(knumh)

Former Member — Mon, 14 Sep 2015 11:50:59 GMT

thank you.It worked

Re: Fetching condition record(knumh)

Former Member — Mon, 24 Aug 2020 14:55:54 GMT

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***)