SAP Table that holds Material Plant description and detail

[Former Member]

Hi,

I am looking for a table in SAP System that holds detail data for WERKS fields from MARC Table. I would appreciate if anyone can tell me which table is the right one.

Sunny

[RichHeilman]

Check out table T001W. This has data for plants.

Please make sure to award points for helpful answers and mark this post as solved if your question is solved. Thanks.

Regards,

Rich Heilman

Message was edited by: Rich Heilman

[Former Member]

Also, in addition to Rich's reply, you can get the full address with a couple of function module calls.

type-pools: szadr.

data: wadr type addr1_sel-addrnumber,

w_ac type szadr_addr1_complete.

wadr = t001w-adrnr.

call function 'ADDR_GET_COMPLETE'

exporting

addrnumber = wadr

importing

addr1_complete = w_ac

exceptions

parameter_error = 1

address_not_exist = 2

internal_error = 3

wrong_access_to_archive = 4

others = 5.

if sy-subrc <> 0.

raise invalid_address.

endif.

call function 'ADDR_CONVERT_TO_BAPIADDR1'

exporting

addr1_complete = w_ac

importing

addr1_complete_bapi = address.

I use the second call becuase the address is a bit easier to interpret.