table for storage location address

[Former Member]

Hi Folks,

I want to download the list of all storage locations assigned to a very Particular Plant along with its address.

From which table can this be fetched ??

[Former Member · Accepted solution]

Hi

Goto SE16N

Enter Table name T001L and press enter

Enter plant and execute.

It will display all the storage locations assigned to plant

Thanks

Raman

[Former Member · Accepted solution]

Folks,

could you please revisit my requirement?

I want to download the addresses of the storage locatio attached to a particular company code.

[Shiva_Ram · Accepted solution]

Hi,

Use table TWLAD to find the storage locations of a plant. This table contains the address number for each storage location.

Then use the address numbers in table ADRC to find the address details.

Regards

[jmark304]

Do SQVI Using tables in order listed:

T001L, TWLAD, ADRC Allow the default join.

Fields for selection:

T001L-WERKS = Plant

Fields for list:

T001L-WERKS = Plant
TWLAD-LGORT = Storage Location
TWLAD-LFDNR
ADRC-NAME1 = Name 1
ADRC-NAME2 = Name 2
ADRC-SORT1 = Search Term 1
ADRC-SORT2 = Search Term 2
ADRC-STR_SUPPL1 = Street 2
ADRC-STREET = Street
ADRC-POST_CODE1 = City Postal Code
ADRC-CITY1

Run it and enter the plant you want the results for. Any SLOC/Sequential Number with an address will be listed. Adjust fields to your liking.

Thanks,

Mark

[Former Member]

HI,

Use the transaction code :MMSC you will find the list of storage location available in a particular plant along with the address.

Hope this will help u.

[Former Member]

Hi

You can write a SQVI Query with Table Join conditions using tables like MARC & MARD .

Thanks & Regards,

Mani