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: 

Purchase order EKKN/EKBE tables

Former Member
0 Kudos

Hi,

I m creating a report based on purchase order. I'm getting sequence number from EKKN table and then getting the invoice details from EKBE table using where clause on EBELN, EBELP and ZEKKN(Seq number) fields.

My question is in some cases in EKBE table, 00 seq number is populated, mostly for VGABE = 1 (Mat doc number) or VGABE= 9(Service entry sheet). But this 00 is not in EKKN table. So in that case i miss these invoices in my internal table, bcoz i'm querying based on seq number, and 00 is not there.

Bcoz you cann't use 00 seq number at the time of PO creation.

Can any body tell me how and in which senarios seq no (EKBE-ZEKKN) field is being populated, so that i can write the code accordingly....

Thanks,

1 REPLY 1

naimesh_patel
Active Contributor
0 Kudos

Start your selection query from EKBE first and then go to EKKN based on the EBELN, EBELP & ZEKKN.

Regards,

Naimesh Patel