...

SAP Product Costing Part 1

Table of Contents

SAP Product Costing Part 1

SAP

Controlling Configuration

Create Controlling area

Tcode: OKKP

Create Controlling Number Range

Tcode: KANK

In controlling CO document are saved are Business transaction types

E.g., of Business Transaction types are.

  • KAUS: Calculate Scrap
  • KAMV: Manual cost allocation

CO number range is assigned to business transaction type

Procedure: Click the create button. Now create the Group say Primary posting and create number range for this group say 1 to 199999. Now come back to the previous screen. Select the unassigned business transaction. Click button Element, select the group created earlier. This business transaction get assigned to the group and get’s the number range of the group

GroupNumber Range
Primary100000-200000
Secondary200001-400000
Planning400001-600000

Controlling Versions

Controlling data is stored in versions.

Default version is zero. Version zero is used for both actual and planning. Other versions are used only for planning.

IMG Path : SPRO-Controlling – General controlling – Organization – Maintain versions

Create Cost Element

Primary Cost Element

  • Create Primary Cost Element: KA01/KA02 /KA03 in CO
  • Create Primary CE in FI: FS00

Secondary Cost Element

  • Create Secondary Cost Element in Controlling: KA06

List / Display Cost Element

Tcode : KA23

Primary Cost Element

GL AcctDescription
41069Raw Material Consumption
41071Packing Material Consumption
41072Purchased Components consumption
Secondary CENameCE Category
942000Canteen assessment cost element42: Assessment
942001Material cost assessment OH cost element42 : Assessment
942002marketing assessment OH cost element42 : Assessment
941000Material Cost OH41 : OH
941001Activity cost OH41 : OH
943000Setup Activity Cost43: activity allocation
943001Labor Activity cost43: activity allocation
943002Machine Activity Cost43: activity allocation

Cost Element Numbering rules can be similar to one shown below:

  • 9: Starting Number.
  • 41 / 42/43: CE Category
  • 000/002: Sequence number

Create Cost Centers

Transaction: OKEON or KS01

Transaction to change / display Cost Center: KS02 / KS03

Cost Center GroupDescriptionCost CenterCatCo. CodeCo. Code
ADMIN_CTRAdministration3301002WIST5IST5
SERV_CTRCanteen Dept3301001HIST5IST5
PROD_CTRProduction Div-13301005FIST5IST5
PROD_CTRProduction Div-23301006FIST5IST5

Create Activity Type

  • Transaction code: KL01 / KL02 /KL03
  • For each activity type secondary cost element of category 43 is required
  • Create secondary CE: KA06
Act TypeDescriptionAct UnitCCTR catAllocation CEAct type catPrice Indicator-PlanAct Activity Type catAct Price Indicator
330100Set Up activity costHR: Hours*943000: Set Up activity cost1: Manual entry, manual allocation1: Plan price, automatically1: Manual entry, manual allocation5: Actual price, automatically based on activity
330101Labor activity costHR: Hours*943001: Labor activity cost1: Manual entry, manual allocation1: Plan price, automatically1: Manual entry, manual allocation5: Actual price, automatically based on activity
330102Machine activity costHR: Hours*943002: Machine activity cost1: Manual entry, manual allocation1: Plan price, automatically1: Manual entry, manual allocation5: Actual price, automatically based on activity

Display Cost Center Report

Tcode: S_ALR_87013611

For detailed, step-by-step instructions on SAP Product Costing Advance, follow along with my video tutorial below

SAP Product Costing Training

SAP Controlling

Activity Independent Cost Center Planning

Tcode: KP06

Layout : 1-101

CCTR# 3301001 – Canteen

Cost ElementDescription
63510Electricity
63520Water
63581Cleaning Services
  

Activity Dependent Planning

Activity Hours Planning for Cost Center

Tcode: KP26

Cost Center # 3301005 – Production Division -1

Plan Activity Dependent Cost

Tcode: KP06

CCTR # 3301005

Activity Type: 330100 to 330102

Cost Element

  • Raw Material Consumption: 41070
  • Packing Material Consumption: 41071
  • Purchased Components: 41072
  • Wages: 60000

Plan Cost Splitting

Transaction code: KSS4

Cost Center # 3301005

Plan Cost Splitting: KSS4

This will split activity independent cost equally among cost center activities. Let’s post planned activity independent cost

Electricity Cost # 63510

Water # 63520

Plan Price Calculation

Tcode: KSPI

KP26 Planned Act CCTR#3301004- Prod Div
KP06 Act Dependent CostKSS4KSPIKSPI
Act TypeDescriptionAllocation CEPlan Act Hr./MonthWages:60000RM:41070PM:41071KSS4/periodKSPIKSPI
330100Setup94300010010001000(KP06+KSS4)Hr20
330101Labor9430012001000100010001000(KP06+KSS4)Hr20
330102Machine943002200100010001000(KP06+KSS4)Hr15

Verify Activity Prices

Tcode: KSBT

For detailed, step-by-step instructions on SAP Product Costing Advance, follow along with my video tutorial below SAP Product Costing Advance

FI-MM Integration

Define Plant

  • A ‘Plant’ is an operating area or a branch or a location within a company. Each ‘Plant’ is assigned to a single ‘company code’. A ‘company code’ can have several ‘Plants.’
  • IMG Path: Enterprise Structure -Definition – Logistics general – Define, copy, delete, check plant

Define Storage Location

A storage location is the place where stock is physically kept within a plant. There may be one or more storage locations within a plant.

  • IMG Path: Enterprise Structure -Definition – Materials Management – Maintain Storage Location
  • Tcode: OX09

Maintain Purchase Organization

The purchasing organization is the highest level of aggregation (after the organizational unit “client”) for purchasing statistics.

IMG Path: Enterprise Structure – Definition – Materials Management – Maintain Purchasing Organization

Assign Plant to Company Code

A Plant needs to be assigned to one of the Company Codes, the relation is always one to one i.e. One Plant can be assigned to only one company code

However, before plant is assign to company code, we have to define Valuation Level. Materials are valued at valuation level.

Define Valuation Level

OX14

Assign Plant to Company Code

Path: Enterprise Structure -Assignment – Logistics general – Assign Plant to Company Code

Assign Purchase Organization to Company code

IMG Path: Enterprise Structure – Assignment – Material Management – Assign purchasing organization to company code

Assign Purchase Org to Plant

IMG Path: Enterprise Structure -Assignment – Logistics general – Assign purchasing organization to Plant.

Purchasing Groups

Path: SPRO – Material Management – Purchasing – Create Purchasing Group

A Purchasing group refers to a people or a group of people who are dealing with specific material or a group of material.

Define Attributes for Material Type

Material Type is a Logical grouping of materials that are similar in characteristics. Any material master record created in SAP ERP must be assigned to a material type.

IMG Path: Logistics – General – Material Master – Basic Settings- Material Types- Define Attributes of Material Types

  • Transaction Code: OMS2
Material TypeDescription
ROHRaw Material
FERTFG Type
HALBSemi FG type

Maintain Posting Period

This activity is done for making a Company Code relevant for materials Management and to define the starting posting period.

IMG Path: Logistics – General -Material Master – Basic Settings- Maintain Company Codes for Materials Management

Transaction Code: OMSY

Creation of Plant Parameters

Transaction code: OMI8

Copy from plant 1000 to our plant IST5

Default values of Tax code for Invoice Verification

Path: SPRO -Materials Management – Logistic Invoice verification – Incoming Invoice – Maintain Default Tax code

GR Tolerance Group

In this step, we set the tolerance limits for goods receipts. When processing a goods receipt, the system checks each item to determine whether the goods receipt varies from the purchase order or the material master data. The different types of variances are defined by tolerance keys. For each tolerance key, tolerance limits can be set per

company code.

Path: SPRO -Material Management – Inventory Management – Good Receipt – Set Tolerance

Copy Tolerance B1, B2 and VP from company code 1000 to IST5

Set Tolerance limit for Price Variance.

When processing a purchase order, the system checks whether the effective price of a PO item shows variances compared with the valuation price stored in the material master record. In addition, it checks whether the specified cash discount value is admissible.

Variances are allowed within the tolerance limits. If a variance exceeds a tolerance limit, the system issues a warning or error message. In SAP, the types of variance are represented by the tolerance keys.

Path: SPRO –Material Management – Purchasing – PO – Set Tolerance limit for price variance

Copy Tolerance limit PE, SE from company code 1000 to IST5.

Set Tolerance limit for price difference between Invoice and Purchase order

IMG Path: Material Management – Logistic Invoice verification – Invoice block – Set Tolerance.

Copy price variance PP and VP from company code 1000 to IST5.

Define Automatic Status Change

Transaction Code: OMRV

Invoice verified in the background. If found correct, status automatically set to completed.

Define Valuation Control

It defines if the valuation areas will be grouped by activating the valuation grouping code. In the standard SAP R/3 System, the valuation grouping code is set to active as default setting.

Transaction code: OMWM

IMG Path: Materials Management -> Valuation and Account Assignment -> Account Determination -> Account Determination without Wizard-> Define Valuation Control

Group Together Valuation area plant

Path: Material Management – Valuation and Account Assignment – Account Determination – Account Determination without wizard – Group together valuation area

Transaction Code: OMWD

In the standard SAP system, valuation is predefined at plant level. All plants are grouped together via valuation grouping code 0001. Assign SAP define valuation grouping 0001 to Plant IST5.

Define Valuation Classes

IMG Path: Materials Management -> Valuation and Account Assignment -> Account Determination -> Account Determination without Wizard->Define Valuation Classes.

Transaction Code: OMSK

Valuation Class / Acct Cat ReferenceDescription
Valuation ClassA grouping of Material
Account Category ReferenceGrouping of Valuation Classes
Material TypeLogical Grouping of material with similar characteristic
Material Type and Account Category Reference assignmentMaterial Types are assigned to Account category Reference. This links Material types to valuation class and to GL accounts to which posting should happen

Account Category Reference

Valuation Class

Transaction Code: OMSK

Material Type and Account Category Reference

Transaction Code: OMSK

FI-MM Integration Configuration

Transaction Code: OBYC

TransactionValuation ClassGLDescription

BSX

Inventory Postings

01FG13200FG Inventory
01SF13100SFG Inventory
01RM13000RM Inventory
    

WRX

GRIR Clearing Account

01FG20100GRIR Clearing Account
01SF20100
01RM20100
    
GBB-BSA01FG13997Inventory Data Load
GBB-VAX01FG41000Cost of Goods Sold
GBB-VBR01RM41070Consumption Raw Materials
GBB-AUF01FG41076Production Receipts
GBB-AUF01SF41076Production Receipts

For detailed, step-by-step instructions on SAP Product Costing Advance, follow along with my video tutorial below SAP Product Costing Advance

Product Costing

Define Costing Sheet Components- Calculation base

Path: SPRO – Controlling – Product Cost Controlling – Product Cost Planning – Basic settings for material costing – Overhead – Costing sheet components – Define Calculation base

The calculation base determines to which cost elements overhead is applied together.

Define Costing Sheet Components

Percentage OH Rates

Path: SPRO – Controlling – Product Cost Controlling – Product Cost Planning – Basic settings for material costing – Overhead – Costing sheet components – Define Percentage OH rates

Define percentage overhead rates, for example, 10% in controlling area AUM1.

Select OH Rate 19MH and below entries.

Select 19AH OH rate and make the below entries

Define Costing Sheet Components- Credits

Path: SPRO – Controlling – Product Cost Controlling – Product Cost Planning – Basic settings for material costing – Overhead – Costing sheet components – Define Credits

Here you define Cost center which is to be credited with OH cost. Further this credit is recorded under secondary cost element of category 41 (overhead rates)

Define Costing Sheet

Path: SPRO – Controlling – Product Cost Controlling – Product Cost Planning – Basic settings for material costing – Overhead – Costing sheet

Define Costing Variant

Costing Variant contain Costing Type, Valuation Variant, Date Control, Quantity structure control, Transfer control and reference variant. We will create three costing variants – Standard cost, Planning cost and Actual cost variant

Costing variants is the link between product costing and Customizing,

The costing variant contains all the control parameters for costing.

The costing variant for a material cost estimate contains the following control parameters:

  • Costing type
  • Valuation variant
  • Date control
  • Quantity structure control
  • (only relevant for cost estimates with quantity structure)
  • Transfer control (optional)
  • Reference variant (optional)

Note:

Costing Type: Determine type of cost is calculated., whether standard cost, Cost for reporting, etc.

Valuation variants determine how Material, Activities, Subcontract, External Operations and OH are valued.

Date Control: Determine validity period of costing run

Define Costing Variant Components

Define Costing Variant Components -Costing Type

Path: Controlling – Product Cost controlling – Product Cost planning – Material Cost estimate with quantity structure – Costing variant components – Define costing type

Here you define the purpose of a material cost estimate by specifying, field in the material master record to which the costing results can be transferred to:

Update – Material master FieldsCost Estimate (CK40N)
Standard priceStandard cost estimate (01)
Tax-based priceInventory cost estimate
Commercial priceInventory cost estimate
Price other than std. priceModified standard cost estimate

In a client there can be only one costing type for standard price. We will keep SAP standard costing type 01 for standard price

Define Valuation Variant

Path: Controlling – Product Cost controlling – Product Cost planning – Material Cost estimate with quantity structure – Costing variant components

Here you specify parameters to be used for cost estimate.

  • Material Valuation: define the sequence in which the system searches for prices from the accounting view or costing view of the material master record to valuate materials. E.g., We can specify the sequence in which material price is picked – use moving average price, if not available use Standard Price, if not available use Purchase Info record and so on
  • Activity Price: Sequence in which activity price is picked. For e.g. take Plan activity price, if not available take actual activity price and so on
  • Overhead costs: Link the costing sheet prepared in earlier steps to pick the OH cost for cost estimates.

Activity type price priority

Sub-contracting price sequence

External Operations price sequence

Under OH select the costing sheet created earlier

OH, on Material Components. Not required in our scenario. If costing sheet assigned here OH 10% and 15% defined in costing sheet will be added to the raw material

To display Number in the drop down enable visualization in the options as below.

Valuation variant is defined at plant level

Click and assign Valuation variant I5 to our plant IST5

Define Date Control

Path: Controlling – Product Cost controlling – Product Cost planning – Material Cost estimate with quantity structure – Costing variant components

Tcode: OKK6

Date control determines which dates are proposed or displayed when a cost estimate is created, and whether these dates can be changed by the user.

  • The validity period of the cost estimate
  • The date on which the quantity structure is determined ( quantity structure date)
  • The date on which the quantity structure is valuated ( valuation date)

Define Quantity Structure Control

Path: Controlling – Product Cost controlling – Product Cost planning – Material Cost estimate with quantity structure – Costing variant components

Tcode: OKK5

Check BOM Selection

Path: Controlling – Product Cost controlling – Product Cost planning – Material Cost estimate with quantity structure – Settings for qty structure – BOM Selection – Check BOM selection

Tcode: OPJI

BOM: BOM (Bill of Material): This is list of Raw material along with the quantities required to produce Finished Goods

Specify different sequences of priorities of BOM usages according to your requirements

Check BOM Application

Path: Controlling – Product Cost controlling – Product Cost planning – Material Cost estimate with quantity structure – Settings for qty structure – BOM Selection – Check BOM application

Tcode: OPJM

Here you define BOM application area. Now you assign BOM selection ID created earlier to this BOM application area. Selection ID decides the sequence in which BOM are selected during cost estimate for this BOM application area

Check Routing Selection

Path: Controlling – Product Cost controlling – Product Cost planning – Material Cost estimate with quantity structure – Settings for qty structure – Routing Selection – Check automatic routing selection

Tcode: OPJF

Routing: It is sequence of activities. It specifies on which Work Center (A work center typically refers to a machine) what activities are to be performed for how many hours. Raw Material is converted into finished goods at work center

Define a Routing selection ID

Assign it to alternative selection priorities

Specify selection priority for each of these scenarios

  • ID: A6: Can be any identifier
  • SP: Selection Priority
  • Task List: N: Routing, R: Rate Routing
  • Plan Usage: 1: Production
  • Status: 4: Released general

Assign BOM application ID and routing selection ID in Quantity structure control

Tcode: OKK5

Define Transfer Control

Path: Controlling – Product Cost controlling – Product Cost planning – Material Cost estimate with quantity structure – costing variant component – define transfer control

Tcode: OKKM

Transfer Control: The transfer control specifies how the existing cost estimate is to be used in the cost estimate of the other product. For e.g. Costing done at beginning of the year. All components of the product cost have to be costed to arrive at final Standard Cost. Costing of new component during the year. We can use standard cost of components costed at the beginning of the year if they are being used in manufacture of this new Product. Here we will use the transfer control

In this step you define parameters for partial costing. The purpose of partial costing is to prevent the system from creating a new cost estimate for a material when costing data already exists. Instead, the existing costing data is simply transferred into the new cost estimate. This improves performance.

Current and Future cost kept for 6 months before archiving

Define Costing Variant

Path: Controlling – Product Cost controlling – Product Cost planning – Material Cost estimate with quantity structure – Define costing variant

Tcode: OKKN

Select costing component created in earlier steps and assign to Costing variant MK14. Costing type assigned is 01 Standard Cost and not one created earlier as we want to do standard costing

Qty Structure selection

Additive cost. These are transportation, packing cost added to COGM.

Update selection

Itemization: Detailed break up of cost based on its components

Error management selection

Assignment is optional so ignored for now

For detailed, step-by-step instructions on SAP Product Costing Advance, follow along with my video tutorial below SAP Product Costing Advance Training

Define Cost Component Structure

Path: Controlling – Product Cost controlling – Product Cost planning – Basic settings for material costing – Define Cost component structure

Tcode: OKTZ

It gives the breakup of the cost estimate of products like material cost, packing mat cost, consumables etc. The cost component structure contains the cost components (grouping of costs or cost elements)

Each cost component specifies whether it is relevant for valuation of inventory or not and also it specifies under which cost components to be updated. Eg. COGM, COGS, Inventory, and Tax inventory etc. Each cost component specifies whether it is to be rolled up or not.

Any component which is relevant for inventory should be rolled up and shown under COGM view.

The cost component can have maximum of 40 components in case of all components are variable. In case of all components are fixed, then the CCS can have maximum of 20 components.

Define cost component Group (CCG)

Path: Controlling – Product Cost controlling – Product Cost planning – Basic settings for material costing – Define Cost component structure

Tcode: OKTZ

Define Cost Component Structure

Define Cost Component with attributes

Select CCS B1 and double click Cost component with attributes. Define as below:

Material Cost

Packing Cost component

Purchased cost component.

Setup Activity Cost

Machine Activity Cost

Labor Activity Cost

Material OH

Activity OH Cost Component

Assign Cost Components to Cost Elements

Select the views for this cost component structure.

Assign Cost component structure to Organizational Units (Co Code and Plant)

Activate Cost Component structure

Activate CCS to Controlling area currency

Path: Controlling – Product Cost controlling – Product Cost planning – Select functions in material costing – activate CCS in CO Area currency

Difference between Plan Cost, Standard Cost and Actual Cost

Plant Cost Standard CostActual Cost
Plan cost for a job orderEstimated cost per unitActual cost
   

Difference between plan cost and actual cost is of Fixed Cost. Fixed cost does not change in plan cost.

Define Costing variant for Plan.

Tcode: OPL1

Path: Controlling- Product Cost Planning – Cost Object Controlling – Product Cost by order – manufacturing orders- Check costing variant for manufacturing orders – new entries

We will use Valuation variant I5 created earlier.

Costing Type, we will use SAP standard: 06 Planned Production Order

Define Costing variant for Actual.

Tcode: OPL1

WIP Settings

Define RA Key

Path: Controlling- Product Cost Planning – Cost Object Controlling – Product Cost by order – Period end closing – work in progress – Define RA Key

Tcode: OKG1


      1. Define CE for WIP calculation

Path: Controlling- Product Cost Planning – Cost Object Controlling – Product Cost by order – Period end closing – work in progress

Create below secondary (31 category CE): KA06

Sec CENameCE Category
931000WIP Material Cost31: Prod Order/ Project Result
931001WIP Direct OH31: Prod Order/ Project Result
931002WIP Indirect OH31: Prod Order/ Project Result
931003WIP Technical (Total of all WIP)31: Prod Order/ Project Result

Define RA version

Path: Controlling- Product Cost Planning – Cost Object Controlling – Product Cost by order – Period end closing – work in progress

All results analysis data calculated in results analysis is updated on the order with reference to the results analysis version. This enables you to calculate work in process on the basis of multiple results analysis versions. This means that you can use different results analysis versions to define different methods of WIP calculation

Save and deselect Transfer to Financial Accounting. This will be reselected after completing subsequent steps.

Define valuation methods actual

Path: Controlling- Product Cost Planning – Cost Object Controlling – Product Cost by order – Period end closing – work in progress

  • In this step you define a valuation method for the calculation of work in process.
  • In the Product Cost by Period component the work in process is valuated at target costs. The valuation is made based on the quantities confirmed at the operations point
  • In the Product Cost by Order component the work in process is normally valuated at actual costs. The value of the work in process is the difference between the debit and the credit of an order if the order has the status PREL (partially released) or REL (released).

Define Line ID

Path: Controlling- Product Cost Planning – Cost Object Controlling – Product Cost by order – Period end closing – work in progress

Define Line ID. In next step you assign CE to these Line ID. Line ID receive WIP value from these CE at the time of Production Order Settlement. Create a Secondary CE of category 31 and assign to these Line ID. Secondary CE receive the settled cost. Secondary CE is mapped to FI BS and PL account. This enable posting of FI documents for WIP balance at the time of production Order settlement

Line ID show WIP breakup. New entries and below entries

Define Assignment

Path: Controlling- Product Cost Planning – Cost Object Controlling – Product Cost by order – Period end closing – work in progress

19M – Material Cost: 41069, 41070, 41071, 41072

19D – Direct OH: 943000-943002

19I – Indirect OH: 941000-941001

19S – Settlement CE: 41077

Assign CE / GL accounts to WIP line ID’s created in above step

SAP GL account length is 10 digits. When masking prefix zeroes if length less than 10 digit

Define Update

Path: Controlling- Product Cost Planning – Cost Object Controlling – Product Cost by order – Period end closing – work in progress

Tcode: OKGA

K : Cost

A : Settled Cost

CE category is 31. This is created for WIP

For each line ID, you specify the results analysis cost element under (31 category) which the work in process is updated, and assign each line ID to a category.

The line IDs put the costs incurred for an order into groups such as the following:

  • Direct material costs
  • Direct OH costs
  • Indirect costs

      1. Define Posting Rule for settling WIP

Path: Controlling- Product Cost Planning – Cost Object Controlling – Product Cost by order – Period end closing – work in progress

Tcode: OKGA

Create below GL accounts: FS00.

GL AcctDescriptionTypeAccount GroupFSGLine ItemSort key
200126WIP Mat Cost BSBSCurrent AssetsG006X001
200127WIP DOH Cost BSBSCurrent AssetsG006X001
200128WIP IOH Cost BSBSCurrent AssetsG006X001
400205WIP Mat Cost PLPLManufacturing ExpensesG001X001
400206WIP DOH Cost PLPLManufacturing ExpensesG001X001
400207WIP IOH Cost PLPLManufacturing ExpensesG001X001

MTS: Make to Stock use WIPR.

MTO: Make to Order use RUCR.

Secondary CE 931000 post WIP material cost to BS:200126 and PL 400205 account

Select Transfer to FI in RA version

Path: Controlling- Product Cost Planning – Cost Object Controlling – Product Cost by order – Period end closing – work in progress

For detailed, step-by-step instructions on SAP Product Costing Advance, follow along with my video tutorial below

SAP Controlling

Variance Calculations

Variance Calculation determines differences between the actual costs incurred on a production order and the standard costs of the material produced. Variances are calculated not at once, but for different variance categories.

Define Variance Keys

Path: Controlling – Product Cost Controlling – Cost Object Controlling – Product Cost by Order – Period End Closing – Variance Calculation

Tcode: OKV1

Variance key is added to Finished Goods material Master. From the material master it is transferred to production order and control variance calculation

Define default variance keys for plants.

Path: Controlling – Product Cost Controlling – Cost Object Controlling – Product Cost by Order – Period End Closing – Variance Calculation

Tcode: OKVW

Define variance variant.

Path: Controlling – Product Cost Controlling – Cost Object Controlling – Product Cost by Order – Period End Closing – Variance Calculation

Tcode: OKVG

Define target cost version.

Path: Controlling – Product Cost Controlling – Cost Object Controlling – Product Cost by Order – Period End Closing – Variance Calculation

Tcode: OKV6

Variance Formula = Control Cost – Target cost

Now Control cost can be Actual Cost or Plan cost depending on version.

Target cost can be current standard cost or any other cost depending on version.

Define Controlling area version for Plan.

Tcode: OKEQ

Select and Click controlling area settings

Select and click settings for each Fiscal Year

Define Number Range for Variance Documents

Path: Controlling – Product Cost Controlling – Cost Object Controlling – Product Cost by Order – Period End Closing – Variance Calculation

Tcode: KANK

Business Transaction: KVAR : assign to secondary postings

Settlement

Create Settlement Profile

Path: Controlling – Product Cost Controlling – Cost Object Controlling – Product Cost by Order – Period End Closing- Settlement

Settlement profile used for settlement of Production order.

To be Settled in Full: Production order can be settled only when balance is zero.

Can Be settled: Order can be settled even with the balance.

Not for settlement: WIP can be settled. Variances cannot be settled.

Max no. Dst rls: Maximum 6 receiver allowed in settlement profile.

Residence time: 6 months before it is archived.

Maintain Number Range for Settlement Documents

Path: Controlling – Product Cost Controlling – Cost Object Controlling – Product Cost by Order – Period End Closing- Settlement

Tcode: SNUM

Create Group

Click Change group

Click create and create below group

Search MK14 (settlement profile created in last step) and assign to the group

(Details Product Costing video 3: 1:20:00)

PP Settings

Define PP Order Type

Path: Production- Shop Floor control – master data – Order – define order type

Tcode: OPJH

Select PP01

Copy SAP standard Production order PP01 as IST5

Define Order Type Dependent Parameters

Path: Production- Shop Floor control – master data – Order – define order type dependent parameters

Tcode: OPL8

Copy from plant 1000 and Order type PP01. Change Plant to IST5 and Order type to IST5.

Define Scheduling Parameters for Production Order

Path: Production- Shop Floor control – operations – scheduling -define scheduling parameters for production orders

Tcode: OPU3

Copy Plant 1000 and Order type PP01 as Plant IST5 and Order type IST5

Production Scheduling Profile

Tcode : OPKP

Define Confirmation Parameters

Path: Production- Shop Floor control – operations – confirmation – define confirmation parameters

Tcode: OPK4

Copy Plant 1000 and Order type PP01 as Plant IST5 and Order type IST5

Define Checking control

Path: Production- Shop Floor control – operations – availability check – define checking control

Tcode: OPJK

Copy Plant 1000 and Order type PP01 as Plant 01M1 and Order type 19PO for business functions 1 and 2

Define Material Type assignment

Path: Production – Basic Data – Routing – General Data – Define Material Type assignment

Tcode: OP50

Material Type defined in FI-MM

Maintain Overall Plant Parameters

Path: Production – MRP – Plant Parameters – carry out overall maintenance of plant parameters

Tcode: OPPQ

Copy Plant 1000 to Plant IST5

Click on Maintain – Enter plant IST5 – Click on MRP Controllers. Click on MRP controller – New entries – Enter Plant IST5 and save

Click on Conversion under maintain planned orders.

Click Planned Order and update Production Order to 19PO

Define Goods Received Valuation for Order Delivery

Path : Controlling – Product Cost Controlling – Cost Object Controlling – Product Cost by Order – Define Goods Received Valuation for Order delivery

Integration between CO and PP

Check Order Type

Path: Controlling – Product Cost Controlling – Cost Object Controlling – Product Cost by Order – Manufacturing Orders – Check Order Types

Tcode: KOT2

Update your order type 19PO as below:

Update Settlement Profile

Update Object Class: Production

Residence Time: 6

Define Cost Accounting relevant default values for order type

Path: Controlling – Product Cost Controlling – Cost Object Controlling – Product Cost by Order – Manufacturing Orders

Update as below:

RA Key: IST5

Costing Variant Plan: ISTP

Costing Variant Actual: ISTA

End User Steps

Create Finished Goods Material Master

Tcode: MM01

Basic Data 1 and 2 view

  • Required for all material types
  • Fields: Base Unit of Measure, Material Group, X-Plant Status, Prod Hierarchy

MRP 1 View (Material Requirement Planning)

  • MRP Type: ND (No Planning)
  • Procurement Type: X (Both Internal and External)
  • Storage Location: FG
  • Availability Check: KP (No Check)

MRP 2 View

Back flush:

  • 1: Always Back flush
  • 2: Work Center decides

Accounting 1

  • Valuation Class: Determine GL account posted
  • Price Control
    • S: Standard cost. Used for FG
    • V: Moving average price. Used for Raw Material
  • Price Unit: Cost per Unit ( Units specified here)

Costing 1

  • With Qty Structure: Selected for material costed with BOM + Routing
  • Material Origin: Select to display Material Number in controlling reports
  • Variance Key: Specify the one created earlier.
  • Costing Lot size

Costing 2

  • Future Price: Current market price
  • Current Price: Current Release Price

FG Created : IST5FGX

Create Raw Material Master

Tcode: MM01

Finished GoodsRaw material
IST5FGXIST5RMX
 IST5RMY

Create BOM

Tcode: CS01 / CS02 / CS03

Create Finished Goods BOM (Bill of Material)

Above BOM => need 2 kg and 3 Kg of Raw material X and Y to manufacture 1 Kg of FG

Routing

RoutingSetup ActivityMachine ActivityLabor ActivityWork Center
Operation 10123WC 1
Operation 20 1 2WC 2

Routing is a list of Operations performed on Raw material to convert it into FG. These operations are performed at locations called work centers.

Create Work Center

Tcode: CR01

To hide Person responsible field, go to OPFA – Basic Data – P3000-VERAN – Hide

Below screen appears when press enter on earlier screen

Cost center to which operational costs would be booked.

Similarly create work center IST5WC3

Create Routing

Tcode: CA01

Click Operations tab and enter below data.

  • Control Key PP01: SAP standard for In House Production. Populated from work center
  • Base Unit 1: Quantity of finished goods (IST5FGX) that will be produced by applying these operations in the work center.
  • IST5WC2: Work Center 1. Will perform 1 hour of Setup activity, 2 hour of Machine activity and 3 hours of labor to produce one unit of FG

Routing was saved with group 50136545 material MK14POFGX.

Standard Cost Estimate

Tcode: CK11N

Reconciliation Excel

BOM: CS01Standard Cost
FGX 1 Kg  
RMX2  
RMY3  
Routing: CA01Setup ActivityM/C ActivityLabor Activity
Operation 10123
Operation 20 12
Std Cost Estimation   
Raw Material CostKgAvg PriceTotal
RMX2300600
RMY3200600
Total Price RMX +RMY  1200
Operation 10 (Price from KSBT)HoursRate/Hr/USDTotal
Setup12020
Machine21530
Labor32060
Total Price OP 10  110
Operation 20   
Setup  
Machine11515
Labor22040
Total Price OP 20  55
OH Cost (Valuation variant : OKKN)   
MOH10%1200120
AOH15%16525
Total OH Price / Kg  145
Standard Cost Estimation for 1 Kg  1510

Raw Material Prices: MM02

Planned Activity Prices: KSBT

Mark and Release Standard Cost Estimation

Transaction code: CK24

Tcode : MM03

MarkStandard cost updated as future price in costing tab 2 in MM03
ReleaseFuture price now becomes current price in costing tab 2 in MM03
Standard cost updated as standard cost in accounting tab 1 in MM02

May have to close MM period in MMPV

Release Standard Cost : CK24

Standard Cost in FG material master: MM03


      1. Display Standard cost with cost component structure.

Transaction Code: CK13N

Standard Cost Report Transaction Code : S_P99_41000111

Product Costing Tables

s.no.TablesDescription
1KEKOProduct Costing – Header Data
2CKISItems Unit Costing/Itemization Product Costing
   

For detailed, step-by-step instructions on SAP Product Costing Advance, follow along with my video tutorial below SAP Product Costing Advance

SAP Product Costing Overview

Facebook
Twitter
LinkedIn

2 thoughts on “SAP Product Costing Part 1”

  1. Pingback: SAP Tutorials | AUMTECH Solutions-SAP Training

  2. Pingback: SAP Controlling Questions & Answers | AUMTECH Solutions-SAP Training

Leave a Comment

Your email address will not be published. Required fields are marked *

error: Content is protected !!
Seraphinite AcceleratorOptimized by Seraphinite Accelerator
Turns on site high speed to be attractive for people and search engines.