SAP ABAP Table JBDST0 (Reference Table for CE0xxxx (Internal Structure CO-PA))

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B-PA-PA (Application Component) Profitability Analysis
     ⤷ JBKE (Package) Bank-Specific Additions to Standard Profitability Analysis

Basic Data

Table Category	INTTAB	Structure
Structure	JBDST0	Table Relationship Diagram
Short Description	Reference Table for CE0xxxx (Internal Structure CO-PA)

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	.INCLUDE	☐				0	0	Bank PA - Fixed Part of Line Items
2	.INCLUDE	☐				0	0	CO-PA Line-Item Actual Data
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	PALEDGER	☐	LEDBO	LEDBO	CHAR	2	0	Currency type for an operating concern	TKEL
5	VRGAR	☐	RKE_VRGAR	VRGAR	CHAR	1	0	Record Type	TVGA
6	VERSI	☐	RKEVERSI	COVERSI	CHAR	3	0	Plan version (CO-PA)	TKVS
7	PERIO	☐	JAHRPER	JAHRPER	NUMC	7	0	Period/year
8	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
9	PASUBNR	☐	RKESUBNR	RKESUBNR	NUMC	4	0	Profitability Segment Changes (CO-PA)
10	BELNR	☐	RKE_BELNR	BELNR	CHAR	10	0	Document number of line item in Profitability Analysis
11	POSNR	☐	RKE_POSNR	RKE_POSNR	CHAR	6	0	Item no. of CO-PA line item
12	HZDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
13	USNAM	☐	ERFASSER	USNAM	CHAR	12	0	Created by
14	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
15	PERDE	☐	PERIODE	NUM3	NUMC	3	0	Period
16	WADAT	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
17	FADAT	☐	FADAT	DATUM	DATS	8	0	Invoice date (date created)
18	BUDAT	☐	DAERF	DATUM	DATS	8	0	Posting Date
19	ALTPERIO	☐	JAHRPERALT	JAHRPER	NUMC	7	0	Period/year in alternative period type
20	PAPAOBJNR	☐	RKEPOBJ	RKEOBJNR	NUMC	10	0	Partner profitability segment number (CO-PA)
21	PAPASUBNR	☐	RKEPSUBNR	RKESUBNR	NUMC	4	0	Changes to partner profitability segments (CO-PA)
22	KNDNR	☐	KUNDE_PA	KUNNR	CHAR	10	0	Customer	KNA1
23	ARTNR	☐	ARTNR	MATNR	CHAR	18	0	Product number	MARA
24	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	TVFK
25	FRWAE	☐	FRWAE	WAERS	CUKY	5	0	Foreign currency key	TCURC
26	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
27	KURSBK	☐	KURSBK	KURSF	DEC	9	5	Exchange rate for op.concern currency -> Co.code currency
28	KURSKZ	☐	KURSKZ	KURSF	DEC	9	5	Exchange rate op.concern currency -> group currency
29	REC_WAERS	☐	RKE_REC_WAERS	WAERS	CUKY	5	0	Currency of the data record	TCURC
30	KAUFN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
31	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
32	RKAUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
33	SKOST	☐	SKOST	KOSTL	CHAR	10	0	Sender cost center	CSKS
34	PRZNR	☐	SEPRZ	CO_PRZNR	CHAR	12	0	Sender Business Process	CBPR
35	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
36	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
37	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
38	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
39	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
40	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
41	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
42	HRKFT	☐	RKEHERK	RKEHERK	CHAR	4	0	Origins (CO-PA)
43	PLIKZ	☐	PLIKZ	PLIKZ	CHAR	1	0	Plan/Actual Indicator
44	KSTAR	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
45	PSPNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
46	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
47	RBELN	☐	RKERFBELNR	BELNR	CHAR	10	0	Reference document number for CO-PA line item
48	RPOSN	☐	RKERFPOSNR	RKE_POSNR	CHAR	6	0	Item number from reference document (CO-PA)
49	STO_BELNR	☐	RKE_STO_BELNR	BELNR	CHAR	10	0	Canceled document
50	STO_POSNR	☐	RKE_STO_POSNR	RKE_POSNR	CHAR	6	0	Canceled document item
51	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
52	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
53	RKESTATU	☐	RKESTATU	RKESTATU	CHAR	10	0	Update status for CO-PA line items
54	TIMESTMP	☐	RKE_HZSTMP	RKE_TSTMP	DEC	16	0	Time created (Greenwich Meantime)
55	COPA_AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
56	COPA_AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
57	COPA_BWZPT	☐	BWZPT	BWZPT	CHAR	1	0	CO-PA Point of valuation
58	COPA_AWSYS	☐	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	TBDLS
59	OBJNRT	☐	JBOBJNR	J_OBJNR	CHAR	22	0	Object number for financial transactions	*
60	RADKEY	☐	JBRADKEY_D	JBRADKEY	CHAR	2	0	Differentiation of Transactions from Costing View	JBRADKEY
61	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
62	RBPROD	☐	JBRBPROD	JBRBPROD	CHAR	10	0	Bank Product	JBDBPRD
63	RKALRG	☐	JBRKALRG	JBRKALRG	CHAR	8	0	Costing Rule	JBTKREG
64	SHERKU	☐	JBSHERKU	JBSHERKU	CHAR	8	0	Source Indicator
65	IKZDUR	☐	JBIKZDUR	JBIZINSS	DEC	10	5	Average Customer Interest Rate
66	IOPDGW	☐	JBIOPDGW	JBIZINSS	DEC	10	5	Average Transfer Price acc. to Transaction Crcy Yield Curve
67	IOPDHW	☐	JBIOPDHW	JBIZINSS	DEC	10	5	Average Transfer Price acc. to Local Currency Yield Curve
68	.INCLUDE	☐				0	0	Fixed Value Fields for Costing-Based Profitability Analysis
69	WTGBTR	☐	WTGXXX	WERTV8	CURR	15	2	Total Value in Transaction Currency
70	WOGBTR	☐	WOGXXX	WERTV8	CURR	15	2	Total Value in Object Currency
71	WKGBTR	☐	WKGXXX	WERTV8	CURR	15	2	Total Value in Controlling Area Currency
72	WKFBTR	☐	WKFXXX	WERTV8	CURR	15	2	Fixed Value in Controlling Area Currency
73	MEGBTR	☐	MEGXXX	MENGV8	QUAN	15	3	Total Quantity
74	MEINH	☐	CO_MEINH	MEINS	UNIT	3	0	Unit of Measure	T006
75	KNT_FRM_KZ	☐	RKE_KNTFRM	RKE_KNTFRM	NUMC	1	0	Indicator for use in account-based Profitability Analysis
76	VALUTYP	☐	VALUTYP_ACT	VALUTYP	NUMC	1	0	Valuation
77	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in