Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

>> Issue Not able to find out primary key link between PO tables

Former Member
0 Kudos

Dear guru,

here i am facing an issue in fetching data from Purchase order item condition--

i not able to find out the link between following --

using ME23 u can view a Purchase order.

The PO header details is getting saved on EKKO

The PO item details is getting saved on EKPO

this two table is linked with EKKO-EBELN = EKPO-EBELN.

The PO header condition is getting saved on KONH

The PO item condition is getting saved on KONP

And i am not able to find out using which key i will build up the link beetween ( EKKO and KONH ) or (EKPO and KONP )

so guru pls help me to find out this ....

Thanks & regards

Saifur rahaman

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hello

For items: table KONV with KNUMV = EKKO-KNUMV

3 REPLIES 3

Former Member
0 Kudos

EKKO-KNUMV = KONH-KNUMH

EKPO-KNUMV = KONP-KNUMH

EKPO-EBELP = KONP-KOPOS

EKKO-KNUMV = KONV-KNUMV

EKPO-EBELP = KONV-KOPOS

Former Member
0 Kudos

Hello

For items: table KONV with KNUMV = EKKO-KNUMV

Former Member
0 Kudos

hi,

the konh,and konp are header and variable table but konv also having the same data by linking with konv u can solve your problem.