Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

F4 help in user created table

Former Member
0 Kudos

Hi all,

i have created a ztable..in that i have a field pernr. i need to have f4 help in screen for entering the data. how to get the F4 help ..

5 REPLIES 5

Former Member
0 Kudos

Hi,

If you set the Search help for that in the Data elemtn of that field then the F4 wil come, or you can give the values in the Domain level(Fixed values) then these values will come in F4, or else you can maintain the Check table to come this F4

Regards

Sudheer

0 Kudos

thanks Sudhir, i want all pernr should come form table pa0001....how it is possible. where ti maintain check table>??

its urgent....

0 Kudos

Hi...

You have to Create a Foreign key relation for the Field PERNR in ur ZTable .

Steps:

1. Place the Cursor on the field PERNR in your ZTable

2. Select Foreign Key Icon (just above the field names you can find a Key button)

3. Assign the Table pa0001 as Cehck Table in the Foreign key window

Activate the Table. Now check out .

<b>Reward if Helpful</b>

Former Member
0 Kudos

Former Member
0 Kudos
"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.

so goto your ztable .... in change mode place the cursour in the PERNR field .. press the Foreign key relation ...in the Dialog box put pa0001 table name as Check table and select the PERNR field .

press enter save, Activate ..

now see in the check table relation exsist for the field PERNR .

Now you can execute your program as using :

"  Parameter : pernr  for ztable-pernr  .

reward points if itis usefull.....

Girish