SAP ABAP Table CEST1 (CO-PA Line-Item Actual Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ KE (Package) Profitability Analysis

Basic Data

Table Category	INTTAB	Structure
Structure	CEST1	Table Relationship Diagram
Short Description	CO-PA Line-Item Actual Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CEST1	ARTNR	MARA	MATNR
2	CEST1	BUKRS	T001	BUKRS
3	CEST1	COPA_AWSYS	TBDLS	LOGSYS		1	CN
4	CEST1	FKART	TVFK	FKART
5	CEST1	FRWAE	TCURC	WAERS
6	CEST1	GSBER	TGSB	GSBER
7	CEST1	KAUFN	VBUK	VBELN
8	CEST1	KNDNR	KNA1	KUNNR
9	CEST1	KOKRS	TKA01	KOKRS
10	CEST1	KSTAR	CSKA	KSTAR	REF	1	CN
11	CEST1	KSTRG	CKPH	KSTRG	REF	1	CN
12	CEST1	MANDT	T000	MANDT
13	CEST1	PALEDGER	TKEL	PALEDGER
14	CEST1	PPRCTR	CEPC	PRCTR	REF	1	CN
15	CEST1	PRCTR	CEPC	PRCTR	REF	1	CN
16	CEST1	PRZNR	CBPR	PRZNR	REF	1	CN
17	CEST1	PSPNR	PRPS	PSPNR
18	CEST1	REC_WAERS	TCURC	WAERS	REF	1	CN
19	CEST1	RKAUFNR	AUFK	AUFNR
20	CEST1	SKOST	CSKS	KOSTL	REF	1	CN
21	CEST1	SPART	TSPA	SPART
22	CEST1	VERSI	TKVS	VERSI
23	CEST1	VKORG	TVKO	VKORG
24	CEST1	VRGAR	TVGA	VRGAR
25	CEST1	VTWEG	TVTW	VTWEG
26	CEST1	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in