topic Input required in Application Development and Automation Discussions

Input required

Former Member — Fri, 18 May 2007 11:20:06 GMT

Hi All,

Anyone can tell me the purpose of checktable,value table, Area Menu.

Thanks,

Maheedhar.T

Re: Input required

Former Member — Fri, 18 May 2007 11:25:27 GMT

Hai,

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.

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.

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.

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.

Area menu is for "Creating your own SAP Customized Main Menu "

Refer this link..

http://www.sap-basis-abap.com/sapbs009.htm

http://help.sap.com/saphelp_nw04/helpdata/en/00/783b377bfdcf61e10000009b38f936/frameset.htm

Regards,

Padmam.

Re: Input required

Former Member — Fri, 18 May 2007 11:26:32 GMT

Check Table is field level checkingm. Means it is use for Primary key foreign key relationship.

Value table is Domain level checking.

Please reward some points if useful.

Regards,

Padmakar

Re: Input required

seshatalpasai_madala — Fri, 18 May 2007 11:26:47 GMT

Hi,

Check table is the table that you want to check, and value table is the table aginst which you want to check your values.

You can ensure a check agisnt the value table by creating a forigen key relation ship for the field of the check table to that of the value table.

Area Menu is to make your programs are transactions available on the SAP Easy acess menu.

Best Regards,

Sesh

Re: Input required

former_member196299 — Fri, 18 May 2007 11:28:39 GMT

hi ,

Check Table

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.

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.

Area menu is for creating your own customized menu in SAP .

Regards,

Ranjita

Re: Input required

Former Member — Fri, 18 May 2007 11:30:06 GMT

Hi,

Check table: The check table is degind for a field in DB table with foreign key constraints. The values in the master table will be used for the secondary table.

Value table: The vales are defind at domain level & field using the domain will hv these values

Area Menu: To customize SAP Screen Main Menu area menu are created.

Thanks

Sandeep

Reward if helpful

Re: Input required

Former Member — Fri, 18 May 2007 11:30:43 GMT

Check table is used for field level checking.

When an entry is made in the check field, there is a check whether the check table contains a record with the key defined by the values in the foreign key fields. If this is so, the entry is valid. Otherwise the system rejects the entry.

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 will be at domain level checking ex: scarr table is check table for carrid.

You can restrict the values that a domain in the ABAP Dictionary may take by assigning fixed values to it. The fixed values can be used as input help for the fields that are defined using that domain. However, the value table of a domain is not used for input help. It is only used as a default value for the check tables of the fields that refer to the domain.

Area menus allow you to group together menus that contain a set of functions intended to perform a particular task in a company.

rgds,

Prajith