P_REALTIMERPTDFINDATA_TN

Reported Financial Data for Real-time Units | view: PREALTIMERFD_TN | Extraction: Not supported | Component: Consolidation

Tables used: SCAL_TT_YEAR, ACDOCA, TF500, FINCS_FSITEM, TF160, TF162, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, T000, TF164, T881, TF165, TF168, TF110, TF103A, TF040, FINSC_LEDGER_REP, FINSC_FISC_DATE, TFIN010, TFIN010

🔑 Keys (1)
💰 Amounts (3)
∑ Quantities (1)
📅 Dates (5)
☰ Categorical (8)
Other (48)
🔗 Relations (31)

Column Name	Description
gl_sirid	Record number of the line item record

Column Name	Description
💲 Currency Key (rtcur):
tsl	Value in Transaction Currency
💲 Currency key of the local currency (rhcur):
hsl	Value in Local Currency
💲 Currency key of the ledger currency (rkcur):
ksl	Value in Group Currency

Column Name	Description
msl	Quantity

Column Name	Description
budat	Posting Date in the Document
cpudt	Day On Which Accounting Document Was Entered
cputm	Time of Entry
wsdat	Value Date for Currency Translation
_dataaging	Data Filter Value for Data Aging

Column Name	Description
rrcty	Record Type	Show values
rtflg	Currency Translation	Show values
drcrk	Debit/Credit Indicator	Show values
coiac	Consolidation of Investments Activity	Show values
plevl	Posting Level	Show values
refdocct	Document Category	Show values
docct	Document Category	Show values
rpflg	Apportionment	Show values

Column Name	Description	Domain name
rldnr	Ledger	RLDNR
rvers	Version	FC_RVERS
ryear	Fiscal Year	GJAHR
poper	Fiscal Period	POPER
ritclg	Consolidation Chart of Accounts	FC_ITCLG
ritem	Financial Statement Item	FC_ITEM
rbuptr	Partner Unit	FC_BUNIT
sityp	Subitem Category	FC_SITYP
subit	Subitem	FC_SITEM
racct	Account Number	SAKNR
zuonr	Assignment Reference	ZUONR
rcntr	Cost Center	KOSTL
prctr	Profit Center	PRCTR
rfarea	Functional Area	FKBER
rbusa	Business Area	GSBER
segment	Segment for Segmental Reporting	FB_SEGMENT
rmvct	Transaction type	RMVCT
ps_posid	WBS Element External ID	FIS_WBSEXT_NO_CONV
ps_pspid	Project	FIS_PROJECT_NO_CONV
konzs	Customer Supplier Corporate Group	KONZS
ps_psp_pnr	WBS Element Internal ID	FIS_WBSINT_NO_CONV
timestamp	Time Stamp of Creation	TZNTSTMPS
docty	Document Type	FC_DOCTY
rldnr_fin	Source Ledger	FINS_LEDGER
docnr	Document Number of an Accounting Document	BELNR
docln	Six-Character Posting Item for Ledger	DOCLN6
refryear	Fiscal Year	GJAHR
fiscyearper	Fiscal Year Period	FIS_JAHRPER_CONV
updhp	Highest update period	POPER
refdocnr	Document Number of an Accounting Document	BELNR
aworg	Reference Organizational Units	AWORG
refdocln	Six-figure number of line item	BUZEI6
coicu	Investee Unit	FC_BUNIT
rvsdocnr	Reverse Document Number	BELNR
revyear	Year of reversal document or reversed document	GJAHR
yracq	Year of Acquisition	GJAHR
sgtxt	Item Text	TEXT50
autom	Indicator: Automatic posting lines	TEXT1
rcongr	Consolidation Group	FC_CONGR
bvorg	Number of Cross-Company Code Posting Transaction	BVORG
orndocnr	Number of Reversed Document	BELNR
coinr	Consolidation of Investments Activity Number	BELNR
refactiv	Business Transaction	CHAR4
activ	Business Transaction	CHAR4
rcomp	Company	RCOMP
pracq	Period of Acquisition	NUM03
xblnr	Reference Document Number	XBLNR1
uppcu	Investor Unit	FC_BUNIT

Master Data Relations	Join Conditions
Order ID Order ID Client	`P_REALTIMERPTDFINDATA_TN.AUFNR == AUFK.AUFNR` `P_REALTIMERPTDFINDATA_TN.MANDT == AUFK.MANDT`
Reference procedure	`P_REALTIMERPTDFINDATA_TN.AWTYP == TTYP.AWTYP`
Customer Supplier Industry Customer Supplier Industry Client	`P_REALTIMERPTDFINDATA_TN.BRSCH == T016.BRSCH` `P_REALTIMERPTDFINDATA_TN.MANDT == T016.MANDT`
Sales District Client Sales District	`P_REALTIMERPTDFINDATA_TN.MANDT == T171.MANDT` `P_REALTIMERPTDFINDATA_TN.BZIRK == T171.BZIRK`
Billing Type Billing Type Client	`P_REALTIMERPTDFINDATA_TN.FKART == TVFK.FKART` `P_REALTIMERPTDFINDATA_TN.MANDT == TVFK.MANDT`
Customer Group Customer Group Client	`P_REALTIMERPTDFINDATA_TN.KDGRP == T151.KDGRP` `P_REALTIMERPTDFINDATA_TN.MANDT == T151.MANDT`
Controlling Area Client Controlling Area	`P_REALTIMERPTDFINDATA_TN.MANDT == TKA01.MANDT` `P_REALTIMERPTDFINDATA_TN.KOKRS == TKA01.KOKRS`
Chart of Accounts Chart of Accounts Client	`P_REALTIMERPTDFINDATA_TN.KTOPL == T004.KTOPL` `P_REALTIMERPTDFINDATA_TN.MANDT == T004.MANDT`
Customer Number Customer Number Client	`P_REALTIMERPTDFINDATA_TN.KUNNR == KNA1.KUNNR` `P_REALTIMERPTDFINDATA_TN.MANDT == KNA1.MANDT`
Bill-to Party Bill-to Party Client	`P_REALTIMERPTDFINDATA_TN.KUNRE == KNA1.KUNNR` `P_REALTIMERPTDFINDATA_TN.MANDT == KNA1.MANDT`
Ship-to Party Client Ship-to Party	`P_REALTIMERPTDFINDATA_TN.MANDT == KNA1.MANDT` `P_REALTIMERPTDFINDATA_TN.KUNWE == KNA1.KUNNR`
Customer or Supplier Country/Region Customer or Supplier Country/Region Client	`P_REALTIMERPTDFINDATA_TN.LAND1 == T005.LAND1` `P_REALTIMERPTDFINDATA_TN.MANDT == T005.MANDT`
Supplier Supplier Client	`P_REALTIMERPTDFINDATA_TN.LIFNR == LFA1.LIFNR` `P_REALTIMERPTDFINDATA_TN.MANDT == LFA1.MANDT`
Logical system	`P_REALTIMERPTDFINDATA_TN.LOGSYS == TBDLS.LOGSYS`
Product Sold Group Client Product Sold Group Product Sold Group	`P_REALTIMERPTDFINDATA_TN.MANDT == T023.MANDT` `P_REALTIMERPTDFINDATA_TN.MATKL == T023.MATKL` `P_REALTIMERPTDFINDATA_TN.MATKL_MM == T023.MATKL`
Product Sold Group Client Product Sold Group Product Sold Group	`P_REALTIMERPTDFINDATA_TN.MANDT == T023.MANDT` `P_REALTIMERPTDFINDATA_TN.MATKL == T023.MATKL` `P_REALTIMERPTDFINDATA_TN.MATKL_MM == T023.MATKL`
Material Number Client Material Number	`P_REALTIMERPTDFINDATA_TN.MANDT == MARA.MANDT` `P_REALTIMERPTDFINDATA_TN.MATNR == MARA.MATNR`
Product Sold Product Sold Client	`P_REALTIMERPTDFINDATA_TN.MATNR_COPA == MARA.MATNR` `P_REALTIMERPTDFINDATA_TN.MANDT == MARA.MANDT`
Partner Profit Center Partner Profit Center ? Client Controlling Area	`P_REALTIMERPTDFINDATA_TN.PPRCTR == CEPC.PRCTR` `P_REALTIMERPTDFINDATA_TN.[column in domain "DATBI"] == CEPC.DATBI` `P_REALTIMERPTDFINDATA_TN.MANDT == CEPC.MANDT` `P_REALTIMERPTDFINDATA_TN.KOKRS == CEPC.KOKRS`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`P_REALTIMERPTDFINDATA_TN.PSEGMENT == FAGL_SEGM.SEGMENT` `P_REALTIMERPTDFINDATA_TN.MANDT == FAGL_SEGM.MANDT`
Company ID of Trading Partner Company ID of Trading Partner Client	`P_REALTIMERPTDFINDATA_TN.RASSC == T880.RCOMP` `P_REALTIMERPTDFINDATA_TN.MANDT == T880.MANDT`
Consolidation Unit Dimension Consolidation Unit Client	`P_REALTIMERPTDFINDATA_TN.RDIMEN == TF160.DIMEN` `P_REALTIMERPTDFINDATA_TN.RBUNIT == TF160.BUNIT` `P_REALTIMERPTDFINDATA_TN.MANDT == TF160.MANDT`
Dimension Dimension Client	`P_REALTIMERPTDFINDATA_TN.RDIMEN == TF150.DIMEN` `P_REALTIMERPTDFINDATA_TN.MANDT == TF150.MANDT`
Company Code Company Code Client	`P_REALTIMERPTDFINDATA_TN.ROBUKRS == T001.BUKRS` `P_REALTIMERPTDFINDATA_TN.MANDT == T001.MANDT`
Partner Business Area Client Partner Business Area	`P_REALTIMERPTDFINDATA_TN.MANDT == TGSB.MANDT` `P_REALTIMERPTDFINDATA_TN.SBUSA == TGSB.GSBER`
Partner Cost Center ? Client Controlling Area Partner Cost Center	`P_REALTIMERPTDFINDATA_TN.[column in domain "DATBI"] == CSKS.DATBI` `P_REALTIMERPTDFINDATA_TN.MANDT == CSKS.MANDT` `P_REALTIMERPTDFINDATA_TN.KOKRS == CSKS.KOKRS` `P_REALTIMERPTDFINDATA_TN.SCNTR == CSKS.KOSTL`
Partner Functional Area Client Partner Functional Area	`P_REALTIMERPTDFINDATA_TN.MANDT == TFKB.MANDT` `P_REALTIMERPTDFINDATA_TN.SFAREA == TFKB.FKBER`
Division Division Client	`P_REALTIMERPTDFINDATA_TN.SPART == TSPA.SPART` `P_REALTIMERPTDFINDATA_TN.MANDT == TSPA.MANDT`
Sales Organization Client Sales Organization	`P_REALTIMERPTDFINDATA_TN.MANDT == TVKO.MANDT` `P_REALTIMERPTDFINDATA_TN.VKORG == TVKO.VKORG`
Distribution Channel Client Distribution Channel	`P_REALTIMERPTDFINDATA_TN.MANDT == TVTW.MANDT` `P_REALTIMERPTDFINDATA_TN.VTWEG == TVTW.VTWEG`
Plant Client Plant	`P_REALTIMERPTDFINDATA_TN.MANDT == T001W.MANDT` `P_REALTIMERPTDFINDATA_TN.WERKS == T001W.WERKS`