‎2006 Nov 30 10:25 AM
I have a select-options on my selection screen. In the database table i have different four values for this. ex EEX01, EEX02, EEX03 and EEX04.
their overall names are DE, HE, IT, TR respectively.
Now the requirement is user will enter this data like DE to TR , i am now confused how do convert these value to the values that i have in table. Because i have to use this for extracting the data from database table.
thanks in advance.
‎2006 Nov 30 10:32 AM
Hi
Either in Start of selection or in at selection screen itself use a CASE - ENDCASE and assign the values accordingly; no other go.
Regards
Surya.
‎2006 Nov 30 10:32 AM
Hi Ganesh,
Check in the table it has conversion exit attached.
If it has any then call conversion function module to convert it in you program and
paas it to your select statement.
Thanks & Regards,
Siri.
‎2006 Nov 30 10:33 AM
actually when seeing data in table, it shows as DE or TR etc...but internally there will be conversion routinue for this field which converts and stores as EEX01 etc...When u use a select statement with DE, the conversion routinue executes internally and fetches data of EEX01 but shows as DE.
‎2006 Nov 30 11:44 AM
hi,
what is the table name for the case.
and jsut list what are the fields .. we'll try to map the same and see if it works..
if for the field there is a check table attached then conversion routine will take care of that .
just check on the field of the domain in the dbtable
like matn1 for dataelement matnr and domain matnr in mara table.
regards,
vijay