P_RepFinData_RT_Aggr_05

Evaluate breakdown by RUNIT, RBUPTR, SUBIT (TF103A, TF040) | view: PRFDRTAG_05 | Extraction: Not supported | Component: Consolidation

Tables used: SCAL_TT_YEAR, ACDOCA, FINCS_FSITEM, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, T000, TF164, T881, TF165, TF168, TF110, TF103A, TF040, FINSC_LEDGER_REP, FINSC_FISC_DATE, TFIN010, TFIN010

🔑 Keys
💰 Amounts (11)
∑ Quantities (1)
📅 Dates
☰ Categorical (3)
Other (17)
🔗 Relations (38)

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
CnsldtnSubitemSource	SAP Consolidation Integration: Sender Field for Subitem	Show values
CnsldtnUnitLocalCrcySource	Sender for Local Currency ID	Show values
CnsldtnUnitGroupCrcySource	Source for Group Currency Key Figure	Show values

Column Name	Description	Domain name
SubItem	null
PartnerConsolidationUnit	null
BaseUnit	null
SubItemCategory	Fixed value for a subitem category-like characteristic	CHAR10
BreakdownCategory	Breakdown Category	FC_ITGRP
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
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_REPFINDATA_RT_AGGR_05.MANDT == TCURC.MANDT` `P_REPFINDATA_RT_AGGR_05.BALANCETRANSACTIONCURRENCY == TCURC.WAERS`
Billing Type Billing Type Client	`P_REPFINDATA_RT_AGGR_05.BILLINGDOCUMENTTYPE == TVFK.FKART` `P_REPFINDATA_RT_AGGR_05.MANDT == TVFK.MANDT`
Bill-to Party Client Bill-to Party	`P_REPFINDATA_RT_AGGR_05.MANDT == KNA1.MANDT` `P_REPFINDATA_RT_AGGR_05.BILLTOPARTY == KNA1.KUNNR`
Business Area Business Area Client	`P_REPFINDATA_RT_AGGR_05.BUSINESSAREA == TGSB.GSBER` `P_REPFINDATA_RT_AGGR_05.MANDT == TGSB.MANDT`
Chart of Accounts Chart of Accounts Client	`P_REPFINDATA_RT_AGGR_05.CHARTOFACCOUNTS == T004.KTOPL` `P_REPFINDATA_RT_AGGR_05.MANDT == T004.MANDT`
Company Code Company Code Client	`P_REPFINDATA_RT_AGGR_05.COMPANYCODE == T001.BUKRS` `P_REPFINDATA_RT_AGGR_05.MANDT == T001.MANDT`
Dimension Dimension Client	`P_REPFINDATA_RT_AGGR_05.CONSOLIDATIONDIMENSION == TF150.DIMEN` `P_REPFINDATA_RT_AGGR_05.MANDT == TF150.MANDT`
Consolidation Unit Dimension Consolidation Unit Client	`P_REPFINDATA_RT_AGGR_05.CONSOLIDATIONDIMENSION == TF160.DIMEN` `P_REPFINDATA_RT_AGGR_05.CONSOLIDATIONUNIT == TF160.BUNIT` `P_REPFINDATA_RT_AGGR_05.MANDT == TF160.MANDT`
Local Currency Client Local Currency	`P_REPFINDATA_RT_AGGR_05.MANDT == TCURC.MANDT` `P_REPFINDATA_RT_AGGR_05.CONSOLIDATIONUNITLOCALCURRENCY == TCURC.WAERS`
Controlling Area Controlling Area Client	`P_REPFINDATA_RT_AGGR_05.CONTROLLINGAREA == TKA01.KOKRS` `P_REPFINDATA_RT_AGGR_05.MANDT == TKA01.MANDT`
Cost Center Controlling Area Cost Center ? Client	`P_REPFINDATA_RT_AGGR_05.CONTROLLINGAREA == CSKS.KOKRS` `P_REPFINDATA_RT_AGGR_05.COSTCENTER == CSKS.KOSTL` `P_REPFINDATA_RT_AGGR_05.[column in domain "DATBI"] == CSKS.DATBI` `P_REPFINDATA_RT_AGGR_05.MANDT == CSKS.MANDT`
Customer Number Customer Number Client	`P_REPFINDATA_RT_AGGR_05.CUSTOMER == KNA1.KUNNR` `P_REPFINDATA_RT_AGGR_05.MANDT == KNA1.MANDT`
Customer Group Customer Group Client	`P_REPFINDATA_RT_AGGR_05.CUSTOMERGROUP == T151.KDGRP` `P_REPFINDATA_RT_AGGR_05.MANDT == T151.MANDT`
Customer or Supplier Country/Region Customer or Supplier Country/Region Client	`P_REPFINDATA_RT_AGGR_05.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `P_REPFINDATA_RT_AGGR_05.MANDT == T005.MANDT`
Customer Supplier Industry Customer Supplier Industry Client	`P_REPFINDATA_RT_AGGR_05.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH` `P_REPFINDATA_RT_AGGR_05.MANDT == T016.MANDT`
Distribution Channel Distribution Channel Client	`P_REPFINDATA_RT_AGGR_05.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `P_REPFINDATA_RT_AGGR_05.MANDT == TVTW.MANDT`
Financial Transaction Type Financial Transaction Type Client	`P_REPFINDATA_RT_AGGR_05.FINANCIALTRANSACTIONTYPE == T856.TRTYP` `P_REPFINDATA_RT_AGGR_05.MANDT == T856.MANDT`
Functional Area Functional Area Client	`P_REPFINDATA_RT_AGGR_05.FUNCTIONALAREA == TFKB.FKBER` `P_REPFINDATA_RT_AGGR_05.MANDT == TFKB.MANDT`
G/L Account Company Code G/L Account Client	`P_REPFINDATA_RT_AGGR_05.COMPANYCODE == SKB1.BUKRS` `P_REPFINDATA_RT_AGGR_05.GLACCOUNT == SKB1.SAKNR` `P_REPFINDATA_RT_AGGR_05.MANDT == SKB1.MANDT`
Material Number Material Number Client	`P_REPFINDATA_RT_AGGR_05.MATERIAL == MARA.MATNR` `P_REPFINDATA_RT_AGGR_05.MANDT == MARA.MANDT`
Product Sold Group Client Product Sold Group Product Sold Group	`P_REPFINDATA_RT_AGGR_05.MANDT == T023.MANDT` `P_REPFINDATA_RT_AGGR_05.MATERIALGROUP == T023.MATKL` `P_REPFINDATA_RT_AGGR_05.SOLDPRODUCTGROUP == T023.MATKL`
Order ID Order ID Client	`P_REPFINDATA_RT_AGGR_05.ORDERID == AUFK.AUFNR` `P_REPFINDATA_RT_AGGR_05.MANDT == AUFK.MANDT`
Division Client Division	`P_REPFINDATA_RT_AGGR_05.MANDT == TSPA.MANDT` `P_REPFINDATA_RT_AGGR_05.ORGANIZATIONDIVISION == TSPA.SPART`
Partner Business Area Client Partner Business Area	`P_REPFINDATA_RT_AGGR_05.MANDT == TGSB.MANDT` `P_REPFINDATA_RT_AGGR_05.PARTNERBUSINESSAREA == TGSB.GSBER`
Company ID of Trading Partner Client Company ID of Trading Partner	`P_REPFINDATA_RT_AGGR_05.MANDT == T880.MANDT` `P_REPFINDATA_RT_AGGR_05.PARTNERCOMPANY == T880.RCOMP`
Partner Cost Center Partner Cost Center Controlling Area ? Client	`P_REPFINDATA_RT_AGGR_05.PARTNERCOSTCENTER == CSKS.KOSTL` `P_REPFINDATA_RT_AGGR_05.CONTROLLINGAREA == CSKS.KOKRS` `P_REPFINDATA_RT_AGGR_05.[column in domain "DATBI"] == CSKS.DATBI` `P_REPFINDATA_RT_AGGR_05.MANDT == CSKS.MANDT`
Partner Functional Area Partner Functional Area Client	`P_REPFINDATA_RT_AGGR_05.PARTNERFUNCTIONALAREA == TFKB.FKBER` `P_REPFINDATA_RT_AGGR_05.MANDT == TFKB.MANDT`
Partner Profit Center Partner Profit Center Controlling Area ? Client	`P_REPFINDATA_RT_AGGR_05.PARTNERPROFITCENTER == CEPC.PRCTR` `P_REPFINDATA_RT_AGGR_05.CONTROLLINGAREA == CEPC.KOKRS` `P_REPFINDATA_RT_AGGR_05.[column in domain "DATBI"] == CEPC.DATBI` `P_REPFINDATA_RT_AGGR_05.MANDT == CEPC.MANDT`
Partner Segment for Segmental Reporting Client Partner Segment for Segmental Reporting	`P_REPFINDATA_RT_AGGR_05.MANDT == FAGL_SEGM.MANDT` `P_REPFINDATA_RT_AGGR_05.PARTNERSEGMENT == FAGL_SEGM.SEGMENT`
Plant Client Plant	`P_REPFINDATA_RT_AGGR_05.MANDT == T001W.MANDT` `P_REPFINDATA_RT_AGGR_05.PLANT == T001W.WERKS`
Profit Center Controlling Area ? Client Profit Center	`P_REPFINDATA_RT_AGGR_05.CONTROLLINGAREA == CEPC.KOKRS` `P_REPFINDATA_RT_AGGR_05.[column in domain "DATBI"] == CEPC.DATBI` `P_REPFINDATA_RT_AGGR_05.MANDT == CEPC.MANDT` `P_REPFINDATA_RT_AGGR_05.PROFITCENTER == CEPC.PRCTR`
Sales District Client Sales District	`P_REPFINDATA_RT_AGGR_05.MANDT == T171.MANDT` `P_REPFINDATA_RT_AGGR_05.SALESDISTRICT == T171.BZIRK`
Sales Organization Sales Organization Client	`P_REPFINDATA_RT_AGGR_05.SALESORGANIZATION == TVKO.VKORG` `P_REPFINDATA_RT_AGGR_05.MANDT == TVKO.MANDT`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`P_REPFINDATA_RT_AGGR_05.MANDT == FAGL_SEGM.MANDT` `P_REPFINDATA_RT_AGGR_05.SEGMENT == FAGL_SEGM.SEGMENT`
Ship-to Party Ship-to Party Client	`P_REPFINDATA_RT_AGGR_05.SHIPTOPARTY == KNA1.KUNNR` `P_REPFINDATA_RT_AGGR_05.MANDT == KNA1.MANDT`
Product Sold Client Product Sold	`P_REPFINDATA_RT_AGGR_05.MANDT == MARA.MANDT` `P_REPFINDATA_RT_AGGR_05.SOLDPRODUCT == MARA.MATNR`
Product Sold Group Client Product Sold Group Product Sold Group	`P_REPFINDATA_RT_AGGR_05.MANDT == T023.MANDT` `P_REPFINDATA_RT_AGGR_05.MATERIALGROUP == T023.MATKL` `P_REPFINDATA_RT_AGGR_05.SOLDPRODUCTGROUP == T023.MATKL`
Supplier Supplier Client	`P_REPFINDATA_RT_AGGR_05.SUPPLIER == LFA1.LIFNR` `P_REPFINDATA_RT_AGGR_05.MANDT == LFA1.MANDT`