topic Re: Production Planning in Application Development and Automation Discussions

Production Planning

Former Member — Mon, 17 Sep 2007 06:13:58 GMT

Hi,

I wanted to know how I can link up the production order operation no with work center (CRHD-ARBPL) in database level.

I mean to say we are able to see for a production order we have operation no & for every operation no we are able to see the work center in CO03 transaction.

But I would like to know how we can find for a particular operation no what is work center in database level??

Appriciated any help.

Regards,

Neha

Re: Production Planning

Former Member — Mon, 17 Sep 2007 06:47:01 GMT

Hi Neha ,

The Production Order table is APKO and AFPO item

In AFPO table there is field AUFPL which is a link to AFVV and AFVC

In Table AFVC there is field ARBID which if objid and link this object to CRHD table objid then ARBPL get the work center

Please reward if useful.

Re: Production Planning

Former Member — Mon, 17 Sep 2007 06:51:22 GMT

hi neha,

you can fetch the work centre(arbpl) based on operation no(vornr) from AFVC table

(i.e)

1.you should fetch AUFPL from AFKO by passing AUFNR

2. u should pass AUFPL to AFVC and get ARBID(u want to get single opeartion means pass vornr also)

3.pass ARBID to OBJID field in CRHD table here u will get work centre(arbpl).

regards,

siva

Re: Production Planning

Former Member — Mon, 17 Sep 2007 06:58:57 GMT

Hi,

the important tables are:

AFKO - Order header data PP orders where we find field AUFPL - Routing number for operations in the order - which helps us to identify the operations in table AFVC. VORNR being Operation Number & ARBID being WorKcenter ID. Pass this value into CRHD in field OBJID along with filed OBJTY = 'A' to get the ARBPL which is the work center.

Hope this helps.

Best Regards, Murugesh AS