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