CKIS SAP (Items Unit Costing/Itemization Product Costing) Table details
Dictionary Type: Table
Description: Items Unit Costing/Itemization Product Costing
Description: Items Unit Costing/Itemization Product Costing
Table field list including key, data, relationships and ABAP select examples
CKIS is a standard SAP Table which is used to store Items Unit Costing/Itemization Product Costing data and is available within R/3 SAP systems depending on the version and release level.
The CKIS table consists of various fields, each holding specific information or linking keys about Items Unit Costing/Itemization Product Costing data available in SAP. These include LEDNR (Ledger for Controlling objects), BZOBJ (Reference Object), KALNR (Cost Estimate Number for Cost Est. w/o Qty Structure), KALKA (Costing Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = CKIT
SAP CKIS table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
LEDNR | Ledger for Controlling objects | LEDNR | CHAR | 2 | ALPHA | LEDNR | |||
BZOBJ | Reference Object | CK_OBJ | CHAR | 1 | Assigned to domain | CK_OBJ | |||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | CKHS | CK_KALNR | KNR | ||
KALKA | Costing Type | CK_KALKA | CHAR | 2 | Assigned to domain | CK_KALKA | KKA | ||
KADKY | Costing Date (Key) | CK_KADKY | DATS | 8 | CK_KADAT | KKK | |||
TVERS | Costing Version | CK_TVERS | NUMC | 2 | CK_VERSION | VSN | |||
BWVAR | Valuation Variant in Costing | CK_BWVAR | CHAR | 3 | Assigned to domain | CK_BWVAR | BWV | ||
KKZMA | Costs Entered Manually in Additive or Automatic Cost Est. | CK_KKZMA | CHAR | 1 | XFELD | KKM | |||
POSNR | Unit Costing Line Item Number | CK_POSNR | NUMC | 5 | CK_POSNR | ||||
STATP | Item Status | STATP_D | CHAR | 4 | STATE | ||||
STRGP | Item Control (for Internal Use) | STRGP | CHAR | 4 | STATE | ||||
TYPPS | Item Category | TYPPS | CHAR | 1 | TYPPS | ||||
KSTAR | Cost Element | KSTAR | CHAR | 10 | Assigned to domain | ALPHA | KSTAR | KAT | |
KSTAR_MANUAL | Cost Element Has Been Manually Changed | CK_COST_ELEMENT_MANUAL | CHAR | 1 | CK_COST_ELEMENT_MANUAL | ||||
HRKFT | Origin Group as Subdivision of Cost Element | HRKFT | CHAR | 4 | Assigned to domain | HRKFT | |||
ELEMT | Cost Component Number of Main Cost Component Split | CK_ELEMENTHS | NUMC | 3 | Assigned to domain | CK_ELEMENT | |||
ELEMTNS | Cost Component Number of Auxiliary Cost Component Split | CK_ELEMENTNS | NUMC | 3 | Assigned to domain | CK_ELEMENT | |||
FVFLG | Fixed/Variable Indicator | FVFLG | CHAR | 1 | FVFLG | ||||
OPCOD | Formula field for calculations at item level | OPCOD | CHAR | 50 | OPCOD | ||||
FRLNR | Unit Costing Formula Number | FORML_EK | CHAR | 3 | FORML | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
PSCHL | Pricing Key | PSCHL | CHAR | 18 | CHAR18 | ||||
KOKRS_HRK | Origin Controlling Area Item | KOKRS_HRK | CHAR | 4 | TKA01 | CACCD | |||
EXTNR | Base Planning Object (External Number) | EXTNR | CHAR | 18 | CKBS | ALPHA | EXTNR | EBT | |
GPREIS | Price in Controlling Area Currency | CK_KPT | CURR | 15(2) | WERTV8 | ||||
FPREIS | Fixed Price in Controlling Area Currency | CK_KPF | CURR | 15(2) | WERTV8 | ||||
PEINH | Price Unit of Prices in Controlling Area Currency | CK_KPEINH | DEC | 5 | PACK3 | ||||
PMEHT | Price Quantity Unit | PMEHT | UNIT | 3 | T006 | CUNIT | MEINS | ||
PRICE_MANUAL | Price Entered Manually | CK_PRICE_MANUAL | CHAR | 1 | CK_PRICE_MANUAL | ||||
WERTB | Value in Controlling Area Currency | CK_KWT | CURR | 15(2) | WERTV8 | ||||
WERTN | Value in Controlling Area Currency | CK_KWT | CURR | 15(2) | WERTV8 | ||||
WRTFX | Fixed Value in Controlling Area Currency | CK_KWF | CURR | 15(2) | WERTV8 | ||||
WRTFW_KPF | Value in Object Currency | CK_OWT | CURR | 15(2) | WERTV8 | ||||
WRTFW_KFX | Fixed Value in Object Currency | CK_OWF | CURR | 15(2) | WERTV8 | ||||
FWAER_KPF | Object Currency | CK_OWAER | CUKY | 5 | Assigned to domain | WAERS | |||
WRTFW_POS | Value in Transaction Currency | CK_TWT | CURR | 15(2) | WERTV8 | ||||
WRTFW_PFX | Fixed Value in Transaction Currency | CK_TWF | CURR | 15(2) | WERTV8 | ||||
FWAER | Transaction Currency | CK_TWAER | CUKY | 5 | TCURC | WAERS | |||
MKURS | Average rate | MKURS | NUMC | 9 | KURSC | ||||
FWEHT | Currency unit | EINHT_CUR | NUMC | 4 | NUM04 | ||||
MENGE | Quantity | MENGE_POS | QUAN | 15(3) | CQUA8 | ||||
MEEHT | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
SUMM1 | Quantities total for item category S | SUMME_MNG | QUAN | 15(3) | CQUA8 | ||||
SUMM2 | Capital Spending Total for Item Category S | SUMME_INV | CURR | 15(2) | CVAL8 | ||||
SUMM3 | Total of two or more items | SUMME_POS | CURR | 15(2) | CVAL8 | ||||
DPREIS | Average price for periods | DPREIS | CURR | 15(2) | CVAL8 | ||||
PREIS1 | Value of Delta Profit in CO Area Currency - Legal View | PREIS1 | CURR | 15(2) | CVAL8 | ||||
PREIS2 | Value of Delta Profit in Object Currency - Legal View | PREIS2 | CURR | 15(2) | CVAL8 | ||||
PREIS3 | Value of Delta Profit in CO Area Currency - Profit Ctr View | PREIS3 | CURR | 15(2) | CVAL8 | ||||
PREIS4 | Value of Delta Profit in Object Currency - Profit Ctr View | PREIS4 | CURR | 15(2) | CVAL8 | ||||
PREIS5 | Price Component 5 | PREIS5 | CURR | 15(2) | CVAL8 | ||||
PFKT1 | Price Component Factor | PFKTX | DEC | 5(2) | QBJ_FAK | ||||
PFKT2 | Price Component Factor | PFKTX | DEC | 5(2) | QBJ_FAK | ||||
PFKT3 | Price Component Factor | PFKTX | DEC | 5(2) | QBJ_FAK | ||||
PFKT4 | Price Component Factor | PFKTX | DEC | 5(2) | QBJ_FAK | ||||
PFKT5 | Price Component Factor | PFKTX | DEC | 5(2) | QBJ_FAK | ||||
ZUABS | Overhead as absolute figure | DZUABS | CURR | 15(2) | CVAL8 | ||||
ZUFKT | Overhead factor | DZUFKT | DEC | 5(4) | QBJ_FK2 | ||||
PSKNZ | Lot-Size-Independent Indicator | PSKNZ | CHAR | 1 | CHAR1 | ||||
SBDKZ | Dependent requirements ind. for individual and coll. reqmts | SBDKZ | CHAR | 1 | SBDKZ | ||||
VTKNZ | Distribution Indicator | VTKNZ | CHAR | 1 | YNFLG | ||||
LSTAR | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART_EMPTY | |
ARBID | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
INFNR | Number of Purchasing Info Record | INFNR | CHAR | 10 | EINA | ALPHA | INFNR | INF | MEIN_C |
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
ESOKZ | Purchasing info record category | ESOKZ | CHAR | 1 | ESOKZ | ESO | |||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
STEUS | Control Key | CK_STEUS | CHAR | 4 | CK_STEUS | ||||
FXPRU | Fixed-Price Co-Product | CK_FIXPRKU | CHAR | 1 | XFELD | ||||
STPOS | Equivalence Number with 4 Places | CK_AEQUI4 | DEC | 4 | CK_AEQUI4 | ||||
AFAKT | Costg.: Apportionment Factor for Itemiz. Line in Joint Prod. | CK_SPLITFAC | FLTP | 16(16) | CK_FLTP | ||||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
MKALK | Mixed Costing Indicator | CK_MKALK | CHAR | 1 | XFELD | ||||
BTYP | Process Category | CKML_BTYP | CHAR | 4 | Assigned to domain | CKML_PROZESS_TYP | |||
KALNR_BA | Cost Estimate Number of Procurement Alternative | CKKALNRBA | NUMC | 12 | Assigned to domain | CK_KALNR | |||
MISCH_VERH | Mixing Ratio | CK_CROSSR | DEC | 13(3) | DEC10_3 | ||||
UMREZ | Numerator for Conversion of Order Unit to Base Unit | UMBSZ | DEC | 5 | UMBSZ | ||||
UMREN | Denominator for Conversion of Order Unit to Base Unit | UMBSN | DEC | 5 | UMBSN | ||||
AUSMG | Scrap Quantity | CK_AUSMG | QUAN | 15(3) | CQUA8 | ||||
AUSMGKO | Component Scrap Quantity | CK_AUSMGKO | QUAN | 15(3) | CQUA8 | ||||
AUSPROZ | Scrap Factor | CK_SCRAP | DEC | 6(3) | DEC3_3 | ||||
APLZL | Continuous Counter for Differentiating Database Entries | CK_COUNT | NUMC | 8 | CK_COUNT | ||||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
UVORN | Suboperation | UVORN | CHAR | 4 | NUMCV | VORNR | |||
STEAS | Target start date of the operation | CK_STEAS | DATS | 8 | CK_DATUM | ||||
POSNR_EXT | Item Number for External Layout (Unit Costing) | CK_POSEXT | NUMC | 5 | Assigned to domain | CK_POSNR | |||
POINTER1 | Pointer n on Item Number | CK_POS_POI | NUMC | 5 | Assigned to domain | CK_POSNR | |||
POINTER2 | Pointer n on Item Number | CK_POS_POI | NUMC | 5 | Assigned to domain | CK_POSNR | |||
POINTER3 | Pointer n on Item Number | CK_POS_POI | NUMC | 5 | Assigned to domain | CK_POSNR | |||
OPREIS | Price in Object Currency | CK_OPT | CURR | 15(2) | WERTV8 | ||||
OPREIFX | Fixed Price in Object Currency | CK_OPF | CURR | 15(2) | WERTV8 | ||||
TPREIS | Price in Transaction Currency | CK_TPT | CURR | 15(2) | WERTV8 | ||||
TPREIFX | Fixed Price in Transaction Currency | CK_TPF | CURR | 15(2) | WERTV8 | ||||
PATNR | Partner number for costing | NKPRTN | NUMC | 6 | NUM6 | ||||
VERWS | Reference of KALKTAB Items to a Context | CK_VERWEIS | CHAR | 35 | CHAR35 | ||||
PRSKZ | Price Indicator | CK_PRSKZ | CHAR | 3 | CHAR3 | ||||
STRAT | Valuation Strategy used for Costing Item | CK_STRAT | CHAR | 1 | XFELD | ||||
SUBSTRAT | Substrategy for Material Valuat. with Purchasing Info Record | CK_SUBSTRAT | CHAR | 1 | CK_PSMINF | ||||
TKURS | Exchange Rate for Item Foreign Currency | TKURS | DEC | 9(5) | UKURS | ||||
SELKZ | Indicator for Relevancy to Costing | CK_SELKZ | CHAR | 1 | TCK08 | CK_SELKZ | |||
VRGGRP | Transaction Group for Cost Element Itemization | CK_VRGGRP | CHAR | 3 | Assigned to domain | VRGGRP | |||
KKZMM | Costs Were Entered Manually in an Additive Cost Estimate | KKZMM | CHAR | 1 | XFELD | ||||
SSEDD | Latest scheduled finish: Execution (date) | SSEDD | DATS | 8 | DATUM | ||||
FEHLKZ | Error Indicator | CK_FEHLKZ | CHAR | 1 | XFELD | ||||
NO_CCSPLIT | Do Not Determine Item Value via Cost Component Split | CK_NO_CCSPLIT | CHAR | 1 | XFELD | ||||
SCHKZ | Main Cost Component Split for KALKTAB Item Exists | CK_SCHKZHS | CHAR | 1 | XFELD | ||||
SCHKZNS | Auxiliary Cost Component Split for KALKTAB Item Exists | CK_SCHKZNS | CHAR | 1 | XFELD | ||||
UFIELD_MODE | Indicator to Override Transfer Control | CK_UFIELD_MODE | CHAR | 1 | CK_UFIELD_MODE | ||||
UKALN | Cost Estimate Number of Transferred Cost Estimate | CK_UKALN | NUMC | 12 | Assigned to domain | CK_KALNR | KNR | ||
UKALKA | Costing Type of Transferred Cost Estimate | CK_UKALKA | CHAR | 2 | Assigned to domain | CK_KALKA | KKA | ||
UKADKY | Date of Transferred Cost Estimate | CK_UKADKY | DATS | 8 | CK_KADAT | KKK | |||
UTVERS | Costing Version for Transfer | CK_UTVERS | NUMC | 2 | CK_VERSION | VSN | |||
UBWVAR | Valuation Variant of Transferred Cost Estimate | CK_UBWVAR | CHAR | 3 | Assigned to domain | CK_BWVAR | BWV | ||
HKMAT | Material-related origin | HKMAT | CHAR | 1 | HKMAT | ||||
SPOSN | BOM Item Number | SPOSN | CHAR | 4 | NUMCV | SPOSN | |||
USTRAT | Transfer Strategy: Search Term 1 | CK_UEBPER1 | NUMC | 1 | CK_PER | ||||
BAUGR | Item Is an Assembly | CK_BAUGR | CHAR | 1 | CHAR1 | ||||
ASNUM | Activity Number | ASNUM | CHAR | 18 | ASMD | ALPHA | ASNUM | ASN | |
PEINH_2 | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
PEINH_3 | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
PRZNR | Business Process | CO_PRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | KWP | |
NLAG | Non-Stock Material | CK_NLAG | CHAR | 1 | XFELD | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PSPNR | Work Breakdown Structure Element (WBS element) | WB_POSNR | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
PAROB | Partner Object | PAROB | CHAR | 22 | Assigned to domain | J_OBJNR | |||
KZANW | 'X' = Do Not Calculate Overhead Costs | CK_KZANW | CHAR | 1 | CK_KZANW | ||||
KZLB | 'X' = Header Material Is Subcontracted | CK_KZLB | CHAR | 1 | CK_KZANW | ||||
SUBKEY | CO key subnumber | CO_SUBKEY | CHAR | 14 | Assigned to domain | CO_SUBKEY | |||
KZWSO | Units of measure usage | KZWSO | CHAR | 1 | KZWSO | ||||
DISST | Low-Level Code | DISST | CHAR | 3 | DISST | ||||
CUOBJ | Object Number for Conf. Objects | CK_CUOBJ | NUMC | 18 | CUOBJ | ||||
GENTYP | Generation Type of Item | CK_GENTYP | CHAR | 1 | CK_GENTYP | ||||
COMPONENT_ID | Unique Pointer to the Itemization Line (Persistent) | CK_COMPONENT_ID | NUMC | 7 | |||||
.INCLU--AP | 0 | ||||||||
RELATIONSHIP_IND | PCP: Flag - Object Relationships Exist | CK_RELATION_IND | CHAR | 1 | CHAR1 | ||||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
.INCLU--AP | 0 | ||||||||
PPEGUID | Internal Identification for PVS Objects | PVS_GUID | RAW | 16 | SYSUUID | ||||
MODEGUID | Internal Identification for PVS Objects | PVS_GUID | RAW | 16 | SYSUUID |
Key field | Non-key field |
How do I retrieve data from SAP table CKIS using ABAP code
The following ABAP code Example will allow you to do a basic selection on CKIS to SELECT all data from the tableDATA: WA_CKIS TYPE CKIS.
SELECT SINGLE *
FROM CKIS
INTO CORRESPONDING FIELDS OF WA_CKIS
WHERE...
How to access SAP table CKIS
Within an ECC or HANA version of SAP you can also view further information about CKIS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects