JOINs

[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.

SAchin.

[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.

SAchin.

[Former Member]

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' or v}vbtyp_v = 'O')

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.

[Former Member]

Hi madhu,

OR will not work IN condition...

sachin.

[Former Member]

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' or v}vbtyp_v = 'O' )

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.

Use OR statement between them

Regards

Shiva

[peter_ruiz2]

hi,

use this code

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 in ('O', '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.

regards,

Peter

[ak_upadhyay]

Hi,

Try This...

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' or v}vbtyp_v = 'O')

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.

Reward points if useful....

Regards

AK

[Former Member]

Hi,

http://help.sap.com/erp2005_ehp_03/helpdata/EN/cf/21ec77446011d189700000e8322d00/frameset.htm

Regards,

Muneesh Gitta.