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: 

VBUP & EKBE

Former Member
0 Kudos

Hi all,

I am having trouble while trying to JOIN these two tables. Condition should be:

ekbebelnr = vbupvbeln

AND ekbebuzei = vbupposnr

Problem is that when ekbebuzei and vbupposnr are compared SAP returns

sy-subrc = 4 because these two fields are not the same leght and it seems like there are no records that satisfy this condition, alltought when i go to SE16 and make a selection based on these conditions in table VBUP, i do get some data as a result.

Please help me to make this JOIN working... if you know how!

Thanx a lot in advance!

Maja

4 REPLIES 4

Former Member
0 Kudos

Hi,

Try like this

ekbebelnr = vbupvbeln

AND ekbebuzei = vbupposnr+2(4).

basically you need to offset posnr.

Reward if it helps,

Satish

0 Kudos

Hi,

I can't put + in JOIN condition

INNER JOIN vbup as vbup

on ekbebelnr = vbupvbeln

and ekbebuzei = vbupposnr + 2(4)....

Former Member
0 Kudos

hi,

i think there isn't a relation between vbuk and ekbe.

You can get the relation between vbup -> ekkn -> ekbe.

Regards, Dieter

Message was edited by:

Dieter Gröhn

0 Kudos

is there any chance to work arround this using GROUP BY???