Co02 - workcenter

[Former Member]

Hi All,

I am trying to identify the field of the work center in the transaction co02 in operations view. If anyone have worked on it. Kindly let me know the table.

regards,

Bala

[Former Member · Accepted solution]

Production order operations are stored in AFVC.

From this table for a given operation fetch the field ARBID.

Now, go to CRHD ( Work center Master Data ) and query this ARBID to OBJID and pass 'A' to OBJTY, u will get the Cost Center assosiated with the operation of PP.

[Former Member · Accepted solution]

when we go for the operation overview in CR02 we get a list with opac start date, time , work center. I wanna know the field for work center.

[Former Member · Accepted solution]

In the table CRHD and field name arbpl.

I hope this helps

[Former Member]

First of all,

If u want to know in which table cost center is stored then the table name is AVFC. But it is not directly stored as ARBPL but as ARBID.

If you want the cost center name then go to CRHD for the same ARBID and fetch ARBPL.

Finally it is AVFC-ARBID.

[Former Member]

This might help:

  loop at order_int.
    clear arbpl_desc.
    select  single gewrk
      from  vafiloa
      into  arbpl_desc-arbpl_o
      where aufnr  = order_int-aufnr.
    if sy-subrc = 0.
      append arbpl_desc.
    endif.
  endloop.

  sort arbpl_desc by arbpl_o.
  delete adjacent duplicates from arbpl_desc.

  loop at arbpl_desc.
    select single h~arbpl h~werks t~ktext_up
           from   crhd as h join crtx as t
             on   h~objty = t~objty
            and   h~objid = t~objid
           into   (arbpl_desc-arbpl, arbpl_desc-werks,
                   arbpl_desc-ktext_up)
           where  h~objty = 'A'
           and    h~objid = arbpl_desc-arbpl_o
           and    t~spras = sy-langu.
    if sy-subrc <> 0.
      clear: arbpl_desc-arbpl,
             arbpl_desc-werks,
             arbpl_desc-ktext_up.
    endif.
    modify arbpl_desc.
  endloop.

Rob