what is a client

[Former Member]

Hai.. I m new to ABAP programming.. Can any one explain what is a client?... Also provide the info about check table and value table.

Advanced thanks to all.

[Former Member]

Client - In commercial, organizational, and technical terms, a self-contained unit in an SAP system with separate master records and its own set of tables.

Value table:

Value table is a domain level checking .In some cases you can see when you define a domain that all the table fields or structure components referring to this domain should be checked against a certain table. This information can be stored in the domain by entering a value table. A check is not implemented by simply entering a value table! The check against the value table only takes effect when a foreign key has been defined

Check table:

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.. 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.

Important Difference

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.

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.

Best Regards,

Vibha

Please mark all the helpful answers

[Former Member]

Hi,

Client

In commercial, organizational, and technical terms, a self-contained unit in an SAP system with separate master records and its own set of tables. ...

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.

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.

Reward Points if found helpfull..

Cheers,

Chandra Sekhar.

[Former Member]

Hi!!

Client:

In commercial, organizational, and technical terms, a self-contained unit in an SAP system with separate master records and its own set of tables.

One server can have different client.Generally for one project we wrk on one client.

CHECK TABLE N VALUE TABLEThe 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.

Reward point if useful

[Former Member]

Hi Selvakumar,

In commercial, organizational, and technical terms, a self-contained unit in an SAP system with separate master records and its own set of tables

A client is a computer program that depends upon another program to function. Usually, client software receives data or instructions from a remote program called a server. Some thin clients actually have critical software components execute on the remote machine to conserve local resources or software licenses. If the computer running the host software is accessed over a network, then the machine hosting it is also referred to as a server. If the server software is running in the background of the client machine, then it is referred to as a daemon. Examples of common client software used in everyday personal computing include web browsers, email clients, instant messenger chat clients, and bittorrent clients.

check table is a primary table

value table is helps as input to the particular fields.

Value table:

Value table is a domain level checking .In some cases you can see when you define a domain that all the table fields or structure components referring to this domain should be checked against a certain table. This information can be stored in the domain by entering a value table. A check is not implemented by simply entering a value table! The check against the value table only takes effect when a foreign key has been defined

Check table:

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.. 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.

Rewards points if helpful

Ganesh.

[Former Member]

Hi selvakumar,

A client is the highest level in the organisational structure.

Each client has specific permissions to access sap objects.

There are two types of objects in SAP, client dependent and client independent. Objects used in several clients are called client independent while objects used in a specific client is called client dependent. To identify if a table is client dependent, one can use tcodes SE11 or SE12. In the table field attributes, if the MANDT field is present that table is client dependent

check table is nothing bt field level checking & value table is domain level checking.

Table whose key fields are used to check the foreign key fields (see Foreign Keys). Only entries that are contained in the key fields of the check table can be contained in the foreign key fields.

The check table is used to check whether the input values are valid and for the input help (F4 help).

In some cases you already know when you define a domain that all the fields referring to this domain should be checked against a certain table. This information can be stored in the domain by entering a value table.

We can select the values provided ,but there is no validation done for the values entered.

Reward if useful.

Thanks & Regards,

khan.