Skip to Content
avatar image
Former Member

How to find number range of table field

Hi All,

I want ot find out the number range of a field of a database table. How to find it out?

Regards,

Jeetu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 24, 2008 at 10:01 AM

    Hi

    I am not clear of what you are really looking for.

    Any how.

    All the number ranges are stored in table NRIV. here you need to pass the Number Range Object which creates these number ranges and also the subobject.

    you must know Number Range Object and Sub Object

    you can also take the help of tcode SNRO or SNUM

    Regards

    Ramchander Rao.K

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Jeetu,

      Using table name and field name you can find the range in three steps as below,

      1. Get the ROLLNAME (Data Element) field from table DD03L for the particular TABNAME (table name) and FIELDNAME.

      2. Get DOMNAME (Domain Name) from table DD04L for the ROLLNAME fetched above.

      3. From table DD07T you can get range from field DOMVALUE_L based on the keys DOMNAME fetched above and DDLANGUAGE (Lnguage 'E' in case of english)

      Regards,

      Manoj Kumar P

      Edited by: Manoj Kumar on Dec 24, 2008 12:17 PM

  • avatar image
    Former Member
    Dec 24, 2008 at 10:03 AM

    Hi,

    you can check in the table trno, where DTELSOBJ = dataelement of the field

    or DOMLEN = domain of the field.

    regards,

    Santosh Thorat

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 24, 2008 at 10:06 AM

    Check with SNRO tranaction.

    Regards

    Sasi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 24, 2008 at 09:42 PM

    Hi Jeetu,

    Function module :- DD_DOMVALUES_GET

    Regards,

    Darshan Mulmule

    Add comment
    10|10000 characters needed characters exceeded