P_ChmlCmplConstants

DDL: P_CHMLCMPLCONSTANTS Type: view COMPOSITE

P_ChmlCmplConstants is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (ehfndv_dummy) and exposes 60 fields with key field Dummy.

Data Sources (1)

SourceAliasJoin Type
ehfndv_dummy ehfndv_dummy from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCCCONST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY Dummy dummy Single-Character Flag
Constant0 constant0 INT1
Constant1 constant1 INT1
Constant2 constant2 INT1
Constant3 constant3 INT1
Constant4 constant4 INT1
ConstantEmptyRaw16 constantemptyraw16 UUID
ConstantHyphen constanthyphen Single-Character Flag
ConstantRaw constantraw 3-Byte field
ConstantEmpty constantempty Single-Character Flag
ConstantTrue constanttrue Single-Character Flag
ConstantFalse constantfalse Single-Character Flag
ConstantNotExisting constantnotexisting Component of the Version Number
ConstantMixture constantmixture Single-Character Flag
ConstantInProgress constantinprogress Component of the Version Number
ConstantReleased constantreleased Component of the Version Number
ConstantCalculated constantcalculated Component of the Version Number
ConstantOutdated constantoutdated Component of the Version Number
ConstantMissing constantmissing Component of the Version Number
ConstantCompStatForrelease constantcompstatforrelease Character Field with Length 10
ConstantCompStatNew constantcompstatnew Character Field with Length 10
Constant01 constant01 Component of the Version Number
Constant02 constant02 Component of the Version Number
Constant03 constant03 Component of the Version Number
Constant04 constant04 Component of the Version Number
ConstantNew constantnew Single-Character Flag
ConstantActive constantactive Single-Character Flag
ConstantUpdated constantupdated Single-Character Flag
ConstantNone constantnone Undefined range (can be used for patch levels)
ConstantComplete constantcomplete Character Field with Length 10
ConstantInProcess constantinprocess Character Field with Length 10
ConstantCCI constantcci Character Field with Length 10
ConstantSUB constantsub Character Field with Length 10
ConstantCSM constantcsm Character Field with Length 10
ConstantCCMPS constantccmps Character Field with Length 10
ConstantCRR constantcrr Character Field with Length 10
ConstantCR constantcr Character Field with Length 10
ConstantCRV constantcrv Character Field with Length 10
ConstantPRP constantprp Character Field with Length 10
ConstantPCSRQ constantpcsrq Character Field with Length 10
ConstantEvtStsNew constantevtstsnew Component of the Version Number
ConstantEvtStsInProgress constantevtstsinprogress Component of the Version Number
ConstantEvtStsFatal constantevtstsfatal Component of the Version Number
ConstantEvtStsError constantevtstserror Component of the Version Number
ConstantEvtStsCompleted constantevtstscompleted Component of the Version Number
ConstantChgStsNewComp constantchgstsnewcomp Character Field with Length 10
ConstantChgStsRemovdComp constantchgstsremovdcomp Character Field with Length 10
ConstantChgStsNewSub constantchgstsnewsub Character Field with Length 10
ConstantChgStsRemovdSub constantchgstsremovdsub Character Field with Length 10
ConstantChgStsDiffConc constantchgstsdiffconc Character Field with Length 10
ConstantChgStsDiffRole constantchgstsdiffrole Character Field with Length 10
ConstantLglDvnCatReplaced constantlgldvncatreplaced Character Field with Length 10
ConstantLglDvnCatUnchanged constantlgldvncatunchanged Character Field with Length 10
ConstantLglDvnCatDeleted constantlgldvncatdeleted Character Field with Length 10
ConstantRawMaterialSemObj constantrawmaterialsemobj Text
ConstantUnpackagedProdSemObj constantunpackagedprodsemobj Text
ConstantSapSe constantsapse Text
ConstantCustomer constantcustomer Text
ConstantSap constantsap Text
ConstantESL constantesl Field name

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_ChmlCmplConstants.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_ChmlCmplConstants AS
SELECT
  Dummy,
  Constant0,
  Constant1,
  Constant2,
  Constant3,
  Constant4,
  ConstantEmptyRaw16,
  ConstantHyphen,
  ConstantRaw,
  ConstantEmpty,
  ConstantTrue,
  ConstantFalse,
  ConstantNotExisting,
  ConstantMixture,
  ConstantInProgress,
  ConstantReleased,
  ConstantCalculated,
  ConstantOutdated,
  ConstantMissing,
  ConstantCompStatForrelease,
  ConstantCompStatNew,
  Constant01,
  Constant02,
  Constant03,
  Constant04,
  ConstantNew,
  ConstantActive,
  ConstantUpdated,
  ConstantNone,
  ConstantComplete,
  ConstantInProcess,
  ConstantCCI,
  ConstantSUB,
  ConstantCSM,
  ConstantCCMPS,
  ConstantCRR,
  ConstantCR,
  ConstantCRV,
  ConstantPRP,
  ConstantPCSRQ,
  ConstantEvtStsNew,
  ConstantEvtStsInProgress,
  ConstantEvtStsFatal,
  ConstantEvtStsError,
  ConstantEvtStsCompleted,
  ConstantChgStsNewComp,
  ConstantChgStsRemovdComp,
  ConstantChgStsNewSub,
  ConstantChgStsRemovdSub,
  ConstantChgStsDiffConc,
  ConstantChgStsDiffRole,
  ConstantLglDvnCatReplaced,
  ConstantLglDvnCatUnchanged,
  ConstantLglDvnCatDeleted,
  ConstantRawMaterialSemObj,
  ConstantUnpackagedProdSemObj,
  ConstantSapSe,
  ConstantCustomer,
  ConstantSap,
  ConstantESL
FROM ehfndv_dummy
;