topic Re: tables in Application Development and Automation Discussions

tables

Former Member — Sat, 29 Mar 2008 04:50:56 GMT

wats da difference between a table and a check table.

Re: tables

Former Member — Sat, 29 Mar 2008 05:01:36 GMT

check table is nothing bt field level checking & value table is domain level checking. u can understand it with this ex scarr table is check table for carried.

The relational data model contains not only tables, but also relationships between tables. These relationships are defined in the ABAP/4 Dictionary by foreign keys. An important function of foreign keys is to support data integrity in the relational data model. Foreign key fields may assume only those values allowed by the check table, in other words, values occurring in the primary key of the check table.

A foreign key provides a link between two tables, for eg.,T1 and T2 by including a reference in table T1 to the primary key of table T2. For this purpose, Foreign key fields assigned to the primary key fields of T2 are included in T1. Table T1, which is the one being checked, is called a foreign key table, and table T2 is called a check table. The terms dependent (foreign key) table and referenced (check) table are also used.

VALUE TABLE:If the domain of the check field has a value table, this is proposed by the system as check table in the foreign field maintenance. The key fields of the value table are in this case assigned fields of the foreign key table with the same domain. These fields may assume only those values allowed by the value table.

The value range of the domain can be defined by specifying value table.All table fields referring to this domain can then be checked against the corresponding field of this value table.In order the check can be executed, a foreign key must be defined for the value table.

Re: tables

Former Member — Sat, 29 Mar 2008 05:07:22 GMT

wats da difference between a normal table( not a value table ) and a check table.

Re: tables

Former Member — Sat, 29 Mar 2008 05:50:46 GMT

Hi,

The check table is the table contains all values can be contained in another table.

For example you want to create a new table where a field is LIFNR (vendor), now you should allow only vendor defined in SAP can be inserted in your table.

You can do it in dictionary inserting a check table (in this case LFA1) for field LIFNR of your table.

Now if you create a dialog program to insert a new record in your table and you use ZTABLE-LIFNR as input field, if user tried to insert a vendor there isn't in LFA1, the system automatically triggers an error message.

If you don't use the check table, you should do this control by yourself:

SELECT SINGLE * FROM LFA1 WHERE LIFNR = ZTABLE-LIFNR.

IF SY-SUBRC 0. ERROR. ENDIF.

Anyway nobody can prevent an error enter by command INSERT or MODIFY.

IF LFA1-LIFNR = 'AAAAAAAAAA' isn't in the table LFA1, you could write:

ZTABLE-LIFNR = 'AAAAAAAAAA'.

INSERT ZTABLE.

But this is an your error during the development of your program.

Table:

Chk this.

http://dev.mysql.com/doc/maxdb/en/ee/1c5bcdeba711d4aa2800a0c9430730/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb6e446011d189700000e8322d00/content.htm

Regards

Kiran Sure

Re: tables

Former Member — Wed, 02 Apr 2008 10:44:49 GMT

hi Suman,

The basic difeerence between table and check table is;

Table: Table is collection of rows and called as fields.Tables hold the persistent data.The data remains same unless it is deleted or removed by some external programs.

Check table:This exists at field level to check the existance of field value.

*******If usefull reward points***********

Regards,

Kiran.

Re: tables

Former Member — Wed, 02 Apr 2008 11:49:11 GMT

Hi,

Value table - It's a field in a domain it helps in domain level data validation.

Check table - unlike value table it helps in feild level data validation.

check table is nothing bt field level checking & value table is domain level checking. u can understand it with this ex scarr table is check table for carried.

The Check Table is the dependent table to which the relationship is defined using foreign keys. The contents of the check table field are shown in the input help for the referenced field.

The Value table is the table attached to a field at the domain level, where the entry to the field can be only from the value table. They are not used in the Input Help.

When Value table becomes check table?

while establishing foriegn key relation between check table and foriegn key table if at the domain level value table is provided then the system will prapose that value table as check table if you accept this prposal then value table will becomes check table.

Thanks&regards,

Sravani.