work center and material

[Former Member]

Hi Gurus,

is there a table that will give me work center, material that is being run at that work center, quantity and date ?

Thanks

Anusha

[Former Member · Accepted solution]

hi

In the Routing only , the material is assigned to the workcenter .

so if you check with the item data of the routing . we can capture this data.

cjheck the tables:

AFPO Order Item Detail

AFVC Order Operations Detail

AFFL Order Sequence Details

PLPO Routing Operation Details

PLKO Routing Header Details

MAPL Routing Link to Material

PLAB Relationships - Standard Network

PLAS Task List - Selection of Operations

PLMZ Component Allocation

[Former Member]

Hi,

You can use this FM 'COIS_SELECT_ORDER_DATA_READ':

CALL FUNCTION 'COIS_SELECT_ORDER_DATA_READ'

EXPORTING

iv_prod_order_sel = lv_prod_order_sel

iv_proc_order_sel = lv_proc_order_sel

iv_planned_order_sel = lv_planned_order_sel

iv_rem_objects_only_sel = lv_rem_objects_only_sel

is_objects_to_read = ls_objects_to_read

it_parameter = lt_parameter

it_status_hdr = lt_status_hdr

it_status_opr = lt_status_opr

it_status_cmp = lt_status_cmp

TABLES

ct_ioheader = lt_ioheader

ct_ioitem = lt_ioitem

ct_iodocl = lt_iodocl

ct_ioopdocl = lt_ioopdocl

ct_iomamo = lt_iomamo

ct_ioconf = lt_ioconf

ct_ioopconf = lt_ioopconf

ct_iosoconf = lt_iosoconf

ct_iogomo = lt_iogomo

ct_ioopgomo = lt_ioopgomo

ct_iosogomo = lt_iosogomo

ct_iogmer = lt_iogmer

ct_ioopgmer = lt_ioopgmer

ct_iosogmer = lt_iosogmer

ct_iosequen = lt_iosequen

ct_iooper = lt_iooper

ct_iosoper = lt_iosoper

ct_ioopcomp = lt_ioopcomp

ct_iooppreq = lt_iooppreq

ct_iosopreq = lt_iosopreq

ct_iooppord = lt_iooppord

ct_iosopord = lt_iosopord

ct_ioopmst = lt_ioopmst

ct_ioopprt = lt_ioopprt

ct_ioopcap = lt_ioopcap

ct_ioopscap = lt_ioopscap

ct_iosocap = lt_iosocap

ct_iososcap = lt_iososcap

ct_ioopsccf = lt_ioopsccf

ct_iososccf = lt_iososccf

ct_ioprodlist = lt_ioprodlist

ct_iomatver = lt_iomatver.

Give the selection for workcenter. Check the transactipon COOIS and fill up the lt_parameter table with the workcenter detail. It will give the detail.

Thanks and regards,

Pradip

Edited by: Pradip Ray on Aug 26, 2009 10:34 AM

[former_member184655]

Dear Anusha,

For the tables check the suggestions given by the forum members.

At T Code Level use MCP1,enter the work center and date range in the input screen.

After executing click on display figures,(Press F6) and select the fields like confirmed quantity,operation quantity.

Check and revert back.

Regards

Mangalraj.S

[Former Member]

Hi,

Try with the foll. combination of tables:

AFKO (For the Production order, you can get the Material)

AFVC (You can get the Object ID of the work center)

CRHD (Get Work center name)

AFVV (Get Operation qty and scheduled date)

-Thaila Shree

[Former Member]

This message was moderated.