SAP ABAP Table KPS1 (CKPS + CKPT)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	KPS1	Table Relationship Diagram
Short Description	CKPS + CKPT

Delivery and Maintenance

Pool/cluster
Delivery Class
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	*
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
47	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
48	TXN08	☐	TXN08	TXN08	CHAR	8	0	Number of the standard text
49	LTEXT	☐	KLTXT	TEXT40	CHAR	40	0	Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KPS1	BUKRS	T001	BUKRS
2	KPS1	EXTNR	CKBS	EXTNR
3	KPS1	FWAER	TCURC	WAERS
4	KPS1	KOKRS	TKA01	KOKRS
5	KPS1	KOKRS_HRK	TKA01	KOKRS
6	KPS1	MATNR	MARA	MATNR
7	KPS1	MEEHT	T006	MSEHI
8	KPS1	SPRAS	T002	SPRAS
9	KPS1	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in