topic Re: regarding joins in Application Development and Automation Discussions

regarding joins

Former Member — Wed, 11 Jul 2007 07:49:45 GMT

HI ANJI,

can i use join conditions like this...using BSID,BSIK,LFA1

SELECT A_{BELNR A}BUDAT A_{VBELN B}LIFNR C_{ORT01 C}ORT02 C_{PSTLZ C}STRAS

INTO CORRESPONDING FIELDS OF TABLE ITAB FROM BSID AS A INNER JOIN BSIK

AS B ON ( A_{BUKRS = B}BUKRS ) AND ( A_{BELNR = B}BELNR ) INNER JOIN LFA1

AS C ON ( B_{LIFNR = C}LIFNR ) WHERE B_{LIFNR IN VENDOR AND A}BUDAT IN

P_DATE AND A~BUKRS = CMP_CD.

regards,

raman.

Former Member — Wed, 11 Jul 2007 07:52:20 GMT

hi Prakash,

Avoid using Joins use <b>FOR ALL ENTRIES</b> statement insted ..

Regards,

Santosh

Former Member — Wed, 11 Jul 2007 07:52:40 GMT

BSID is Customer related data

BSIK is Vendor related data

You can join BSIK with LFA1 table not BSID table

SELECT A_{BELNR A}BUDAT A_{EBELN A}LIFNR C_{ORT01 C}ORT02 C_{PSTLZ C}STRAS

INTO CORRESPONDING FIELDS OF TABLE ITAB FROM BSIK AS A INNER JOIN LFA1

AS C ON ( A_{LIFNR = C}LIFNR ) WHERE A_{LIFNR IN VENDOR AND A}BUDAT IN

P_DATE AND A~BUKRS = CMP_CD.

<b>Reward points for useful Answers</b>

Regards

Anji

Former Member — Wed, 11 Jul 2007 08:54:03 GMT

HI,

i am trying to join BSIK and LFA1 using the same join conditions ie BSIK-LIFNR AND LFA1-LIFNR as suggested by you..but it is still not working.

SELECT A_{BELNR A}BUDAT A_{LIFNR C}ORT01 C_{ORT02 C}PSTLZ C~STRAS

INTO CORRESPONDING FIELDS OF TABLE ITAB FROM BSIK AS A INNER JOIN LFA1

AS C ON ( A_{LIFNR = C}LIFNR ) WHERE A_{LIFNR IN VENDOR AND A}BUDAT IN

P_DATE AND A~BUKRS = CMP_CD.