11-16-2006 6:16 AM
Hi All,
If i have Material number and plant number with me, How should i get the Workcenter for the Material/Plant combination...
Is there any FM available for this?
Amogh
11-16-2006 6:29 AM
Hi amogh ,
u ll get this in the table .. MKAL-MDV01
goto table MKAL
MKAL - matnr ,
werks
MDV01 -
> WORK CENTER ..
OR SELECT mdv01 into v_mdv01
where matnr
and werks ..
regards,
VIjay
11-16-2006 6:37 AM
Hi Vijay,
Thanks for the help. I tried this way but the work center is not maintained in MKAL table by my client.
Is there any other method to get the WC...
Thanks
Amogh
11-16-2006 6:55 AM
did u pass matnr werks <b> verid</b>
version id has to be passed this is compulsory ..
check now
mdv01 values
mdv02 values ..
or do one thing .. just give the plant and the material number and compare the same for all the entries ..
check this table by passing ur Plant in the T437P table and check for the list of workcenters ...here u will get the workcenters under a plant ..
this is ur check table ...
-
T437L--->the entry has to be in this table ..
-
now MKAL
when i do a routing then my <b>material master table has to get updated</b> .. it has to store in here ..
..
do one thing .. goto MM03 and check the view for planning ..
regards,
VIjay
Message was edited by:
vijay k
11-16-2006 6:29 AM
Hi,
May be try to get the work centers for a particular plant and material by joining the tables CRHD and MARC on Plant (WERKS field).
11-16-2006 7:05 AM