P_ChmlSuplrMatlSuplrStsCritlty

--Label of view
-- e.g. display as filter name in the consumption
@EndUserText.label: 'Criticality of Supplier Status'

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

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

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

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

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

define view P_ChmlSuplrMatlSuplrStsCritlty
  --Select data from basic view supplier status
  as select from I_ChmlSuplrMatlSuplrSts as SupplierStatus
{
      --Supplier status
  key SupplierStatus.ChmlSuplrMatlSuplrSts,

      --Criticality of supplier status
      case SupplierStatus.ChmlSuplrMatlSuplrSts
          when 'AP' then 3
          when 'BL' then 1
          when 'OD' then 1
          else 2
        end as ChmlSuplrMatlSuplrStsCritlty,

      _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLSUPLRMATLSUPLRSTS"
],
"ASSOCIATED":
[
"I_CHMLSUPLRMATLSUPLRSTST"
],
"BASE":
[
"I_CHMLSUPLRMATLSUPLRSTS"
],
"VERSION":0
}
}*/