C_RealTimeRptdFinData

FINCS Realtime Reported Data | view: CREALTPTDFIND | 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

🔑 Keys (1)
💰 Amounts (3)
∑ Quantities (1)
📅 Dates
☰ Categorical
Other (25)
🔗 Relations (27)

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

Column Name	Description

Column Name	Description	Domain name
ReferenceDocumentNumber	Character field, length 32	CHAR32
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
ConsolidationDimension	Dimension	FC_DIMEN
ConsolidationUnit	Consolidation Unit	FC_BUNIT
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

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