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: 

Storage Location

Former Member
0 Kudos

I have created a new table for restricted value of storage location!

and some addition Z-fields!

I'd like the F4 on the field wERKS of My Z-table to show the liste of the werks in the table + the field NAME1 of the Standard table of storage location!

How would you do this ? The F4 possibility ? Any foreign key etc ? I'd like to say in fact the text is the field NAME1 of standard!

Stph

3 REPLIES 3

Former Member
0 Kudos

Hy

You should create an Z-SEARCH HELP based on view created by a join with your Z-TABLE and master table of storage location (T001L).

Max

Former Member
0 Kudos

Hi Stephen,

THe best bet is to create a search help and attach the same to your Ztable WERKS field.

Shobana

Former Member
0 Kudos

Hi Stephan,

You can also achieve this by creating a foreign key relationship for the field WERKS.

All you need to do is:

1) select field WERKS in your table and click on Foreign key button.

2) Click YES on the pop up window.

3) Another window will be poped up for creating foreign key relationship.

4) Change the Check Table name to T001L.

5) It will ask to Create proposal for field assignment.

6) Click YES.

7) Press ENTER and activate your table.

😎 While making the entries, F4 Help will appear with Plant and Storage Location.

Hope it will solve your problem.

Regards,

Neeraj Gupta