SAP table CKIS2 (Unit Costing Items/Itemization for Product Costing)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
LEDNR Ledger for Controlling Objects CHAR 2 0 LEDNR
00 Standard ledger
BZOBJ Reference Object CHAR 1 0 * CK_OBJ
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure NUMC 12 0 CKHS CK_KALNR
KALKA Costing Type CHAR 2 0 * CK_KALKA
KADKY Costing Date (Key) DATS 8 0 CK_KADKY
TVERS Costing Version NUMC 2 0 CK_TVERS
BWVAR Valuation Variant in Costing CHAR 3 0 * CK_BWVAR
KKZMA Costs Entered Manually in Additive or Automatic Cost Est. CHAR 1 0 CK_KKZMA
POSNR Unit Costing Line Item Number NUMC 5 0 * CK_POSNR
STATP Item Status CHAR 4 0 STATP_D
STRGP Item Control (for Internal Use) CHAR 4 0 STRGP
TYPPS Item Category CHAR 1 0 TYPPS
1 Costing Master Data (Concurrent Costing)
A Co-Product
B Base Planning Object
E Internal Activity
F External Activity
G Overhead
H Credit Line (Goods Receipt Simulation)
I Delivery Costs
J Costing Model
K Cost Element
L Subcontracting
M Material
N Service
O Arithmetical Operation
P Process (Manual)
R Production Resources and Tools
S Total
T Text Item
V Variable Item
X Process Costs ABC
Y Customer-Specific Enhancement
Z Overhead Rate
KSTAR Cost Element CHAR 10 0 * KSTAR
KSTAR_MANUAL Cost Element Has Been Manually Changed CHAR 1 0 CK_COST_ELEMENT_MANUAL
Cost Element Not Changed Manually
X Cost Element Changed Manually
HRKFT Origin Group as Subdivision of Cost Element CHAR 4 0 * HRKFT
ELEMT Cost Component Number of Main Cost Component Split NUMC 3 0 * CK_ELEMENTHS
ELEMTNS Cost Component Number of Auxiliary Cost Component Split NUMC 3 0 * CK_ELEMENTNS
FVFLG Fixed/Variable Indicator CHAR 1 0 FVFLG
F
V
OPCOD Formula field for calculations at item level CHAR 50 0 OPCOD
FRLNR Unit Costing Formula Number CHAR 3 0 FORML_EK
BUKRS Company Code CHAR 4 0 T001 BUKRS
WERKS Plant CHAR 4 0 T001W WERKS_D
MATNR Material Number CHAR 40 0 MARA MATNR
PSCHL Pricing Key CHAR 18 0 PSCHL
KOKRS_HRK Origin Controlling Area Item CHAR 4 0 TKA01 KOKRS_HRK
EXTNR Base Planning Object (External Number) CHAR 18 0 CKBS EXTNR
GPREIS Price in Controlling Area Currency CURR 15 2 CK_KPT
FPREIS Fixed Price in Controlling Area Currency CURR 15 2 CK_KPF
PEINH Price Unit of Prices in Controlling Area Currency DEC 5 0 CK_KPEINH
PMEHT Price Quantity Unit UNIT 3 0 T006 PMEHT
PRICE_MANUAL Price Entered Manually CHAR 1 0 CK_PRICE_MANUAL
Price Not Changed Manually
X Price Entered Manually
WERTB Value in Controlling Area Currency CURR 15 2 CK_KWT
WERTN Value in Controlling Area Currency CURR 15 2 CK_KWT
WRTFX Fixed Value in Controlling Area Currency CURR 15 2 CK_KWF
WRTFW_KPF Value in Object Currency CURR 15 2 CK_OWT
WRTFW_KFX Fixed Value in Object Currency CURR 15 2 CK_OWF
FWAER_KPF Object Currency CUKY 5 0 * CK_OWAER
WRTFW_POS Value in Transaction Currency CURR 15 2 CK_TWT
WRTFW_PFX Fixed Value in Transaction Currency CURR 15 2 CK_TWF
FWAER Transaction Currency CUKY 5 0 TCURC CK_TWAER
MKURS Average rate NUMC 9 0 MKURS
FWEHT Currency unit NUMC 4 0 EINHT_CUR
MENGE Quantity QUAN 15 3 MENGE_POS
MEEHT Base Unit of Measure UNIT 3 0 T006 MEINS
SUMM1 Quantities total for item category S QUAN 15 3 SUMME_MNG
SUMM2 Capital Spending Total for Item Category S CURR 15 2 SUMME_INV
SUMM3 Total of two or more items CURR 15 2 SUMME_POS
DPREIS Average price for periods CURR 15 2 DPREIS
PREIS1 Value of Delta Profit in CO Area Currency - Legal View CURR 15 2 PREIS1
PREIS2 Value of Delta Profit in Object Currency - Legal View CURR 15 2 PREIS2
PREIS3 Value of Delta Profit in CO Area Currency - Profit Ctr View CURR 15 2 PREIS3
PREIS4 Value of Delta Profit in Object Currency - Profit Ctr View CURR 15 2 PREIS4
PREIS5 Price Component 5 CURR 15 2 PREIS5
PFKT1 Price Component Factor DEC 5 2 PFKTX
PFKT2 Price Component Factor DEC 5 2 PFKTX
PFKT3 Price Component Factor DEC 5 2 PFKTX
PFKT4 Price Component Factor DEC 5 2 PFKTX
PFKT5 Price Component Factor DEC 5 2 PFKTX
ZUABS Overhead as absolute figure CURR 15 2 DZUABS
ZUFKT Overhead Factor DEC 5 4 DZUFKT
PSKNZ Lot-Size-Independent Indicator CHAR 1 0 PSKNZ
SBDKZ Dependent requirements ind. for individual and coll. reqmts CHAR 1 0 SBDKZ
Individual and collective requirements
1 Individual requirements only
2 Collective requirements only
VTKNZ Distribution Indicator CHAR 1 0 VTKNZ
LSTAR Activity Type CHAR 6 0 LSTAR
ARBID Object ID NUMC 8 0 OBJEKTID
KOSTL Cost Center CHAR 10 0 * KOSTL
INFNR Number of purchasing info record CHAR 10 0 EINA INFNR
EKORG Purchasing organization CHAR 4 0 * EKORG
ESOKZ Purchasing info record category CHAR 1 0 ESOKZ
0 Standard
1 Chargeable
2 Consignment
3 Subcontracting
P Pipeline
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 * EBELP
STEUS Control Key CHAR 4 0 CK_STEUS
FXPRU Fixed-Price Co-Product CHAR 1 0 CK_FIXPRKU
STPOS Equivalence Number with 4 Places DEC 4 0 CK_AEQUI4
AFAKT Costg.: Apportionment Factor for Itemiz. Line in Joint Prod. FLTP 16 16 CK_SPLITFAC
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
MKALK Mixed Costing Indicator CHAR 1 0 CK_MKALK
BTYP Process Category CHAR 4 0 * CKML_BTYP
KALNR_BA Cost Estimate Number of Procurement Alternative NUMC 12 0 * CKKALNRBA
MISCH_VERH Mixing Ratio DEC 13 3 CK_CROSSR
UMREZ Numerator for Conversion of Order Unit to Base Unit DEC 5 0 UMBSZ
UMREN Denominator for Conversion of Order Unit to Base Unit DEC 5 0 UMBSN
AUSMG Scrap Quantity QUAN 15 3 CK_AUSMG
AUSMGKO Component Scrap Quantity QUAN 15 3 CK_AUSMGKO
AUSPROZ Scrap Factor DEC 6 3 CK_SCRAP
APLZL Continuous Counter for Differentiating Database Entries NUMC 8 0 CK_COUNT
VORNR Operation/Activity Number CHAR 4 0 VORNR
UVORN Suboperation CHAR 4 0 UVORN
STEAS Target start date of the operation DATS 8 0 CK_STEAS
POSNR_EXT Item Number for External Layout (Unit Costing) NUMC 5 0 * CK_POSEXT
POINTER1 Pointer n on Item Number NUMC 5 0 * CK_POS_POI
POINTER2 Pointer n on Item Number NUMC 5 0 * CK_POS_POI
POINTER3 Pointer n on Item Number NUMC 5 0 * CK_POS_POI
OPREIS Price in Object Currency CURR 15 2 CK_OPT
OPREIFX Fixed Price in Object Currency CURR 15 2 CK_OPF
TPREIS Price in Transaction Currency CURR 15 2 CK_TPT
TPREIFX Fixed Price in Transaction Currency CURR 15 2 CK_TPF
PATNR Partner number for costing NUMC 6 0 NKPRTN
VERWS Reference of KALKTAB Items to a Context CHAR 35 0 CK_VERWEIS
PRSKZ Price Indicator CHAR 3 0 CK_PRSKZ
RLDNR Ledger in General Ledger Accounting CHAR 2 0 FINS_LEDGER
STRAT Valuation Strategy used for Costing Item CHAR 1 0 CK_STRAT
SUBSTRAT Substrategy for Material Valuat. with Purchasing Info Record CHAR 1 0 CK_SUBSTRAT
CATERGORY Plan Category CHAR 10 0 * FCOM_CATEGORY
TKURS Exchange Rate for Item Foreign Currency DEC 9 5 TKURS
SELKZ Indicator for Relevancy to Costing CHAR 1 0 TCK08 CK_SELKZ
VRGGRP Transaction Group for Cost Element Itemization CHAR 3 0 * CK_VRGGRP
KKZMM Costs Were Entered Manually in an Additive Cost Estimate CHAR 1 0 KKZMM
SSEDD Latest scheduled finish: Execution (date) DATS 8 0 SSEDD
FEHLKZ Error Indicator CHAR 1 0 CK_FEHLKZ
NO_CCSPLIT Do Not Determine Item Value via Cost Component Split CHAR 1 0 CK_NO_CCSPLIT
SCHKZ Main Cost Component Split for KALKTAB Item Exists CHAR 1 0 CK_SCHKZHS
SCHKZNS Auxiliary Cost Component Split for KALKTAB Item Exists CHAR 1 0 CK_SCHKZNS
UFIELD_MODE Indicator to Override Transfer Control CHAR 1 0 CK_UFIELD_MODE
Transfer Fields: Which Cost Estimate Was Transferred
X Transfer Fields: Which Cost Estimate Should Be Transferred
UKALN Cost Estimate Number of Transferred Cost Estimate NUMC 12 0 * CK_UKALN
UKALKA Costing Type of Transferred Cost Estimate CHAR 2 0 * CK_UKALKA
UKADKY Date of Transferred Cost Estimate DATS 8 0 CK_UKADKY
UTVERS Costing Version for Transfer NUMC 2 0 CK_UTVERS
UBWVAR Valuation Variant of Transferred Cost Estimate CHAR 3 0 * CK_UBWVAR
HKMAT Material-related origin CHAR 1 0 HKMAT
No material-related origin
X Keep costs/quantities under material number
SPOSN BOM Item Number CHAR 4 0 SPOSN
USTRAT Transfer Strategy: Search Term 1 NUMC 1 0 CK_UEBPER1
BAUGR Item Is an Assembly CHAR 1 0 CK_BAUGR
ASNUM Activity Number CHAR 18 0 ASMD ASNUM
PEINH_2 Price unit DEC 5 0 PEINH
PEINH_3 Price unit DEC 5 0 PEINH
PRZNR Business Process CHAR 12 0 * CO_PRZNR
NLAG Non-Stock Material CHAR 1 0 CK_NLAG
PRCTR Profit Center CHAR 10 0 PRCTR
TPTYP Transfer Price Type CHAR 1 0 FVC_TPTYP
1 Inter-Company Transfer Price
2 At Cost
3 Profit Center Transfer Price
SEGUNIT Valuation Segmentation Unit CHAR 30 0 FINS_SEGMENTATION_UNIT
GSBER Business Area CHAR 4 0 * GSBER
PSPNR Work Breakdown Structure Element (WBS element) NUMC 8 0 * WB_POSNR
PAROB Partner Object CHAR 22 0 * PAROB
KZANW 'X' = Do Not Calculate Overhead Costs CHAR 1 0 CK_KZANW
1 Product Costing
2 Unit Costing
3 Production Order
KZLB 'X' = Header Material Is Subcontracted CHAR 1 0 CK_KZLB
SUBKEY CO key subnumber CHAR 14 0 * CO_SUBKEY
KZWSO Units of measure usage CHAR 1 0 KZWSO
Alternative unit of measure
A Proportion unit
B Product unit
DISST Low-Level Code CHAR 3 0 DISST
CUOBJ Object Number for Conf. Objects NUMC 18 0 CK_CUOBJ
GENTYP Generation Type of Item CHAR 1 0 CK_GENTYP
Item Was Created Manually
M Item Arose from the Costing Model
T Item Generated Through Template
COMPONENT_ID Unique Pointer to the Itemization Line (Persistent) NUMC 7 0 CK_COMPONENT_ID
/CWM/XCWMAT Material Is Activated for CW CHAR 1 0 /CWM/XCWMAT
/CWM/MENGE_BEW Input Quantity in Valuation Unit of Measure QUAN 15 3 /CWM/CK_MENGE_BEW
/CWM/AUSMG_BEW Scrap Quantity in Valuation Unit of Measure QUAN 15 3 /CWM/CK_AUSMG_BEW
/CWM/AUSMGKO_BEW Component Scrap Quantity in Valuation Unit of Measure QUAN 15 3 /CWM/CK_AUSMGKO_BEW
RELATIONSHIP_IND PCP: Flag - Object Relationships Exist CHAR 1 0 CK_RELATION_IND
MATKL Material Group CHAR 9 0 MATKL
PPEGUID Internal Identification for PVS Objects RAW 16 0 PVS_GUID
MODEGUID Internal Identification for PVS Objects RAW 16 0 PVS_GUID

CKIS2 foreign key relationships

Table Field Check Table Check Field
0 CKIS2 BUKRS T001 Company Codes BUKRS
1 CKIS2 BWTAR T149D Global Valuation Types MANDT
1 CKIS2 BWTAR T149D Global Valuation Types BWTAR
0 CKIS2 EXTNR CKBS Base Planning Object - Unit Costing MANDT
0 CKIS2 EXTNR CKBS Base Planning Object - Unit Costing KOKRS
1 CKIS2 FWAER TCURC Currency Codes MANDT
1 CKIS2 FWAER TCURC Currency Codes WAERS
0 CKIS2 INFNR EINA Purchasing Info Record: General Data INFNR
1 CKIS2 KALNR CKHS Header: Unit Costing (Control + Totals) MANDT
1 CKIS2 KALNR CKHS Header: Unit Costing (Control + Totals) LEDNR
1 CKIS2 KALNR CKHS Header: Unit Costing (Control + Totals) KALNR
1 CKIS2 KALNR CKHS Header: Unit Costing (Control + Totals) KALKA
1 CKIS2 KALNR CKHS Header: Unit Costing (Control + Totals) KADKY
1 CKIS2 KALNR CKHS Header: Unit Costing (Control + Totals) TVERS
1 CKIS2 KALNR CKHS Header: Unit Costing (Control + Totals) BWVAR
1 CKIS2 KALNR CKHS Header: Unit Costing (Control + Totals) KKZMA
0 CKIS2 KOKRS_HRK TKA01 Controlling Areas MANDT
1 CKIS2 MANDT T000 Clients MANDT
0 CKIS2 MATNR MARA General Material Data MANDT
0 CKIS2 MATNR MARA General Material Data MATNR
1 CKIS2 MEEHT T006 Units of Measurement MANDT
0 CKIS2 PMEHT T006 Units of Measurement MANDT
0 CKIS2 PMEHT T006 Units of Measurement MSEHI
1 CKIS2 SELKZ TCK08 Indicator for Relevancy to Costing MANDT
1 CKIS2 SELKZ TCK08 Indicator for Relevancy to Costing SELKZ
0 CKIS2 WERKS T001W Plants/Branches MANDT
0 CKIS2 WERKS T001W Plants/Branches WERKS