How do you back track from a costing sheet to find where it is used?

By Tanya Duncan

How do you back track from a costing sheet to find out where it is actually used?  Unfortunately, there is not an easy way to verify this without going through configuration screens or table data. This is also complicated because costing sheets can be attributed to material masters or orders. I recommend you use two tables in Transaction SE16 or SE16N to determine where costing sheets are used in a standard cost (table KEKO, field KALSM) or on an order (table AUFK, field KALSM).

I also want to offer additional information on how costing sheets are configured and specifically what rate is used for a material. When you define percentage overhead rates or quantity overhead rates in the configuration of your costing sheet, you select an overhead rate that has a dependency.  The options for dependencies include overhead type, overhead type/OH key, overhead type/plant, overhead type/company code, overhead type/order type, and so on. This dependency determines when the overhead rate in your costing sheet is applied.

I typically use the dependency overhead type/OH key. This requires two additional configuration items to define OH keys, and then assign these OH keys to OH groups. On the material master, you can assign those configured OH groups to materials on the Costing 1 view field Overhead Group. If you use this method, you can run table MBEW in SE16 or SE16N and filter on the field KOSGR where not blank to see which OH groups are assigned to which materials. You can refer to your costing sheet configuration to determine where that OH group is being used. Note that even if an OH group is assigned on a material, the valuation variant you use for costing the material must also contain a costing sheet. Run table TCK05 in SE16 or SE16N and check if a costing sheet is entered in the fields KALSM or KALSM_RAW. The KALSM_RAW field indicates a costing sheet is relevant for component materials. 

As I mentioned before, you can also assign costing sheets to orders instead of assigning them directly to material masters. For example, on internal orders (KO03) the period end closing tab has a field to indicate a costing sheet. Another example is the assignment of costing sheets on production orders (CO03). There is one table for all order types that you can run to determine if a costing sheet is being used. Run table AUFK in SE16 or SE16N and search for field KALSM where not blank.

Costing sheet configuration is within the IMG Menu Path: SPRO • CONTROLLING • PRODUCT COST CONTROLLING • PRODUCT COSTING PLANNING • BASIC SETTINGS FOR MATERIAL COSTING • OVERHEAD • COSTING SHEET COMPONENTS