Steps for Allocation Cycle – Segment – Cost Center mapping
Business Purpose:
Cost allocation is a very common tool deployed within organizations to collect cost for a specific purpose. This cost is then spread across other cost centers/departments/inventory units after a certain period. After several periods, financial controllers and auditors often struggle in SAP to find out what was the origination and destination of cost allocation in SAP. This whitepaper details step by step process to get sending and receiving cost centers relationship from several allocation cycles.
Scenario:
Business may be looking for a list of all sending cost centers and receiving cost centers from different cycles/years in the past to do cost allocation analysis.
SAP Technical Steps:
1. Go to Cost center master data KS03 > Environment > Where Used List > Cycles in CO-OM and download the list. Record Cycle Names and Segment Numbers.
2. Go to table T811K (Allocations: Key Fields) and input “Controlling Area name & Cycle concatenated” in Cycle field with cycle names obtained from KS03 data.
Identify Sending Cost Centers:
3. Get sending cost center from field “From value (and to value if any)” where field = “KOSTL” and “I (Type of Set)” = 2 (Sending cost center) from T811K data.
4. Get the sending cost center group from field “Set Identification” from T811K data.
5. Get related set nodes for the current set. Remove setclass and Controlling area number prefix from the receiving cost center ID.
6. Go to SETNODE table and input Set Class = 0101, Org Unit = 0003 (Controlling area), Set Name from T811K data. Extract and get subset ID for further process.
7. Go to SETLEAF table and input Set Class = 0101, Org Unit = 0003 (Controlling area), Set Name = Subset ID from SETNODE Table data.
8. Rerun T811K sets in SETLEAF as some of the cost center hierarchies don’t have any nodes, but directly assigned with cost centers.
Identify Receiving Cost Centers:
9. For Receiving cost center, get “Set Identification” for fields where field = “KOSTL” and “I (Type of Set)” 3 = ReceiverSet from T811K data
10. Get related set nodes for the current set. Remove setclass and Controlling area number prefix from the receiving cost center ID.
11. Go to SETNODE table and input Set Class = 0101, Org Unit = 0003 (Controlling area), Set Name from step 4. Extract and get subset ID for further process.
12. Go to SETLEAF table and input Set Class = 0101, Org Unit = 0003 (Controlling area), Set Name = Subset ID from SETNODE Table data.
13. Rerun T811K sets in SETLEAF as some of the cost center hierarchies don’t have any nodes, but directly assigned with cost centers.
CHECKS:
KS03 for cost center – cycle – segments
KSH3 for cost center hierarchy.
