I_NominationVersionItem

@AbapCatalog.sqlViewName: 'INOMVERSITEM'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'CDS for nomination version to item'
@VDM.viewType: #BASIC
@ObjectModel:{
  usageType.serviceQuality: #D,
  usageType.sizeCategory: #L
  }
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.type: #INHERITED 
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_NominationVersionItem 
as 
select from oijnomivers as i
inner join I_CalendarDate as calDate on calDate.CalendarDate = i.idate
left outer join oijnomi as e on i.nomtk = e.nomtk and i.nomit = e.nomit
{
i.nomtk as NominationDoc, 
i.nomit as NominationDocItem,
i.locid as LocationId,
i.s_matnr_i as ScheduledMaterial,
@DefaultAggregation : #SUM
i.menge as NominationPlannedQuantity, 
i.unit_i as NominationPlannedUnit,
i.idate as NominationScheduleDate,
calDate.YearWeek as NominationCalendarWeek,
calDate.YearMonth as NominationCalendarMonth,
calDate.CalendarYear as NominationCalendarYear,
i.sched_tst_from as ScheduledBatchStartDateTime,
i.sched_tst_to as ScheduledBatchEndDateTime,
i.sityp as NominationScheduleType,
i.docind as IsReferenceDocument,
i.conpat as ContractPartner, 
i.unit_i as ScheduledQuantityUnit,
i.vers_id as NominationVersion
}
group by calDate.YearWeek, i.nomtk, i.nomit,i.locid, i.s_matnr_i,i.sched_tst_from, 
i.sched_tst_to, i.unit_i,i.sityp,i.conpat,i.docind, i.idate, i.menge, i.vers_id,
calDate.YearMonth,calDate.CalendarYear
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE",
"OIJNOMI",
"OIJNOMIVERS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/