SAP ABAP Table CKIS (Items Unit Costing/Itemization Product Costing)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CK (Package) R/3 Application development: PP Product Costing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CKIS	Table Relationship Diagram
Short Description	Items Unit Costing/Itemization Product Costing

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LEDNR	☑	LEDNR	LEDNR	CHAR	2	0	Ledger for Controlling objects
3	BZOBJ	☑	CK_OBJ	CK_OBJ	CHAR	1	0	Reference Object	*
4	KALNR	☑	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	CKHS
5	KALKA	☑	CK_KALKA	CK_KALKA	CHAR	2	0	Costing Type	*
6	KADKY	☑	CK_KADKY	CK_KADAT	DATS	8	0	Costing Date (Key)
7	TVERS	☑	CK_TVERS	CK_VERSION	NUMC	2	0	Costing Version
8	BWVAR	☑	CK_BWVAR	CK_BWVAR	CHAR	3	0	Valuation Variant in Costing	*
9	KKZMA	☑	CK_KKZMA	XFELD	CHAR	1	0	Costs Entered Manually in Additive or Automatic Cost Est.
10	POSNR	☑	CK_POSNR	CK_POSNR	NUMC	5	0	Unit Costing Line Item Number
11	STATP	☐	STATP_D	STATE	CHAR	4	0	Item Status
12	STRGP	☐	STRGP	STATE	CHAR	4	0	Item Control (for Internal Use)
13	TYPPS	☐	TYPPS	TYPPS	CHAR	1	0	Item Category
14	KSTAR	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	*
15	KSTAR_MANUAL	☐	CK_COST_ELEMENT_MANUAL	CK_COST_ELEMENT_MANUAL	CHAR	1	0	Cost Element Has Been Manually Changed
16	HRKFT	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	*
17	ELEMT	☐	CK_ELEMENTHS	CK_ELEMENT	NUMC	3	0	Cost Component Number of Main Cost Component Split	*
18	ELEMTNS	☐	CK_ELEMENTNS	CK_ELEMENT	NUMC	3	0	Cost Component Number of Auxiliary Cost Component Split	*
19	FVFLG	☐	FVFLG	FVFLG	CHAR	1	0	Fixed/Variable Indicator
20	OPCOD	☐	OPCOD	OPCOD	CHAR	50	0	Formula field for calculations at item level
21	FRLNR	☐	FORML_EK	FORML	CHAR	3	0	Unit Costing Formula Number
22	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
23	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
24	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
25	PSCHL	☐	PSCHL	CHAR18	CHAR	18	0	Pricing Key
26	KOKRS_HRK	☐	KOKRS_HRK	CACCD	CHAR	4	0	Origin Controlling Area Item	TKA01
27	EXTNR	☐	EXTNR	EXTNR	CHAR	18	0	Base Planning Object (External Number)	CKBS
28	GPREIS	☐	CK_KPT	WERTV8	CURR	15	2	Price in Controlling Area Currency
29	FPREIS	☐	CK_KPF	WERTV8	CURR	15	2	Fixed Price in Controlling Area Currency
30	PEINH	☐	CK_KPEINH	PACK3	DEC	5	0	Price Unit of Prices in Controlling Area Currency
31	PMEHT	☐	PMEHT	MEINS	UNIT	3	0	Price Quantity Unit	T006
32	PRICE_MANUAL	☐	CK_PRICE_MANUAL	CK_PRICE_MANUAL	CHAR	1	0	Price Entered Manually
33	WERTB	☐	CK_KWT	WERTV8	CURR	15	2	Value in Controlling Area Currency
34	WERTN	☐	CK_KWT	WERTV8	CURR	15	2	Value in Controlling Area Currency
35	WRTFX	☐	CK_KWF	WERTV8	CURR	15	2	Fixed Value in Controlling Area Currency
36	WRTFW_KPF	☐	CK_OWT	WERTV8	CURR	15	2	Value in Object Currency
37	WRTFW_KFX	☐	CK_OWF	WERTV8	CURR	15	2	Fixed Value in Object Currency
38	FWAER_KPF	☐	CK_OWAER	WAERS	CUKY	5	0	Object Currency	*
39	WRTFW_POS	☐	CK_TWT	WERTV8	CURR	15	2	Value in Transaction Currency
40	WRTFW_PFX	☐	CK_TWF	WERTV8	CURR	15	2	Fixed Value in Transaction Currency
41	FWAER	☐	CK_TWAER	WAERS	CUKY	5	0	Transaction Currency	TCURC
42	MKURS	☐	MKURS	KURSC	NUMC	9	0	Average rate
43	FWEHT	☐	EINHT_CUR	NUM04	NUMC	4	0	Currency unit
44	MENGE	☐	MENGE_POS	CQUA8	QUAN	15	3	Quantity
45	MEEHT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
46	SUMM1	☐	SUMME_MNG	CQUA8	QUAN	15	3	Quantities total for item category S
47	SUMM2	☐	SUMME_INV	CVAL8	CURR	15	2	Capital Spending Total for Item Category S
48	SUMM3	☐	SUMME_POS	CVAL8	CURR	15	2	Total of two or more items
49	DPREIS	☐	DPREIS	CVAL8	CURR	15	2	Average price for periods
50	PREIS1	☐	PREIS1	CVAL8	CURR	15	2	Value of Delta Profit in CO Area Currency - Legal View
51	PREIS2	☐	PREIS2	CVAL8	CURR	15	2	Value of Delta Profit in Object Currency - Legal View
52	PREIS3	☐	PREIS3	CVAL8	CURR	15	2	Value of Delta Profit in CO Area Currency - Profit Ctr View
53	PREIS4	☐	PREIS4	CVAL8	CURR	15	2	Value of Delta Profit in Object Currency - Profit Ctr View
54	PREIS5	☐	PREIS5	CVAL8	CURR	15	2	Price Component 5
55	PFKT1	☐	PFKTX	QBJ_FAK	DEC	5	2	Price Component Factor
56	PFKT2	☐	PFKTX	QBJ_FAK	DEC	5	2	Price Component Factor
57	PFKT3	☐	PFKTX	QBJ_FAK	DEC	5	2	Price Component Factor
58	PFKT4	☐	PFKTX	QBJ_FAK	DEC	5	2	Price Component Factor
59	PFKT5	☐	PFKTX	QBJ_FAK	DEC	5	2	Price Component Factor
60	ZUABS	☐	DZUABS	CVAL8	CURR	15	2	Overhead as absolute figure
61	ZUFKT	☐	DZUFKT	QBJ_FK2	DEC	5	4	Overhead factor
62	PSKNZ	☐	PSKNZ	CHAR1	CHAR	1	0	Lot-Size-Independent Indicator
63	SBDKZ	☐	SBDKZ	SBDKZ	CHAR	1	0	Dependent requirements ind. for individual and coll. reqmts
64	VTKNZ	☐	VTKNZ	YNFLG	CHAR	1	0	Distribution Indicator
65	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
66	ARBID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
67	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
68	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
69	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
70	ESOKZ	☐	ESOKZ	ESOKZ	CHAR	1	0	Purchasing info record category
71	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
72	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
73	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
74	STEUS	☐	CK_STEUS	CK_STEUS	CHAR	4	0	Control Key
75	FXPRU	☐	CK_FIXPRKU	XFELD	CHAR	1	0	Fixed-Price Co-Product
76	STPOS	☐	CK_AEQUI4	CK_AEQUI4	DEC	4	0	Equivalence Number with 4 Places
77	AFAKT	☐	CK_SPLITFAC	CK_FLTP	FLTP	16	16	Costg.: Apportionment Factor for Itemiz. Line in Joint Prod.
78	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
79	MKALK	☐	CK_MKALK	XFELD	CHAR	1	0	Mixed Costing Indicator
80	BTYP	☐	CKML_BTYP	CKML_PROZESS_TYP	CHAR	4	0	Process Category	*
81	KALNR_BA	☐	CKKALNRBA	CK_KALNR	NUMC	12	0	Cost Estimate Number of Procurement Alternative	*
82	MISCH_VERH	☐	CK_CROSSR	DEC10_3	DEC	13	3	Mixing Ratio
83	UMREZ	☐	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
84	UMREN	☐	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
85	AUSMG	☐	CK_AUSMG	CQUA8	QUAN	15	3	Scrap Quantity
86	AUSMGKO	☐	CK_AUSMGKO	CQUA8	QUAN	15	3	Component Scrap Quantity
87	AUSPROZ	☐	CK_SCRAP	DEC3_3	DEC	6	3	Scrap Factor
88	APLZL	☐	CK_COUNT	CK_COUNT	NUMC	8	0	Continuous Counter for Differentiating Database Entries
89	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
90	UVORN	☐	UVORN	VORNR	CHAR	4	0	Suboperation
91	STEAS	☐	CK_STEAS	CK_DATUM	DATS	8	0	Target start date of the operation
92	POSNR_EXT	☐	CK_POSEXT	CK_POSNR	NUMC	5	0	Item Number for External Layout (Unit Costing)	*
93	POINTER1	☐	CK_POS_POI	CK_POSNR	NUMC	5	0	Pointer n on Item Number	*
94	POINTER2	☐	CK_POS_POI	CK_POSNR	NUMC	5	0	Pointer n on Item Number	*
95	POINTER3	☐	CK_POS_POI	CK_POSNR	NUMC	5	0	Pointer n on Item Number	*
96	OPREIS	☐	CK_OPT	WERTV8	CURR	15	2	Price in Object Currency
97	OPREIFX	☐	CK_OPF	WERTV8	CURR	15	2	Fixed Price in Object Currency
98	TPREIS	☐	CK_TPT	WERTV8	CURR	15	2	Price in Transaction Currency
99	TPREIFX	☐	CK_TPF	WERTV8	CURR	15	2	Fixed Price in Transaction Currency
100	PATNR	☐	NKPRTN	NUM6	NUMC	6	0	Partner number for costing
101	VERWS	☐	CK_VERWEIS	CHAR35	CHAR	35	0	Reference of KALKTAB Items to a Context
102	PRSKZ	☐	CK_PRSKZ	CHAR3	CHAR	3	0	Price Indicator
103	STRAT	☐	CK_STRAT	XFELD	CHAR	1	0	Valuation Strategy used for Costing Item
104	SUBSTRAT	☐	CK_SUBSTRAT	CK_PSMINF	CHAR	1	0	Substrategy for Material Valuat. with Purchasing Info Record
105	TKURS	☐	TKURS	UKURS	DEC	9	5	Exchange Rate for Item Foreign Currency
106	SELKZ	☐	CK_SELKZ	CK_SELKZ	CHAR	1	0	Indicator for Relevancy to Costing	TCK08
107	VRGGRP	☐	CK_VRGGRP	VRGGRP	CHAR	3	0	Transaction Group for Cost Element Itemization	*
108	KKZMM	☐	KKZMM	XFELD	CHAR	1	0	Costs Were Entered Manually in an Additive Cost Estimate
109	SSEDD	☐	SSEDD	DATUM	DATS	8	0	Latest scheduled finish: Execution (date)
110	FEHLKZ	☐	CK_FEHLKZ	XFELD	CHAR	1	0	Error Indicator
111	NO_CCSPLIT	☐	CK_NO_CCSPLIT	XFELD	CHAR	1	0	Do Not Determine Item Value via Cost Component Split
112	SCHKZ	☐	CK_SCHKZHS	XFELD	CHAR	1	0	Main Cost Component Split for KALKTAB Item Exists
113	SCHKZNS	☐	CK_SCHKZNS	XFELD	CHAR	1	0	Auxiliary Cost Component Split for KALKTAB Item Exists
114	UFIELD_MODE	☐	CK_UFIELD_MODE	CK_UFIELD_MODE	CHAR	1	0	Indicator to Override Transfer Control
115	UKALN	☐	CK_UKALN	CK_KALNR	NUMC	12	0	Cost Estimate Number of Transferred Cost Estimate	*
116	UKALKA	☐	CK_UKALKA	CK_KALKA	CHAR	2	0	Costing Type of Transferred Cost Estimate	*
117	UKADKY	☐	CK_UKADKY	CK_KADAT	DATS	8	0	Date of Transferred Cost Estimate
118	UTVERS	☐	CK_UTVERS	CK_VERSION	NUMC	2	0	Costing Version for Transfer
119	UBWVAR	☐	CK_UBWVAR	CK_BWVAR	CHAR	3	0	Valuation Variant of Transferred Cost Estimate	*
120	HKMAT	☐	HKMAT	HKMAT	CHAR	1	0	Material-related origin
121	SPOSN	☐	SPOSN	SPOSN	CHAR	4	0	BOM Item Number
122	USTRAT	☐	CK_UEBPER1	CK_PER	NUMC	1	0	Transfer Strategy: Search Term 1
123	BAUGR	☐	CK_BAUGR	CHAR1	CHAR	1	0	Item Is an Assembly
124	ASNUM	☐	ASNUM	ASNUM	CHAR	18	0	Activity Number	ASMD
125	PEINH_2	☐	PEINH	PACK3	DEC	5	0	Price unit
126	PEINH_3	☐	PEINH	PACK3	DEC	5	0	Price unit
127	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
128	NLAG	☐	CK_NLAG	XFELD	CHAR	1	0	Non-Stock Material
129	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
130	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
131	PSPNR	☐	WB_POSNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS element)	*
132	PAROB	☐	PAROB	J_OBJNR	CHAR	22	0	Partner Object	*
133	KZANW	☐	CK_KZANW	CK_KZANW	CHAR	1	0	'X' = Do Not Calculate Overhead Costs
134	KZLB	☐	CK_KZLB	CK_KZANW	CHAR	1	0	'X' = Header Material Is Subcontracted
135	SUBKEY	☐	CO_SUBKEY	CO_SUBKEY	CHAR	14	0	CO key subnumber	*
136	KZWSO	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
137	DISST	☐	DISST	DISST	CHAR	3	0	Low-level code
138	CUOBJ	☐	CK_CUOBJ	CUOBJ	NUMC	18	0	Object Number for Conf. Objects
139	GENTYP	☐	CK_GENTYP	CK_GENTYP	CHAR	1	0	Generation Type of Item
140	COMPONENT_ID	☐	CK_COMPONENT_ID		NUMC	7	0	Unique Pointer to the Itemization Line (Persistent)
141	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CKIS	ASNUM	ASMD	ASNUM		1	CN
2	CKIS	BUKRS	T001	BUKRS	REF	1	CN
3	CKIS	BWTAR	T149D	BWTAR	REF	1	CN
4	CKIS	EXTNR	CKBS	EXTNR	REF	1	CN
5	CKIS	FWAER	TCURC	WAERS	REF	1	CN
6	CKIS	INFNR	EINA	INFNR	REF	1	CN
7	CKIS	KALNR	CKHS	KALNR	KEY	1	CN
8	CKIS	KOKRS_HRK	TKA01	KOKRS	REF	1	CN
9	CKIS	MANDT	T000	MANDT	KEY	1	CN
10	CKIS	MATNR	MARA	MATNR	REF	1	CN
11	CKIS	MEEHT	T006	MSEHI	REF	1	CN
12	CKIS	PMEHT	T006	MSEHI	REF	1	CN
13	CKIS	SELKZ	TCK08	SELKZ	REF	1	CN
14	CKIS	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in