topic Re: value range in Application Development and Automation Discussions

value range

Former Member — Tue, 11 Mar 2008 02:56:57 GMT

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

what it means.

Re: value range

Former Member — Tue, 11 Mar 2008 03:00:34 GMT

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.

Re: value range

Former Member — Tue, 11 Mar 2008 03:01:57 GMT

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]

Re: value range

Former Member — Tue, 11 Mar 2008 03:21:55 GMT

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