P_CmplRqVersConstants

DDL: P_CMPLRQVERSCONSTANTS Type: view CONSUMPTION

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

Data Sources (1)

SourceAliasJoin Type
ehfndv_dummy ehfndv_dummy from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCRVCONST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY Dummy dummy Single-Character Flag
Constant0 constant0 INT1
Constant1 constant1 INT1
Constant2 constant2 INT1
Constant3 constant3 INT1
Constant4 constant4 INT1
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
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
ConstantNew constantnew Single-Character Flag
ConstantActive constantactive Single-Character Flag
ConstantUpdated constantupdated Single-Character Flag

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_CmplRqVersConstants.
-- 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_CmplRqVersConstants AS
SELECT
  Dummy,
  Constant0,
  Constant1,
  Constant2,
  Constant3,
  Constant4,
  ConstantHyphen,
  ConstantRaw,
  ConstantEmpty,
  ConstantTrue,
  ConstantFalse,
  ConstantNotExisting,
  ConstantMixture,
  ConstantInProgress,
  ConstantReleased,
  ConstantCalculated,
  ConstantOutdated,
  ConstantCompStatForrelease,
  ConstantCompStatNew,
  Constant01,
  Constant02,
  Constant03,
  ConstantNew,
  ConstantActive,
  ConstantUpdated
FROM ehfndv_dummy
;