ABAP

[Former Member]

Hello,

This is Prabhakar,

Actually I am new to ABAP programming,

I have one Doubt about "Value Table", What for we use that? Also give some functionality about this

Thank you

[Former Member · Accepted solution]

Hi ,

Check Table is for Field level Validation whereas Value table is for Domain Level Validations. Value Table proposes table for check table.

I think you are clear with this.

--venkat

[Former Member · Accepted solution]

Hello Venkata Dasari, with your answer i satisfied

Thank you

[Former Member]

hi all,

Value table is maintained at domain level

when ever we try to establish a foreign key relation ship it proposes a foreign a key and it provides the F4 functionality .

[Former Member]

Value table is at Domain level, when u r creating a domain there u can give the value table name, so that the field only accepts that values which r in the value table.

In SE11 u can find when u will create a domain.

[Former Member]

Hi,

Have a look at these good links-

<b>Check Table and Value Table</b>

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

<b>General ABAP Links-</b>

http://www.sappoint.com/abap.html

http://www.sap-img.com/abap-function.htm

http://www.easymarketplace.de/online-pdfs-q-s.php

http://help.sap.com/

http://sapassist.com/groups/groups.asp?v=sap-r3-dev&m=3&y=2004

http://training.saptechies.com/sap-basis-certification-sample-questions/

http://www.geocities.com/mpioud/Abap_programs.html

http://cma.zdnet.com/book/abap/index.htm

http://www.sapdevelopment.co.uk/

http://www.sap-img.com/

http://juliet.stfx.ca/people/fac/infosys/abap.htm

http://help.sap.com

http://www.sap-img.com

http://www.thespot4sap.com

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

http://www.sapdevelopment.co.uk/

http://www.sap-img.com/

http://juliet.stfx.ca/people/fac/infosys/abap.htm

http://help.sap.com/saphelp_46c/helpdata/en/d3/2e974d35c511d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_46c/helpdata/en/d6/0db357494511d182b70000e829fbfe/frameset.htm

http://www.henrikfrank.dk/abapexamples/SapScript/sapscript.htm

http://www.sapgenie.com/abap/example_code.htm

http://www.geocities.com/SiliconValley/Campus/6345/abapindx.htm

http://help.sap.com/printdocu/core/Print46c/en/Data/Index_en.htm

http://help.sap.com/saphelp_40b/helpdata/en/4f/991f82446d11d189700000e8322d00/applet.htm

http://www.sap-img.com/abap-function.htm

http://www.sapgenie.com/abap/code/abap19.htm

http://www.sap-img.com/abap/more-than-100-abap-interview-faqs.htm

http://www.planetsap.com/Tips_and_Tricks.htm

http://help.sap.com/saphelp_40b/helpdata/ru/d6/0dc169494511d182b70000e829fbfe/applet.htm

http://www.henrikfrank.dk/abapexamples/SapScript/symbols.htm

http://www.henrikfrank.dk/abapexamples/index.html

http://sap.ittoolbox.com/documents/document.asp?i=752

http://members.aol.com/_ht_a/skarkada/sap/

http://sappoint.com/abap/

http://members.tripod.com/abap4/SAP_Functions.html

http://members.ozemail.com.au/~anmari/sap/index.html

http://www.planetsap.com/Userexit_List.htm

http://www.planetsap.com/Tips_and_Tricks.htm

http://www.kabai.com/abaps/q.htm

http://www.planetsap.com/Userexit_List.htm

http://help.sap.com/saphelp_bw21c/helpdata/en/c4/3a8090505211d189550000e829fbbd/frameset.htm

http://www.sapgenie.com/abap/bapi/example.htm

http://help.sap.com/saphelp_45b/helpdata/en/65/897415dc4ad111950d0060b03c6b76/content.htm

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

http://help.sap.com/saphelp_40b/helpdata/en/fc/eb2c46358411d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_46c/helpdata/en/aa/aeb23789e95378e10000009b38f8cf/frameset.htm

http://www.geocities.com/ResearchTriangle/1635/system.html

http://www.sapdesignguild.org/resources/MiniSG/3_Managing/3_Functions_Table_Control.htm

http://help.sap.com/saphelp_45b/helpdata/en/d1/801bdf454211d189710000e8322d00/content.htm

http://www.sapfans.com/sapfans/repos/saprep.htm

http://www.planetsap.com/howdo_a.htm

http://help.sap.com/saphelp_util464/helpdata/en/69/c2516e4ba111d189750000e8322d00/content.htm

http://www.sapgenie.com/abap/smartforms_detail.htm

http://www.sap-img.com/abap.htm

http://help.sap.com/saphelp_46c/helpdata/en/fc/eb2d67358411d1829f0000e829fbfe/content.htm

http://www.geocities.com/victorav15/sapr3/abap.html

http://www.henrikfrank.dk/abapexamples/SapScript/sapscript.htm

http://abap4.tripod.com/Other_Useful_Tips.html

http://help.sap.com/saphelp_45b/helpdata/en/cf/21ee2b446011d189700000e8322d00/content.htm

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

http://sap.ittoolbox.com/nav/t.asp?t=303&p=448&h1=303&h2=322&h3=448

http://sapfans.com/

http://cma.zdnet.com/book/abap/ch03/ch03.htm

http://help.sap.com/saphelp_40b/helpdata/en/4f/991f82446d11d189700000e8322d00/applet.htm

http://sappoint.com/abap/

http://www.henrikfrank.dk/abapuk.html

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/abapindx.htm

http://www.sapgenie.com/abap/index.htm

http://www.sap-img.com/abap.htm

http://www.sapdevelopment.co.uk/tips/tipshome.htm

http://help.sap.com/printdocu/core/Print46c/en/Data/Index_en.htm

http://sap.ittoolbox.com/nav/t.asp?t=322&p=322&h1=322

http://sap.ittoolbox.com/nav/t.asp?t=448&p=448&h1=448

http://www.thespot4sap.com/

http://www.kabai.com/abaps/q.htm

http://www.geocities.com/mpioud/Abap_programs.html

http://www.sapgenie.com/abap/tips_and_tricks.htm

http://www.sapassist.com/code/d.asp?whichpage=1&pagesize=10&i=10&a=c&o=&t=&q=&qt=

<b>Please Reward Points & Mark Helpful Answers

To mark Helpful Answers ;click radio Button next to the post.

RadioButtons

o Helpful Answer

o Very helpful Answer

o Problem Solved.

Click any of the above button next to the post; as per the anwers

To close the thread; Click Probelm solved Radio Button next to the post , which u feel is the best possible answer.</b>

Regards,

Tanuja.

[Former Member]

Hi Prabhakar,

It can be defined as default check table.

For eg: a country code check table may be needed to validate country codes for all tables where country codes will be stored. When you create a simple check table you have to create multuiple foreign key relationships linking many other tables to a check table. But with value table you define value table in domain and simplify this relationship.

eg: whenyou crate a check table you create a domain also. then you will create a data element say ztxland1 and then check table itself.then activate table. Then go back into domain for primary key field and put name of check table you just created in value table field.

Now create another table ztxlfa1 and land1 field and use ztxland1 data element and then bioth fields use same domain.

Now you create foreign key to validate land1.place your cursor on ztxlfa1-land1 field and press foreign key button. when you do this system will lookinto domain at value table field. If there were a table name there the system would automatically propose that name as check table.

Hope this cud be of somehelp.

You can also refer to following link:

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

Regards,

Amit.

Please reward any help.

Message was edited by: amit bhadauria

[Former Member]

Hi

Value table will act as a search help by listing the values contained in the value table when you press F4.

Kindly check this link:

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

Please refer the following threads:

best regards,

Thangesh

[Former Member]

Hi Prabhakar,

Welcome to SDN

The value range (allowed values) of a field is defined by specifying a value table for a domain. In contrast to fixed values, however, simply specifying a value table does not cause the input to be checked. There is no F4 help either.

The application of Value table is that, if you enter a value table, the system can make a proposal for the foreign key definition. A value table only becomes a check table when a foreign key is defined.

regards,

Raj

[Former Member]

Hi,

A check table becomes a value table, once the foreign key is defined.

Table A: Master Table

EMPNO

NAME

Table B: Transaction Table

EMPNO

DOB

Address

Here in the table B, EMPNO is defined as a foreign key, because enries or transactions are possible in table B for any employee only if the corresponding EMPNO exists in table A.

So you define Table A as a check table for table B, once you define the check table A becomes a Value table for B. (That is allowable values in table B with respect to EMPNO in table A).-

Regs,

Venkat Ramanan N

[Former Member]

Hi Prabhakar,

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

[Former Member]

Hii

check this link..

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

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.

[Former Member]

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

chk this also

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