Reg:master table

[Former Member]

Is there any standard table which has werks , matnr,mtart as fields ..thanx in advance ........

[Former Member]

Hi

T001W for WERKS (Plants/Branches)

MARA for MATNR (Material Master)

T134 for MTART (Material Types)

For the Tables list check this table -

Or

MATNR MTART are in MARA

MATNR WERKS are in MARC.

Use the for all entires or Join to have the combination.

Thanks & Regards,

Chandralekha.

[Former Member]

Have a join bet MARA and MARC

[Former Member]

Hi

For MTART, MATNR you will get MARA and pass the same MARA-MATNR to MARC-MATNR to get the WERKS.

Hope thi helps .

Rewart Points.

Regards,

[vinod_vemuru2]

HI,

Join MARA and MARC table.

Mara has material and material type.

MARC has plant.

SELECT a_{matnr a}mtart b~werks INTO TABLE i_materials

FROm mara AS a INNER JOIN marc AS b

ON a_{matnr EQ b}matnr

WHERE ur where clause.

Thanks,

Vinod.

[Former Member]

Hi

PA0001 has werks as a field.

MARA table has matnr,mtart as fields.

[GauthamV]

hi,

EKPO table.

MATNR - Material Number

WERKS - Plant

MTART - Material Type.

[Former Member]

Please take into consideration that this is just the Purchasing Document Item table.

It will not contain each Material that is created in SAP, if you want to find all Materials for a specific plant and specific material type.

For these cases you should create a query.

Correct me if I am wrong.

[Former Member]

i want to have a table which has all the three fields .............

[GauthamV]

hi,

i hope u saw my reply.

[Former Member]

thanx for the immediate reply .