P_ChmlCmplIsRawMat

@AbapCatalog:
{
  sqlViewName: 'PCCINFORAW',
  compiler.compareFilter: true,
  preserveKey: true
}

--Access Control: Authorizations Checks
@AccessControl:
{
  authorizationCheck: #NOT_REQUIRED
}

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

--VDM view type
@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view P_ChmlCmplIsRawMat
  as select from I_ChmlCmplncInfo
{

  key ChmlCmplncInfoUUID,
  
  cast( 
            case 
              when MaterialIsSourced = 'X' 
                and MaterialIsTransported = ''
                and MaterialIsSold = ''
                and MaterialIsProduced = ''
                
                then 'X'
             
              when MaterialIsSourced = '' 
                or MaterialIsTransported = 'X'
                or MaterialIsSold = 'X'
                or MaterialIsProduced = 'X'
                
                then ''
                   
            end as boole_d ) as ChmlCmplncInfoIsRawMatl
}