topic Re: data retriew from table in Application Development and Automation Discussions

data retriew from table

Former Member — Mon, 01 Jun 2009 14:45:23 GMT

Hello Friends,

I have pulled the data from a atable.

However this data is all Numbers.

Ex - 1 means 'Requested'.

2 'Approved'

3 'Rejected'

When i run my report it gets all this numbers and this Numbers mean nothing to the user. However when i look inot this table it has the F4 help. on the F4 it gives the number against the meaning of it. How do we pull this into the report.

I dont want to hard code this vaues.

Ster

Re: data retriew from table

Former Member — Mon, 01 Jun 2009 14:48:34 GMT

What table field are you getting the data from? Is there a check table against the field?

Re: data retriew from table

Former Member — Mon, 01 Jun 2009 14:49:42 GMT

Hi,

Fetch the description from the DB table and update the internal table with corresponding descriptions.

Re: data retriew from table

Former Member — Mon, 01 Jun 2009 15:03:26 GMT

if the above does not works out, then see the VALUE TABLE for that domain level in SE11

thanq

Re: data retriew from table

Former Member — Mon, 01 Jun 2009 15:07:05 GMT

Hi Kevin,

there is no check Table against it. the Value is stored at the Domain level of the field in the value range TAB.

For ur reference pls chech the Table

table - T000

field, data element, domian - CCCORACTIV

In the value range of the domain you would find some Values.

Please suggest

Ster

Re: data retriew from table

Former Member — Mon, 01 Jun 2009 15:15:45 GMT

You answered your own question - you get the translations of the values from the domain.

Rob

Re: data retriew from table

Former Member — Mon, 01 Jun 2009 15:18:04 GMT

Thanks Rob.

Yes I could get it from the Domain. but my question was which table stores this values so I can pull it in the program.

However I got the table

DD07V ,

the input is the Domain name and the language.

Please let me know if this is the correct approach or is thr any other way.

Ster.....

Re: data retriew from table

Former Member — Mon, 01 Jun 2009 15:21:48 GMT

Maybe there's a FM to do this. Have you looked?

Rob

Re: data retriew from table

Former Member — Mon, 01 Jun 2009 15:27:59 GMT

Hi,

Use this Function Module to retrieve those values.

RS_DME_ANA_WB_GET_DOM_FIXVALUE

Pass the field name and value, you will get text of that value.

Aswarth

Re: data retriew from table

Former Member — Mon, 01 Jun 2009 15:47:00 GMT

thanks for suggesting to find and FM.

I have found one - LIS_SSV_GET_DOM_VALUE_TEXT

However i didnt find this in My system - RS_DME_ANA_WB_GET_DOM_FIXVALUE

Ster.