I_CostRevenueReassignment

@AbapCatalog.sqlViewName: 'ICOSREVREASSGMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Cost Revenue Reassignment - basic view'


@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE

@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
define view I_CostRevenueReassignment 
  as select distinct from P_CostRevenueReassignment as _Header 
  
   association [0..1] to I_CompanyCode as _CompanyCodeText
    on  $projection.CompanyCode = _CompanyCodeText.CompanyCode 
    
   association [0..1] to I_CompanyCode as _SenderCompanyCodeText        
    on  $projection.SenderCompanyCode = _SenderCompanyCodeText.CompanyCode 
{
  key FiscalYear,      
      
  key ReferenceDocument,
  
  key ControllingArea,
  
//  key LedgerGLLineItem,

      
      max( CompanyCode ) as CompanyCode,
      max( SenderCompanyCode ) as SenderCompanyCode,
      max( AccountingDocument ) as AccountingDocument,
                   
      AccountingDocumentHeaderText,
      
      DocumentDate,

      PostingDate,

      FiscalPeriod,
      
      AccountingDocumentCreationDate,
      
      AccountingDocCreatedByUser,
            
      IsReversal,
      IsReversed,      

      ReferenceDocumentType,   
      ReferenceDocumentContext,
      
      cast('' as costrevenuereassignmentaction)    as CostRevenueReassignmentAction,
      cast('' as gjahr) as PostingFiscalYear,       
      
      ExchangeRateDate,
      
      PredecessorReferenceDocument,
      ReversalReferenceDocument,
      
      //Sender and Receiver dummy fields

     
      cast('' as fco_allocation_account) as GLAccount,      
      cast('' as lstar) as CostCtrActivityType,     
      cast('' as sendercostcenter) as OriginCostCenter,
      cast('' as fis_skost) as PartnerCostCenter,
      cast('' as fis_par_lstar) as PartnerCostCtrActivityType,
      cast('' as fis_partner_wbs) as PartnerWBSElement,
      cast('' as fis_wbs) as WBSElement,     
      cast('' as fco_psrvdoc_type) as PartnerServiceDocumentType,
      cast('' as fco_psrvdoc_id) as PartnerServiceDocument,
      cast('' as fco_psrvdoc_item_id) as PartnerServiceDocumentItem,
      cast('' as fco_srvdoc_type) as ServiceDocumentType,      
      cast('' as fco_srvdoc_id) as ServiceDocument,      
      cast('' as fco_srvdoc_item_id) as ServiceDocumentItem,      
      cast('' as par_npln) as PartnerProjectNetwork,
      cast('' as par_vornr_auf) as PartnerProjectNetworkActivity,
      cast('' as nplnr) as ProjectNetwork,      
      cast('' as npvrg) as RelatedNetworkActivity,      
      cast('' as fis_par_aufnr) as PartnerOrder,
      cast('' as fis_aufnr) as OrderID,      
      cast('' as vdm_vornr) as OrderOperation,  
      cast('' as vdm_vornr) as PartnerOrderOperation,   
      cast('' as par_kstrg) as PartnerCostObject,
      cast('' as kstrg) as CostObject, 
      cast('' as fis_par_kdauf) as PartnerSalesDocument,
      cast('' as fis_par_kdpos) as PartnerSalesDocumentItem,
      cast('' as vbeln_va) as SalesDocument,      
      cast('' as posnr_va) as SalesDocumentItem,  
      cast('' as pernr_d) as PersonnelNumber,
      cast('' as par_prznr) as PartnerBusinessProcess,
      cast('' as sprznr) as BusinessProcess,
      cast('' as jv_recind_cds) as JointVentureCostRecoveryCode,
      cast('' as jv_srecind_cds) as SenderCostRecoveryCode,   
      cast('' as fm_sfonds) as Fund,
      cast('' as fm_sfarea) as FunctionalArea,
      cast('' as gm_grant_sender) as GrantID,
      cast('' as fm_budget_period) as BudgetPeriod,
      cast('' as fm_efonds) as PartnerFund,
      cast('' as fm_efarea) as PartnerFunctionalArea,
      cast('' as gm_grant_receiver) as PartnerGrant,
      cast('' as fm_pbudget_period) as PartnerBudgetPeriod,
      cast('' as ebemot) as RcvrAcctgIndCode,
      cast('' as bemot) as BillableControl,
            
      @Semantics.currencyCode:true
      GlobalCurrency,
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      cast(sum(AmountInGlobalCurrency) as fis_hsl) as TotalAmountInGlobalCurrency,
      
      ControllingBusTransacType,
      
      count( distinct IsSettled ) as NumberOfDocumentItems,
      cast( max( IsSettled ) as fins_xsettled) as IsSettled,
      
      ReversedReferenceDocument,
      AllocationPostingType,
       
      _ReferenceDocumentType,
      _CompanyCodeText,
      _SenderCompanyCodeText

}

group by
FiscalYear,    
ReferenceDocument,
ControllingArea,    
//CompanyCode,      

//CompanyCodeName,                  

//AccountingDocument,             

AccountingDocumentHeaderText,
DocumentDate,
PostingDate,
FiscalPeriod,
AccountingDocumentCreationDate,
AccountingDocCreatedByUser,      
IsReversal,
IsReversed,      
ReferenceDocumentType,
ReferenceDocumentContext,
ExchangeRateDate,
PredecessorReferenceDocument,
ReversalReferenceDocument,
GlobalCurrency,
ControllingBusTransacType,
ReversedReferenceDocument,
AllocationPostingType