topic VBUP & EKBE in Application Development and Automation Discussions

VBUP & EKBE

Former Member — Fri, 09 Nov 2007 10:37:11 GMT

Hi all,

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

ekbe_{belnr = vbup}vbeln

AND ekbe_{buzei = vbup}posnr

Problem is that when ekbe_{buzei and vbup}posnr 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

Re: VBUP & EKBE

Former Member — Fri, 09 Nov 2007 10:41:04 GMT

Hi,

Try like this

ekbe_{belnr = vbup}vbeln

AND ekbe_{buzei = vbup}posnr+2(4).

basically you need to offset posnr.

Reward if it helps,

Satish

Re: VBUP & EKBE

Former Member — Fri, 09 Nov 2007 10:46:52 GMT

Hi,

I can't put + in JOIN condition

INNER JOIN vbup as vbup

on ekbe_{belnr = vbup}vbeln

and ekbe_{buzei = vbup}posnr + 2(4)....

Re: VBUP & EKBE

Former Member — Fri, 09 Nov 2007 10:54:28 GMT

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

Re: VBUP & EKBE

Former Member — Fri, 09 Nov 2007 11:06:38 GMT

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