P_EquipMatlSerialNumberStatus

@AbapCatalog.sqlViewName: 'PEQMATLSRNUMSTAT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Status of Material Serial Number'

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE   // technically a BASIC but due to view layering a COMPOSITE)

@VDM.private: true
define view P_EquipMatlSerialNumberStatus
as select from I_Equipment  as Equipment 
inner join I_StatusObjectActiveStatus as jest on jest.StatusObject = Equipment.MaintObjectInternalID
{
  key Equipment.Material,
  key Equipment.SerialNumber,
  Equipment.MaintObjectInternalID,

      case jest.StatusCode
        when 'I0099' then 'X'
        else ''
      end as MatlSrlNmbrIsAvailable,
      case jest.StatusCode
        when 'I0013' then 'X'
        else ''
      end as MatlSrlNmbrIsDeleted,
      case jest.StatusCode
        when 'I0076' then 'X'
        else ''
      end as MatlSrlNmbrIsMrkdForDeltn,   
      case jest.StatusCode
        when 'I0320' then 'X'
        else ''
      end as MatlSrlNmbrIsInactive,   
      case jest.StatusCode
        when 'I0100' then 'X'
        else ''
      end as MatlSrlNmbrIsInstalled,   
       case jest.StatusCode
        when 'I0116' then 'X'
        else ''
      end as MatlSrlNmbrIsAllcToParent,  
       case jest.StatusCode
        when 'I0184' then 'X'
        else ''
      end as MatlSrlNmbrIsInWarehouse, 
       case jest.StatusCode
        when 'I0186' then 'X'
        else ''
      end as MatlSrlNmbrIsAssgdToDeliv,  
       case jest.StatusCode
        when 'I0188' then 'X'
        else ''
      end as MatlSrlNmbrIsAtCustomer,    
       case jest.StatusCode
        when 'I0488' then 'X'
        else ''
      end as MatlSrlNmbrIsUndrCnstrctn,    
       case jest.StatusCode
        when 'I0039' then 'X'
        else ''
      end as MatlSrlNmbrIsAssgdToJITCall,    
       case jest.StatusCode
        when 'I8027' then 'X'
        else ''
      end as MatlSrlNmbrDocIsCreated,    
       case jest.StatusCode
        when 'I0190' then 'X'
        else ''
      end as MatlSrlNmbrIsLocked,    
       case jest.StatusCode
        when 'I0193' then 'X'
        else ''
      end as MatlSrlNmbrHndlgUntIsAssgd,   
       case jest.StatusCode
        when 'I0194' then 'X'
        else ''
      end as MatlSrlNmbrInvtryIsActv,    
       case jest.StatusCode
        when 'I0180' then 'X'
        else ''
      end as MatlSrlNmbrIsOnHold,      
       case jest.StatusCode
        when 'IUII0' then 'X'
        else ''
      end as MatlSrlNmbrIsIDUndefined,    
       case jest.StatusCode
        when 'IUII1' then 'X'
        else ''
      end as MatlSrlNmbrUUIDIsGnrtd,     
       case jest.StatusCode
        when 'IUII2' then 'X'
        else ''
      end as MatlSrlNmbrUUIDIsAttached,    
       case jest.StatusCode
        when 'IUII3' then 'X'
        else ''
      end as MatlSrlNmbrUUIDIsSent,   
       case jest.StatusCode
        when 'IUII4' then 'X'
        else ''
      end as MatlSrlNmbrUUIDIsConfd,
      Equipment._Material                                                     
}
where
  (
       jest.StatusCode   =    'I0013'
    or jest.StatusCode   =    'I0076'
    or jest.StatusCode   =    'I0099'
    or jest.StatusCode   =    'I0320'
    or jest.StatusCode   =    'I0100' 
    or jest.StatusCode   =    'I0116'
    or jest.StatusCode   =    'I0184'
    or jest.StatusCode   =    'I0186'
    or jest.StatusCode   =    'I0188'    
    or jest.StatusCode   =    'I0488'    
    or jest.StatusCode   =    'I0039'    
    or jest.StatusCode   =    'I8027'  
    or jest.StatusCode   =    'I0190'   
    or jest.StatusCode   =    'I0193'      
    or jest.StatusCode   =    'I0194'   
    or jest.StatusCode   =    'I0180'     
    or jest.StatusCode   =    'IUII0'  
    or jest.StatusCode   =    'IUII1'   
    or jest.StatusCode   =    'IUII2'      
    or jest.StatusCode   =    'IUII3'   
    or jest.StatusCode   =    'IUII4'     
  )
  and  jest.StatusObject like 'IE%'
  and Equipment.SerialNumber is not null and
      Equipment.SerialNumber != ' '  and
      Equipment.Material is not null and 
      Equipment.Material != ' '
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EQUIPMENT",
"I_STATUSOBJECTACTIVESTATUS"
],
"ASSOCIATED":
[
"I_MATERIAL"
],
"BASE":
[
"I_EQUIPMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/