Arbeitsbereich nicht lang genug bei INNER JOIN

Code: Alles auswählen.

DATA: gt_tdt TYPE /tab0/zgf_tdt,

SELECT * FROM /tab0/zgf_tdt as a
    INTO TABLE gt_tdt
      WHERE a~trace_id         IN so_trace
        AND a~dep_date         IN so_date
      ORDER BY rnumber
               adate DESCENDING.

Code: Alles auswählen.

DATA: gt_tdt TYPE /tab0/zgf_tdt,

SELECT * FROM /tab0/zgf_tdt as a
    INTO TABLE gt_tdt
      WHERE a~trace_id         IN so_trace
        AND a~dep_date         IN so_date
       AND rnumber         IN (SELECT r_id
                                    FROM /tab0/zgf_mas
                                    WHERE active = p_mdtact
                                    AND tmp = p_mdttem)
      ORDER BY rnumber
               adate DESCENDING.

Code: Alles auswählen.

 SELECT * FROM /tab0/zgf_tdt as a
      INNER JOIN /tab0/zgf_Mas as b
      ON a~rnumber = b~r_id
    INTO TABLE gt_tdt
      WHERE a~trace_id         IN so_trace
        AND a~dep_date         IN so_date
        AND b~active           EQ p_mdtact
        AND b~tmp              EQ p_mdttem

      ORDER BY rnumber
               adate DESCENDING.