SAP ABAP Table GLPCA (EC-PCA: Actual Line Items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ KE1 (Package) Profit Center Accounting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	GLPCA	Table Relationship Diagram
Short Description	EC-PCA: Actual Line Items

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	RCLNT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	GL_SIRID	☑	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
3	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
4	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
5	RVERS	☐	RVERS_PCA	COVERSI	CHAR	3	0	Version	TKVS
6	RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
8	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
9	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
10	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
11	DOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
12	DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
13	DOCLN	☐	DOCLN	DOCLN	CHAR	3	0	Document line
14	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
15	RPRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
16	RHOART	☐	HOART	HOART	NUMC	2	0	Type of origin object (EC-PCA)
17	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
18	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
19	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	*
20	HRKFT	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	*
21	RASSC	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
22	EPRCTR	☐	EPRCTR	PRCTR	CHAR	10	0	Partner profit center for elimination of internal business	CEPC
23	ACTIV	☐	ACTI1	ACTIVITY	CHAR	4	0	FI-SL Business Transaction	T022
24	AFABE	☐	AFABE_D	AFABE	NUMC	2	0	Real depreciation area	*
25	OCLNT	☐	OCLNT	NUM3	NUMC	3	0	Original client
26	SBUKRS	☐	S_BUKRS	BUKRS	CHAR	4	0	Sender company code	T001
27	SPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
28	SHOART	☐	SHOART	HOART	NUMC	2	0	Type of receiver object
29	SFAREA	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
30	TSL	☐	VTCUR_PCA	WERTV8	CURR	15	2	Amount in transaction currency
31	HSL	☐	VLCUR_PCA	WERTV8	CURR	15	2	Amount in company code currency
32	KSL	☐	VGCUR_PCA	WERTV8	CURR	15	2	Amount in profit center local currency
33	MSL	☐	QUAN1	MENG8	QUAN	15	3	Quantity
34	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
35	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
36	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
37	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
38	AUTOM	☐	AUTOM	TEXT1	CHAR	1	0	Indicator: Automatic posting lines
39	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
40	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
41	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
42	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
43	REFDOCNR	☐	PCA_REFBELNR	BELNR	CHAR	10	0	Reference Document Number (External Document Number)
44	REFRYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
45	REFDOCLN	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
46	REFDOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
47	REFACTIV	☐	ACTI1	ACTIVITY	CHAR	4	0	FI-SL Business Transaction	T022
48	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
49	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
50	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
51	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
52	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
53	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
54	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
55	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
56	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
57	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
58	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
59	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
60	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
61	ANBWA	☐	ANBWA	BWASL	CHAR	3	0	Asset Transaction Type	*
62	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
63	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
64	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
65	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
66	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
67	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
68	ERKRS	☐	ERKRS	ERKRS	CHAR	4	0	Operating concern	*
69	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
70	PASUBNR	☐	RKESUBNR	RKESUBNR	NUMC	4	0	Profitability Segment Changes (CO-PA)
71	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
72	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
73	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
74	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	*
75	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
76	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
77	AUBEL	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
78	AUPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
79	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
80	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
81	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
82	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
83	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
84	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
85	LOGSYS	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	TBDLS
86	ALEBN	☐	PCA_ALEBN	BELNR	CHAR	10	0	ALE: PCA document number in system where created
87	AWSYS	☐	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	*
88	VERSA	☐	VERSN_ABGR	VERSN_ABGR	CHAR	3	0	Results Analysis Version	*
89	STFLG	☐	CO_STFLG	FLAG	CHAR	1	0	Identifier for reversal document
90	STOKZ	☐	CO_STOKZ	FLAG	CHAR	1	0	Indicator: Document Has Been Reversed
91	STAGR	☐	STAGR	STAGR	CHAR	6	0	Statistical key figure	TKA03
92	GRTYP	☐	GRTYP	GRTYP	CHAR	1	0	Statistical Key Figure Category
93	REP_MATNR	☐	REP_MATNR	MATNR	CHAR	18	0	Representative material for Profit Center Accounting	T8A60
94	CO_PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	CBPR
95	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
96	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
97	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
98	RSCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
99	AWREF_REV	☐	AWREF_REV	AWREF	CHAR	10	0	Reversal: Reverse Document Reference Document Number
100	AWORG_REV	☐	AWORG_REV	AWORG	CHAR	10	0	Reversal: Reverse Document Reference Organization
101	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
102	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	GLPCA	ACTIV	T022	ACTIVITY		C	CN
2	GLPCA	AUFNR	AUFK	AUFNR		C	CN
3	GLPCA	CO_PRZNR	CBPR	PRZNR		C	CN
4	GLPCA	DOCTY	T889	DOCTY		1	CN
5	GLPCA	EPRCTR	CEPC	PRCTR		C	CN
6	GLPCA	GSBER	TGSB	GSBER		C	CN
7	GLPCA	KOKRS	TKA01	KOKRS		C	CN
8	GLPCA	KOSTL	CSKS	KOSTL		C	CN
9	GLPCA	LOGSYS	TBDLS	LOGSYS
10	GLPCA	LSTAR	CSLA	LSTAR		C	CN
11	GLPCA	RASSC	T880	RCOMP		C	CN
12	GLPCA	RBUKRS	T001	BUKRS	REF	1	CN
13	GLPCA	RCLNT	T000	MANDT	KEY	1	CN
14	GLPCA	REFACTIV	T022	ACTIVITY		C	CN
15	GLPCA	REP_MATNR	T8A60	REP_MATNR
16	GLPCA	RFAREA	TFKB	FKBER		C	CN
17	GLPCA	RLDNR	T881	RLDNR	REF	C	CN
18	GLPCA	RMVCT	T856	TRTYP		C	CN
19	GLPCA	RPRCTR	CEPC	PRCTR		C	CN
20	GLPCA	RTCUR	TCURC	WAERS	REF	C	CN
21	GLPCA	RUNIT	T006	MSEHI	REF	C	CN
22	GLPCA	RVERS	TKVS	VERSI	REF	C	CN
23	GLPCA	SBUKRS	T001	BUKRS		C	CN
24	GLPCA	SFAREA	TFKB	FKBER		C	CN
25	GLPCA	SPRCTR	CEPC	PRCTR		C	CN
26	GLPCA	STAGR	TKA03	STAGR		C	CN
27	GLPCA	WERKS	T001W	WERKS		C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in