konp table

[Former Member]

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

[Former Member]

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

[Former Member]

Hi

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

<b>I hope this answers your question</b>

<b>Reward pts iffound usefull :)</b>

rewards

Sathish

[Former Member]

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

"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

[Former Member]

Hi

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

<b>Reward points for useful Answers</b>

Regards

Anji

[Former Member]

Hi,

For purchase orders:

EKKO-KNUMV -> table KONV.

Pls reward points.

Regards,

Ameet