Infoset Join

Former Member — Fri, 27 Jun 2008 15:06:11 GMT

Hello gurus,

i'm trying to join tables VBAP, VBAK, VBFA, VBRK and VBRP in an infoset.

My joining conditions are :

VBRP-vbeln = vbrk-vbeln

VBRK-VBELN = VBFA-VBELN

VBFA-VBELV = VBAK-VBELN

VBAK-VBELN = VBAP-VBALN

I get the message "Table VBAP must be the right-hand table in a join"

I tried to change table joins to join the item tables with vbfa but it doesnot change anything.

Tried to make inner joins, left outer joins but still the same result.

Do you have any ideas ?

Thank you

Re: Infoset Join

Former Member — Fri, 27 Jun 2008 15:21:28 GMT

keep adding them one by one then it proposes automatically.

VBAP, VBAK, VBFA, VBRK and VBRP

if you want to change the conditon(join type ) right click on the link and change it to left outer join or inner join.