Subquery gesucht

Code: Alles auswählen.

...
AND stzae EQ ( SELECT MAX( stzae ) FROM drap as d WHERE d~dokar EQ drap~dokar AND d~doknr EQ drap~doknr AND d~dokvr EQ drap~dokvr AND d~doktl EQ drap~doktl )
...

Code: Alles auswählen.

SELECT c~carrname, p~connid, f~fldate 
INTO CORRESPONDING FIELDS OF TABLE @itab FROM ( ( scarr AS c 
INNER JOIN spfli AS p 
  ON  p~carrid   = c~carrid 
  AND p~cityfrom = @p_cityfr 
  AND p~cityto   = @p_cityto ) 
INNER JOIN sflight AS f 
  ON f~carrid = p~carrid 
  AND f~connid = p~connid ). 

Code: Alles auswählen.

SELECT scarr~carrname, spfli~connid, sflight~fldate 
INTO CORRESPONDING FIELDS OF TABLE @itab FROM ( ( scar 
INNER JOIN spfli 
  ON spfli~carrid   = scarr~carrid 
  AND spfli~cityfrom = @p_cityfr 
  AND spfli~cityto   = @p_cityto ) 
INNER JOIN sflight 
  ON sflight~carrid = spfli~carrid 
  AND sflight~connid = spfli~connid ). 

Code: Alles auswählen.

 SELECT DISTINCT equi~equnr equi~matnr equi~sernr ehaua~post_code1 ehaua~post_code1
                  equi~zzebeln equi~zzebelp eh~einbdat ehaua~post_code1
                  ekko~waers ekpo~netwr   ##too_many_itab_fields
    INTO CORRESPONDING FIELDS OF TABLE gt_equizip
    FROM  equi
    INNER JOIN egerh   AS eh    ON eh~equnr = equi~equnr
    INNER JOIN jest    AS sinst ON sinst~objnr = equi~objnr
    INNER JOIN jest    AS uinst ON uinst~objnr = equi~objnr
    INNER JOIN m_ehaua AS ehaua ON ehaua~tplnr = eh~devloc
    INNER JOIN ekko    AS ekko  ON ekko~ebeln = equi~zzebeln
    INNER JOIN ekpo    AS ekpo  ON ekpo~ebeln = ekko~ebeln AND ekpo~ebelp = equi~zzebelp
        WHERE  equi~eqtyp   = p_eqtyp
         AND   equi~eqart   = p_eqart
         AND   eh~einbdat   IN s_date
         AND   eh~bis       EQ '99991231'
         AND   sinst~stat   = gv_systemstatus
         AND   sinst~inact  = abap_false
         AND   uinst~stat   = gv_userstatus
         AND   uinst~inact  = abap_false
         AND   zzebeln      IN s_ebeln.