P_OrderIsShopFloorStatusBasic

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE   
@VDM.private: true

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK", "KEY_CHECK" ]  } */
define view entity P_OrderIsShopFloorStatusBasic
  as select from I_StatusObjectStatusBasic as jest

{
    // Key

    @ObjectModel.foreignKey.association: '_StatusObject'
key jest.StatusObject as ObjectInternalID,

    case jest.StatusCode
      when 'I0665' then 'X'
    end as OrderIsShopFloorOrder,

    case jest.StatusCode
      when 'I0076' then 'X'
    end as OrderIsMarkedForDeletion,

    // Associations

    jest._StatusObject
}
where
  ( jest.StatusCode       = 'I0665' or
    jest.StatusCode       = 'I0076' ) 
    and
    jest.StatusIsInactive = '' and jest.StatusObject like 'OR%'
  ;