I_RealTimeRptdFinData

GR Realtime Reported Data ORL | view: IREALTPTDFIND | TRAN | Extraction: Not supported | Component: Consolidation

Tables used: SCAL_TT_YEAR, ACDOCA, 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 (55)
🔗 Relations (29)

Column Name	Description
ConsolidationRecordNumber	Record number of the line item record

Column Name	Description
💲 Currency key of the local currency (LocalCurrency):
AmountInLocalCurrency	Value in Local Currency
💲 Currency key of the ledger currency (GroupCurrency):
AmountInGroupCurrency	Value in Group Currency
💲 Currency Key (TransactionCurrency):
AmountInTransactionCurrency	Value in Transaction Currency

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
QuantityInBaseUnit	Quantity

Column Name	Description
PostingDate	Posting Date in the Document
CurrencyTranslationDate	Value Date for Currency Translation
CreationDate	Day On Which Accounting Document Was Entered
CreationTime	Time of Entry
DataAgingObject	Data Filter Value for Data Aging

Column Name	Description
GLRecordType	Record Type	Show values
PostingLevel	Posting Level	Show values
ConsolidationApportionment	Apportionment	Show values
CurrencyConversionsDiffType	Currency Translation	Show values
DocumentCategory	Document Category	Show values
RefConsolidationDocumentType	Document Category	Show values
InvestmentActivityType	Consolidation of Investments Activity	Show values
DebitCreditCode	Debit/Credit Indicator	Show values

Column Name	Description	Domain name
SubItemCategory	Subitem Category	FC_SITYP
SubItem	Subitem	FC_SITEM
PartnerConsolidationUnit	Partner Unit	FC_BUNIT
FinancialTransactionType	Transaction type	RMVCT
FunctionalArea	Functional Area	FKBER
BusinessArea	Business Area	GSBER
CostCenter	Cost Center	KOSTL
GLAccount	Account Number	SAKNR
ProfitCenter	Profit Center	PRCTR
Segment	Segment for Segmental Reporting	FB_SEGMENT
FinancialStatementItem	Financial Statement Item	FC_ITEM
ConsolidationChartOfAccounts	Consolidation Chart of Accounts	FC_ITCLG
ConsolidationVersion	Version	FC_RVERS
ConsolidationLedger	Ledger	RLDNR
FiscalPeriod	Fiscal Period	POPER
FiscalYear	Fiscal Year	GJAHR
AssignmentReference	Assignment Reference	ZUONR
WBSElementExternalID	WBS Element External ID	FIS_WBSEXT_NO_CONV
Project	Project	FIS_PROJECT_NO_CONV
CustomerSupplierCorporateGroup	Customer Supplier Corporate Group	KONZS
WBSElementInternalID	WBS Element Internal ID	FIS_WBSINT_NO_CONV
CreationDateTime	Time Stamp of Creation	TZNTSTMPS
SourceLedger	Source Ledger	FINS_LEDGER
Ledger	Ledger in General Ledger Accounting	FINS_LEDGER
LedgerGLLineItem	Ledger Journal Entry Item	DOCLN6
AccountingDocument	Document Number of an Accounting Document	BELNR
ReferenceFiscalYear	Fiscal Year	GJAHR
ReferenceDocumentNumber	Character field, length 32	CHAR32
ConsolidationGroup	Consolidation Group	FC_CONGR
InvesteeConsolidationUnit	Investee Unit	FC_BUNIT
ConsolidationAcquisitionPeriod	Period of Acquisition	NUM03
ConsolidationAcquisitionYear	Year of Acquisition	GJAHR
ConsolidationDocumentType	Document Type	FC_DOCTY
FiscalYearPeriod	Fiscal Year + Fiscal Period	FINS_FYEARPERIOD
ConsolidationDocumentNumber	Document Number of an Accounting Document	BELNR
ConsolidationPostingItem	Ledger Journal Entry Item	DOCLN6
Company	Company	RCOMP
CnsldtnHighestUpdatePeriod	Highest update period	POPER
DocumentItemText	Item Text	TEXT50
ConsolidationPostgItemAutoFlag	Indicator: Automatic posting lines	TEXT1
BusinessTransactionType	Business Transaction	CHAR4
IntercompanyTransaction	Number of Cross-Company Code Posting Transaction	BVORG
RefConsolidationDocumentNumber	Document Number of an Accounting Document	BELNR
RefConsolidationPostingItem	Six-figure number of line item	BUZEI6
RefBusinessTransactionType	Business Transaction	CHAR4
AccountingDocCreatedByUser	User Name	XUBNAME
UserID	User Name	XUBNAME
ReverseDocument	Reverse Document Number	BELNR
ReversedDocument	Number of Reversed Document	BELNR
InvestmentActivity	Consolidation of Investments Activity Number	BELNR
InvestorConsolidationUnit	Investor Unit	FC_BUNIT
ConsolidationDocReversalYear	Year of reversal document or reversed document	GJAHR
ReferenceDocumentType	Reference procedure	AWTYP
ReferenceDocumentContext	Reference Organizational Units	AWORG
LogicalSystem	Logical system	LOGSYS

Master Data Relations	Join Conditions
Billing Type Client Billing Type	`I_REALTIMERPTDFINDATA.MANDT == TVFK.MANDT` `I_REALTIMERPTDFINDATA.BILLINGDOCUMENTTYPE == TVFK.FKART`
Bill-to Party Client Bill-to Party	`I_REALTIMERPTDFINDATA.MANDT == KNA1.MANDT` `I_REALTIMERPTDFINDATA.BILLTOPARTY == KNA1.KUNNR`
Chart of Accounts Chart of Accounts Client	`I_REALTIMERPTDFINDATA.CHARTOFACCOUNTS == T004.KTOPL` `I_REALTIMERPTDFINDATA.MANDT == T004.MANDT`
Company Code Company Code Client	`I_REALTIMERPTDFINDATA.COMPANYCODE == T001.BUKRS` `I_REALTIMERPTDFINDATA.MANDT == T001.MANDT`
Dimension Client Dimension	`I_REALTIMERPTDFINDATA.MANDT == TF150.MANDT` `I_REALTIMERPTDFINDATA.CONSOLIDATIONDIMENSION == TF150.DIMEN`
Consolidation Unit Client Consolidation Unit Dimension	`I_REALTIMERPTDFINDATA.MANDT == TF160.MANDT` `I_REALTIMERPTDFINDATA.CONSOLIDATIONUNIT == TF160.BUNIT` `I_REALTIMERPTDFINDATA.CONSOLIDATIONDIMENSION == TF160.DIMEN`
Controlling Area Client Controlling Area	`I_REALTIMERPTDFINDATA.MANDT == TKA01.MANDT` `I_REALTIMERPTDFINDATA.CONTROLLINGAREA == TKA01.KOKRS`
Customer Number Client Customer Number	`I_REALTIMERPTDFINDATA.MANDT == KNA1.MANDT` `I_REALTIMERPTDFINDATA.CUSTOMER == KNA1.KUNNR`
Customer Group Customer Group Client	`I_REALTIMERPTDFINDATA.CUSTOMERGROUP == T151.KDGRP` `I_REALTIMERPTDFINDATA.MANDT == T151.MANDT`
Customer or Supplier Country/Region Customer or Supplier Country/Region Client	`I_REALTIMERPTDFINDATA.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `I_REALTIMERPTDFINDATA.MANDT == T005.MANDT`
Customer Supplier Industry Client Customer Supplier Industry	`I_REALTIMERPTDFINDATA.MANDT == T016.MANDT` `I_REALTIMERPTDFINDATA.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH`
Distribution Channel Client Distribution Channel	`I_REALTIMERPTDFINDATA.MANDT == TVTW.MANDT` `I_REALTIMERPTDFINDATA.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Material Number Client Material Number	`I_REALTIMERPTDFINDATA.MANDT == MARA.MANDT` `I_REALTIMERPTDFINDATA.MATERIAL == MARA.MATNR`
Product Sold Group Product Sold Group Product Sold Group Client	`I_REALTIMERPTDFINDATA.SOLDPRODUCTGROUP == T023.MATKL` `I_REALTIMERPTDFINDATA.MATERIALGROUP == T023.MATKL` `I_REALTIMERPTDFINDATA.MANDT == T023.MANDT`
Order ID Client Order ID	`I_REALTIMERPTDFINDATA.MANDT == AUFK.MANDT` `I_REALTIMERPTDFINDATA.ORDERID == AUFK.AUFNR`
Division Client Division	`I_REALTIMERPTDFINDATA.MANDT == TSPA.MANDT` `I_REALTIMERPTDFINDATA.ORGANIZATIONDIVISION == TSPA.SPART`
Partner Business Area Client Partner Business Area	`I_REALTIMERPTDFINDATA.MANDT == TGSB.MANDT` `I_REALTIMERPTDFINDATA.PARTNERBUSINESSAREA == TGSB.GSBER`
Company ID of Trading Partner Company ID of Trading Partner Client	`I_REALTIMERPTDFINDATA.PARTNERCOMPANY == T880.RCOMP` `I_REALTIMERPTDFINDATA.MANDT == T880.MANDT`
Partner Cost Center Client Partner Cost Center ? Controlling Area	`I_REALTIMERPTDFINDATA.MANDT == CSKS.MANDT` `I_REALTIMERPTDFINDATA.PARTNERCOSTCENTER == CSKS.KOSTL` `I_REALTIMERPTDFINDATA.[column in domain "DATBI"] == CSKS.DATBI` `I_REALTIMERPTDFINDATA.CONTROLLINGAREA == CSKS.KOKRS`
Partner Functional Area Client Partner Functional Area	`I_REALTIMERPTDFINDATA.MANDT == TFKB.MANDT` `I_REALTIMERPTDFINDATA.PARTNERFUNCTIONALAREA == TFKB.FKBER`
Partner Profit Center Client ? Controlling Area Partner Profit Center	`I_REALTIMERPTDFINDATA.MANDT == CEPC.MANDT` `I_REALTIMERPTDFINDATA.[column in domain "DATBI"] == CEPC.DATBI` `I_REALTIMERPTDFINDATA.CONTROLLINGAREA == CEPC.KOKRS` `I_REALTIMERPTDFINDATA.PARTNERPROFITCENTER == CEPC.PRCTR`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`I_REALTIMERPTDFINDATA.PARTNERSEGMENT == FAGL_SEGM.SEGMENT` `I_REALTIMERPTDFINDATA.MANDT == FAGL_SEGM.MANDT`
Plant Client Plant	`I_REALTIMERPTDFINDATA.MANDT == T001W.MANDT` `I_REALTIMERPTDFINDATA.PLANT == T001W.WERKS`
Sales District Client Sales District	`I_REALTIMERPTDFINDATA.MANDT == T171.MANDT` `I_REALTIMERPTDFINDATA.SALESDISTRICT == T171.BZIRK`
Sales Organization Client Sales Organization	`I_REALTIMERPTDFINDATA.MANDT == TVKO.MANDT` `I_REALTIMERPTDFINDATA.SALESORGANIZATION == TVKO.VKORG`
Ship-to Party Client Ship-to Party	`I_REALTIMERPTDFINDATA.MANDT == KNA1.MANDT` `I_REALTIMERPTDFINDATA.SHIPTOPARTY == KNA1.KUNNR`
Product Sold Product Sold Client	`I_REALTIMERPTDFINDATA.SOLDPRODUCT == MARA.MATNR` `I_REALTIMERPTDFINDATA.MANDT == MARA.MANDT`
Product Sold Group Product Sold Group Product Sold Group Client	`I_REALTIMERPTDFINDATA.SOLDPRODUCTGROUP == T023.MATKL` `I_REALTIMERPTDFINDATA.MATERIALGROUP == T023.MATKL` `I_REALTIMERPTDFINDATA.MANDT == T023.MANDT`
Supplier Supplier Client	`I_REALTIMERPTDFINDATA.SUPPLIER == LFA1.LIFNR` `I_REALTIMERPTDFINDATA.MANDT == LFA1.MANDT`