on 05-19-2006 8:31 AM
what is check table?
what is value table?
what are the differences between these two tables??
Hi,
<b>Check Table:</b>The Check Table is the table used by system to check if a data exist or not exist.
While creating a table if you want to be sure that a field can have some values and these are in a certain table, you can give IT this table as CHECK TABLE.
<b>value table:</b>
Value Table
This is maintained at Domain Level.
When ever you create a domain , you can entered allowed values. For example you go to Domain SHKZG - Debit/credit indicator. Here only allowed values is H or S.
When ever you use this Domain, the system will forces you to enter only these values.
This is a sort of master check . To be maintained as a customization object. This mean that if you want to enter values to this table you have to create a development request & transport the same.
<b>Differences:</b>1)check table will carry out the check for input values for the table field being entered in any application and value table will provide values on F4 help for that table field.
2)The check table defines the foreign keys and is part of the table definition. The value table is part of the domain definition.
Message was edited by: Latheesh Kaduthara
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi shree,
1. This concepts come into picture
only when we have to define
FOREIGN KEY RELATION SHIP
2. If primary values in some table (A)
needs to be validated/checked against
some master table (B)
then this master table (B) is called the CHECK TABLE.
3. Now,
Instead of SELECTING this check table,
the system automatically proposes
this check table,
if the primary key data element
has a 'VALUE Table' attached to it.
(This Value Table is JUST FOR DEFAULTING
/ PROPOSING THE CHECK TABLE, AND NOTHING ELSE)
regards,
amit m.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Shree,
CHECK TABLE -it is a parent table.
for example..
i have two tables ZTAB1 and ZTAB2.
I have one common field in both the tables,i can make any ztable to be the check table .If i make Ztab1 to be the check table then when i have to make an entry in ztab2 i will check whether ztab1 is having that value or not..
its also field level checking..
Valuetable-It is nothing but default check table.
one parent can have n number of child tables.For example
For ztable we have zchild1 and zchild2 tables r there.
Its domain level checking..When zchild2 uses the same domain as used by zchild1 then the system automatically generates a popup saying a check table already exists would u want to maintain it.
go to domain and then press the value tab u can see the valuetable at the end...
I guess it gives some idea.
Regards,
Nagaraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
chk this also
http://www.sap-img.com/abap/difference-between-a-check-table-and-a-value-table.htm
reward pts if helpful and close thread if solved
Message was edited by: Chandrasekhar Jagarlamudi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you can press F1 in those fields to get the meaning but for a inital starting point... check table is done on the table level to check entries and value table is done on the domain lavel.......
hoe this helps
Anirban
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Check table
System will control that the data is contained in the check table. An error message will occurs if control fail
Value table
It will act as a search help by listing the values contained in the value table when you press F4.
Hope this help
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shree
Value table is the first proposal that a system made for a foreign key relationship on any field
You define value table in the domain
While check table is the table that you actually use in fk relation ship.
Defining check table ..only triggers value validation.
Just specifying value table doesnt trigger any value validation..
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.