07-11-2007 8:49 AM
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.
07-11-2007 8:52 AM
hi Prakash,
Avoid using Joins use <b>FOR ALL ENTRIES</b> statement insted ..
Regards,
Santosh
07-11-2007 8:52 AM
Hi
BSID is Customer related data
BSIK is Vendor related data
You can join BSIK with LFA1 table not BSID table
SELECT ABELNR ABUDAT AEBELN ALIFNR CORT01 CORT02 CPSTLZ CSTRAS
INTO CORRESPONDING FIELDS OF TABLE ITAB FROM BSIK AS A INNER JOIN LFA1
AS C ON ( ALIFNR = CLIFNR ) WHERE ALIFNR IN VENDOR AND ABUDAT IN
P_DATE AND A~BUKRS = CMP_CD.
<b>Reward points for useful Answers</b>
Regards
Anji
07-11-2007 9:54 AM
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 ABELNR ABUDAT ALIFNR CORT01 CORT02 CPSTLZ C~STRAS
INTO CORRESPONDING FIELDS OF TABLE ITAB FROM BSIK AS A INNER JOIN LFA1
AS C ON ( ALIFNR = CLIFNR ) WHERE ALIFNR IN VENDOR AND ABUDAT IN
P_DATE AND A~BUKRS = CMP_CD.