P_RFD_RT_AGGR_simple_05

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