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