Skip to Content
0
Former Member
Dec 01, 2009 at 10:22 AM

Data fetch problem from EBAN table

239 Views

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