11-09-2007 10:37 AM
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
11-09-2007 10:41 AM
Hi,
Try like this
ekbebelnr = vbupvbeln
AND ekbebuzei = vbupposnr+2(4).
basically you need to offset posnr.
Reward if it helps,
Satish
11-09-2007 10:46 AM
Hi,
I can't put + in JOIN condition
INNER JOIN vbup as vbup
on ekbebelnr = vbupvbeln
and ekbebuzei = vbupposnr + 2(4)....
11-09-2007 10:54 AM
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
11-09-2007 11:06 AM