P_RFD_RT_AGGR_simple_03

Account mapping and Partner Consolidation Unit | view: PRFDRTAGS_03 | Extraction: Not supported | Component: Consolidation
Tables used: SCAL_TT_YEAR, ACDOCA, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, T000, TF164, T881, TF165, TF168, FINSC_LEDGER_REP, TFIN010, TFIN010
Column Name Description
Column Name Description
AmountInTransactionCurrency null
AmountInLocalCurrency null
AmountInGroupCurrency null
osl null
vsl null
bsl null
csl null
dsl null
esl null
fsl null
gsl null
Column Name Description
QuantityInBaseUnit null
Column Name Description
Column Name Description
CnsldtnUnitLocalCrcySource Sender for Local Currency ID Show values
CnsldtnUnitGroupCrcySource Source for Group Currency Key Figure Show values
Column Name Description Domain name
FinancialStatementItem Financial Statement Item FC_ITEM
ConsolidationChartOfAccounts Consolidation Chart of Accounts FC_ITCLG
PartnerConsolidationUnit null
ConsolidationVersion Version FC_RVERS
ConsolidationLedger Ledger RLDNR
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
AssignmentReference Assignment Reference ZUONR
WBSElementExternalID WBS Element FIS_WBS
Project Project FIS_PROJECT
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
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == TCURC.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_RFD_RT_AGGR_SIMPLE_03.BASEUNIT == T006.MSEHI
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == T006.MANDT
Billing Type
  • Billing Type
  • Client
  • P_RFD_RT_AGGR_SIMPLE_03.BILLINGDOCUMENTTYPE == TVFK.FKART
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • P_RFD_RT_AGGR_SIMPLE_03.BILLTOPARTY == KNA1.KUNNR
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == KNA1.MANDT
Business Area
  • Business Area
  • Client
  • P_RFD_RT_AGGR_SIMPLE_03.BUSINESSAREA == TGSB.GSBER
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_RFD_RT_AGGR_SIMPLE_03.CHARTOFACCOUNTS == T004.KTOPL
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == T001.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.COMPANYCODE == T001.BUKRS
Dimension
  • Client
  • Dimension
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == TF150.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.CONSOLIDATIONDIMENSION == TF150.DIMEN
Consolidation Unit
  • Client
  • Consolidation Unit
  • Dimension
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == TF160.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.CONSOLIDATIONUNIT == TF160.BUNIT
  • P_RFD_RT_AGGR_SIMPLE_03.CONSOLIDATIONDIMENSION == TF160.DIMEN
Local Currency
  • Client
  • Local Currency
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == TCURC.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.CONSOLIDATIONUNITLOCALCURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_RFD_RT_AGGR_SIMPLE_03.CONTROLLINGAREA == TKA01.KOKRS
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • ?
  • Client
  • Cost Center
  • P_RFD_RT_AGGR_SIMPLE_03.CONTROLLINGAREA == CSKS.KOKRS
  • P_RFD_RT_AGGR_SIMPLE_03.[column in domain "DATBI"] == CSKS.DATBI
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == CSKS.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.COSTCENTER == CSKS.KOSTL
Customer Number
  • Customer Number
  • Client
  • P_RFD_RT_AGGR_SIMPLE_03.CUSTOMER == KNA1.KUNNR
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == T151.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.CUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Client
  • Customer or Supplier Country/Region
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == T005.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
Customer Supplier Industry
  • Client
  • Customer Supplier Industry
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == T016.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Client
  • Distribution Channel
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == TVTW.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • P_RFD_RT_AGGR_SIMPLE_03.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == T856.MANDT
Functional Area
  • Client
  • Functional Area
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == TFKB.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Company Code
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == SKB1.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.GLACCOUNT == SKB1.SAKNR
  • P_RFD_RT_AGGR_SIMPLE_03.COMPANYCODE == SKB1.BUKRS
Material Number
  • Client
  • Material Number
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == MARA.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.MATERIAL == MARA.MATNR
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • P_RFD_RT_AGGR_SIMPLE_03.SOLDPRODUCTGROUP == T023.MATKL
  • P_RFD_RT_AGGR_SIMPLE_03.MATERIALGROUP == T023.MATKL
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == T023.MANDT
Order ID
  • Client
  • Order ID
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == AUFK.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.ORDERID == AUFK.AUFNR
Division
  • Client
  • Division
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == TSPA.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.ORGANIZATIONDIVISION == TSPA.SPART
Partner Business Area
  • Client
  • Partner Business Area
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == TGSB.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == T880.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • Controlling Area
  • ?
  • Client
  • Partner Cost Center
  • P_RFD_RT_AGGR_SIMPLE_03.CONTROLLINGAREA == CSKS.KOKRS
  • P_RFD_RT_AGGR_SIMPLE_03.[column in domain "DATBI"] == CSKS.DATBI
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == CSKS.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Client
  • Partner Functional Area
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == TFKB.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • Controlling Area
  • ?
  • Partner Profit Center
  • Client
  • P_RFD_RT_AGGR_SIMPLE_03.CONTROLLINGAREA == CEPC.KOKRS
  • P_RFD_RT_AGGR_SIMPLE_03.[column in domain "DATBI"] == CEPC.DATBI
  • P_RFD_RT_AGGR_SIMPLE_03.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == FAGL_SEGM.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plant
  • Plant
  • Client
  • P_RFD_RT_AGGR_SIMPLE_03.PLANT == T001W.WERKS
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == T001W.MANDT
Profit Center
  • Controlling Area
  • ?
  • Client
  • Profit Center
  • P_RFD_RT_AGGR_SIMPLE_03.CONTROLLINGAREA == CEPC.KOKRS
  • P_RFD_RT_AGGR_SIMPLE_03.[column in domain "DATBI"] == CEPC.DATBI
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == CEPC.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.PROFITCENTER == CEPC.PRCTR
Sales District
  • Client
  • Sales District
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == T171.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == TVKO.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == FAGL_SEGM.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.SEGMENT == FAGL_SEGM.SEGMENT
Ship-to Party
  • Client
  • Ship-to Party
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == KNA1.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.SHIPTOPARTY == KNA1.KUNNR
Product Sold
  • Client
  • Product Sold
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == MARA.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.SOLDPRODUCT == MARA.MATNR
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • P_RFD_RT_AGGR_SIMPLE_03.SOLDPRODUCTGROUP == T023.MATKL
  • P_RFD_RT_AGGR_SIMPLE_03.MATERIALGROUP == T023.MATKL
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == T023.MANDT
Supplier
  • Client
  • Supplier
  • P_RFD_RT_AGGR_SIMPLE_03.MANDT == LFA1.MANDT
  • P_RFD_RT_AGGR_SIMPLE_03.SUPPLIER == LFA1.LIFNR