topic Re: konp table in Application Development and Automation Discussions

konp table

Former Member — Wed, 18 Jul 2007 14:42:00 GMT

i want to fetch condition types & its related data from KONP table for an purchase order smartform.please tell me the link between KONP & EKKO or any other link between PO tables & KONP.please help.

Thanks&Regards

srinivas k

Re: konp table

Former Member — Wed, 18 Jul 2007 15:17:12 GMT

Srinivas,

From EKKO, get the condition document number KNUMV and based on that search the KONV table and get the field KNUMH. Use these KNUMH values to seach KONP records.

Rgds,

Naren

Message was edited by:

Naren Someneni

Re: konp table

Former Member — Thu, 19 Jul 2007 03:04:44 GMT

hope this helps

EKKO-KNUMV = KONP-KNUMH

KONV-KNUMV = VBAK-KNUMV and

KONV-KPOSN = VBAP-POSNR

Link between EKKO, EKPO and KONP

KONP is conditions table.

If we need the conditions(prices) of a purchase order, we can get it from EKKO, EKPO & KONV.

1. Extract KNUMV from EKKO.

2. Using EKKO-KNUMV - Extract conditions from KONV where KONV-KNUMV = EKKO-KNUMV.

3. We can find item prices where KONV-KPOSN = EKPO-EBELP.

IMPORTANT INFO

KONV and KONP tables are both conditions tables. These tables are used when you want to find e.g : the Basic price value or excise duty values (just to name some ) .

These tales store the values based on the document condition number.

The Document Consition number(KONV-KNUMV) is number that gets generated whenever a PO or a sales order gets created. So this KNUMV is the link between the PO or the sales order. The KNUMV gets stored in KONV as well as the header tables of Sales order and Purchase order.

Let me give you an example: Incase you have a sales order number say 1206 now for this you want to create to know what is the Basic price: - so you would go to VBAK get the KNUMV of 1206 , for the KNUMV fetched go to KONV and give this KNUMV you will get all the conditions for this sales order. Same is the case with PO's also.

Now KONP also stores the conditions can be used with access sequences eg a003 or a055 etc. you cantake the KNUMH value from these tables and get the rate from KONP.This table only stores the rates and not the values. i.e KBETR value and not KWERT value.

HI,

1)EKKO-KNUMV = KONV-KNUMV

= KONP-KNUMH

= KONH-KNUMH

= KOMV-KNUMH (THIS IS A STRUCTURE)

2)EKPO-EBELN = KOMV-KPOSN

= KONP-KOPOS

= KONV-KPOSN

I hope this answers your question

Reward pts iffound usefull :)

rewards

Sathish

Re: konp table

Former Member — Thu, 19 Jul 2007 04:06:51 GMT

Condition types & its related data from KONP & EKKO or any other link between PO tables

"Can  be  linked  like  this  
EKKO-KNUMV = KONV-KNUMV
EKKO-KNUMV = KONP-KNUMH
EKKO-KNUMV = KONH-KNUMH
EKKO-KNUMV = KOMV-KNUMH (THIS IS A STRUCTURE)

"or else  like this
EKPO-EBELN = KOMV-KPOSN
EKPO-EBELN= KONP-KOPOS
EKPO-EBELN= KONV-KPOSN

reward points if it is usefull ....

Girish

Re: konp table

Former Member — Thu, 19 Jul 2007 05:26:43 GMT

You can link

EKKO-KNUMV to KONV-KNUMV and EKPO-EBELP = KONV-KPOSN

this will fetch few pricing related condition types values/amounts

But to get the data like PO TAXES you have to search for the Access sequence related condition tables (starting with A* like A003, A012 or A353 etc) related to that PO and have to take the KNUMH field from them and to use the same KUMH to KONP-KNUMH and using the related KSCHL fetch the data from KONP table

Reward points for useful Answers

Regards

Anji

Re: konp table

Former Member — Thu, 19 Jul 2007 06:06:13 GMT

Hi,

For purchase orders:

EKKO-KNUMV -> table KONV.

Pls reward points.

Regards,

Ameet