CKIS SAP table for – Items Unit Costing/Itemization Product Costing

Here we would like to draw your attention to CKIS table in SAP. As we know it is being mainly used with the SAP CO-PC (Product Cost Controlling in CO) component which is coming under CO module (Controlling). CKIS is a SAP standard transparent table used for storing Items Unit Costing/Itemization Product Costing related data in SAP. It comes under the package CK.

SAP CKIS table

Table CKIS technical data

TableCKIS
Data storingItems Unit Costing/Itemization Product Costing
ModuleCO
ComponentCO-PC
SAP PackageCK
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP CKIS Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in CKIS table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • POSNR : Item number of the SD document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5
  • PATNR
    Its data type is N (Character String with Digits Only) with field length 6
  • VERWS
    Its data type is C (Character String) with field length 35
  • PRSKZ
    Its data type is C (Character String) with field length 3
  • STRAT
    Its data type is C (Character String) with field length 1
  • SUBSTRAT
    Its data type is C (Character String) with field length 1
  • TKURS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • SELKZ : Selection indicator for costing line items
    Its data type is C (Character String) with field length 1
  • VRGGRP
    Its data type is C (Character String) with field length 3
  • KKZMM
    Its data type is C (Character String) with field length 1
  • SSEDD : Latest scheduled finish: Execution (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • STATP
    Its data type is C (Character String) with field length 4
  • FEHLKZ
    Its data type is C (Character String) with field length 1
  • NO_CCSPLIT
    Its data type is C (Character String) with field length 1
  • SCHKZ
    Its data type is C (Character String) with field length 1
  • SCHKZNS
    Its data type is C (Character String) with field length 1
  • UFIELD_MODE
    Its data type is C (Character String) with field length 1
  • UKALN
    Its data type is N (Character String with Digits Only) with field length 12
  • UKALKA
    Its data type is C (Character String) with field length 2
  • UKADKY
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • UTVERS
    Its data type is N (Character String with Digits Only) with field length 2
  • UBWVAR
    Its data type is C (Character String) with field length 3
  • STRGP
    Its data type is C (Character String) with field length 4
  • HKMAT : Material-related origin
    Its data type is C (Character String) with field length 1
  • SPOSN
    Its data type is C (Character String) with field length 4
  • USTRAT
    Its data type is N (Character String with Digits Only) with field length 1
  • BAUGR
    Its data type is C (Character String) with field length 1
  • ASNUM : Activity Number
    Its data type is C (Character String) with field length 18
  • PEINH_2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • PEINH_3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • PRZNR : Business Process
    Its data type is C (Character String) with field length 12
  • NLAG
    Its data type is C (Character String) with field length 1
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • TYPPS
    Its data type is C (Character String) with field length 1
  • GSBER : Business Area
    Its data type is C (Character String) with field length 4
  • PSPNR : Standard WBS element
    Its data type is N (Character String with Digits Only) with field length 8
  • PAROB
    Its data type is C (Character String) with field length 22
  • KZANW
    Its data type is C (Character String) with field length 1
  • KZLB
    Its data type is C (Character String) with field length 1
  • SUBKEY
    Its data type is C (Character String) with field length 14
  • KZWSO
    Its data type is C (Character String) with field length 1
  • DISST
    Its data type is C (Character String) with field length 3
  • CUOBJ : Configuration (internal object number)
    Its data type is N (Character String with Digits Only) with field length 18
  • GENTYP
    Its data type is C (Character String) with field length 1
  • KSTAR : Cost Element
    Its data type is C (Character String) with field length 10
  • COMPONENT_ID : Unique Pointer to the Itemization Line (Persistent)
    Its data type is N (Character String with Digits Only) with field length 7
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CI_CKIS
  • KSTAR_MANUAL
    Its data type is C (Character String) with field length 1
  • HRKFT : Origin Group as Subdivision of Cost Element
    Its data type is C (Character String) with field length 4
  • ELEMT
    Its data type is N (Character String with Digits Only) with field length 3
  • ELEMTNS
    Its data type is N (Character String with Digits Only) with field length 3
  • FVFLG
    Its data type is C (Character String) with field length 1
  • LEDNR
    Its a key field. Its data type is C (Character String) with field length 2
  • OPCOD
    Its data type is C (Character String) with field length 50
  • FRLNR
    Its data type is C (Character String) with field length 3
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • PSCHL
    Its data type is C (Character String) with field length 18
  • KOKRS_HRK
    Its data type is C (Character String) with field length 4
  • EXTNR
    Its data type is C (Character String) with field length 18
  • GPREIS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • FPREIS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BZOBJ : Reference Object
    Its a key field. Its data type is C (Character String) with field length 1
  • PEINH : Price unit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • PMEHT
    Its data type is C (Character String) with field length 3
  • PRICE_MANUAL
    Its data type is C (Character String) with field length 1
  • WERTB
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WERTN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WRTFX
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WRTFW_KPF
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WRTFW_KFX
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • FWAER_KPF
    Its data type is C (Character String) with field length 5
  • WRTFW_POS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KALNR : Cost Estimate Number for Cost Est. w/o Qty Structure
    Its a key field. Its data type is N (Character String with Digits Only) with field length 12
  • WRTFW_PFX
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • FWAER
    Its data type is C (Character String) with field length 5
  • MKURS
    Its data type is N (Character String with Digits Only) with field length 9
  • FWEHT
    Its data type is N (Character String with Digits Only) with field length 4
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MEEHT
    Its data type is C (Character String) with field length 3
  • SUMM1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SUMM2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SUMM3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • DPREIS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KALKA : Costing Type
    Its a key field. Its data type is C (Character String) with field length 2
  • PREIS1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • PREIS2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • PREIS3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • PREIS4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • PREIS5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • PFKT1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • PFKT2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • PFKT3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • PFKT4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • PFKT5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • KADKY : Costing Date (Key)
    Its a key field. Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ZUABS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUFKT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • PSKNZ
    Its data type is C (Character String) with field length 1
  • SBDKZ
    Its data type is C (Character String) with field length 1
  • VTKNZ
    Its data type is C (Character String) with field length 1
  • LSTAR : Activity Type
    Its data type is C (Character String) with field length 6
  • ARBID : Object ID
    Its data type is N (Character String with Digits Only) with field length 8
  • KOSTL : Cost Center
    Its data type is C (Character String) with field length 10
  • INFNR : Number of purchasing info record
    Its data type is C (Character String) with field length 10
  • EKORG : Purchasing organization
    Its data type is C (Character String) with field length 4
  • TVERS : Costing Version
    Its a key field. Its data type is N (Character String with Digits Only) with field length 2
  • ESOKZ : Purchasing info record category
    Its data type is C (Character String) with field length 1
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • EBELN : Purchasing Document Number
    Its data type is C (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its data type is N (Character String with Digits Only) with field length 5
  • STEUS : Control key
    Its data type is C (Character String) with field length 4
  • FXPRU : Fixed-Price Co-Product
    Its data type is C (Character String) with field length 1
  • STPOS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • AFAKT
    Its data type is F (Floating point number) with field length 8
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • MKALK
    Its data type is C (Character String) with field length 1
  • BWVAR : Valuation Variant in Costing
    Its a key field. Its data type is C (Character String) with field length 3
  • BTYP
    Its data type is C (Character String) with field length 4
  • KALNR_BA
    Its data type is N (Character String with Digits Only) with field length 12
  • MISCH_VERH
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • UMREZ : Numerator for Conversion to Base Units of Measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • UMREN : Denominator for conversion to base units of measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • AUSMG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • AUSMGKO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • AUSPROZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • APLZL : Internal counter
    Its data type is N (Character String with Digits Only) with field length 8
  • VORNR : Operation/Activity Number
    Its data type is C (Character String) with field length 4
  • KKZMA : Costs Entered Manually in Additive or Automatic Cost Est.
    Its a key field. Its data type is C (Character String) with field length 1
  • UVORN : Suboperation
    Its data type is C (Character String) with field length 4
  • STEAS
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • POSNR_EXT
    Its data type is N (Character String with Digits Only) with field length 5
  • POINTER1
    Its data type is N (Character String with Digits Only) with field length 5
  • POINTER2
    Its data type is N (Character String with Digits Only) with field length 5
  • POINTER3
    Its data type is N (Character String with Digits Only) with field length 5
  • OPREIS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • OPREIFX
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TPREIS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TPREIFX
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8