value table

[Former Member]

what is value tab ?

[hymavathi_oruganti]

the value table is the table u give in domain level for the field.

[Former Member]

Hi,

Plese check this link.

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

Cheers

Sunny

If helpful , rewrds points

[Former Member]

Hi charan,

we give value table in domain level for a field.

It contains the values for a particular field.

Thanks..

[Former Member]

what purpose this value is useful

[Former Member]

when U press F4 for a field the value is picked from

here.

[Former Member]

Hi ravi

Value table is given in the domain inddic

it used to specify that the domain should have value which are present in the given value table.

it is like a check table in the domain level itself

regards

kishore

[Former Member]

If value table is attached at domain lavel then what all values are defined in it , user can enter only those values.

It means it won't allow values other then the one which is defined in value table.

Please close the thread if ur satisfied with it.

Cheers

Sunny

Rewrd points, if helpful

[Former Member]

Hi Ravi,

Value table consists of the valid set of values for the field and is defined in the domain.All the fields referring to this domain will be checked against this table.Entering a value table does not implement a check. The check against the value table only takes place when a foreign key is defined.

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.

[Former Member]

Hi Ravi,

Please visit this link for actual diff. between value table and checktable.

Plese check this link.

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

Cheers

Sunny

If helpful , rewrd points

[Former Member]

HI

Within the domain is the Value Table field. The table named within this field provides the following functions to the domain:

It is automatically proposed as the check table when creating a foreign key

It provides a list of values for F4 (possible entries) help, but it does not provide validation

Whenever you create a foreign key relationship, the system looks in the value table field. If there is a table name there, it proposes that name as the check table.

FOR FURTHER DETAILS CHECK THE LINK<a href="http://cma.zdnet.com/book/abap/">http://cma.zdnet.com/book/abap/</a>

<u>AND GOTHROUGH DAY 4</u>

IF THESE FINDS USEFUL PLEASE REWARD POINTS

REGARDS

ANOOP

[Former Member]

U can have a look at this link.

For example : T002 is the value table for Domain SPRAS

(Language Key)

http://help.sap.com/saphelp_46c/helpdata/en/35/2cd77bd7705394e10000009b387c12/frameset.htm

[Former Member]

Hi Ravicharan,

First of all, I would like to clear two things:

1) Value table does not provide any F4 help.

2) Value table does not provide any validation.

Only thing happened by specifying a Value table is: System proposes the value table name as the check table name when we try to create a foreign key relationship for the field and we can override this proposal.

Value table is defined at Domain level.

Try to test these.

Regards,

Neeraj Gupta.

Message was edited by: Neeraj Gupta

[Former Member]

Hi Gupta,

Thanks for u reply . Can tell me the difference between value table and check tale .And how to use and where to use?

Thanks & Regards

ravi

[Former Member]

<b>Check tables</b>

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 tables:

<b>Value table</b>

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.

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>There is 1 more important Difference in Value Table and Check Table is that:</b>

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.

<b>reward if useful</b>

Message was edited by: Ashok Kumar Prithiviraj

[Former Member]

For Check table please refer to

http://help.sap.com/saphelp_46c/helpdata/en/35/2cd77bd7705394e10000009b387c12/frameset.htm

[Former Member]

Table that contains validate set of values is nothing but Checktable.

This is must we you are going to making foreign key relationship.

valuetable :

Within the domain is the Value Table field. The table named within this field provides the following functions to the domain:

It is automatically proposed as the check table when creating a foreign key

It provides a list of values for F4 (possible entries) help, but it does not provide validation

Whenever you create a foreign key relationship, the system looks in the value table field. If there is a table name there, it proposes that name as the check table.

Message was edited by: Eswar Kanakanti

[Former Member]

Hi Ravi

value table in entered in the domian level. if you want to restric the value of the domain you created to the some values. then you can create a table using this values and give that values as the value table to that domain.

check table in used for attaining the foreign key relationship between two table i.e parent child relationship

regards

kishore

[Former Member]

hi Ravi,

If ur satisfied with the replies , please close the thread and as per form Etiquettes , Kindly reward points to the useful answers by clicking the radiobutton which will be there on the left side.

Cheers

Sunny

[Former Member]

Hi Everybody,

Please go through the link given by sunny.

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

It is clearly mentioned in the bottom that contents of Value Table are never used in Input Help.

You can test it by creating a Z-Domain and attaching a Z-table to that domain as a Value Table.

Regards,

Neeraj Gupta

[Former Member]

HI

<u>Value Table</u>

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.

<u>Check table</u>

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.

<u>There is 1 more important Difference in Value Table and Check Table is that:</u>

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.

REGARDS

ANOOP