How to find number range of table field

[Former Member]

Hi All,

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

Regards,

Jeetu

[former_member1245113]

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

[Former Member]

Hi,

For exampla I know a database table XXX.

It has a field called yyy.

I just want to know what is permissible value for yyy. That means e.g it can start from 0001 to 1000. Between these numbers only the values can be possible.

So how to find out this range?

Regards,

Jeetu

[former_member1245113]

Hi

At domain level of the field you can maintain these FIXED or Intervals ( Ranges) can be maintained.

Regards

Ramc

[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

[Former Member]

Hi,

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

or DOMLEN = domain of the field.

regards,

Santosh Thorat

[Former Member]

Check with SNRO tranaction.

Regards

Sasi

[Former Member]

Hi Jeetu,

Function module :- DD_DOMVALUES_GET

Regards,

Darshan Mulmule