What are the master data tables for 'Plant'?

[Former Member]

Hi friends,

What are the master data tables for 'Plant' that contain below data?:

PLANT

NAME1

NAME2

LANGUAGE

HOUSE_NUM_STREET

PO_BOX

POSTAL_CODE

CITY

COUNTRY_KEY

REGION

COUNTRY_CODE

CITY_CODE

TIME_ZONE

TAX_JURISDICTION

FACTORY_CALENDAR

Thanks a lot!

[Former Member · Accepted solution]

Hi ,

Tables used are T001W which will have adrnr field ,use that field in table ADRC you will get maximum data you required.

[Former Member]

Another option is by transaction OX10 then transport via request.

[Former Member]

address : ADRC, t001w and marc

T001W : werks TYPE t001w-werks, "PLANT

name1 TYPE t001w-name1, "PLANT DESCRIPTION

adrnr TYPE t001w-adrnr, "PLANT ADDRESS NUMBER

ADRC: addrnumber TYPE adrc-addrnumber, "ADDRESS NUMBER

str_suppl1 TYPE adrc-str_suppl1, "STREET2

str_suppl2 TYPE adrc-str_suppl2, "STREET3

street TYPE adrc-street, "STREET

city1 TYPE adrc-city1, "CITY

post_code1 TYPE adrc-post_code1, "CITY POSTAL CODE

post_code2 TYPE adrc-post_code2, "PO Box postal code

tel_number TYPE adrc-tel_number, "TELEPHONE NUMBER

fax_number TYPE adrc-fax_number, "FAX NUMBER

str_suppl3 TYPE adrc-str_suppl3, "STREET4

location TYPE adrc-location, "STREET5

city2 TYPE adrc-city2,

For Tax Details :

J_1IMOCOMP : werks TYPE j_1imocomp-werks,

j_1icstno TYPE j_1imocomp-j_1icstno,

j_1ilstno TYPE j_1imocomp-j_1ilstno,

[former_member333737]

Hi,

Plz try out following for your requirement.: T001W, ADRC, J_1IMOCOMP Tables.

In these tables you will find out the master data

[Former Member]

You will get plant data in MARC, MAST, MAPL,

[Former Member]

Hi,

The field name for plant is WERKS. You can find the the check table for the field in MARA table corresponding to the field WERKS ie T001W. You will get all the details from T001W table.

Regards

Sabu

[Former Member]

hi

goto SE11 enter the table name T001W

u will get the info related to Plants & Branches.

Regards

[Former Member]

Hi,

Use below function Module. U can fetch all the plant related data.

PIA_CSO_PLANT_ADDRESS_READ

[Former Member]

Hi,

Check T001W table, you will get all the plant data information

Regards,

Jyothi CH.

[Former Member]

Hi,

Plz try out following tables for your requirement.

TOO1W

ADRC

J_1IMOCOMP

T001W : werks TYPE t001w-werks, "PLANT

name1 TYPE t001w-name1, "PLANT DESCRIPTION

adrnr TYPE t001w-adrnr, "PLANT ADDRESS NUMBER

ADRC: addrnumber TYPE adrc-addrnumber, "ADDRESS NUMBER

str_suppl1 TYPE adrc-str_suppl1, "STREET2

str_suppl2 TYPE adrc-str_suppl2, "STREET3

street TYPE adrc-street, "STREET

city1 TYPE adrc-city1, "CITY

post_code1 TYPE adrc-post_code1, "CITY POSTAL CODE

post_code2 TYPE adrc-post_code2, "PO Box postal code

tel_number TYPE adrc-tel_number, "TELEPHONE NUMBER

fax_number TYPE adrc-fax_number, "FAX NUMBER

str_suppl3 TYPE adrc-str_suppl3, "STREET4

location TYPE adrc-location, "STREET5

city2 TYPE adrc-city2,

For Tax Details :

J_1IMOCOMP : werks TYPE j_1imocomp-werks,

j_1icstno TYPE j_1imocomp-j_1icstno,

j_1ilstno TYPE j_1imocomp-j_1ilstno,

Hope this will help.

Regards,

Archana

[former_member555112]

Hi,

You will get all these details in T001W table.

Regards,

Ankur Parab