P_MaterialLedgerDocAggregation

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType:{
    serviceQuality: #B,
    sizeCategory: #XXL,
    dataClass: #MIXED
}
@VDM: {
  viewType: #COMPOSITE,
  private:true
}
@EndUserText.label: 'Aggregated data for the ML document'
define view entity P_MaterialLedgerDocAggregation
  as select from I_PriceChangeDocumentItem as Item
    inner join   I_CompanyCode           as CompanyCode on Item.CompanyCode = CompanyCode.CompanyCode
{
  key Item.MaterialLedgerDocument,
  key Item.MaterialLedgerDocumentYear,
      max(Item.CompanyCode)            as CompanyCode,
      max(CompanyCode.CompanyCodeName) as CompanyCodeName,
      min(Item.PostingDate)            as PostingDate,
      min(Item.FiscalYear)             as FiscalYear,
      min(Item.FiscalPeriod)           as FiscalPeriod
}
where
      Item.FiscalYear   <> '0000'
  and Item.FiscalPeriod <> '000'
group by
  Item.MaterialLedgerDocument,
  Item.MaterialLedgerDocumentYear