Main menu
Member section cover

BLOG

ERPCorp SAP FICO Blog

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

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 SE16 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

 

 

Controlling 2014 Plenary Presentation Slides: SAP ...
How do settlement rules, settlement profiles and a...

Related Posts

 

Comments 1

Guest - varshaa on Thursday, 29 September 2016 06:35

Its so much informative for the followers. I like the way you describe this post. Its really helpful for the users of this site. I am also searching about these type of sites now a days. So your site really helps me for searching the new and great stuff. This site contain all my specifications. Thanks for sharing. Keep it up. I am waiting for your more posts like this or related to any other informative topic.

Regards,
Varsha
SAP Mentor

Its so much informative for the followers. I like the way you describe this post. Its really helpful for the users of this site. I am also searching about these type of sites now a days. So your site really helps me for searching the new and great stuff. This site contain all my specifications. Thanks for sharing. Keep it up. I am waiting for your more posts like this or related to any other informative topic. Regards, Varsha SAP Mentor
Already Registered? Login Here
Guest
Monday, 06 July 2020
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

By accepting you will be accessing a service provided by a third-party external to https://erpcorp.com/