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: 

BSAK and EKBE tables...

aris_hidalgo
Contributor
0 Kudos

Hello experts,

I am currently trying to modify a report where in it gets a PO's balance from BSAK-wrbtr but instead I need to get it from EKBE-wrbtr. So, is there a link between the 2 tables? Thanks guys and take care!

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Vijay,

You can check the link as Purchasing Document Number and Item Number of Purchasing Document:

BSAK-EBELN and BSAK-EBELP

in EKBE-EBELN and EKBE-EBELP.

Then you ca retrieve EKBE-WRBTR.

Hope this may help you.

Regards,

Lanka

6 REPLIES 6

Former Member
0 Kudos

Hi Vijay,

You can check the link as Purchasing Document Number and Item Number of Purchasing Document:

BSAK-EBELN and BSAK-EBELP

in EKBE-EBELN and EKBE-EBELP.

Then you ca retrieve EKBE-WRBTR.

Hope this may help you.

Regards,

Lanka

0 Kudos

The fields BELNR and BUZEI.

0 Kudos

Hello Lanka,

Can you give me an SQL example if thats not too much to ask. Thanks man!

0 Kudos

Hi ,

BELNR in BSAK is --Accounting Document Number

and

BELNR in EKBE is --Number of Material Document

I think it doesn't work.

Regards,

Lanka

0 Kudos

Hi Vijay,

Select single * from EKBE where EBELN = BSAK-EBELN

and EBELP = BSAK-EBELP.

V_AMOUNT = EKBE-WRBTR.

Hope this may help you.

Please award points for all useful answers.

Regards,

Lanka

Former Member
0 Kudos

BSAK-EBELN and BSAK-EBELP should get you back to EKBE-EBELN and EKBE-EBELP.

Rob