Skip to Content
0
Former Member
Jul 11, 2007 at 07:49 AM

regarding joins

11 Views

HI ANJI,

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

SELECT ABELNR ABUDAT AVBELN BLIFNR CORT01 CORT02 CPSTLZ CSTRAS

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

AS B ON ( ABUKRS = BBUKRS ) AND ( ABELNR = BBELNR ) INNER JOIN LFA1

AS C ON ( BLIFNR = CLIFNR ) WHERE BLIFNR IN VENDOR AND ABUDAT IN

P_DATE AND A~BUKRS = CMP_CD.

regards,

raman.