P_RepFinData_RT_AggrNRL_01

Aggregated select from ACDOCA | view: PRFDRTAGNRL_01 | Extraction: Not supported | Component: S/4HANA Financial Consolidation, Core Processing
Tables used: ACDOCA, FINSC_LEDGER_REP
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
PostingDate Posting Date
Column Name Description
Column Name Description Domain name
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
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
Master Data Relations Join Conditions
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == TCURC.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.BASEUNIT == T006.MSEHI
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == T006.MANDT
Billing Type
  • Billing Type
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.BILLINGDOCUMENTTYPE == TVFK.FKART
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.BILLTOPARTY == KNA1.KUNNR
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == KNA1.MANDT
Business Area
  • Business Area
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.BUSINESSAREA == TGSB.GSBER
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.CHARTOFACCOUNTS == T004.KTOPL
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.COMPANYCODE == T001.BUKRS
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.CONTROLLINGAREA == TKA01.KOKRS
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • Controlling Area
  • ?
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.COSTCENTER == CSKS.KOSTL
  • P_REPFINDATA_RT_AGGRNRL_01.CONTROLLINGAREA == CSKS.KOKRS
  • P_REPFINDATA_RT_AGGRNRL_01.[column in domain "DATBI"] == CSKS.DATBI
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == CSKS.MANDT
Customer Number
  • Customer Number
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.CUSTOMER == KNA1.KUNNR
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.CUSTOMERGROUP == T151.KDGRP
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == T151.MANDT
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == T005.MANDT
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == T016.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == TVTW.MANDT
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == T856.MANDT
  • P_REPFINDATA_RT_AGGRNRL_01.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Client
  • Functional Area
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == TFKB.MANDT
  • P_REPFINDATA_RT_AGGRNRL_01.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Company Code
  • G/L Account
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.COMPANYCODE == SKB1.BUKRS
  • P_REPFINDATA_RT_AGGRNRL_01.GLACCOUNT == SKB1.SAKNR
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Material Number
  • Material Number
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.MATERIAL == MARA.MATNR
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.SOLDPRODUCTGROUP == T023.MATKL
  • P_REPFINDATA_RT_AGGRNRL_01.MATERIALGROUP == T023.MATKL
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == T023.MANDT
Order ID
  • Order ID
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.ORDERID == AUFK.AUFNR
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.ORGANIZATIONDIVISION == TSPA.SPART
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == TSPA.MANDT
Partner Business Area
  • Partner Business Area
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.PARTNERBUSINESSAREA == TGSB.GSBER
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == TGSB.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.PARTNERCOMPANY == T880.RCOMP
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == T880.MANDT
Partner Cost Center
  • Controlling Area
  • ?
  • Client
  • Partner Cost Center
  • P_REPFINDATA_RT_AGGRNRL_01.CONTROLLINGAREA == CSKS.KOKRS
  • P_REPFINDATA_RT_AGGRNRL_01.[column in domain "DATBI"] == CSKS.DATBI
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == CSKS.MANDT
  • P_REPFINDATA_RT_AGGRNRL_01.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Partner Functional Area
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == TFKB.MANDT
Partner Profit Center
  • Controlling Area
  • ?
  • Partner Profit Center
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.CONTROLLINGAREA == CEPC.KOKRS
  • P_REPFINDATA_RT_AGGRNRL_01.[column in domain "DATBI"] == CEPC.DATBI
  • P_REPFINDATA_RT_AGGRNRL_01.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == FAGL_SEGM.MANDT
Plant
  • Plant
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.PLANT == T001W.WERKS
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == T001W.MANDT
Profit Center
  • Profit Center
  • Controlling Area
  • ?
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.PROFITCENTER == CEPC.PRCTR
  • P_REPFINDATA_RT_AGGRNRL_01.CONTROLLINGAREA == CEPC.KOKRS
  • P_REPFINDATA_RT_AGGRNRL_01.[column in domain "DATBI"] == CEPC.DATBI
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == CEPC.MANDT
Sales District
  • Sales District
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.SALESDISTRICT == T171.BZIRK
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.SALESORGANIZATION == TVKO.VKORG
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.SEGMENT == FAGL_SEGM.SEGMENT
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == FAGL_SEGM.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.SHIPTOPARTY == KNA1.KUNNR
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.SOLDPRODUCT == MARA.MATNR
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.SOLDPRODUCTGROUP == T023.MATKL
  • P_REPFINDATA_RT_AGGRNRL_01.MATERIALGROUP == T023.MATKL
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == T023.MANDT
Supplier
  • Supplier
  • Client
  • P_REPFINDATA_RT_AGGRNRL_01.SUPPLIER == LFA1.LIFNR
  • P_REPFINDATA_RT_AGGRNRL_01.MANDT == LFA1.MANDT