07-23-2007 11:42 AM
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,
PK
07-23-2007 11:46 AM
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
07-23-2007 11:45 AM
Hi
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
<b>REMEBER REWARD POINTS IS THE BEST WAY TO SAY THANK YOU</b>
07-23-2007 11:46 AM
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
07-23-2007 11:46 AM
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.
07-23-2007 11:46 AM
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
07-23-2007 11:46 AM
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
07-23-2007 11:48 AM
<b> Single value/lower limit</b>
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.
<b>Value table</b>
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.
07-23-2007 11:49 AM
Hi
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.
<b>Value table</b>
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.
<b>Reward points for useful Answers</b>
Regards
Anji
07-23-2007 11:53 AM
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