SAP ABAP Table CKPS (Unit Costing Items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CIC (Application Component) Interaction Center WinClient
     ⤷ KKEK (Package) Cost accounting unit costing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CKPS	Table Relationship Diagram
Short Description	Unit Costing Items

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
2	KOKRS	☑	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
3	KALNR	☑	KALNR	KALNR	CHAR	8	0	Cost Estimate Number (Unit Costing)
4	WTTYP	☑	WTTYP	WTTYP	NUMC	2	0	Unit costing value type
5	VERSN	☑	VERS2	VERS2	NUMC	2	0	Version Number of the Value Type of a Unit Cost Estimate	CKKS
6	POSNR	☑	PSNUM	POSN5	NUMC	5	0	Unit Costing Item Number
7	STATP	☐	STATP_D	STATE	CHAR	4	0	Item Status
8	STRGP	☐	STRGP	STATE	CHAR	4	0	Item Control (for Internal Use)
9	TYPPS	☐	TYPPS	TYPPS	CHAR	1	0	Item Category
10	KSTAR	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element
11	FVFLG	☐	FVFLG	FVFLG	CHAR	1	0	Fixed/Variable Indicator
12	OPCOD	☐	OPCOD	OPCOD	CHAR	50	0	Formula field for calculations at item level
13	FRLNR	☐	FORML_EK	FORML	CHAR	3	0	Unit Costing Formula Number
14	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
15	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
16	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
17	PSCHL	☐	PSCHL	CHAR18	CHAR	18	0	Pricing Key
18	KOKRS_HRK	☐	KOKRS_HRK	CACCD	CHAR	4	0	Origin Controlling Area Item	TKA01
19	EXTNR	☐	EXTNR	EXTNR	CHAR	18	0	Base Planning Object (External Number)	CKBS
20	GPREIS	☐	GPREIS	CVAL8	CURR	15	2	Total Price for Costing Item
21	WERTB	☐	WERTB	CVAL8	CURR	15	2	Item Gross Value
22	WERTN	☐	WERTN	CVAL8	CURR	15	2	Net Value of Item
23	WERTF	☐	WERTF	CVAL8	CURR	15	2	Gross Value in Foreign Currency
24	FWAER	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
25	MKURS	☐	MKURS	KURSC	NUMC	9	0	Average rate
26	FWEHT	☐	EINHT_CUR	NUM04	NUMC	4	0	Currency unit
27	MENGE	☐	MENGE_POS	CQUA8	QUAN	15	3	Quantity
28	MEEHT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
29	SUMM1	☐	SUMME_MNG	CQUA8	QUAN	15	3	Quantities total for item category S
30	SUMM2	☐	SUMME_INV	CVAL8	CURR	15	2	Capital Spending Total for Item Category S
31	SUMM3	☐	SUMME_POS	CVAL8	CURR	15	2	Total of two or more items
32	DPREIS	☐	DPREIS	CVAL8	CURR	15	2	Average price for periods
33	PREIS1	☐	PREIS1	CVAL8	CURR	15	2	Value of Delta Profit in CO Area Currency - Legal View
34	PREIS2	☐	PREIS2	CVAL8	CURR	15	2	Value of Delta Profit in Object Currency - Legal View
35	PREIS3	☐	PREIS3	CVAL8	CURR	15	2	Value of Delta Profit in CO Area Currency - Profit Ctr View
36	PREIS4	☐	PREIS4	CVAL8	CURR	15	2	Value of Delta Profit in Object Currency - Profit Ctr View
37	PREIS5	☐	PREIS5	CVAL8	CURR	15	2	Price Component 5
38	PFKT1	☐	PFKTX	QBJ_FAK	DEC	5	2	Price Component Factor
39	PFKT2	☐	PFKTX	QBJ_FAK	DEC	5	2	Price Component Factor
40	PFKT3	☐	PFKTX	QBJ_FAK	DEC	5	2	Price Component Factor
41	PFKT4	☐	PFKTX	QBJ_FAK	DEC	5	2	Price Component Factor
42	PFKT5	☐	PFKTX	QBJ_FAK	DEC	5	2	Price Component Factor
43	ZUABS	☐	DZUABS	CVAL8	CURR	15	2	Overhead as absolute figure
44	ZUFKT	☐	DZUFKT	QBJ_FK2	DEC	5	4	Overhead factor
45	PSKNZ	☐	PSKNZ	CHAR1	CHAR	1	0	Lot-Size-Independent Indicator
46	VTKNZ	☐	VTKNZ	YNFLG	CHAR	1	0	Distribution Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CKPS	BUKRS	T001	BUKRS
2	CKPS	EXTNR	CKBS	EXTNR	REF	C	CN
3	CKPS	FWAER	TCURC	WAERS	REF	1	1
4	CKPS	KOKRS	TKA01	KOKRS	KEY	1	CN
5	CKPS	KOKRS_HRK	TKA01	KOKRS	REF	C	CN
6	CKPS	MATNR	MARA	MATNR	REF	1	C
7	CKPS	MEEHT	T006	MSEHI	REF	C	CN
8	CKPS	VERSN	CKKS	VERSN	KEY	1	CN
9	CKPS	WERKS	T001W	WERKS	REF	C	C

History

Last changed by/on	SAP	19970812
SAP Release Created in