P_CmplRqVersActvtnDynValues

DDL: P_CMPLRQVERSACTVTNDYNVALUES Type: view CONSUMPTION
22 Fields 1 Data Sources 4 Associations

P_CmplRqVersActvtnDynValues is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_CmplRqVersEnhanced) and exposes 22 fields with key field CmplRqVersUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmplRqVersEnhanced CmplRqVers from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_CmplRqVersActvtn _CmplRqVersActvtn $projection.CmplRqVersUUID = _CmplRqVersActvtn.CmplRqVersUUID
[1..1] I_CmplRqVersMaintStatusTxt _CmplRqVersMaintStatusText $projection.CmplRqVersMaintStatus = _CmplRqVersMaintStatusText.CmplRqVersMaintStatus and _CmplRqVersMaintStatusText.Language = $session.system_language
[0..1] P_CmplRqVersPredecessorCount _CmplRqVersPredecessorCount $projection.CmplRqVersUUID = _CmplRqVersPredecessorCount.CmplRqVersUUID
[1..1] P_CmplRqVersConstants _CmplRqVersConstants _CmplRqVersConstants.Dummy = 'X'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCRVACTVDYNVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CmplRqVersUUID I_CmplRqVersEnhanced CmplRqVersUUID NodeID
CmplRqVers I_CmplRqVersEnhanced CmplRqVers Compliance Requirement
CmplRqVersName I_CmplRqVersEnhanced CmplRqVersName Compliance Requirement Name
CmplRqVersActivatedByUser _CmplRqVersActvtn CmplRqVersActivatedByUser Activated By
CmplRqVersActivationDate _CmplRqVersActvtn CmplRqVersActivationDate Activated On
CmplRqVersDeactivatedByUser _CmplRqVersActvtn CmplRqVersDeactivatedByUser Deactivated By
CmplRqVersDeactivationDate _CmplRqVersActvtn CmplRqVersDeactivationDate Deactivated On
CmplRqVersMaintStatus I_CmplRqVersEnhanced CmplRqVersMaintStatus Status
EffectiveDate I_CmplRqVersEnhanced EffectiveDate Effective Date
TransitionPeriodEndDate I_CmplRqVersEnhanced TransitionPeriodEndDate End of Transition
CmplRqVersBuildDateOrg CmplRqVersBuildDate Build Date
ContentProvider I_CmplRqVersEnhanced ContentProvider Content Provider
CmplRqPattern I_CmplRqVersEnhanced CmplRqPattern Compliance Pattern
CmplRqPatternName _CompReqPattern CmplRqPatternName Pattern Name
ComplianceRequirement I_CmplRqVersEnhanced ComplianceRequirement Compliance Requirement
CmplRqApplicationComponent I_CmplRqVersEnhanced CmplRqApplicationComponent Solution Area
ValidityEndDate _CmplRqVersActvtn ValidityEndDate ValidTo
ChmlCompositionType _CmplRqVersActvtn ChmlCompositionType Legal Area
CmplRqVersNameInCurLang I_CmplRqVersEnhanced CmplRqVersNameInCurLang Compliance Requirement Name
CmplRqVersEnglishName I_CmplRqVersEnhanced CmplRqVersEnglishName Compliance Requirement Name
CmplRqDomain I_CmplRqVersEnhanced CmplRqDomain Requirement Domain
_CmplRqVersMaintStatusText _CmplRqVersMaintStatusText

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_CmplRqVersActvtnDynValues.
-- 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_CmplRqVersActvtnDynValues AS
SELECT
  CmplRqVers.CmplRqVersUUID AS CmplRqVersUUID,
  CmplRqVers.CmplRqVers AS CmplRqVers,
  CmplRqVers.CmplRqVersName AS CmplRqVersName,
  _CmplRqVersActvtn.CmplRqVersActivatedByUser AS CmplRqVersActivatedByUser,
  _CmplRqVersActvtn.CmplRqVersActivationDate AS CmplRqVersActivationDate,
  _CmplRqVersActvtn.CmplRqVersDeactivatedByUser AS CmplRqVersDeactivatedByUser,
  _CmplRqVersActvtn.CmplRqVersDeactivationDate AS CmplRqVersDeactivationDate,
  CmplRqVers.CmplRqVersMaintStatus AS CmplRqVersMaintStatus,
  CmplRqVers.EffectiveDate AS EffectiveDate,
  CmplRqVers.TransitionPeriodEndDate AS TransitionPeriodEndDate,
  CmplRqVersBuildDate AS CmplRqVersBuildDateOrg,
  CmplRqVers.ContentProvider AS ContentProvider,
  CmplRqVers.CmplRqPattern AS CmplRqPattern,
  _CompReqPattern.CmplRqPatternName AS CmplRqPatternName,
  CmplRqVers.ComplianceRequirement AS ComplianceRequirement,
  CmplRqVers.CmplRqApplicationComponent AS CmplRqApplicationComponent,
  _CmplRqVersActvtn.ValidityEndDate AS ValidityEndDate,
  _CmplRqVersActvtn.ChmlCompositionType AS ChmlCompositionType,
  CmplRqVers.CmplRqVersNameInCurLang AS CmplRqVersNameInCurLang,
  CmplRqVers.CmplRqVersEnglishName AS CmplRqVersEnglishName,
  CmplRqVers.CmplRqDomain AS CmplRqDomain
FROM I_CmplRqVersEnhanced AS CmplRqVers
LEFT OUTER JOIN I_CmplRqVersActvtn AS _CmplRqVersActvtn ON CmplRqVersUUID = _CmplRqVersActvtn.CmplRqVersUUID  -- association [0..1]
LEFT OUTER JOIN I_CmplRqVersMaintStatusTxt AS _CmplRqVersMaintStatusText ON CmplRqVersMaintStatus = _CmplRqVersMaintStatusText.CmplRqVersMaintStatus AND _CmplRqVersMaintStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN P_CmplRqVersPredecessorCount AS _CmplRqVersPredecessorCount ON CmplRqVersUUID = _CmplRqVersPredecessorCount.CmplRqVersUUID  -- association [0..1]
LEFT OUTER JOIN P_CmplRqVersConstants AS _CmplRqVersConstants ON _CmplRqVersConstants.Dummy = 'X'  -- association [1..1]
;

Learn More