Hi All,
I have a problem in data fetching. My SQL statement is
SELECT A~BANFN
A~FRGDT
A~MATNR
A~MENGE
A~MEINS
A~AFNAM
A~EKGRP
A~PRIO_URG
A~STATU
A~RLWRT
A~EBELN
A~LOEKZ
A~EBELP
A~FRGKZ
INTO CORRESPONDING FIELDS OF TABLE ITAB_DATA
FROM EBAN AS A
WHERE A~STATU IN S_STATU
AND A~EKGRP = S_EKGRP
AND A~BANPR = '05'
AND AFNAM IN P_AFNAM
AND BEDNR IN P_BEDNR .
In EBAN table data in AFNAM field is like 'Mech', 'mech' & 'Mech'
Now in selection screen if user give Mech then system picks only that data where 'Mech' is there but requirement is it should pick all data related to ('Mech', 'mech', 'Mech') in AFNAM field. How do I do?
Thanks and regards,
Rajesh Vasudeva