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.
Showing results for 
Search instead for 
Did you mean: 

table realtionship

Former Member
0 Kudos

hello guys,

Can u help me with this: how can I relate 2 tables VBRP billing document (field vbeln) and EKKO purchansing document header (field ebeln).

Thanks for your help !!!


Former Member
0 Kudos


Through VBRP table you can find the sales order and based on the sales order you can get the PO number from VBAK-BSTNK, with PO number you can like EKKO-ebeln.

Please let me know if u need any further information.


  • dj

reward for all helpful answers.

0 Kudos

Thanks for your help dj, but I was in a big mistake, what I need is the relationship between RBKP invoice receipt (field belnr) and EKKO purchansing document header (field ebeln). I thinks it makes more sense.

Thanks again dj.

0 Kudos

RBKP is not directly related to EKKO, but you can try if XBLNR has the PO number (depending on how it is configured). You will find the PO number in RSEG-EBELN which is the invoice receipt item field. From that you can get the BELNR number and go to its header tabel RBKP

Former Member
0 Kudos


Use VBFA and pass the approprite Prec doc category.