Storage Location

[Former Member]

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

[Former Member]

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]

Hi Stephen,

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

Shobana

[Former Member]

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