SAP ABAP Table CE4S_CP_KENC (Template for Consumer Goods Industry)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CO-PA (Application Component) Profitability Analysis
     ⤷ KEG2 (Package) Profitability Analysis: Generated Objects (Transportable)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CE4S_CP_KENC	Table Relationship Diagram
Short Description	Template for Consumer Goods Industry

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	CHGRUN	☑	RKENCCRUN	RKENCUNIFY	NUMC	10	0	Realignment run
3	AKTBO	☑	AKTBO	CHAR1	CHAR	1	0	Current profitability segment (CO-PA)
4	PAOBJNR	☑	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
5	PASUBNR	☑	RKESUBNR	RKESUBNR	NUMC	4	0	Profitability Segment Changes (CO-PA)
6	BISDAT	☐	AUFDATBI	DATUM	DATS	8	0	Valid to
7	KNDNR	☐	KUNDE_PA	KUNNR	CHAR	10	0	Customer	KNA1
8	ARTNR	☐	ARTNR	MATNR	CHAR	18	0	Product number	MARA
9	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	TVFK
10	KAUFN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
11	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
12	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
13	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
14	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
15	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
16	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
17	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
18	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
19	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
20	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
21	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
22	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
23	PSPNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
24	MEINH	☐	CO_MEINH	MEINS	UNIT	3	0	Unit of Measure	T006
25	KMBRND	☐	RKESKMBRND	RKESKMBRND	NUMC	2	0	Brand	T2249
26	KMCATG	☐	RKESKMCATG	RKESKMCATG	NUMC	2	0	Business field	T2248
27	KMHI01	☐	HIEZU01	KUNNR	CHAR	10	0	Customer hierarchy Level 1	KNA1
28	KMHI02	☐	HIEZU02	KUNNR	CHAR	10	0	Customer hierarchy Level 2	KNA1
29	KMHI03	☐	HIEZU03	KUNNR	CHAR	10	0	Customer hierarchy Level 3	KNA1
30	KMKDGR	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
31	KMLAND	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
32	KMMAKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
33	KMNIEL	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
34	KMSTGE	☐	RKESKMSTGE	RKESKMSTGE	NUMC	2	0	Strategic Business Unit	T2247
35	KMVKBU	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
36	KMVKGR	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
37	KMVTNR	☐	VRTNR	PERNR	NUMC	8	0	Sales employee
38	KWSVME_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CE4S_CP_KENC	ARTNR	MARA	MATNR	REF	C	CN
2	CE4S_CP_KENC	AUFNR	AUFK	AUFNR	REF	C	CN
3	CE4S_CP_KENC	BUKRS	T001	BUKRS	REF	C	CN
4	CE4S_CP_KENC	FKART	TVFK	FKART	REF	C	CN
5	CE4S_CP_KENC	GSBER	TGSB	GSBER	REF	C	CN
6	CE4S_CP_KENC	KAUFN	VBUK	VBELN	REF	C	CN
7	CE4S_CP_KENC	KMBRND	T2249	KMBRND	REF	C	CN
8	CE4S_CP_KENC	KMCATG	T2248	KMCATG	REF	C	CN
9	CE4S_CP_KENC	KMHI01	KNA1	KUNNR	REF	C	CN
10	CE4S_CP_KENC	KMHI02	KNA1	KUNNR	REF	C	CN
11	CE4S_CP_KENC	KMHI03	KNA1	KUNNR	REF	C	CN
12	CE4S_CP_KENC	KMKDGR	T151	KDGRP	REF	C	CN
13	CE4S_CP_KENC	KMLAND	T005	LAND1	REF	C	CN
14	CE4S_CP_KENC	KMMAKL	T023	MATKL	REF	C	CN
15	CE4S_CP_KENC	KMNIEL	TNLS	NIELS	REF	C	CN
16	CE4S_CP_KENC	KMSTGE	T2247	KMSTGE	REF	C	CN
17	CE4S_CP_KENC	KMVKBU	TVBUR	VKBUR	REF	C	CN
18	CE4S_CP_KENC	KMVKGR	TVKGR	VKGRP	REF	C	CN
19	CE4S_CP_KENC	KNDNR	KNA1	KUNNR	REF	C	CN
20	CE4S_CP_KENC	KOKRS	TKA01	KOKRS	REF	C	CN
21	CE4S_CP_KENC	KSTRG	CKPH	KSTRG	REF	C	CN
22	CE4S_CP_KENC	KWSVME_ME	T006	MSEHI	REF	C	CN
23	CE4S_CP_KENC	MANDT	T000	MANDT	KEY	1	CN
24	CE4S_CP_KENC	MEINH	T006	MSEHI	REF	C	CN
25	CE4S_CP_KENC	PSPNR	PRPS	PSPNR	REF	C	CN
26	CE4S_CP_KENC	SPART	TSPA	SPART	REF	C	CN
27	CE4S_CP_KENC	VKORG	TVKO	VKORG	REF	C	CN
28	CE4S_CP_KENC	VTWEG	TVTW	VTWEG	REF	C	CN
29	CE4S_CP_KENC	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in