SAP Table GLPCA

EC-PCA: Actual Line Items

GLPCA (EC-PCA: Actual Line Items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link GLPCA to other SAP tables.

GLPCA table fields

Field Data element Checktable Datatype Length Decimals
RCLNT Client MANDT T000 CLNT 3 0
GL_SIRID Record number of the line item record GU_RECID CHAR 18 0
RLDNR Ledger RLDNR T881 CHAR 2 0
RRCTY Record Type RRCTY CHAR 1 0
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
RVERS Version RVERS_PCA TKVS CHAR 3 0
RYEAR Fiscal Year GJAHR NUMC 4 0
RTCUR Currency Key RTCUR TCURC CUKY 5 0
RUNIT Base Unit of Measure MEINS T006 UNIT 3 0
DRCRK Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
POPER Posting period POPER NUMC 3 0
DOCCT Document Type DOCCT CHAR 1 0
A Documents with assigned document no. of receiver application
* Any document type
B Documents from accounting
C Documents from currency translation
K Documents from CO
G Documents from FI-SL for global postings
L Documents from FI-SL for local postings
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
S Documents for which FI-SL assigns document numbers
J Documents from Joint Venture
R Rollup documents
M Consolidation documents (EC-MC)
W Documents from the FI/CO doc
P Documents from manual planning
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
DOCNR Accounting Document Number BELNR_D CHAR 10 0
DOCLN Document line DOCLN CHAR 3 0
RBUKRS Company Code BUKRS T001 CHAR 4 0
RPRCTR Profit Center PRCTR CEPC CHAR 10 0
RHOART Type of origin object (EC-PCA) HOART NUMC 2 0
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
88 Profit Center Costing
98 Reconciliation of Differences
99 Legacy Data from a 2.x Release
46 Real Estate General Contract
RFAREA Functional Area FKBER TFKB CHAR 16 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
RACCT Account Number RACCT CHAR 10 0
HRKFT Origin Group as Subdivision of Cost Element HRKFT CHAR 4 0
RASSC Company ID of trading partner RASSC T880 CHAR 6 0
EPRCTR Partner profit center for elimination of internal business EPRCTR CEPC CHAR 10 0
ACTIV FI-SL Business Transaction ACTI1 T022 CHAR 4 0
AFABE Real depreciation area AFABE_D NUMC 2 0
OCLNT Original client OCLNT NUMC 3 0
SBUKRS Sender company code S_BUKRS T001 CHAR 4 0
SPRCTR Partner Profit Center PPRCTR CEPC CHAR 10 0
SHOART Type of receiver object SHOART NUMC 2 0
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
88 Profit Center Costing
98 Reconciliation of Differences
99 Legacy Data from a 2.x Release
46 Real Estate General Contract
SFAREA Partner Functional Area SFKBER TFKB CHAR 16 0
TSL Amount in transaction currency VTCUR_PCA CURR 15 2
HSL Amount in company code currency VLCUR_PCA CURR 15 2
KSL Amount in profit center local currency VGCUR_PCA CURR 15 2
MSL Quantity QUAN1 QUAN 15 3
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
USNAM User name USNAM CHAR 12 0
SGTXT Item Text SGTXT CHAR 50 0
AUTOM Indicator: Automatic posting lines AUTOM CHAR 1 0
DOCTY FI-SL Document Type DOCTY T889 CHAR 2 0
BLDAT Document Date in Document BLDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
WSDAT Value Date for Currency Translation WSDAT DATS 8 0
REFDOCNR Reference Document Number (External Document Number) PCA_REFBELNR CHAR 10 0
REFRYEAR Fiscal Year GJAHR NUMC 4 0
REFDOCLN Number of Line Item Within Accounting Document BUZEI NUMC 3 0
REFDOCCT Document Type DOCCT CHAR 1 0
A Documents with assigned document no. of receiver application
* Any document type
B Documents from accounting
C Documents from currency translation
K Documents from CO
G Documents from FI-SL for global postings
L Documents from FI-SL for local postings
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
S Documents for which FI-SL assigns document numbers
J Documents from Joint Venture
R Rollup documents
M Consolidation documents (EC-MC)
W Documents from the FI/CO doc
P Documents from manual planning
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
REFACTIV FI-SL Business Transaction ACTI1 T022 CHAR 4 0
AWTYP Reference Transaction AWTYP CHAR 5 0
AWORG Reference Organizational Units AWORG CHAR 10 0
WERKS Plant WERKS_D T001W CHAR 4 0
GSBER Business Area GSBER TGSB CHAR 4 0
KOSTL Cost Center KOSTL CSKS CHAR 10 0
LSTAR Activity Type LSTAR CSLA CHAR 6 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
MATNR Material Number MATNR CHAR 18 0
BWKEY Valuation Area BWKEY CHAR 4 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
ANBWA Asset Transaction Type ANBWA CHAR 3 0
KUNNR Customer Number KUNNR CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
RMVCT Transaction Type RMVCT T856 CHAR 3 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
KSTRG Cost Object KSTRG CHAR 12 0
ERKRS Operating concern ERKRS CHAR 4 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PASUBNR Profitability segment changes (CO-PA) RKESUBNR NUMC 4 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
FKART Billing Type FKART CHAR 4 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
AUBEL Sales Document VBELN_VA CHAR 10 0
AUPOS Sales Document Item POSNR_VA NUMC 6 0
SPART Division SPART CHAR 2 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR NUMC 6 0
VKGRP Sales Group VKGRP CHAR 3 0
VKBUR Sales Office VKBUR CHAR 4 0
VBUND Company ID of trading partner RASSC CHAR 6 0
LOGSYS Logical System LOGSYSTEM TBDLS CHAR 10 0
ALEBN ALE: PCA document number in system where created PCA_ALEBN CHAR 10 0
AWSYS Logical system of source document AWSYS CHAR 10 0
VERSA Results Analysis Version VERSN_ABGR CHAR 3 0
STFLG Identifier for reversal document CO_STFLG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
STOKZ Indicator: Document Has Been Reversed CO_STOKZ CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
STAGR Statistical key figure STAGR TKA03 CHAR 6 0
GRTYP Statistical Key Figure Category GRTYP CHAR 1 0
1 Fixed values
2 Totals values
REP_MATNR Representative material for Profit Center Accounting REP_MATNR T8A60 CHAR 18 0
CO_PRZNR Business Process CO_PRZNR CBPR CHAR 12 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
VALUT Value date VALUT DATS 8 0
RSCOPE Object Class SCOPE_CV CHAR 2 0
OC Overhead costs
IV Investment
PR Production
PA Profit analysis
AWREF_REV Reversal: Reverse Document Reference Document Number AWREF_REV CHAR 10 0
AWORG_REV Reversal: Reverse Document Reference Organization AWORG_REV CHAR 10 0
BWART Movement Type (Inventory Management) BWART CHAR 3 0
BLART Document Type BLART CHAR 2 0

GLPCA foreign key relationships

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