How to get description of fixed value?

[naveen_inuganti2]

Hi....

Iam having one table -> filed -> domain with fixed entries.

say my entries in domain...

Fixed value -> short description 
    IN              -> India
    RS            -> Russia
    CH            -> China

And i am having some entries in my table.., So as we know following query...

select * from MYTABLE into table ITAB.
loop at itab.
  write: iatb-MYFILED.
endloop.

will give output entries like...

IN
RS
CH

But i want to get India, Russia, China.

How to do that?

Thanks,

Naveen.I

[Former Member]

Hi Naveen,

Check the table:

DD07T - DD: Texts for Domain Fixed Values (Language-Dependent)

Regards,

Chandra Sekhar

[Former Member]

Hi,

You can get the description of fixed values from the table DD07T.

Regards,

Surinder

[Former Member]

Hi Naveen,

There is always a text table in SAP for such type of fields.

e.g. t005 is the table for countries and t005t is the table for country text.

you will always get text table having 'T' at the end.

Regards,

Hemant

[Former Member]

Hi,

we will find then maintained short description for domain in table DD07T.

plz try this way .

types: typ_itab type dd07t.

data: itab type standard table of typ_itab,
      wa_itab like line of itab.


select * from DD07T
into table itab
where domname = 'ZCOUNTRY'.

loop at itab into wa_itab.
write: wa_itab-ddtext.
endloop.

thanks.

Edited by: Dhanashri Pawar on Sep 5, 2008 8:18 AM

[Former Member]

Hi,

check this link it may help you.

http://www.sap-img.com/abap/how-to-get-the-field-descriptions-of-a-table.htm

[Former Member]

Hi,

check this...

SELECT domvalue_l

ddtext

FROM dd07t

INTO TABLE IT_DOM.

[Former Member]

Try : DD_DOMVALUE_TEXT_GET

[naveen_inuganti2]

Hi...

Yes.. we can get texts from DD07T..,

But to pass that text into our list we have to go for

another internal table declaration and

We have to know domain name of that field and

we have check condition in loop or some where... Is n't it?

The code will be like this...

data: itab like DBTABLE occurs 0 with header line.
data: jtab like dd07t occurs 0 with header line.

select * from DBTABLE into corresponding fields of table itab.

select * from dd07t into corresponding fields of table jtab where domname = 'DOMAIN NAME'.

loop at itab.

  read table jtab with key domvalue_l = itab-feild.
if sy-subrc = 0.
  write:/ itab-field,                                      <------------ fixed value
            jtab-ddtext.                                   <------------ Its short text  
endif.
endloop.

Any comments on this code?

And i dont think there is code decriment with above function modules also.

Thanks,

Naveen.I

[Former Member]

Hi Naveen,

Yes you have to go in that way.

first get the field and then get the domain text using that field.

Regards,

sujit

[Former Member]

Why not utilize the ready FM : DD_DOMVALUE_TEXT_GET rather than putting your own select queries and defining internal table .

regards,

[former_member188685]

you can use the function module to read the fixed values

DD_DOMA_GET

pass the Domain name to it and get the values.

[naveen_inuganti2]

Hi....

Friends thanks for all...

So we have to go for

Table DD07T

or

Function module DD_DOMA_GET

As we can solve this in module pool screen by giving extra functionalty to that screen element...i.e. drop down selection.

But I faced some inconviences there also plz see my thread in UI Programming.. Try to solve the problem..

Once again thanks for your attention,

Naveen.I