P_CChmlCmplConstants

@AbapCatalog:
{
  sqlViewName: 'PCCCCONST',
  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
@VDM.private: true

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

define view P_CChmlCmplConstants
  as select from ehfndv_dummy
{
  key dummy                        as Dummy,
      constant0                    as Constant0,
      constant1                    as Constant1,
      constant2                    as Constant2,
      constant3                    as Constant3,
      constant4                    as Constant4,
      constantemptyraw16           as ConstantEmptyRaw16,
      constanthyphen               as ConstantHyphen,
      constantraw                  as ConstantRaw,
      constantempty                as ConstantEmpty,
      constanttrue                 as ConstantTrue,
      constantfalse                as ConstantFalse,
      constantnotexisting          as ConstantNotExisting,
      constantmixture              as ConstantMixture,
      constantinprogress           as ConstantInProgress,
      constantinitialversion       as ConstantInitialVersion,
      constantreleased             as ConstantReleased,
      constantcalculated           as ConstantCalculated,
      constantoutdated             as ConstantOutdated,
      constantmissing              as ConstantMissing,
      constantcompstatforrelease   as ConstantCompStatForrelease,
      constantcompstatnew          as ConstantCompStatNew,
      constant01                   as Constant01,
      constant02                   as Constant02,
      constant03                   as Constant03,
      constant04                   as Constant04,
      constantnew                  as ConstantNew,
      constantactive               as ConstantActive,
      constantupdated              as ConstantUpdated,
      constantnone                 as ConstantNone,
      constantcomplete             as ConstantComplete,
      constantinprocess            as ConstantInProcess,
      constantcci                  as ConstantCCI,
      constantsub                  as ConstantSUB,
      constantcsm                  as ConstantCSM,
      constantccmps                as ConstantCCMPS,
      constantcrr                  as ConstantCRR,
      constantcr                   as ConstantCR,
      constantcrv                  as ConstantCRV,
      constantprp                  as ConstantPRP,
      constantpcsrq                as ConstantPCSRQ,
      constantevtstsnew            as ConstantEvtStsNew,
      constantevtstsinprogress     as ConstantEvtStsInProgress,
      constantevtstsfatal          as ConstantEvtStsFatal,
      constantevtstserror          as ConstantEvtStsError,
      constantevtstscompleted      as ConstantEvtStsCompleted,
      constantchgstsnewcomp        as ConstantChgStsNewComp,
      constantchgstsremovdcomp     as ConstantChgStsRemovdComp,
      constantchgstsnewsub         as ConstantChgStsNewSub,
      constantchgstsremovdsub      as ConstantChgStsRemovdSub,
      constantchgstsdiffconc       as ConstantChgStsDiffConc,
      constantchgstsdiffrole       as ConstantChgStsDiffRole,
      constantlgldvncatreplaced    as ConstantLglDvnCatReplaced,
      constantlgldvncatunchanged   as ConstantLglDvnCatUnchanged,
      constantrawmaterialsemobj    as ConstantRawMaterialSemObj,
      constantunpackagedprodsemobj as ConstantUnpackagedProdSemObj,
      
      case 
        when constant0 = constant1
            then constant0
      end as ConstantNull

}