By Tanya Duncan
Start with the costing sheet ID. Search KEKO-KALSM for cost estimates and AUFK-KALSM for orders. Then use TCK05 and MBEW to trace the valuation variant and material overhead group behind the assignment.
Find Cost Estimates, Orders, and Valuation Variants
Use SE16 or SE16N where available in your system. Filter by the exact costing sheet ID when tracing a specific sheet. Use a nonblank filter to find records with any costing sheet or overhead group assignment. Table 1 shows what each lookup tells you.
| What to Check | Table and Field | How to Use the Result |
|---|---|---|
| Material cost estimates | KEKO-KALSM | Find cost estimate headers that reference the sheet. Check the costing variant, date, and status when investigating a particular standard cost estimate. |
| Orders | AUFK-KALSM | Find orders with the sheet assigned. Narrow the results by order type or the relevant organizational values. |
| Valuation variants | TCK05-KALSM TCK05-KALSM_RAW |
Check the costing sheet for overhead and the separate costing sheet for raw material overhead, where configured. |
| Material overhead groups | MBEW-KOSGR | Find material valuation records with an overhead group. Check the material and valuation area before comparing assignments. |
Trace the Overhead Rate for a Material
A costing sheet can use percentage-based or quantity-based overhead rates. The rate dependency determines which factors SAP uses to select a rate, such as overhead type combined with overhead key, plant, company code, or order type.
- Check the material’s Overhead Group on the Costing 1 view, or look up MBEW-KOSGR.
- In Customizing, check which overhead key is assigned to that overhead group. Find the corresponding rate in the costing sheet when the rate depends on overhead type and overhead key.
- Check TCK05 to confirm that the valuation variant used for the material cost estimate references the expected costing sheet. An overhead group on the material alone does not establish that the rate was applied.
Check the Assignment on an Order
Use KO03 for an internal order and check the costing sheet in its period-end closing data. Use CO03 to review a production order. To see whether SAP actually calculated or posted overhead, review the relevant costing or overhead calculation results. The assignment alone shows which sheet is referenced.
Where to Find Costing Sheet Configuration
In the classic IMG, go to SPRO → Controlling → Product Cost Controlling → Product Cost Planning → Basic Settings for Material Costing → Overhead → Costing Sheet Components. Menu labels and access to classic transactions can vary by SAP edition, release, and authorization.
Diagnose Missing or Unexpected SAP Overhead
Start with one material or order whose overhead looks wrong. ERP Corp can help you trace the costing sheet, overhead key, and rate selection to pinpoint which setting explains the result.
