Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

joining of 4 tables

Hi experts,

Iam trying to join 4 tables.(EQUI,EQUZ,ILOA,JEST)

SELECTION-SCREEN BEGIN OF BLOCK A1 WITH FRAME TITLE TEXT-001.
SELECT-OPTIONS:S_EQTYP FOR EQUI-EQTYP, " DEFAULT 'H',
               S_VKBUR FOR ILOA-VKBUR,
               S_STATUS FOR TJ02T-TXT04.
PARAMETERS P_INBDT LIKE EQUI-INBDT DEFAULT SY-DATUM.
SELECTION-SCREEN END OF BLOCK A1.
  SELECT EQUI~EQUNR EQUI~EQTYP EQUI~EQART EQUI~INBDT
         EQUI~OBJNR ILOA~VKBUR JEST~STAT
     INTO CORRESPONDING FIELDS OF TABLE T_ET
     FROM ( ( ( ( <b>EQUI</b> INNER JOIN <b>EQUZ</b>
     ON EQUI~EQUNR = EQUZ~EQUNR )
       INNER JOIN <b>ILOA</b>
     ON EQUZ~ILOAN = ILOA~ILOAN )
       INNER JOIN <b>JEST</b>       
     ON EQUI~OBJNR = JEST~OBJNR )
     INNER JOIN TJ02T
     ON JEST~STAT = TJ02T~ISTAT )
     
           WHERE EQUI~EQTYP IN S_EQTYP AND
                 ILOA~VKBUR IN S_VKBUR AND
                 EQUI~INBDT LE P_INBDT AND
                 JEST~INACT = SPACE.

In this code iam not able to get proper data.Where iam doing wrong in select statement?

reward guaranteed,

thanks

kaki

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question