I_ProdnRtgVersWrkflwInboxTP

@AbapCatalog.sqlViewName: 'IPRODRTGVWFINBOX'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Production Routing Workflow MyInbox'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType: {
    serviceQuality: #B,
    sizeCategory:   #M,
    dataClass:      #MASTER
}

@AbapCatalog: {preserveKey: true }

@ObjectModel: {
    transactionalProcessingEnabled: true,   -- on root node only
    compositionRoot:                true,   -- on root node only
    writeActivePersistence: 'IPRODRTGVWFINBOX',
    semanticKey: ['BillOfOperationsKey'],
    representativeKey: 'BillOfOperationsKey'
}

define view I_ProdnRtgVersWrkflwInboxTP as select from I_ProductionRoutingVersion
  association [0..*] to I_BOOVersionStatusText as _BOOVersionStatusText on $projection.BillOfOperationsVersionStatus = _BOOVersionStatusText.BillOfOperationsVersionStatus
//  association [0..*] to I_BOOVersionBOMAssignment as _BOOVersionBOMAssignment on $projection.BillOfOperationsGroup = _BOOVersionBOMAssignment.BillOfOperationsGroup

//                                                                              and $projection.BillOfOperationsVersion = _BOOVersionBOMAssignment.billofoperationsversion

//                                                                              and $projection.BillOfOperationsType = _BOOVersionBOMAssignment.billofoperationstype

//                                                                              and $projection.BillOfOperationsVariant = _BOOVersionBOMAssignment.billofoperationsvariant

 // association [0..*] to P_MfgProcgExecOrdMainStatus as _MfgProcgExecOrdMainStatus on $projection.orderid = _MfgProcgExecOrdMainStatus.ManufacturingOrder

 
                                                                              
  -- C_ProdnVersObjPgTP need to add the production version to get the details of prod version lock detail
{
      @UI.hidden: true
  key cast(concat(concat(BillOfOperationsType, BillOfOperationsGroup), concat(BillOfOperationsVariant, BillOfOperationsVersion)) as abap.sstring(100) ) as   BillOfOperationsKey,

      @UI.identification: [{position: 10, label: 'Routing' }]
      @Consumption: { semanticObject: 'ShopFloorRouting'}
      concat(concat(BillOfOperationsGroup, ('-')), concat(BillOfOperationsVariant, concat(('-'), BillOfOperationsVersion))) as   BillOfOperations,


      BillOfOperationsGroup,
      BillOfOperationsVersion,
      BillOfOperationsVariant,
      BillOfOperationsType,
      BillOfOperationsSubtype,
      BillOfOperationsStatus,
      BillOfOperationsUsage,

      @UI.identification: [{position: 20}]
      BillOfOperationsDesc,

      @UI.identification: [{position: 30}]
      @ObjectModel.readOnly: true
      @ObjectModel.text.association: '_BOOVersionStatusText'
      BillOfOperationsVersionStatus,

      @UI.identification: [{position: 40}]
      Plant,

      //      @UI.identification: [{position: 57}]

      //      case

      //      when BillOfOperationsVersionStatus = '10'

      //      then 2

      //      when BillOfOperationsVersionStatus = '20'

      //      then 3

      //      else 1

      //      end    as  BOOVersionStatusCriticality,

      
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      MinimumLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      MaximumLotSizeQuantity,
      BillOfOperationsUnit,
      
      RoutingIsReworkRouting,
      ProdnProcgIsFlexible,

      @UI.identification: [{position: 50}]
      CreationDateTime,
      @UI.identification: [{position: 60}]
      CreatedByUser,
      @UI.identification: [{position: 70}]
      LastChangeDateTime,
      @UI.identification: [{position: 80}]
      LastChangedByUser,
      
//      // *** Material Details *****************

//      

//      _BOOVersionBOMAssignment.Material,

//      _BOOVersionBOMAssignment._Material._Text.MaterialName,

//      

//      // ******* Production order Details ***********

//      

//      OrderID,

//      _MfgProcgExecOrdMainStatus.OrderMainStatus,

//

//      // ***** For Production Version Fields ********

//      

//      -- cast('                                        ' as matnr preserving type )                                            as   Material,

//      cast('    ' as verid preserving type )                                                                                as   ProductionVersion,

//      cast('                                        ' as vers_text preserving type )                                        as   ProductionVersionText,

//      cast( '00000000' as vdm_v_validity_start_date )                                                                       as   ValidityStartDate,

//      cast( '00000000' as vdm_v_validity_end_date )                                                                         as   ValidityEndDate,

//      cast( 0 as sa_losvn )                                                                                                 as   MaterialMinLotSizeQuantity,

//      cast( 0 as sa_losbs )                                                                                                 as   MaterialMaxLotSizeQuantity,

//


      _BOOVersionStatusText
//      _BOOVersionBOMAssignment

      // ,

     // _MfgProcgExecOrdMainStatus

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