2007 Jul 11 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.
2007 Jul 11 8:52 AM
hi Prakash,
Avoid using Joins use <b>FOR ALL ENTRIES</b> statement insted ..
Regards,
Santosh
2007 Jul 11 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
2007 Jul 11 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.