Skip to Content
author's profile photo
Former Member

SAP Table that holds Material Plant description and detail

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 05, 2005 at 10:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 06, 2005 at 04:39 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded