P_RealTimeRptdFinData_06

Evaluate breakdown by RTCUR and provide fields from ACDOCA | view: PREALTIMERFD_06 | 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
Column Name Description
Column Name Description
AmountInTransactionCurrency Amount in Balance Transaction Currency
AmountInLocalCurrency Amount in Freely Defined Currency 8
AmountInGroupCurrency Amount in Freely Defined Currency 8
Column Name Description
QuantityInBaseUnit Quantity
Column Name Description
Column Name Description
Column Name Description Domain name
SubItemCategory Fixed value for a subitem category-like characteristic CHAR10
SubItem null
PartnerConsolidationUnit null
BaseUnit null
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 FIS_WBS
WBSElement WBS Element FIS_WBS
Project Project FIS_PROJECT
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
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
AccountingDocument Journal Entry BELNR
ReferenceFiscalYear Fiscal Year GJAHR
Master Data Relations Join Conditions
Billing Type
  • Billing Type
  • Client
  • P_REALTIMERPTDFINDATA_06.BILLINGDOCUMENTTYPE == TVFK.FKART
  • P_REALTIMERPTDFINDATA_06.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • P_REALTIMERPTDFINDATA_06.BILLTOPARTY == KNA1.KUNNR
  • P_REALTIMERPTDFINDATA_06.MANDT == KNA1.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_REALTIMERPTDFINDATA_06.CHARTOFACCOUNTS == T004.KTOPL
  • P_REALTIMERPTDFINDATA_06.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_REALTIMERPTDFINDATA_06.COMPANYCODE == T001.BUKRS
  • P_REALTIMERPTDFINDATA_06.MANDT == T001.MANDT
Dimension
  • Client
  • Dimension
  • P_REALTIMERPTDFINDATA_06.MANDT == TF150.MANDT
  • P_REALTIMERPTDFINDATA_06.CONSOLIDATIONDIMENSION == TF150.DIMEN
Consolidation Unit
  • Client
  • Consolidation Unit
  • Dimension
  • P_REALTIMERPTDFINDATA_06.MANDT == TF160.MANDT
  • P_REALTIMERPTDFINDATA_06.CONSOLIDATIONUNIT == TF160.BUNIT
  • P_REALTIMERPTDFINDATA_06.CONSOLIDATIONDIMENSION == TF160.DIMEN
Local Currency
  • Client
  • Local Currency
  • P_REALTIMERPTDFINDATA_06.MANDT == TCURC.MANDT
  • P_REALTIMERPTDFINDATA_06.CONSOLIDATIONUNITLOCALCURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_REALTIMERPTDFINDATA_06.CONTROLLINGAREA == TKA01.KOKRS
  • P_REALTIMERPTDFINDATA_06.MANDT == TKA01.MANDT
Customer Number
  • Customer Number
  • Client
  • P_REALTIMERPTDFINDATA_06.CUSTOMER == KNA1.KUNNR
  • P_REALTIMERPTDFINDATA_06.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • P_REALTIMERPTDFINDATA_06.CUSTOMERGROUP == T151.KDGRP
  • P_REALTIMERPTDFINDATA_06.MANDT == T151.MANDT
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • P_REALTIMERPTDFINDATA_06.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • P_REALTIMERPTDFINDATA_06.MANDT == T005.MANDT
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • P_REALTIMERPTDFINDATA_06.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • P_REALTIMERPTDFINDATA_06.MANDT == T016.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • P_REALTIMERPTDFINDATA_06.MANDT == TVTW.MANDT
  • P_REALTIMERPTDFINDATA_06.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Ledger
Material Number
  • Material Number
  • Client
  • P_REALTIMERPTDFINDATA_06.MATERIAL == MARA.MATNR
  • P_REALTIMERPTDFINDATA_06.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • P_REALTIMERPTDFINDATA_06.MATERIALGROUP == T023.MATKL
  • P_REALTIMERPTDFINDATA_06.SOLDPRODUCTGROUP == T023.MATKL
  • P_REALTIMERPTDFINDATA_06.MANDT == T023.MANDT
Order ID
  • Order ID
  • Client
  • P_REALTIMERPTDFINDATA_06.ORDERID == AUFK.AUFNR
  • P_REALTIMERPTDFINDATA_06.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • P_REALTIMERPTDFINDATA_06.ORGANIZATIONDIVISION == TSPA.SPART
  • P_REALTIMERPTDFINDATA_06.MANDT == TSPA.MANDT
Partner Business Area
  • Partner Business Area
  • Client
  • P_REALTIMERPTDFINDATA_06.PARTNERBUSINESSAREA == TGSB.GSBER
  • P_REALTIMERPTDFINDATA_06.MANDT == TGSB.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_REALTIMERPTDFINDATA_06.PARTNERCOMPANY == T880.RCOMP
  • P_REALTIMERPTDFINDATA_06.MANDT == T880.MANDT
Partner Cost Center
  • Controlling Area
  • ?
  • Client
  • Partner Cost Center
  • P_REALTIMERPTDFINDATA_06.CONTROLLINGAREA == CSKS.KOKRS
  • P_REALTIMERPTDFINDATA_06.[column in domain "DATBI"] == CSKS.DATBI
  • P_REALTIMERPTDFINDATA_06.MANDT == CSKS.MANDT
  • P_REALTIMERPTDFINDATA_06.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Partner Functional Area
  • Client
  • P_REALTIMERPTDFINDATA_06.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • P_REALTIMERPTDFINDATA_06.MANDT == TFKB.MANDT
Partner Profit Center
  • Controlling Area
  • ?
  • Partner Profit Center
  • Client
  • P_REALTIMERPTDFINDATA_06.CONTROLLINGAREA == CEPC.KOKRS
  • P_REALTIMERPTDFINDATA_06.[column in domain "DATBI"] == CEPC.DATBI
  • P_REALTIMERPTDFINDATA_06.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_REALTIMERPTDFINDATA_06.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • P_REALTIMERPTDFINDATA_06.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • P_REALTIMERPTDFINDATA_06.MANDT == FAGL_SEGM.MANDT
Plant
  • Plant
  • Client
  • P_REALTIMERPTDFINDATA_06.PLANT == T001W.WERKS
  • P_REALTIMERPTDFINDATA_06.MANDT == T001W.MANDT
Sales District
  • Sales District
  • Client
  • P_REALTIMERPTDFINDATA_06.SALESDISTRICT == T171.BZIRK
  • P_REALTIMERPTDFINDATA_06.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • P_REALTIMERPTDFINDATA_06.SALESORGANIZATION == TVKO.VKORG
  • P_REALTIMERPTDFINDATA_06.MANDT == TVKO.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • P_REALTIMERPTDFINDATA_06.SHIPTOPARTY == KNA1.KUNNR
  • P_REALTIMERPTDFINDATA_06.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • P_REALTIMERPTDFINDATA_06.SOLDPRODUCT == MARA.MATNR
  • P_REALTIMERPTDFINDATA_06.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • P_REALTIMERPTDFINDATA_06.MATERIALGROUP == T023.MATKL
  • P_REALTIMERPTDFINDATA_06.SOLDPRODUCTGROUP == T023.MATKL
  • P_REALTIMERPTDFINDATA_06.MANDT == T023.MANDT
Supplier
  • Supplier
  • Client
  • P_REALTIMERPTDFINDATA_06.SUPPLIER == LFA1.LIFNR
  • P_REALTIMERPTDFINDATA_06.MANDT == LFA1.MANDT