Skip to Content
author's profile photo Former Member
Former Member

fetching values from domain from fixed values

hi,

this is related to my earlier posting of fetching values from domain.

TABLE NAME IS Z_CODES

FIELD NAME IS CODE

DOMAIN IS CD

under DOMAIN, value range tab -> single values. in that i have few FIXED values around 10 and may likely to change. how to pull these and insert these values in the range table in my program .

any help would be appreciated.

Thanks,

kranthi.

Message was edited by: kranthi kumar

Message was edited by: kranthi kumar

Message was edited by: kranthi kumar

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 27, 2005 at 12:51 AM

    Hi Kranthi,

    If you know the domain name, then, you can execute a query on table DD07L. The texts for the values can be retrieved from DD07T, with sy-langu.

    DOMNAME - Domain name

    AS4LOCAL - Activiation status. Make sure you query with value 'A', for the active version.

    VALPOS will determine the order in which the values exist.

    If the domain has a range, then, the fields DOMVALUE_L and DOMVALUE_H will be populated.

    Cheers,

    Rahul

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 27, 2005 at 07:42 AM

    Hi,

    try fm SWU_GET_TABLE_TO_DOMNAME

    regards Andreas

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      > Hi,

      >

      > try fm SWU_GET_TABLE_TO_DOMNAME

      >

      >

      > regards Andreas

      Believe me: DDIF_FIELDINFO_GET is more robust, and if it is to complicated for you, you may also use DDUT_DOMVALUES_GET, although its documentation states that it is obsolete and now should be replaced by DDIF_FIELDINFO_GET.

      Greetings

      Stephan

  • author's profile photo Former Member
    Former Member
    Posted on May 28, 2005 at 07:01 PM

    Hi,

    I tried the function modules, but im unable to pick up the fixed values(under single values in value range tab) from the domain corresponding to that field.

    im filling my range table in my program in hard coded way. i want to fill this range table with the values picked up from the domain.

    could some one help me on this . your help would be appreciated.

    Thanks,

    kranthi.

    Add a comment
    10|10000 characters needed characters exceeded

    • use one of the following FMs which would give you the domains fixed values.

      DDUT_DOMVALUES_GET

      SWU_GET_TABLE_TO_DOMNAME

      now declare a range table.

      ranges: code_r for Z_CODES-code .

      now loop thru the resulting table of the FM.

      loop at ....

      move: fmresult_tab-value to code_r-low ,

      'I' to code_r-sign ,

      'EQ' to code_r-option .

      append code_r .

      clear code_r .

      endloop .

      Hope this helps.

      Regards

      Raja

  • Posted on May 29, 2005 at 05:55 AM

    Hi Kranthi,

    I think you can use Function Module

    GET_DOMAIN_VALUES

    This returns all the fixed values in a domain with the

    values description in the VALUES_TAB table parameter.

    Hope it helps,

    Eyal.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.