P_ChmlSuplrMatlDataStsSortSqnc

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

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

  --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: #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_ChmlSuplrMatlDataStsSortSqnc
  --Select data from basic view supplier status
  as select from I_ChmlSuplrMatlDataSts as DataStatus
{
      --Supplier status
  key DataStatus.ChmlSuplrMatlDataStatus,

      --Criticality of supplier status
      case DataStatus.ChmlSuplrMatlDataStatus
          when 'CO' then 4
          when 'NO' then 3
          when 'RQ' then 2
          else 1
        end as SortSequence
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLSUPLRMATLDATASTS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/