P_CHMLCMPLCONSTANTS

CDS View

P_CHMLCMPLCONSTANTS is a CDS View in S/4HANA. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_CmplRqRsltProcessorVH view from CONSUMPTION Value Help for Processor of Compliance Requirement Results
C_CmplRqRsltProcessorVH view union_all CONSUMPTION Value Help for Processor of Compliance Requirement Results
I_ProdCmplncCntntUser view union_all COMPOSITE User Names for Admin Data 
@AbapCatalog:
{
  sqlViewName: 'PCCCONST',
  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: #COMPOSITE
@VDM.private: true

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

define view P_ChmlCmplConstants
  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,
      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,
      constantlgldvncatdeleted     as ConstantLglDvnCatDeleted,
      constantrawmaterialsemobj    as ConstantRawMaterialSemObj,
      constantunpackagedprodsemobj as ConstantUnpackagedProdSemObj,
      constantsapse                as ConstantSapSe,
      constantcustomer             as ConstantCustomer,
      constantsap                  as ConstantSap,
      constantesl                  as ConstantESL
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHFNDV_DUMMY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More