topic Re: value table in Application Development and Automation Discussions

value table

Former Member — Tue, 28 Feb 2006 10:39:42 GMT

what is value tab ?

Re: value table

hymavathi_oruganti — Tue, 28 Feb 2006 10:40:25 GMT

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

Re: value table

Former Member — Tue, 28 Feb 2006 10:44:52 GMT

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

Re: value table

Former Member — Tue, 28 Feb 2006 10:45:00 GMT

Hi charan,

we give value table in domain level for a field.

It contains the values for a particular field.

Thanks..

Re: value table

Former Member — Tue, 28 Feb 2006 10:48:03 GMT

what purpose this value is useful

Re: value table

Former Member — Tue, 28 Feb 2006 10:51:09 GMT

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

here.

Re: value table

Former Member — Tue, 28 Feb 2006 10:53:01 GMT

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>

AND GOTHROUGH DAY 4

IF THESE FINDS USEFUL PLEASE REWARD POINTS

REGARDS

ANOOP

Re: value table

Former Member — Tue, 28 Feb 2006 10:53:23 GMT

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

Re: value table

Former Member — Tue, 28 Feb 2006 10:55:17 GMT

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

Re: value table

Former Member — Tue, 28 Feb 2006 10:57:16 GMT

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.

Re: value table

Former Member — Tue, 28 Feb 2006 11:12:17 GMT

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

Re: value table

Former Member — Tue, 28 Feb 2006 11:22:50 GMT

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

Re: value table

Former Member — Tue, 28 Feb 2006 12:29:36 GMT

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

Re: value table

Former Member — Tue, 28 Feb 2006 12:37:42 GMT

Check tables

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:

Value table

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.

There is 1 more important Difference in Value Table and Check Table is that:

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.

reward if useful

Message was edited by: Ashok Kumar Prithiviraj

Re: value table

Former Member — Tue, 28 Feb 2006 12:40:29 GMT

For Check table please refer to

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

Re: value table

Former Member — Tue, 28 Feb 2006 12:40:57 GMT

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

Re: value table

Former Member — Tue, 28 Feb 2006 12:41:57 GMT

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

Re: value table

Former Member — Tue, 28 Feb 2006 13:10:46 GMT

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

Re: value table

Former Member — Tue, 28 Feb 2006 13:57:27 GMT

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

Re: value table

Former Member — Wed, 01 Mar 2006 06:11:53 GMT

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