topic Re: Value Table and Value Range in Application Development and Automation Discussions

Value Table and Value Range

Former Member — Mon, 23 Jul 2007 10:42:55 GMT

Hello,

For some of cases Value Range is assigned as either single value or Value table for a Domain.

Lets say If you look at the Table VBFA For the field Data element-VBTYP_N Domain-VBTYP - Document Category

There are fixed value i.e. Single value (A,B,C,D...U,V,W,X,0,1,2...8,a,e...)

Whereas for the field SOBKZ -data element SOBKZ-Domain SOBKZ-Special stock indicator has the Value Table T148.

Please let me know How to decided when should we go for single or Value Table

for a Value Range given for a Domain

Thanking in Advance!!!

Thanks,

Re: Value Table and Value Range

Former Member — Mon, 23 Jul 2007 10:45:43 GMT

When you have a smaller number of values, you should always prefer Value range, or fixed values.

However, if your values tend to increase with time, they will need to be maintained in a table as entering fresh values is realtively easy. So for large number of values we always opt for value tables.

Thanks & regards

Ravish Garg

REMEBER REWARD POINTS IS THE BEST WAY TO SAY THANK YOU

Re: Value Table and Value Range

seshatalpasai_madala — Mon, 23 Jul 2007 10:46:09 GMT

Hi,

When you have few values that you want to mainly show in a DROP DOWN then use the option FIXED VALUES else if you want this domain to store values that are there in a table then mention that table as CHECK TABLE.

CHECK TABLE is not for F4 help though its help in giving F4 help, its main purpose is to be used as a check table in Foriegn key relationship.

Regards,

Sesh

Re: Value Table and Value Range

Former Member — Mon, 23 Jul 2007 10:46:13 GMT

Hi,

If there is a possibility for having very less number of values say 1 to 10 you can go for single values.

If there are 100's of value for a filed then you go for value table.

Reward if helpful.

Re: Value Table and Value Range

former_member404244 — Mon, 23 Jul 2007 10:46:43 GMT

Hi,

If u want fixed values then go for value range.value table is default check table,which is maintained in the domain level. It serves like check table whenever we use the same domain.

Regards,

Nagaraj

Re: Value Table and Value Range

Former Member — Mon, 23 Jul 2007 10:46:50 GMT

You can also maintain both together..

For more info visit this page

http://help.sap.com/saphelp_47x200/helpdata/en/5e/f938361329ec5ae10000009b38f889/frameset.htm

Reward if helpful..

Regards

Prax

Re: Value Table and Value Range

Former Member — Mon, 23 Jul 2007 10:48:03 GMT

Single value/lower limit

Single value or lower limit of the value range of a domain of type CHAR

with lower case letters.

The value range of a domain can be limited by defining fixed values. In

this case, only the values entered in the fixed values are possible for

all the table fields referring to this domain. The fixed values can be

single values or intervals.

You can only define fixed values for domains of data types CHAR, NUMC,

DEC, INT1, INT2 and INT4.

There is only an input check of the mask for data types CHAR and NUMC.

Note that the system only checks single values for NUMC.

if a check table and fixed values are defined for a table field, only

values that exist in both the check table and in the fixed values can be

entered in the field.

Value table

In some cases you already know when you define a domain that all the

fields referring to this domain should be checked against a certain

table. This information can be stored in the domain by entering a value

table.

The system proposes the value table as check table when you try to

define a foreign key for this field. You can override this proposal.

Entering a value table does not implement a check. The check against the

value table only takes place when a foreign key is defined.

Re: Value Table and Value Range

Former Member — Mon, 23 Jul 2007 10:49:45 GMT

Most of the times for a single CHAR domains(fields) we assign a Value Range

and The value range of a domain can be limited by defining fixed values. In this case, only the values entered in the fixed values are possible for all the table fields referring to this domain. The fixed values can be single values or intervals.

You can only define fixed values for domains of data types CHAR, NUMC, DEC, INT1, INT2 and INT4.

There is only an input check of the mask for data types CHAR and NUMC. Note that the system only checks single values for NUMC.

if a check table and fixed values are defined for a table field, only values that exist in both the check table and in the fixed values can be entered in the field.

Value table

In some cases you already know when you define a domain that all the fields referring to this domain should be checked against a certain table. This information can be stored in the domain by entering a value table.

The system proposes the value table as check table when you try to define a foreign key for this field. You can override this proposal.

Entering a value table does not implement a check. The check against the value table only takes place when a foreign key is defined.

Reward points for useful Answers

Regards

Anji

Re: Value Table and Value Range

Former Member — Mon, 23 Jul 2007 10:53:05 GMT

hi,

according to me there are two different things......

value table is a table in which the data element is basically defined i.e for field SOBKZ base table is T148.

like wise if u are using ield VBTYP_N there are possible value defined for this field.

suppose in ur program if u are using

p_VBTYP_N type VBTYP_N.

then in the F4 help only these single Vlaues(A,B,C,D...U,V,W,X,0,1,2...8,a,e...) will display and u have to choose from them.

where as the concept of value table is like i am referncing a data element SOBKZ whose value table is t148 then the table t148 is directly referenced this saves time and increase speed.

hope this is understandable

reward points if helpful

thanks

Divya