CKPS

Unit Costing Items | #masterdata | Component: Product Cost Planning
Column Name Description
MANDT Client
KOKRS FK Controlling Area
KALNR Cost Estimate Number (Unit Costing)
WTTYP Unit costing value type
VERSN FK Version Number of the Value Type of a Unit Cost Estimate
POSNR Unit Costing Item Number
Column Name Description
💲 Currency Key (TCURC.WAERS):
GPREIS Total Price for Costing Item
WERTB Item Gross Value
WERTN Net Value of Item
SUMM2 Capital Spending Total for Item Category S
SUMM3 Total of two or more items
DPREIS Average price for periods
PREIS1 Value of Delta Profit in CO Area Currency - Legal View
PREIS2 Value of Delta Profit in Object Currency - Legal View
PREIS3 Value of Delta Profit in CO Area Currency - Profit Ctr View
PREIS4 Value of Delta Profit in Object Currency - Profit Ctr View
PREIS5 Price Component 5
ZUABS Overhead as absolute figure
💲 Currency Key (FWAER):
WERTF Gross Value in Foreign Currency
Column Name Description
📏 Base Unit of Measure (MEEHT):
MENGE Quantity
SUMM1 Quantities total for item category S
Column Name Description
Column Name Description
TYPPS Item Category Show values
FVFLG Fixed/Variable Indicator Show values
VTKNZ Distribution Indicator Show values
Column Name Description Domain name
STATP Item Status STATE
STRGP Item Control (for Internal Use) STATE
KSTAR Cost Element KSTAR
OPCOD Formula field for calculations at item level OPCOD
FRLNR Unit Costing Formula Number FORML
PSCHL Pricing Key CHAR18
MKURS Average rate KURSC
FWEHT Currency unit NUM04
PFKT1 Price Component Factor QBJ_FAK
PFKT2 Price Component Factor QBJ_FAK
PFKT3 Price Component Factor QBJ_FAK
PFKT4 Price Component Factor QBJ_FAK
PFKT5 Price Component Factor QBJ_FAK
ZUFKT Overhead Factor QBJ_FK2
PSKNZ Lot-Size-Independent Indicator CHAR1
Master Data Relations Join Conditions
Company Code
  • CKPS.MANDT == T001.MANDT
  • CKPS.BUKRS == T001.BUKRS
Base Planning Object (External Number)
  • Origin Controlling Area Item
  • Base Planning Object (External Number)
  • CKPS.MANDT == CKBS.MANDT
  • CKPS.KOKRS_HRK == CKBS.KOKRS
  • CKPS.EXTNR == CKBS.EXTNR
Currency Key
  • CKPS.MANDT == TCURC.MANDT
  • CKPS.FWAER == TCURC.WAERS
Controlling Area
  • CKPS.MANDT == TKA01.MANDT
  • CKPS.KOKRS == TKA01.KOKRS
Origin Controlling Area Item
  • CKPS.MANDT == TKA01.MANDT
  • CKPS.KOKRS_HRK == TKA01.KOKRS
Material Number
  • Material Number
  • Client
  • CKPS.MATNR == MARA.MATNR
  • CKPS.MANDT == MARA.MANDT
Base Unit of Measure
  • CKPS.MANDT == T006.MANDT
  • CKPS.MEEHT == T006.MSEHI
Version Number of the Value Type of a Unit Cost Estimate
  • Version Number of the Value Type of a Unit Cost Estimate
  • Cost Estimate Number (Unit Costing)
  • Unit costing value type
  • Client
  • Controlling Area
  • CKPS.VERSN == CKKS.VERSN
  • CKPS.KALNR == CKKS.KALNR
  • CKPS.WTTYP == CKKS.WTTYP
  • CKPS.MANDT == CKKS.MANDT
  • CKPS.KOKRS == CKKS.KOKRS
Plant
  • CKPS.MANDT == T001W.MANDT
  • CKPS.WERKS == T001W.WERKS