value table and search help

[Former Member]

Can any one say what is the difference between value table and search help

[Former Member]

Hi Mahesh,

Value Table : it checks all the records against to the check table and provide the possible values for the field or parameter.

It's a field in a domain it helps in domain level data validation.

Search Help : It also provides the possible values according to our own entries.

Search help can be assigned to data element level in FURTHER CHARACTERISTICS tab or at FIELD level.

Plz reward points if helpful,

Ganesh.

[prasanth_kasturi]

Hi,

Value Table : Its the domain level propsed check table, its assigned to domain and we can ceate it as check table and after we create it as check table we get F4 help and we can enter only that values

Search Help : It used for F4 functionality and we can ovveride that values

reward if helpful

prasanth

[Former Member]

Difference between a check table and a 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.

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.

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.

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.

reward points dear.

[Former Member]

hi....

Funtionality wise there is no diffrenece in value table and search help.Both give the list of possible values for f4.

The only thing is that lue table is defined at domain lel whereas serach heply can be defined at field leel or table level.

But there is defined hierachy for there f4 hepls.Which eans that if for a particular field both value table and search hepls are defined then serach help will take the priority over value table and the when u click for f4 help,values defined in serach help wll be taken first rather than value table.

Edited by: shlesha K on Jun 6, 2008 11:58 AM

[Former Member]

thanks for ur help