Problem mit einer Datenselektion

Code: Alles auswählen.

  select a~land1
             a~pstlz
             a~ort01
             a~name1
             a~name2
             a~ktokk
             a~stceg
             a~lifnr
             a~vbund
             b~land1
             b~stceg
      into corresponding fields of table l_it_sel_data
      up to 500 rows
      from lfa1 as a
      left join lfas as b
      on a~lifnr = b~lifnr
      where a~land1 in land1
        and a~pstlz in pstlz
        and a~mcod3 in mcod3
        and a~mcod1 in mcod1
        and a~ktokk in ktokk
        and a~stceg in stceg
        and a~loevm in loevm
        and a~sperr in sperr
        and a~sperm in sperm
        and a~lifnr in lifnr
        and a~vbund in vbund
      .

Code: Alles auswählen.

SELECT WHERE ( T_01 . "MANDT" (+) = '093' AND T_00 . "LIFNR" = T_01 . "LIFNR" (+) ) AND T_00 . "MANDT" = '093' AND ROWNUM <= 500

Code: Alles auswählen.

RANGES: land1 for lfa1-land1,
        pstlz for lfa1-pstlz,
        mcod3 for lfa1-mcod3,
        mcod1 for lfa1-mcod1,
        ktokk for lfa1-ktokk,
        stceg for lfa1-stceg,
        loevm for lfa1-loevm,
        sperr for lfa1-sperr,
        sperm for lfa1-sperm,
        lifnr for lfa1-lifnr,
        vbund for lfa1-vbund
.

Code: Alles auswählen.

Für land1:
SIGN OPTION LOW HIGH 
I   |EQ    |DE |      
Für pstlz
SIGN OPTION LOW        HIGH   
 I   |EQ   |69115     |