Searching Object ID (ARBID) based on Routing and Group Counter (PLNAL)

[Former Member]

Dear All

I want to search cost center (KOSTL) based on Order (AUFNR), right now i use 3 tables:

Selection: Order (AUFNR) to AFKO --> PLPO --> CRCO

1.AFKO table: to take Group Routing (PLNNR) and Group Counter (PLNAL)

2.PLPO table: to take Object ID (ARBID)

3.CRCO table: to take Cost Center (KOSTL)

The problem occur when 1 Material using more than 1 work center. If i can get Object ID (ARBID) based on not only Group Routing (PLNNR) but also based on Group Counter (PLNAL) then there is no problem. Unfortunately i can't find the way yet. PLPO table only have Group Routing but not Group Counter, so I can't get the right Object ID (ARBID) that represent work center.

I really need help here, please give some advice to get the right Cost Center.

Best Regards,

Edited by: Miikodesu on Sep 14, 2011 2:40 PM

[Former Member · Accepted solution]

Hi,

Use FM get_productionorder_details FM to get production order details. you will get list of operations and work centers in production order.

From that you cand erive the cost centers associated with work center from work center master tables like CRCO/CRCK.

If there are multiple operations in work center with different work centers , there could be multiple cost centers each one different in each work center.

check and revert,

santosh sarda

[Former Member · Accepted solution]

Thank you santosh,

That is very helpful answer..

Regards,

Ratri

[former_member184701]

dear friend,

you could try to use PLPO-PLNKN as your "Group Counter".

good luck!

[Former Member]

PLPO-PLNKN is only sequence number of task list, it can't be use to search work center/Object ID