PLEASE ANY ONE EXPLIN ME THESE FOLLOWING ?

[Former Member]

1. CHECK TABLE ?

2. VALUE TABLE ?

3. TRANSACTION TABLE ?

4. MASTER TABLE ?

[abdulazeez12]

When we are creating the foriegn key relationship Check Table is the master table where the primary key exists. These primary key will bw the foreign key of the other table.

Value Table describes the Range of Values. The value range of a field can be defined by specifying a value table in the domain. A value table becomes a check table when a foreign key is defined.If u refer to a domain with a value table in a field , but no foriegn key was defined at field level, there is no check

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.

[former_member404244]

Hi,

check the belwo threads

http://www.sap-img.com/abap/difference-between-a-check-table-and-a-value-table.htm

Reward if helpful.

Regards,

nagaraj

[Former Member]

Hi,

Check table means the table against which the data to be entered in another table is checked.If the data to be entered in the table does not refer to an existng data entry in the Check table,then the data entry is rejected.

Value table is the table which defnes the range of values that a particular field can have.

Transacton table contains the data which frequently changes lke the Purchase order.

Master table contains the master data which remains the same for a long period like the Organisational data.

In case you have any further clarifications,do let me know.

Regards,

Puneet Jhari.

Message was edited by:

Puneet Jhari

[Former Member]

Hi frd ...

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

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

3.TRANSACTION TABLE:

Used SE12 to display the tables

4. MASTER TABLE :

Master table contains the master data which remains the same for a long period like the Organisational data.

[Former Member]

1) Primary key table

2)Foreign key table

3)order tables, purchasing items etc..,

Freequently updating tables

4)Customer master, Vendor master etc..,

Rarely modified

and company's fixed transaction partners

[Former Member]

<b>Value Table</b>

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.

<b>Check table</b>

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.

In short,

Check Table is <b>MASTER TABLE.</b>

Value Table is <b>TRANSACTION(VALUE) TABLE</b>.

reward if useful

Thanks & Regards

[Former Member]

HI

<b>Check table</b>

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

<b>Value tableIn</b> 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.

The system proposes the value table as check table when you try to define a foreign key for this field. You can override this proposal.

Entering a value table does not implement a check. The check against the value table only takes place when a foreign key is defined.

<b>TRANSACTION TABLE</b> for which the data will changed very frequently

<b>MASTER TA</b> for which the data won't be changed frequently

<b>Reward if usefull</b>

[Former Member]

hi

good

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.

reward point if helpful.

thanks

mrutyun^

[varma_narayana]

Hi...

1. CHECK TABLE - Table that contains Primary key in a Foreign key relation

2. VALUE TABLE - Assigned in a Domain , This will be proposed as check table by default

3. TRANSACTION TABLE - Stores day to day Transaction data like Orders (EKKO)

4. MASTER TABLE -Stores Master data which is rarely updated like customers, Materials.

reward if Helpful