I_ChmlSuplrMatlDataStsCritlty

--Label of view
@EndUserText.label: 'Criticality of Data Status'

@AbapCatalog:
{
  -- SQL view name (16 characters)
  sqlViewName: 'ICSMDSTSCRIT',

  --If it's true, the filter conditions are compared and, if they match, the associated join expression is evaluated only once
  compiler.compareFilter: true,
  preserveKey: true
}

--Access Control: Authorizations Checks
@AccessControl:
{
  authorizationCheck: #CHECK,
  // personal data blocking not required as view does not expose personal data fields of supplier material

  personalData.blocking: #NOT_REQUIRED
}

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

--VDM view type
@VDM.viewType: #COMPOSITE

@ObjectModel:
{
  --Performance Annotations
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #C
  },
  representativeKey: 'ChmlSuplrMatlUUID'
}

define view I_ChmlSuplrMatlDataStsCritlty
  --Select data from basic view supplier material
  as select from I_ChmlSuplrMatl as SupplierMaterial
  --join to criticality of data status 
  left outer join I_ChmlSuplrMatlDataSts as Criticality on SupplierMaterial.ChmlSuplrMatlDataStatus = Criticality.ChmlSuplrMatlDataStatus 
{
      --Supplier Material
  key SupplierMaterial.ChmlSuplrMatlUUID,

      --Data status
      Criticality.ChmlSuplrMatlDataStatus,
      
      --Criticality of data status
      Criticality.ChmlSuplrMatlDataStsCritlty,
      
      SupplierMaterial.ResponsibleUnit
}