topic Re: Facing Problem with Select-options input data......help me? in Application Development and Automation Discussions

Facing Problem with Select-options input data......help me?

Former Member — Thu, 30 Nov 2006 10:25:30 GMT

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.

Re: Facing Problem with Select-options input data......help me?

Former Member — Thu, 30 Nov 2006 10:32:36 GMT

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.

Re: Facing Problem with Select-options input data......help me?

Former Member — Thu, 30 Nov 2006 10:32:40 GMT

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.

Re: Facing Problem with Select-options input data......help me?

Former Member — Thu, 30 Nov 2006 10:33:52 GMT

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.

Re: Facing Problem with Select-options input data......help me?

Former Member — Thu, 30 Nov 2006 11:44:31 GMT

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