Skip to Content
author's profile photo Former Member
Former Member

Use of Value table

Hello All,

While go through SAP documentation for Value table, i found the following information:

"The value range of a field can be also defined by specifying a value table in domain.

In contrast to fixed values, however, simply specifying a value table does not cause the input to be checked.

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. If you refer to a domain with a value table in a field, but no foreign key was defined at field level, there is no check."

What I understood from the above is that, value table validation does not work, unless and until we define foreign key. Then what is the use of having a value table at domain level, giving a foreign key relationship will act as input check?

Thanks in advance,

Naga Sunkara

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 19, 2016 at 01:46 PM

    You have understood very well, and you also pasted the documentation which gives the answer to your question.

    If you enter a value table, the system can make a proposal for the foreign key definition.

    [...]

    What I understood from the above is that, value table validation does not work, unless and until we define foreign key. Then what is the use of having a value table at domain level, giving a foreign key relationship will act as input check?

    The interest is to propose the value table as default check table. It avoids looking for the table name. Very useful for BUKRS for instance, which is used in hundreds of tables.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 19, 2016 at 12:42 PM

    Hi,

    Specifying value table at domain level provides F4 help for the field. Apart from values in F4 help, you can give any input you want.

    After defining foreign key relationship and check table at data element, it will also do validation on fields input value. In this case, you will not be able to input any values other than what are present there in check table (foreign key).

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Pranay,

      Thanks for the reply.

      Forgot to mention one more point from the documentation:

      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.


      So giving value table, does not help for F4 help.


      what i want to know, why do we need a value table, if the foreign key needs to be defined at field level. Defining a foreign key alone will come as a validation, then what is the need of value table.


      Consider tables, EKKO and T001.

      1. BUKRS domain has the value table as T001

      2. BUKRS of EKPO table has the check table as T001,

      In EKPO table, check table is given as T001 for BUKRS field, so that the value table is to be considered. Why do we need that, when we have a foreign key relationship between EKPO and T001 table.


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.