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.
Edited by: Miikodesu on Sep 14, 2011 2:40 PM