topic Re: Storage Location in Application Development and Automation Discussions

Storage Location

Former Member — Wed, 15 Feb 2006 12:51:34 GMT

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

Re: Storage Location

Former Member — Wed, 15 Feb 2006 12:54:32 GMT

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

Re: Storage Location

Former Member — Wed, 15 Feb 2006 12:55:18 GMT

Hi Stephen,

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

Shobana

Re: Storage Location

Former Member — Wed, 15 Feb 2006 13:10:34 GMT

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