P_SVTConstants

@AbapCatalog:
{
  sqlViewName: 'PSVTCONST',
  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: #BASIC
@VDM.private: true
@ObjectModel.usageType:{ serviceQuality: #A,        // < 1 msec

                         sizeCategory:   #S,         // < 1.000

                         dataClass:      #META }

// Dummy constant selection to solve issues with case-statements with constants (not null-preserving)

define view P_SVTConstants
  as select from ehfndv_dummy
{

  key dummy              as Dummy,
      constant0          as Constant0,
      constant1          as Constant1,
      constant2          as Constant2,
      constant3          as Constant3,
      constant4          as Constant4,
      constant01         as Constant01,
      constant02         as Constant02,
      constant03         as Constant03,
      constant04         as Constant04,
      constantccmps      as ConstantCCMPS,
      constantcci        as ConstantCCI,
      constantcrr        as ConstantCRR,
      constantmaterial   as ConstantMaterial,
      constantesl        as ConstantESL,
      constantemptyraw16 as ConstantEmptyRaw16
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHFNDV_DUMMY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/