SAP ABAP Table CE1S001 (Sample operating concern)

Hierarchy

☛ HOME (Software Component)
   ⤷ KEG0 (Package) Profitability Analysis: objects generated by the customer

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CE1S001	Table Relationship Diagram
Short Description	Sample operating concern

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	PALEDGER	☑	LEDBO	LEDBO	CHAR	2	0	Currency type for an operating concern	TKEL
3	VRGAR	☑	RKE_VRGAR	VRGAR	CHAR	1	0	Record Type	TVGA
4	VERSI	☑	RKEVERSI	COVERSI	CHAR	3	0	Plan version (CO-PA)	TKVS
5	PERIO	☑	JAHRPER	JAHRPER	NUMC	7	0	Period/year
6	PAOBJNR	☑	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
7	PASUBNR	☑	RKESUBNR	RKESUBNR	NUMC	4	0	Profitability Segment Changes (CO-PA)
8	BELNR	☑	RKE_BELNR	BELNR	CHAR	10	0	Document number of line item in Profitability Analysis
9	POSNR	☑	RKE_POSNR	RKE_POSNR	CHAR	6	0	Item no. of CO-PA line item
10	HZDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
11	USNAM	☐	ERFASSER	USNAM	CHAR	12	0	Created by
12	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
13	PERDE	☐	PERIODE	NUM3	NUMC	3	0	Period
14	WADAT	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
15	FADAT	☐	FADAT	DATUM	DATS	8	0	Invoice date (date created)
16	BUDAT	☐	DAERF	DATUM	DATS	8	0	Posting Date
17	ALTPERIO	☐	JAHRPERALT	JAHRPER	NUMC	7	0	Period/year in alternative period type
18	PAPAOBJNR	☐	RKEPOBJ	RKEOBJNR	NUMC	10	0	Partner profitability segment number (CO-PA)
19	PAPASUBNR	☐	RKEPSUBNR	RKESUBNR	NUMC	4	0	Changes to partner profitability segments (CO-PA)
20	KNDNR	☐	KUNDE_PA	KUNNR	CHAR	10	0	Customer	KNA1
21	ARTNR	☐	ARTNR	MATNR	CHAR	18	0	Product number	MARA
22	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	TVFK
23	FRWAE	☐	FRWAE	WAERS	CUKY	5	0	Foreign currency key	TCURC
24	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
25	KURSBK	☐	KURSBK	KURSF	DEC	9	5	Exchange rate for op.concern currency -> Co.code currency
26	KURSKZ	☐	KURSKZ	KURSF	DEC	9	5	Exchange rate op.concern currency -> group currency
27	REC_WAERS	☐	RKE_REC_WAERS	WAERS	CUKY	5	0	Currency of the data record	TCURC
28	KAUFN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
29	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
30	RKAUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
31	SKOST	☐	SKOST	KOSTL	CHAR	10	0	Sender cost center	CSKS
32	PRZNR	☐	SEPRZ	CO_PRZNR	CHAR	12	0	Sender Business Process	CBPR
33	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
34	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
35	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
36	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
37	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
38	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
39	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
40	HRKFT	☐	RKEHERK	RKEHERK	CHAR	4	0	Origins (CO-PA)
41	PLIKZ	☐	PLIKZ	PLIKZ	CHAR	1	0	Plan/Actual Indicator
42	KSTAR	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
43	PSPNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
44	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
45	RBELN	☐	RKERFBELNR	BELNR	CHAR	10	0	Reference document number for CO-PA line item
46	RPOSN	☐	RKERFPOSNR	RKE_POSNR	CHAR	6	0	Item number from reference document (CO-PA)
47	STO_BELNR	☐	RKE_STO_BELNR	BELNR	CHAR	10	0	Canceled document
48	STO_POSNR	☐	RKE_STO_POSNR	RKE_POSNR	CHAR	6	0	Canceled document item
49	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
50	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
51	RKESTATU	☐	RKESTATU	RKESTATU	CHAR	10	0	Update status for CO-PA line items
52	TIMESTMP	☐	RKE_HZSTMP	RKE_TSTMP	DEC	16	0	Time created (Greenwich Meantime)
53	COPA_AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
54	COPA_AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
55	COPA_BWZPT	☐	BWZPT	BWZPT	CHAR	1	0	CO-PA Point of valuation
56	COPA_AWSYS	☐	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	TBDLS
57	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
58	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
59	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
60	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
61	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
62	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
63	MAABC	☐	MAABC	MAABC	CHAR	1	0	ABC indicator	*
64	BONUS	☐	BONUS	BONUS	CHAR	2	0	Volume rebate group	TVBO
65	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
66	EFORM	☐	RKEG_EFORM	RKEG_EFORM	CHAR	5	0	Form of manufacture	T2513
67	GEBIE	☐	RKEG_GEBIE	RKEG_GEBIE	CHAR	4	0	Area	T2538
68	ABSMG_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
69	ABSMG	☐	RKE2_ABSMG	MENGV15_3	QUAN	15	3	Sales quantity
70	ERLOS	☐	RKE2_ERLOS	WERTV8	CURR	15	2	Revenue
71	MRABA	☐	RKE2_MRABA	WERTV8	CURR	15	2	Quantity discount
72	PRABA	☐	RKE2_PRABA	WERTV8	CURR	15	2	Price reduction
73	RABAT	☐	RKE2_RABAT	WERTV8	CURR	15	2	Other discounts
74	AUSFR	☐	RKE2_AUSFR	WERTV8	CURR	15	2	Outgoing freight
75	VSVP	☐	RKE2_VSVP	WERTV8	CURR	15	2	Dispatch Packaging
76	UMSLZ	☐	RKE2_UMSLZ	WERTV8	CURR	15	2	Licensing Fees
77	PROVV	☐	RKE2_PROVV	WERTV8	CURR	15	2	External Sales Commission
78	VWGK	☐	RKE2_VWGK	WERTV8	CURR	15	2	Administration Overhead Costs
79	VTRGK	☐	RKE2_VTRGK	WERTV8	CURR	15	2	Sales overhead costs
80	VRPRS	☐	RKE2_VRPRS	WERTV8	CURR	15	2	Stock Value

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CE1S001	ABSMG_ME	T006	MSEHI	REF	C	CN
2	CE1S001	ARTNR	MARA	MATNR	REF	C	CN
3	CE1S001	BONUS	TVBO	BONUS	REF	C	CN
4	CE1S001	BRSCH	T016	BRSCH	REF	C	CN
5	CE1S001	BUKRS	T001	BUKRS	REF	C	CN
6	CE1S001	BZIRK	T171	BZIRK	REF	C	CN
7	CE1S001	COPA_AWSYS	TBDLS	LOGSYS	REF	C	CN
8	CE1S001	EFORM	T2513	EFORM	REF	C	CN
9	CE1S001	FKART	TVFK	FKART	REF	C	CN
10	CE1S001	FRWAE	TCURC	WAERS	REF	C	CN
11	CE1S001	GEBIE	T2538	GEBIE	REF	C	CN
12	CE1S001	GSBER	TGSB	GSBER	REF	C	CN
13	CE1S001	KAUFN	VBUK	VBELN	REF	C	CN
14	CE1S001	KDGRP	T151	KDGRP	REF	C	CN
15	CE1S001	KNDNR	KNA1	KUNNR	REF	C	CN
16	CE1S001	KOKRS	TKA01	KOKRS	REF	C	CN
17	CE1S001	KSTAR	CSKA	KSTAR	REF	C	CN
18	CE1S001	KSTRG	CKPH	KSTRG	REF	C	CN
19	CE1S001	LAND1	T005	LAND1	REF	C	CN
20	CE1S001	MANDT	T000	MANDT	KEY	1	CN
21	CE1S001	MATKL	T023	MATKL	REF	C	CN
22	CE1S001	PALEDGER	TKEL	PALEDGER	KEY	1	CN
23	CE1S001	PPRCTR	CEPC	PRCTR	REF	C	CN
24	CE1S001	PRCTR	CEPC	PRCTR	REF	C	CN
25	CE1S001	PRZNR	CBPR	PRZNR	REF	C	CN
26	CE1S001	PSPNR	PRPS	PSPNR	REF	C	CN
27	CE1S001	REC_WAERS	TCURC	WAERS	REF	C	CN
28	CE1S001	RKAUFNR	AUFK	AUFNR	REF	C	CN
29	CE1S001	SKOST	CSKS	KOSTL	REF	C	CN
30	CE1S001	SPART	TSPA	SPART	REF	C	CN
31	CE1S001	VERSI	TKVS	VERSI	KEY	1	CN
32	CE1S001	VKBUR	TVBUR	VKBUR	REF	C	CN
33	CE1S001	VKGRP	TVKGR	VKGRP	REF	C	CN
34	CE1S001	VKORG	TVKO	VKORG	REF	C	CN
35	CE1S001	VRGAR	TVGA	VRGAR	KEY	1	CN
36	CE1S001	VTWEG	TVTW	VTWEG	REF	C	CN
37	CE1S001	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in