P_RFD_RT_AGGR_simple

Reported Financial Data for Real-time Units | view: PRFDRTAGS | 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, TFIN010, TFIN010
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
QuantityInBaseUnit Quantity
Column Name Description
Column Name Description
Column Name Description Domain name
ReferenceDocumentNumber Reference Document Number XBLNR1
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
CompanyCode Company Code BUKRS
ChartOfAccounts Chart of Accounts KTOPL
AssignmentReference Assignment Reference ZUONR
ControllingArea Controlling Area CACCD
PartnerCostCenter Partner Cost Center KOSTL
PartnerProfitCenter Partner Profit Center PRCTR
PartnerFunctionalArea Partner Functional Area FKBER
PartnerBusinessArea Partner Business Area GSBER
PartnerCompany Company ID of Trading Partner RCOMP
PartnerSegment Partner Segment for Segmental Reporting FB_SEGMENT
OrderID Order ID AUFNR
Customer Customer Number KUNNR
Supplier Supplier LIFNR
Material Material Number MATNR
MaterialGroup Product Sold Group MATKL
Plant Plant WERKS
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
Project Project FIS_PROJECT_NO_CONV
BillingDocumentType Billing Type FKART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Division SPART
SoldProduct Product Sold MATNR
SoldProductGroup Product Sold Group MATKL
CustomerGroup Customer Group KDGRP
CustomerSupplierCountry Customer or Supplier Country/Region LAND1
CustomerSupplierIndustry Customer Supplier Industry BRSCH
SalesDistrict Sales District BZIRK
BillToParty Bill-to Party KUNNR
ShipToParty Ship-to Party KUNNR
CustomerSupplierCorporateGroup Customer Supplier Corporate Group KONZS
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
CreationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Dimension
  • Client
  • Dimension
  • P_RFD_RT_AGGR_SIMPLE.MANDT == TF150.MANDT
  • P_RFD_RT_AGGR_SIMPLE.CONSOLIDATIONDIMENSION == TF150.DIMEN
Consolidation Unit
  • Consolidation Unit
  • Client
  • Dimension
  • P_RFD_RT_AGGR_SIMPLE.CONSOLIDATIONUNIT == TF160.BUNIT
  • P_RFD_RT_AGGR_SIMPLE.MANDT == TF160.MANDT
  • P_RFD_RT_AGGR_SIMPLE.CONSOLIDATIONDIMENSION == TF160.DIMEN
Currency key of the local currency
  • Client
  • Currency key of the local currency
  • P_RFD_RT_AGGR_SIMPLE.MANDT == TCURC.MANDT
  • P_RFD_RT_AGGR_SIMPLE.LOCALCURRENCY == TCURC.WAERS