P_RepFinData_RT_Aggr_07

@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PRFDRTAG_07'
@AbapCatalog.compiler.compareFilter: true

@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
//@AccessControl.authorizationCheck: #NOT_ALLOWED

@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

define view P_RepFinData_RT_Aggr_07
  with parameters
    P_CreationDateTimeRgFr :timestamp,
    P_CreationDateTimeRgTo :timestamp

  as select from           P_RepFinData_RT_Aggr_06
                 (P_CreationDateTimeRgFr : :P_CreationDateTimeRgFr,
                            P_CreationDateTimeRgTo : :P_CreationDateTimeRgTo) as Source

  //  TF103A: Breakdown info for transaction currency (RTCUR) depending on breakdown category (ITGRP)

    left outer to one join I_BreakdownCategoryField tf103a_rtcur on  Source.ConsolidationChartOfAccounts = tf103a_rtcur.ConsolidationChartOfAccounts
                                                                 and Source.BreakdownCategory            = tf103a_rtcur.BreakdownCategory
                                                                 and tf103a_rtcur.BreakdownCatFieldName  = 'RTCUR'

  //  TF160: Cons. unit master data

    inner join             I_CnsldtnUnit                         on  Source.ConsolidationDimension = I_CnsldtnUnit.ConsolidationDimension
                                                                 and Source.ConsolidationUnit      = I_CnsldtnUnit.ConsolidationUnit

{
  // Value in transaction currency (TSL): Evaluate breakdown type for RTCUR

  case //only 0 and 2 are possible for RTCUR

      when tf103a_rtcur.BreakdownType = '0'
        or tf103a_rtcur.BreakdownType is null
  //      no breakdown

          then
  //      TSL is never empty: Set local or group currency as default

              case I_CnsldtnUnit.DocumentEntryIsInGroupCurrency
                  when '' then Source.AmountInLocalCurrency
                  when 'X' // The cons. unit provides only values in group currency

                      then Source.AmountInGroupCurrency
              end
      when tf103a_rtcur.BreakdownType = '2'
  //      breakdown required, default allowed

         then Source.AmountInTransactionCurrency
  end as AmountInTransactionCurrency,

  // Transaction currency key (RTCUR): Evaluate breakdown type

  case  //only 0 and 2 are possible for RTCUR

      when tf103a_rtcur.BreakdownType = '0'
        or tf103a_rtcur.BreakdownType is null
  //      no breakdown

          then
  //    RTCUR is never empty: Set local or group currency as default

              case I_CnsldtnUnit.DocumentEntryIsInGroupCurrency
                  when '' then Source.ConsolidationUnitLocalCurrency
                  when 'X' // The cons. unit provides only values in group currency

                      then Source.GroupCurrency
              end
      when tf103a_rtcur.BreakdownType = '2'
  //      breakdown required, default allowed

          then Source.BalanceTransactionCurrency
  end as BalanceTransactionCurrency,

  // case

  Source.SubItemCategory,
  Source.SubItem,
  Source.PartnerConsolidationUnit,
  Source.BaseUnit,
  Source.QuantityInBaseUnit,
  Source.FinancialTransactionType,
  Source.FunctionalArea,
  Source.BusinessArea,
  Source.CostCenter,
  Source.GLAccount,
  Source.ProfitCenter,
  Source.Segment,
  Source.AmountInLocalCurrency,
  Source.AmountInGroupCurrency,

  // I_CnsldtnFinStmntItem

  /*Source.BreakdownCategory,*/

  // I_FSItemMappingAssgmtWithVers

  Source.FinancialStatementItem,
  Source.ConsolidationChartOfAccounts,

  // P_ConsolidationUnitCurrency

  Source.ConsolidationUnitLocalCurrency,

  // tfin010

  Source.ConsolidationDimension,
  Source.ConsolidationUnit,

  // I_CnsldtnVersion

  Source.ConsolidationVersion,

  // t881

  Source.ConsolidationLedger,
  Source.GroupCurrency,

  // I_FiscalCalendarDate / Or other source

  Source.FiscalPeriod,
  Source.FiscalYear,

  // mandatory standard fields

  /*Source.BalanceTransactionCurrency,*/
  /*Source.AmountInTransactionCurrency,*/

  // additional fields

  Source.PartnerCompany,
  Source.CompanyCode,
  Source.ChartOfAccounts,
  Source.AssignmentReference,
  Source.ControllingArea,
  Source.PartnerCostCenter,
  Source.PartnerProfitCenter,
  Source.PartnerFunctionalArea,
  Source.PartnerBusinessArea,
  Source.PartnerSegment,
  Source.OrderID,
  Source.Customer,
  Source.Supplier,
  Source.Material,
  Source.MaterialGroup,
  Source.Plant,
  Source.WBSElementExternalID,
  Source.Project,
  Source.BillingDocumentType,
  Source.SalesOrganization,
  Source.DistributionChannel,
  Source.OrganizationDivision,
  Source.SoldProduct,
  Source.SoldProductGroup,
  Source.CustomerGroup,
  Source.CustomerSupplierCountry,
  Source.CustomerSupplierIndustry,
  Source.SalesDistrict,
  Source.BillToParty,
  Source.ShipToParty,
  Source.CustomerSupplierCorporateGroup,
  Source.WBSElementInternalID,
  Source.CreationDateTime

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BREAKDOWNCATEGORYFIELD",
"I_CNSLDTNUNIT",
"P_REPFINDATA_RT_AGGR_06"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/