Skip to Content

How to get description of fixed value?

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

9 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 05, 2008 at 06:23 AM

    Try : DD_DOMVALUE_TEXT_GET

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2008 at 06:10 AM

    Hi,

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

    Regards,

    Surinder

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2008 at 06:12 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2008 at 06:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2008 at 06:15 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Sep 05, 2008 at 06:27 AM

    you can use the function module to read the fixed values

    DD_DOMA_GET

    pass the Domain name to it and get the values.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2008 at 06:07 AM

    Hi Naveen,

    Check the table:

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

    Regards,

    Chandra Sekhar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2008 at 06:16 AM

    Hi,

    check this...

    SELECT domvalue_l

    ddtext

    FROM dd07t

    INTO TABLE IT_DOM.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 05, 2008 at 06:56 AM

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

    Drop down icon in cell ( table control )

    Once again thanks for your attention,

    Naveen.I

    Add comment
    10|10000 characters needed characters exceeded