SAP table GLPCA (EC-PCA: Actual Line Items)

SAP table GLPCA has 2 primary key fields being RCLNT,GL_SIRID.

Field Description Data Type Length Decimals Checktable Data Element
RCLNT Client CLNT 3 0 T000 MANDT
GL_SIRID Record number of the line item record CHAR 18 0 GU_RECID
RLDNR Ledger CHAR 2 0 T881 RLDNR
RRCTY Record Type CHAR 1 0 RRCTY
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
5 Year-End Closing Posting
RVERS Version CHAR 3 0 TKVS RVERS_PCA
RYEAR Fiscal Year NUMC 4 0 GJAHR
RTCUR Currency Key CUKY 5 0 TCURC RTCUR
RUNIT Base Unit of Measure UNIT 3 0 T006 MEINS
DRCRK Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
POPER Posting period NUMC 3 0 POPER
DOCCT Document Category CHAR 1 0 DOCCT
* Any document type
A Documents with assigned document no. of receiver application
B Documents from accounting
C Documents from currency translation
G Documents from FI-SL for global postings
J Documents from Joint Venture
K Documents from CO
L Documents from FI-SL for local postings
M Consolidation documents (EC-MC)
P Documents from manual planning
R Rollup documents
S Documents for which FI-SL assigns document numbers
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
W Documents from the FI/CO doc
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
DOCNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
DOCLN Document line CHAR 3 0 DOCLN
RBUKRS Company Code CHAR 4 0 T001 BUKRS
RPRCTR Profit Center CHAR 10 0 CEPC PRCTR
RHOART Type of origin object (EC-PCA) NUMC 2 0 HOART
01 Profit Center
02 Cost Center
03 Overhead Cost Order
04 Production Order
05 Billing Document
06 Sales Order
07 WBS Element
08 Network
09 Network Activity
10 Profitability Segment in Account-Based CO-PA
11 Cost Object
12 Business Process
13 Fixed Asset
14 Material
15 Maintenance Order
16 Maintenance Plan
17 SOP Order
18 G/L Account
19 Material Stocks
20 Investment Order
21 Sales Order
22 Asset Portfolios
23 Work in Process
24 Receivables
25 Payables
26 Assets under Construction
27 Cash Discount
28 Credit Valuation Difference
29 Debit Valuation Difference
31 Net Cash Discounts
32 Tax
33 Planned Orders
34 Profitability Segment in Costing-Based CO-PA
35 Additional Balance Sheet Accounts and P&L Accounts
36 Order Items
38 Settlement Unit
39 Buildings
40 Management Contract
41 Real Estate
42 Rental Unit
43 Lease-Out
44 Business Entity
45 Reconciliation Object
46 Real Estate General Contract
47 Service Order
48 Service Contract
88 Profit Center Costing
98 Reconciliation of Differences
99 Legacy Data from a 2.x Release
RFAREA Functional Area CHAR 16 0 TFKB FKBER
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
RACCT Account Number CHAR 10 0 RACCT
HRKFT Origin Group as Subdivision of Cost Element CHAR 4 0 HRKFT
RASSC Company ID of Trading Partner CHAR 6 0 T880 RASSC
EPRCTR Partner profit center for elimination of internal business CHAR 10 0 CEPC EPRCTR
ACTIV FI-SL Business Transaction CHAR 4 0 T022 ACTI1
AFABE Real depreciation area NUMC 2 0 AFABE_D
OCLNT Original client NUMC 3 0 OCLNT
SBUKRS Sender company code CHAR 4 0 T001 S_BUKRS
SPRCTR Partner Profit Center CHAR 10 0 CEPC PPRCTR
SHOART Type of receiver object NUMC 2 0 SHOART
SFAREA Partner Functional Area CHAR 16 0 TFKB SFKBER
TSL Amount in transaction currency CURR 23 2 VTCUR_PCA
HSL Amount in company code currency CURR 23 2 VLCUR_PCA
KSL Amount in profit center local currency CURR 23 2 VGCUR_PCA
MSL Quantity QUAN 15 3 QUAN1
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
USNAM User Name CHAR 12 0 USNAM
SGTXT Item Text CHAR 50 0 SGTXT
AUTOM Indicator: Automatic posting lines CHAR 1 0 AUTOM
DOCTY FI-SL Document Type CHAR 2 0 T889 DOCTY
BLDAT Document Date in Document DATS 8 0 BLDAT
BUDAT Posting Date in the Document DATS 8 0 BUDAT
WSDAT Value Date for Currency Translation DATS 8 0 WSDAT
REFDOCNR Reference Document Number (External Document Number) CHAR 10 0 PCA_REFBELNR
REFRYEAR Fiscal Year NUMC 4 0 GJAHR
REFDOCLN Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
REFDOCCT Document Category CHAR 1 0 DOCCT
* Any document type
A Documents with assigned document no. of receiver application
B Documents from accounting
C Documents from currency translation
G Documents from FI-SL for global postings
J Documents from Joint Venture
K Documents from CO
L Documents from FI-SL for local postings
M Consolidation documents (EC-MC)
P Documents from manual planning
R Rollup documents
S Documents for which FI-SL assigns document numbers
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
W Documents from the FI/CO doc
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
REFACTIV FI-SL Business Transaction CHAR 4 0 T022 ACTI1
AWTYP Reference procedure CHAR 5 0 AWTYP
AWORG Reference Organizational Units CHAR 10 0 AWORG
WERKS Plant CHAR 4 0 T001W WERKS_D
GSBER Business Area CHAR 4 0 TGSB GSBER
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
LSTAR Activity Type CHAR 6 0 CSLA LSTAR
AUFNR Order Number CHAR 12 0 AUFK AUFNR
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
ANLN1 Main Asset Number CHAR 12 0 ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLN2
MATNR Material Number CHAR 40 0 MATNR
BWKEY Valuation area CHAR 4 0 BWKEY
BWTAR Valuation Type CHAR 10 0 BWTAR_D
ANBWA Asset Transaction Type CHAR 3 0 ANBWA
KUNNR Customer Number CHAR 10 0 KUNNR
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
RMVCT Transaction type CHAR 3 0 T856 RMVCT
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
KSTRG Cost Object CHAR 12 0 KSTRG
ERKRS Operating concern CHAR 4 0 ERKRS
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PASUBNR Profitability Segment Changes (CO-PA) NUMC 4 0 RKESUBNR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
KDAUF Sales Order Number CHAR 10 0 KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
FKART Billing Type CHAR 4 0 FKART
VKORG Sales Organization CHAR 4 0 VKORG
VTWEG Distribution Channel CHAR 2 0 VTWEG
AUBEL Sales Document CHAR 10 0 VBELN_VA
AUPOS Sales Document Item NUMC 6 0 POSNR_VA
SPART Division CHAR 2 0 SPART
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
POSNR Item number of the SD document NUMC 6 0 POSNR
VKGRP Sales group CHAR 3 0 VKGRP
VKBUR Sales office CHAR 4 0 VKBUR
VBUND Company ID of Trading Partner CHAR 6 0 RASSC
LOGSYS Logical System CHAR 10 0 TBDLS LOGSYSTEM
ALEBN ALE: PCA document number in system where created CHAR 10 0 PCA_ALEBN
AWSYS Logical system of source document CHAR 10 0 AWSYS
VERSA Results Analysis Version CHAR 3 0 VERSN_ABGR
STFLG Identifier for reversal document CHAR 1 0 CO_STFLG
STOKZ Indicator: Document was reversed CHAR 1 0 CO_STOKZ
STAGR Statistical key figure CHAR 6 0 TKA03 STAGR
GRTYP Statistical Key Figure Category CHAR 1 0 GRTYP
1 Fixed values
2 Totals values
REP_MATNR Representative material for Profit Center Accounting CHAR 40 0 T8A60 REP_MATNR
CO_PRZNR Business Process CHAR 12 0 CBPR CO_PRZNR
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
DABRZ Reference date for settlement DATS 8 0 DABRBEZ
VALUT Value date DATS 8 0 VALUT
RSCOPE Object Class CHAR 2 0 SCOPE_CV
IV Investment
OC Overhead costs
PA Profit analysis
PR Production
AWREF_REV Reversal: Reference Document No. of Document to Be Reversed CHAR 10 0 AWREF_REV
AWORG_REV Reversal: Reference Organizations of Document to Be Reversed CHAR 10 0 AWORG_REV
BWART Movement type (inventory management) CHAR 3 0 BWART
BLART Document Type CHAR 2 0 BLART

GLPCA foreign key relationships

Table Field Check Table Check Field
0 GLPCA AUFNR AUFK Order master data AUFNR
1 GLPCA CO_PRZNR CBPR CO-ABC: Activity Master Table KOKRS
1 GLPCA CO_PRZNR CBPR CO-ABC: Activity Master Table PRZNR
1 GLPCA CO_PRZNR CBPR CO-ABC: Activity Master Table DATBI
0 GLPCA DOCTY T889 FI-SL Document Types MANDT
0 GLPCA DOCTY T889 FI-SL Document Types DOCTY
1 GLPCA EPRCTR CEPC Profit Center Master Data Table PRCTR
1 GLPCA EPRCTR CEPC Profit Center Master Data Table DATBI
1 GLPCA EPRCTR CEPC Profit Center Master Data Table KOKRS
0 GLPCA GSBER TGSB Business Areas MANDT
0 GLPCA GSBER TGSB Business Areas GSBER
1 GLPCA KOKRS TKA01 Controlling Areas MANDT
0 GLPCA KOSTL CSKS Cost Center Master Record MANDT
0 GLPCA KOSTL CSKS Cost Center Master Record KOKRS
0 GLPCA KOSTL CSKS Cost Center Master Record KOSTL
0 GLPCA KOSTL CSKS Cost Center Master Record DATBI
1 GLPCA LOGSYS TBDLS Logical system LOGSYS
0 GLPCA LSTAR CSLA Activity master MANDT
0 GLPCA LSTAR CSLA Activity master KOKRS
0 GLPCA LSTAR CSLA Activity master DATBI
1 GLPCA RASSC T880 Global Company Data (for KONS Ledger) MANDT
1 GLPCA RASSC T880 Global Company Data (for KONS Ledger) RCOMP
0 GLPCA RBUKRS T001 Company Codes BUKRS
1 GLPCA RCLNT T000 Clients MANDT
0 GLPCA REP_MATNR T8A60 Representative Materials MANDT
0 GLPCA REP_MATNR T8A60 Representative Materials KOKRS
0 GLPCA REP_MATNR T8A60 Representative Materials REP_MATNR
1 GLPCA RFAREA TFKB Functional areas FKBER
0 GLPCA RLDNR T881 Ledger Master MANDT
1 GLPCA RMVCT T856 Transaction Types MANDT
1 GLPCA RMVCT T856 Transaction Types TRTYP
0 GLPCA RPRCTR CEPC Profit Center Master Data Table PRCTR
0 GLPCA RPRCTR CEPC Profit Center Master Data Table DATBI
0 GLPCA RPRCTR CEPC Profit Center Master Data Table KOKRS
1 GLPCA RTCUR TCURC Currency Codes MANDT
1 GLPCA RTCUR TCURC Currency Codes WAERS
0 GLPCA RUNIT T006 Units of Measurement MSEHI
1 GLPCA RVERS TKVS CO Versions VERSI
0 GLPCA SBUKRS T001 Company Codes BUKRS
1 GLPCA SFAREA TFKB Functional areas FKBER
0 GLPCA SPRCTR CEPC Profit Center Master Data Table PRCTR
0 GLPCA SPRCTR CEPC Profit Center Master Data Table DATBI
0 GLPCA SPRCTR CEPC Profit Center Master Data Table KOKRS
1 GLPCA STAGR TKA03 Statistical key figures MANDT
1 GLPCA STAGR TKA03 Statistical key figures KOKRS
0 GLPCA WERKS T001W Plants/Branches MANDT
0 GLPCA WERKS T001W Plants/Branches WERKS