P_RepFinData_RT_Aggr_04

Get Subitem (TF100, TF103A, TF110) | view: PRFDRTAG_04 | 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, FINSC_LEDGER_REP, FINSC_FISC_DATE, TFIN010, TFIN010

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

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