Skip to Content
author's profile photo
Former Member

Co02 - workcenter

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Sep 30, 2005 at 10:49 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 30, 2005 at 02:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 03, 2005 at 10:31 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded