P_REPFINDATA_RT_AGGRSNRL_02

Consolidation Unit; Period and Year | view: PRFDRTAGSNRL_02 | Extraction: Not supported | Component: S/4HANA Financial Consolidation, Core Processing

Tables used: ACDOCA, FINCS_BUNIT_ATVD, FINCS_BUNIT, TF200, T001, TKA02, FINSC_LEDGER_REP

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

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
DocumentEntryIsInGroupCurrency	Group Currency is Leading Currency	Show values
CnsldtnUnitGroupCrcySource	Source for Group Currency Key Figure	Show values
CnsldtnUnitLocalCrcySource	Source for Local Currency Key Figure	Show values

Column Name	Description	Domain name
ConsolidationUnit	Consolidation Unit	FINCS_MD_BUNIT
ConsolidationVersion	Version	FC_RVERS
ConsolidationLedger	Consolidation Ledger	FC_RLDNR_CONS
FiscalPeriod	Fiscal Period	POPER
FiscalYear	Fiscal Year	GJAHR
FiscalYearPeriod	Fiscal Year Period	FIS_JAHRPER_CONV
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_REPFINDATA_RT_AGGRSNRL_02.BALANCETRANSACTIONCURRENCY == TCURC.WAERS` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == TCURC.MANDT`
Base Unit of Measure Base Unit of Measure Client	`P_REPFINDATA_RT_AGGRSNRL_02.BASEUNIT == T006.MSEHI` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == T006.MANDT`
Billing Type Billing Type Client	`P_REPFINDATA_RT_AGGRSNRL_02.BILLINGDOCUMENTTYPE == TVFK.FKART` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == TVFK.MANDT`
Bill-to Party Bill-to Party Client	`P_REPFINDATA_RT_AGGRSNRL_02.BILLTOPARTY == KNA1.KUNNR` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == KNA1.MANDT`
Business Area Business Area Client	`P_REPFINDATA_RT_AGGRSNRL_02.BUSINESSAREA == TGSB.GSBER` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == TGSB.MANDT`
Chart of Accounts Chart of Accounts Chart of Accounts Client	`P_REPFINDATA_RT_AGGRSNRL_02.CHARTOFACCOUNTS == T004.KTOPL` `P_REPFINDATA_RT_AGGRSNRL_02.REFERENCECHARTOFACCOUNTS == T004.KTOPL` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == T004.MANDT`
Company Code Client Company Code	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == T001.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.COMPANYCODE == T001.BUKRS`
Dimension Dimension Client	`P_REPFINDATA_RT_AGGRSNRL_02.CONSOLIDATIONDIMENSION == TF150.DIMEN` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == TF150.MANDT`
Controlling Area Controlling Area Client	`P_REPFINDATA_RT_AGGRSNRL_02.CONTROLLINGAREA == TKA01.KOKRS` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == TKA01.MANDT`
Cost Center Controlling Area ? Client Cost Center	`P_REPFINDATA_RT_AGGRSNRL_02.CONTROLLINGAREA == CSKS.KOKRS` `P_REPFINDATA_RT_AGGRSNRL_02.[column in domain "DATBI"] == CSKS.DATBI` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == CSKS.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.COSTCENTER == CSKS.KOSTL`
Customer Number Customer Number Client	`P_REPFINDATA_RT_AGGRSNRL_02.CUSTOMER == KNA1.KUNNR` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == KNA1.MANDT`
Customer Group Client Customer Group	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == T151.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.CUSTOMERGROUP == T151.KDGRP`
Customer or Supplier Country/Region Customer or Supplier Country/Region Client	`P_REPFINDATA_RT_AGGRSNRL_02.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == T005.MANDT`
Customer Supplier Industry Customer Supplier Industry Client	`P_REPFINDATA_RT_AGGRSNRL_02.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == T016.MANDT`
Distribution Channel Distribution Channel Client	`P_REPFINDATA_RT_AGGRSNRL_02.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == TVTW.MANDT`
Financial Transaction Type Client Financial Transaction Type	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == T856.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.FINANCIALTRANSACTIONTYPE == T856.TRTYP`
FS Item Mapping Version Client FS Item Mapping Version	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == TF23A.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.FSITEMMAPPINGVERSION == TF23A.IMPVS`
Functional Area Client Functional Area	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == TFKB.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.FUNCTIONALAREA == TFKB.FKBER`
G/L Account G/L Account Client Company Code	`P_REPFINDATA_RT_AGGRSNRL_02.GLACCOUNT == SKB1.SAKNR` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == SKB1.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.COMPANYCODE == SKB1.BUKRS`
Group Currency of Consolidation Version Client Group Currency of Consolidation Version	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == TCURC.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.GROUPCURRENCY == TCURC.WAERS`
Material Number Client Material Number	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == MARA.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.MATERIAL == MARA.MATNR`
Product Sold Group Client Product Sold Group Product Sold Group	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == T023.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.MATERIALGROUP == T023.MATKL` `P_REPFINDATA_RT_AGGRSNRL_02.SOLDPRODUCTGROUP == T023.MATKL`
Order ID Order ID Client	`P_REPFINDATA_RT_AGGRSNRL_02.ORDERID == AUFK.AUFNR` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == AUFK.MANDT`
Division Client Division	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == TSPA.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.ORGANIZATIONDIVISION == TSPA.SPART`
Partner Business Area Partner Business Area Client	`P_REPFINDATA_RT_AGGRSNRL_02.PARTNERBUSINESSAREA == TGSB.GSBER` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == TGSB.MANDT`
Company ID of Trading Partner Company ID of Trading Partner Client	`P_REPFINDATA_RT_AGGRSNRL_02.PARTNERCOMPANY == T880.RCOMP` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == T880.MANDT`
Partner Cost Center Controlling Area Partner Cost Center ? Client	`P_REPFINDATA_RT_AGGRSNRL_02.CONTROLLINGAREA == CSKS.KOKRS` `P_REPFINDATA_RT_AGGRSNRL_02.PARTNERCOSTCENTER == CSKS.KOSTL` `P_REPFINDATA_RT_AGGRSNRL_02.[column in domain "DATBI"] == CSKS.DATBI` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == CSKS.MANDT`
Partner Functional Area Client Partner Functional Area	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == TFKB.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.PARTNERFUNCTIONALAREA == TFKB.FKBER`
Partner Profit Center Controlling Area Partner Profit Center ? Client	`P_REPFINDATA_RT_AGGRSNRL_02.CONTROLLINGAREA == CEPC.KOKRS` `P_REPFINDATA_RT_AGGRSNRL_02.PARTNERPROFITCENTER == CEPC.PRCTR` `P_REPFINDATA_RT_AGGRSNRL_02.[column in domain "DATBI"] == CEPC.DATBI` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == CEPC.MANDT`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`P_REPFINDATA_RT_AGGRSNRL_02.PARTNERSEGMENT == FAGL_SEGM.SEGMENT` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == FAGL_SEGM.MANDT`
Plant Client Plant	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == T001W.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.PLANT == T001W.WERKS`
Profit Center Controlling Area Profit Center ? Client	`P_REPFINDATA_RT_AGGRSNRL_02.CONTROLLINGAREA == CEPC.KOKRS` `P_REPFINDATA_RT_AGGRSNRL_02.PROFITCENTER == CEPC.PRCTR` `P_REPFINDATA_RT_AGGRSNRL_02.[column in domain "DATBI"] == CEPC.DATBI` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == CEPC.MANDT`
Chart of Accounts Client Chart of Accounts Chart of Accounts	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == T004.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.CHARTOFACCOUNTS == T004.KTOPL` `P_REPFINDATA_RT_AGGRSNRL_02.REFERENCECHARTOFACCOUNTS == T004.KTOPL`
Sales District Client Sales District	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == T171.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.SALESDISTRICT == T171.BZIRK`
Sales Organization Sales Organization Client	`P_REPFINDATA_RT_AGGRSNRL_02.SALESORGANIZATION == TVKO.VKORG` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == TVKO.MANDT`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == FAGL_SEGM.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.SEGMENT == FAGL_SEGM.SEGMENT`
Ship-to Party Client Ship-to Party	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == KNA1.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.SHIPTOPARTY == KNA1.KUNNR`
Product Sold Product Sold Client	`P_REPFINDATA_RT_AGGRSNRL_02.SOLDPRODUCT == MARA.MATNR` `P_REPFINDATA_RT_AGGRSNRL_02.MANDT == MARA.MANDT`
Product Sold Group Client Product Sold Group Product Sold Group	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == T023.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.MATERIALGROUP == T023.MATKL` `P_REPFINDATA_RT_AGGRSNRL_02.SOLDPRODUCTGROUP == T023.MATKL`
Supplier Client Supplier	`P_REPFINDATA_RT_AGGRSNRL_02.MANDT == LFA1.MANDT` `P_REPFINDATA_RT_AGGRSNRL_02.SUPPLIER == LFA1.LIFNR`