Check Tables, Valure Range and Search Help

[Former Member]

Hi ,

Could you please explain difference between Check Tables, Valure Range and Search Help?Can we have both check table and Value Range assigned to table field?

Thnaks

Saurabh

[Former Member]

fsdfsdf

[Former Member]

Hi,

Check table: Check table will be at field level checking.

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: Value table will be at domain level checking

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.

ex: scarr table is check table for carrid.

Search Helps

There are two kinds of search helps: elementary and collective. An elementary search help represents a search path. It defines the location of the data for the hit list, how values are exchanged between the screen and the selection method, and the user dialog that occurs when the user chooses input help. A collective search help consists of two or more elementary search helps. A collective search help combines all the search paths that are meaningful for a field. The collective search help is the interface between the screen and the various elementary search helps.

Hope this helps you.

Thanks,

Ruthra

[Former Member]

Hi

search help is used for input help(f4)when you call f4 help it will display a list of values.

if you dont assign any search help to a field then fixed values of domain is displayed.

if you want to check any entry of a field then you need to define value table in domain.

but for it you must implement a foreign key .

as you implement a foreign key value table becomes check table

[GauthamV]

hi,

check this.

[]

[Former Member]

HI,

SIMPLE ANSWERS.

CHECK TABLE IS THE TABLE WHERE THE VALUES ARE CHECKED OR VALIDATED.

VALUE RANGE IS THE RANGE OF VALUES U PROVIDE FOR A FIELD TO HAVE.IT IS GIVEN AT DOMAIN LEVEL..

SEARCH HELP IS FOR GETTING THE VALUES FROM THEIR RESPECTIVE BASE TABLES.

[Former Member]

Hi,

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.

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.

[Former Member]

Hi,

I hope the below links will help you.

For Check table and Value tables.

For search help use below link.

http://help.sap.com/saphelp_nw04/helpdata/en/eb/e8dbc3e53d11d4b36c0050da429303/frameset.htm

Thanks,

Khushboo.

Edited by: khushboo Brahmbhatt on Sep 15, 2008 11:36 AM