Skip to Content
0
Former Member
Mar 31, 2009 at 07:44 AM

What is the wrong with my select query

41 Views

HI All,

TYPES: BEGIN OF t_equi,
         equnr          TYPE equi-equnr,
         aedat          TYPE equi-aedat,
         matnr          TYPE equi-matnr,
         sernr          TYPE equi-sernr,
         kunde          TYPE equi-kunde,
         zzreg_date     TYPE equi-zzreg_date,
         zzin_indic     TYPE equi-zzin_indic,
         zzinvoice_num  TYPE equi-zzinvoice_num,
         zzinvoice_date TYPE equi-zzinvoice_date,
         kund1          TYPE equz-kund1,
      END OF t_equi,

DATA: it_equi        TYPE TABLE OF t_equi,



  SELECT equnr
         aedat
         matnr
         sernr
         kunde          "Ship to
         zzreg_date
         zzin_indic
         zzinvoice_num
         zzinvoice_date
         kund1            "Sold to
         INTO TABLE it_equi
         FROM equi AS a
         INNER JOIN equz AS b
         ON a~equnr = b~equnr
         WHERE a~equnr      IN s_equnr AND
*               aedat GE gv_rdate AND
               a~matnr      IN s_matnr AND
               a~sernr      IN s_sernr AND
               a~kunde      IN r_shpbr_kunde AND
               a~zzin_indic IN s_indic  AND
               b~datbi      EQ c_datbi  AND  
               b~kund1     IN r_sldbr_kund1 .

what is the wrong with this select query.. ?

its giving me error "The column name "EQUNR" is unclear ."

Thanks