creating checktable for custom table field

[Former Member]

Hello Guys,

Can anybody explain me steps involved in createing a check table for the field in

ztable.if possible can u send me link with screen shots.

your help will be greatly appreciated.

Regards

Janapathi

[Former Member]

Check the below link :

http://fuller.mit.edu/tech/view_clusters.pdf

http://fuller.mit.edu/tech/data_dictionary.ppt#260,4,Vocabulary

Thanks

Seshu

[Former Member]

Check table

For example you have Employee master table & Employee Transaction table.

When ever an employee Transacts we need to check whether that employee exists , so we can refer to the employee master table.

This is nothing but a Parent & Child relationship . Here data can be maintained at client level , no development involved.

As per DBMS what we call foregin key table, is called as check table in SAP.

There is 1 more important Difference in Value Table and Check Table is that:

1. The contents of the check will be used as an input help(F4 Help) for a particular field on which a check table is assigned.

But the contents of Value Table are never used in Input Help.

The Heirarchy which decides from where to used the Input Help is:

1. Input help defined explicitly in ABAP Program or Dialog Module.

2. Input Help Attached to the referenced Database Table field.

3. Using the contents of Check Table as an input help if neither (1) or (2) help are there.

4. Input help from Fixed value or Value range given in Domain.

Check table will be at field level checking.

Value table will be at domain level checking ex: scarr table is check table for carrid.

also refer

http://help.sap.com/saphelp_nw2004s/helpdata/en/e2/667092730811d2959500a0c929b3c3/content.htm

http://www.abapmaster.com/cgi-bin/SAP-ABAP-interview-questions.cgi

Message was edited by:

Karthikeyan Pandurangan

[Former Member]

Check table

For example you have Employee master table & Employee Transaction table.

When ever an employee Transacts we need to check whether that employee exists , so we can refer to the employee master table.

This is nothing but a Parent & Child relationship . Here data can be maintained at client level , no development involved.

As per DBMS what we call foregin key table, is called as check table in SAP.

1. The contents of the check will be used as an input help(F4 Help) for a particular field on which a check table is assigned.

But the contents of Value Table are never used in Input Help.

The Heirarchy which decides from where to used the Input Help is:

1. Input help defined explicitly in ABAP Program or Dialog Module.

2. Input Help Attached to the referenced Database Table field.

3. Using the contents of Check Table as an input help if neither (1) or (2) help are there.

4. Input help from Fixed value or Value range given in Domain.

Check Table: The ABAP Dictionary allows you to define relationships between tables using foreign keys . A dependent table is called a foreign key table, and the referenced table is called the check table. Each key field of the check table corresponds to a field in the foreign key table. These fields are called foreign key fields. One of the foreign key fields is designated as the check field for checking the validity of values. The key fields of the check table can serve as input help for the check field.

Value Table: Prior to Release 4.0, it was possible to use the value table of a domain to provide input help. This is no longer possible, primarily because unexpected results could occur if the value table had more than one key field. It was not possible to restrict the other key fields, which meant that the environment of the field was not considered, as is normal with check tables.

In cases where this kind of value help was appropriate, you can reconstruct it by creating a search help for the data elements that use the domain in question, and using the value table as the selection method.

Check table will be at field level checking.

Value table will be at domain level checking ex: scarr table is check table for carrid.

also refer

http://help.sap.com/saphelp_nw2004s/helpdata/en/e2/667092730811d2959500a0c929b3c3/content.htm

http://www.abapmaster.com/cgi-bin/SAP-ABAP-interview-questions.cgi