data retriew from table

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

Rob

[Former Member]

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.....

[Former Member]

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

Rob

[Former Member]

Hi,

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

[Former Member]

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

thanq

[Former Member]

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

[Former Member]

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.