work centre name from order number

[former_member1242643]

Hi Gurus,

Can you please tell me how can i get( from which tables and joining condition) work centre name for each operation by using the order number.

Regards

Rajib Pathak

[former_member199502 · Accepted solution]

Hi,

You Can do like this also,

Go to AFKO-AUFNR,take AUFPL(reference routing for order)then Go to AFVc,give AUFPL take ARBID and then input in CRHD,u will get workcenter name(ARBPL)

I think this is correct instead of going to AFRU

[muthusamy_sankaran]

Hi,

see below

table AFKO fields (AUFPL), input field AUFNR

table AFVC fields (ARBID), input field AFKO-AUFPL

table CRHD fields (ARBPL), input field CRHD-OBJID = AFVC-ARBID

Regards,

Sankaran

[Former Member]

Hi ,

Use the below tables for your reqt :

AUFK for identifying the OBJNR

AFRU for identifying the Confirmation no and Rotuing number for the operation (AUFPL)

AFVC / AFVV for identifying the Work center / opeation number and std times.

Regards

radhak mk

[Former Member]

Hi,

Input Order (AUFNR) to AFKO table - Get the value of AUFPL (Routing no. for operations)

Now goto AFVC table (Operation within an order) - Input AUFPL and get the values of ARBID (Object ID)

This ARBID acts as OBJID (Object ID) in table CRHD (Work Center Header). Get the value of ARBPL (Work center name ) for the corresponding OBJID.

-Thaila Shree

[Former Member]

Hi,

Its better to go with AFKO (Order Header Table) as AFRU only gives you data for confirmed orders.

AFKO-PLNNR

PLPO-PLNNR

PLPO-ARBID

CRHD-OBJID

Regards

[former_member199502]

Hi,

Go to AFRU table,give the order(AUFNR) and execute.get the ARBID(object ID) for that order number and input that in OBJID field of CRHD table,u will get the workcenter name(ARBPL)

Hope it is helpfull

Edited by: Girish Adaviswamy on Apr 1, 2009 9:37 AM