Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

value range

Former Member
0 Likes
1,178

in the table. domain has value range one opiton is there.

what it means.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
876

Value table :

Value table is a domain level checking .In some cases you can see when you define a domain that all the table fields or structure components referring to this domain should be checked against a certain table. This information can be stored in the domain by entering a value table.A check is not implemented by simply entering a value table! The check against the value table only takes effect when a foreign key has been defined.

3 REPLIES 3
Read only

Former Member
0 Likes
877

Value table :

Value table is a domain level checking .In some cases you can see when you define a domain that all the table fields or structure components referring to this domain should be checked against a certain table. This information can be stored in the domain by entering a value table.A check is not implemented by simply entering a value table! The check against the value table only takes effect when a foreign key has been defined.

Read only

Former Member
0 Likes
876

Hi,

domain describes the value range of a field by its data type and length. The

value range can be limited by specifying fixed values.

The domain describes the value range of a field by specifying its data type and

field length. If only a limited set of values is allowed, they can be defined as

fixed values.

Specifying fixed values causes the value range of the domain to be restricted by

these values. Fixed values are immediately used as check values in screen entries.

There is also F4 help.

Fixed values can either be listed individually or defined as an interval.

The value range of a field can also be defined by specifying a value table in the

domain.

In contrast to fixed values, however, simply specifying a value table does not

cause the input to be checked. There is no F4 help either.

check them

[http://help.sap.com/saphelp_47x200/helpdata/en/e5/7c3438fd263402e10000009b38f8cf/frameset.htm]

[http://help.sap.com/saphelp_47x200/helpdata/en/6a/082f38ffccf905e10000009b38f8cf/frameset.htm]

[http://www.sap-img.com/abap/difference-between-a-check-table-and-a-value-table.htm]

Read only

Former Member
0 Likes
876

Domain definitions enable ranges of values to be defined and designated for table columns.

Each value range definition has a name that is unique within the overall database system.

If a domain was defined without an owner, the catalog sections (part catalogs) are searched in the following order to locate the specified value range:

1.Catalog part of the current owner

2.Catalog part of the DBA who created the current user

3.Catalog part of the SYSDBA