topic Re: Reg:master table in Application Development and Automation Discussions

Reg:master table

Former Member — Fri, 25 Jul 2008 07:07:05 GMT

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

Re: Reg:master table

Former Member — Fri, 25 Jul 2008 07:08:34 GMT

T001W for WERKS (Plants/Branches)

MARA for MATNR (Material Master)

T134 for MTART (Material Types)

For the Tables list check this table -

MATNR MTART are in MARA

MATNR WERKS are in MARC.

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

Thanks & Regards,

Chandralekha.

Re: Reg:master table

Former Member — Fri, 25 Jul 2008 07:10:08 GMT

Have a join bet MARA and MARC

Re: Reg:master table

Former Member — Fri, 25 Jul 2008 07:12:03 GMT

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,

Re: Reg:master table

vinod_vemuru2 — Fri, 25 Jul 2008 07:12:04 GMT

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.

Re: Reg:master table

Former Member — Fri, 25 Jul 2008 07:12:21 GMT

PA0001 has werks as a field.

MARA table has matnr,mtart as fields.

Re: Reg:master table

GauthamV — Fri, 25 Jul 2008 07:25:31 GMT

hi,

EKPO table.

MATNR - Material Number

WERKS - Plant

MTART - Material Type.

Re: Reg:master table

Former Member — Fri, 25 Jul 2008 07:40:52 GMT

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

Re: Reg:master table

GauthamV — Fri, 25 Jul 2008 07:43:03 GMT

hi,

i hope u saw my reply.

Re: Reg:master table

Former Member — Fri, 25 Jul 2008 07:50:45 GMT

thanx for the immediate reply .

Re: Reg:master table

Former Member — Wed, 17 Jun 2020 10:39:39 GMT

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.