GLPCA

EC-PCA: Actual Line Items | #itemdata | Component: Profit Center Accounting

🔑 Keys (2)
💰 Amounts (3)
∑ Quantities (1)
📅 Dates (7)
☰ Categorical (10)
Other (53)
🔗 Relations (27)

Column Name	Description
RCLNT FK	Client
GL_SIRID	Record number of the line item record

Column Name	Description
💲 Currency Key (RTCUR):
TSL	Amount in transaction currency
💲 Currency Key (T001.WAERS):
HSL	Amount in company code currency
💲 Currency key of currency 3 (T882.CURR2):
KSL	Amount in profit center local currency

Column Name	Description
📏 Base Unit of Measure (RUNIT):
MSL	Quantity

Column Name	Description
CPUDT	Day On Which Accounting Document Was Entered
CPUTM	Time of Entry
BLDAT	Document Date in Document
BUDAT	Posting Date in the Document
WSDAT	Value Date for Currency Translation
DABRZ	Reference date for settlement
VALUT	Value date

Column Name	Description
RRCTY	Record Type	Show values
DRCRK	Debit/Credit Indicator	Show values
DOCCT	Document Category	Show values
RHOART	Type of origin object (EC-PCA)	Show values
SHOART	Type of receiver object	Show values
REFDOCCT	Document Category	Show values
STFLG	Identifier for reversal document	Show values
STOKZ	Indicator: Document was reversed	Show values
GRTYP	Statistical Key Figure Category	Show values
RSCOPE	Object Class	Show values

Column Name	Description	Domain name
RYEAR	Fiscal Year	GJAHR
POPER	Posting period	POPER
DOCNR	Document Number of an Accounting Document	BELNR
DOCLN	Document line	DOCLN
RACCT	Account Number	SAKNR
HRKFT	Origin Group as Subdivision of Cost Element	HRKFT
AFABE	Real depreciation area	AFABE
OCLNT	Original client	NUM3
USNAM	User Name	XUBNAME
SGTXT	Item Text	TEXT50
AUTOM	Indicator: Automatic posting lines	TEXT1
REFDOCNR	Reference Document Number (External Document Number)	BELNR
REFRYEAR	Fiscal Year	GJAHR
REFDOCLN	Number of Line Item Within Accounting Document	BUZEI
AWTYP	Reference procedure	AWTYP
AWORG	Reference Organizational Units	AWORG
AUFPL	Routing number of operations in the order	AUFPL
ANLN1	Main Asset Number	ANLN1
ANLN2	Asset Subnumber	ANLN2
MATNR	Material Number	MATNR
BWKEY	Valuation area	BWKEY
BWTAR	Valuation Type	BWTAR
ANBWA	Asset Transaction Type	BWASL
KUNNR	Customer Number	KUNNR
LIFNR	Account Number of Supplier	LIFNR
EBELN	Purchasing Document Number	EBELN
EBELP	Item Number of Purchasing Document	EBELP
KSTRG	Cost Object	KSTRG
ERKRS	Operating concern	ERKRS
PAOBJNR	Profitability Segment Number (CO-PA)	RKEOBJNR
PASUBNR	Profitability Segment Changes (CO-PA)	RKESUBNR
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	PS_POSNR
KDAUF	Sales Order Number	VBELN
KDPOS	Item number in Sales Order	NUM06
FKART	Billing Type	FKART
VKORG	Sales Organization	VKORG
VTWEG	Distribution Channel	VTWEG
AUBEL	Sales Document	VBELN
AUPOS	Sales Document Item	POSNR
SPART	Division	SPART
VBELN	Sales and Distribution Document Number	VBELN
POSNR	Item number of the SD document	POSNR
VKGRP	Sales group	VKGRP
VKBUR	Sales office	VKBUR
VBUND	Company ID of Trading Partner	RCOMP
ALEBN	ALE: PCA document number in system where created	BELNR
AWSYS	Logical system of source document	LOGSYS
VERSA	Results Analysis Version	VERSN_ABGR
IMKEY	Internal Key for Real Estate Object	IMKEY
AWREF_REV	Reversal: Reference Document No. of Document to Be Reversed	AWREF
AWORG_REV	Reversal: Reference Organizations of Document to Be Reversed	AWORG
BWART	Movement type (inventory management)	BWART
BLART	Document Type	BLART

Master Data Relations	Join Conditions
Activity	`GLPCA.ACTIV == T022.ACTIVITY`
Order number Order Number Client	`GLPCA.AUFNR == AUFK.AUFNR` `GLPCA.RCLNT == AUFK.MANDT`
Business Process Controlling Area Business Process Client ?	`GLPCA.KOKRS == CBPR.KOKRS` `GLPCA.CO_PRZNR == CBPR.PRZNR` `GLPCA.RCLNT == CBPR.MANDT` `GLPCA.[column in domain "DATBI"] == CBPR.DATBI`
Document type GL	`GLPCA.RCLNT == T889.MANDT` `GLPCA.DOCTY == T889.DOCTY`
Elimination profit center ? ? Partner profit center for elimination of internal business	`GLPCA.RCLNT == CEPC.MANDT` `GLPCA.[column in domain "DATBI"] == CEPC.DATBI` `GLPCA.[column in domain "KOKRS"] == CEPC.KOKRS` `GLPCA.EPRCTR == CEPC.PRCTR`
Business area	`GLPCA.RCLNT == TGSB.MANDT` `GLPCA.GSBER == TGSB.GSBER`
Controlling area	`GLPCA.RCLNT == TKA01.MANDT` `GLPCA.KOKRS == TKA01.KOKRS`
Cost center ? Cost Center Controlling Area	`GLPCA.RCLNT == CSKS.MANDT` `GLPCA.[column in domain "DATBI"] == CSKS.DATBI` `GLPCA.KOSTL == CSKS.KOSTL` `GLPCA.KOKRS == CSKS.KOKRS`
Logical System	`GLPCA.LOGSYS == TBDLS.LOGSYS`
Activity type Controlling Area Activity Type ?	`GLPCA.RCLNT == CSLA.MANDT` `GLPCA.KOKRS == CSLA.KOKRS` `GLPCA.LSTAR == CSLA.LSTAR` `GLPCA.[column in domain "DATBI"] == CSLA.DATBI`
Partner company number	`GLPCA.RCLNT == T880.MANDT` `GLPCA.RASSC == T880.RCOMP`
Receiver company code	`GLPCA.RCLNT == T001.MANDT` `GLPCA.RBUKRS == T001.BUKRS`
Client	`GLPCA.RCLNT == T000.MANDT`
FI-SL Business Transaction	`GLPCA.REFACTIV == T022.ACTIVITY`
Functional Area	`GLPCA.RCLNT == TFKB.MANDT` `GLPCA.RFAREA == TFKB.FKBER`
Ledger Ledger Client	`GLPCA.RLDNR == T881.RLDNR` `GLPCA.RCLNT == T881.MANDT`
Transaction type	`GLPCA.RCLNT == T856.MANDT` `GLPCA.RMVCT == T856.TRTYP`
Profit center ? ? Profit Center	`GLPCA.RCLNT == CEPC.MANDT` `GLPCA.[column in domain "DATBI"] == CEPC.DATBI` `GLPCA.[column in domain "KOKRS"] == CEPC.KOKRS` `GLPCA.RPRCTR == CEPC.PRCTR`
Transaction currency	`GLPCA.RCLNT == TCURC.MANDT` `GLPCA.RTCUR == TCURC.WAERS`
Transaction unit of measure	`GLPCA.RCLNT == T006.MANDT` `GLPCA.RUNIT == T006.MSEHI`
Version Version Client	`GLPCA.RVERS == TKVS.VERSI` `GLPCA.RCLNT == TKVS.MANDT`
Sender company code	`GLPCA.RCLNT == T001.MANDT` `GLPCA.SBUKRS == T001.BUKRS`
Partner Functional Area	`GLPCA.RCLNT == TFKB.MANDT` `GLPCA.SFAREA == TFKB.FKBER`
Partner profit center ? ? Partner Profit Center	`GLPCA.RCLNT == CEPC.MANDT` `GLPCA.[column in domain "DATBI"] == CEPC.DATBI` `GLPCA.[column in domain "KOKRS"] == CEPC.KOKRS` `GLPCA.SPRCTR == CEPC.PRCTR`
Statistical key figure Controlling Area Statistical key figure Client	`GLPCA.KOKRS == TKA03.KOKRS` `GLPCA.STAGR == TKA03.STAGR` `GLPCA.RCLNT == TKA03.MANDT`
Plant	`GLPCA.RCLNT == T001W.MANDT` `GLPCA.WERKS == T001W.WERKS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Representative material for Profit Center Accounting Representative material for Profit Center Accounting Controlling Area	`GLPCA.RCLNT == T8A60.MANDT` `GLPCA.REP_MATNR == T8A60.REP_MATNR` `GLPCA.KOKRS == T8A60.KOKRS`