I_ProcOrdFailedGoodsMovement

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Process Orders Failed Goods Movement'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType:  #COMPOSITE
define view entity I_ProcOrdFailedGoodsMovement as 
select from I_GoodsMovementExceptionItem                as _Exception
inner join   I_LogisticsOrder                           as _ManufacturingOrder    on  _Exception.OrderID      = _ManufacturingOrder.OrderID
                                                                                  and _ManufacturingOrder.OrderCategory = '40'
association        to parent I_ProcessOrderMgmtWorkList as _ProcOrdMgmt           on  $projection.OrderID = _ProcOrdMgmt.ProcessOrder
association [0..1] to I_MaterialText                    as _MaterialText          on  $projection.Material   = _MaterialText.Material
                                                                                  and _MaterialText.Language = $session.system_language
association [0..1] to I_GoodsMovementTypeT              as _GoodsMovementTypeText on  $projection.GoodsMovementType   = _GoodsMovementTypeText.GoodsMovementType
                                                                                  and _GoodsMovementTypeText.Language = $session.system_language                                                                                 
{
  key _Exception.GoodsMovementException,
  key _Exception.GoodsMovementExceptionItem,
  key _Exception.OrderID,
  _ManufacturingOrder.OrderType,
  
  _Exception.CreationDate,
  _Exception.CreationTime,
  _Exception.CreatedByUser,
  _Exception.LastChangeDate,
  _Exception.LastChangedByUser,
  
  _Exception.Material,
  _MaterialText.MaterialName as MaterialName,
  
  _Exception.Plant,
  _ManufacturingOrder._Plant.PlantName,
  
  _Exception.StorageLocation,
  _Exception.Batch,
  
  _Exception.GoodsMovementType,
  _GoodsMovementTypeText.GoodsMovementTypeName,
  
  _Exception.GoodsMovementReasonCode,  
  _Exception.ErrorOccurrenceDate,
  _Exception.ErrorOccurrenceTime,
  _Exception.SystemMessageIdentification,
  _Exception.SystemMessageNumber,
  _Exception.SystemMessageType,
  _Exception.SystemMessageVariable1,
  _Exception.SystemMessageVariable2,
  _Exception.SystemMessageVariable3,
  _Exception.SystemMessageVariable4,
  
  cast('' as char255) as SystemMessageText,
  
//  _Exception.CreatedByUser,

//  _Exception.CreationDate,

//  _Exception.CreationTime,

//  _Exception.DocumentDate,

//  _Exception.ErrorOccurrenceDate,

//  _Exception.ErrorOccurrenceTime,

//  _Exception.LastChangeDate,

//  _Exception.LastChangedByUser,

//  _Exception.MRPController,

//  _Exception.OrderID,

//  _Exception.OrderCategory,

//  _Exception.PostingDate,

//  _Exception.ProductionSupervisor,

//  _Exception.SupplyArea,

//  _Exception.GoodsMovementReasonCode,

//  _Exception.Warehouse,

//  _Exception.StorageType,

//  _Exception.StorageBin,

//  _Exception.Supplier,

//  _Exception.UnloadingPointName,

//  _Exception.InventoryValuationType,

  
  _Exception.GoodsMovementEntryUnit,
  @Semantics.quantity.unitOfMeasure: 'GoodsMovementEntryUnit'
  @Aggregation.default: #SUM
  _Exception.GoodsMovementEntryQty,
  
  
  _ProcOrdMgmt
}
where _Exception.OrderCategory        =  '40'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GOODSMOVEMENTEXCEPTIONITEM",
"I_GOODSMOVEMENTTYPET",
"I_LOGISTICSORDER",
"I_MATERIALTEXT",
"I_PLANT"
],
"ASSOCIATED":
[
"I_PROCESSORDERMGMTWORKLIST"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/