P_RFD_RT_AGGR_simple_04

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