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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

What is the link between EKPO and KONP tables

Former Member

‎10-13-2005 12:01 PM

0 Kudos

Dear All,

Please I want to access KONP table based on purchasing document number(Ebeln).

I have to pick kbetr field from konp and I know the kshcl field.

But to access the Konp table I have only EBELN with me.

Regards

Mave

3 REPLIES 3

Former Member

‎10-13-2005 12:09 PM

0 Kudos

hi,

EKKO-KNUMV = KONP-KNUMH

cheers,

sasi

Former Member

‎10-13-2005 12:11 PM

0 Kudos

Hi Mave,

Can you please clarify a little more,can u specify the tables name that you are using to achieve join with Konp table, may be some other fields , not ebeln will be used. tell us the other table names

Former Member

‎10-13-2005 12:21 PM

Hi Mave ,

There is a table <b>A016</b> which links Purchase Order Items to condition record number KNUMH. From A016 you can select a record corresponding to PO Number & Item Number. Using this KNUMH you can select from KONP.

For header conditions you can use A019.

Cheers