JOIN??

[Former Member]

Hi all,

IN this join i am getting document types 'O'.

Now i need to get both types O and J from VBFA table.

what are the required changes...if i place the order type 'J' including type 'O'...i am getting wrong number of records....

SELECT k_{vbeln k}fkdat p_{posnr p}matnr p_{arktx l}charg p_{fkimg p}vrkme

FROM vbrk AS k INNER JOIN vbrp AS p

ON k_{vbeln = p}vbeln

INNER JOIN vbfa AS v

ON v_{vbeln = p}vbeln

AND v_{posnn = p}posnr

AND v~vbtyp_v = 'J'

INNER JOIN lips AS l

ON l_{vbeln = v}vbelv

AND l_{uecha = v}posnv

INTO CORRESPONDING FIELDS OF TABLE gt_doc_details

WHERE p~matnr IN matnr

AND k~fkdat IN fkdat

AND kdgrp IN kdgrp.

The following also not working...

*(v_{vbtyp_v = 'J' or v}vbtyp_v = 'O')*

*AND ( v_{vbtyp_v = 'J' or v}vbtyp_v = 'O' )*

*AND v~vbtyp_v in ('O', 'J')*

SAchin.

[Former Member]

Hi,

Try this

AND v~vbtyp_v in ('O','J')

Regards,

Satish

[Former Member]

Hi,

Don't use ON on v~vbtyp_v

put v~vbtyp_v in where condition

v_{vbtyp_v = 'O' or v}vbtyp_v = 'J'.

Suman