I_CmplRqVersActiveActivation

DDL: I_CMPLRQVERSACTIVEACTIVATION Type: view_entity BASIC Package: EHFND_BO_COMPLIANCE_REQ
14 Fields 1 Data Sources

Active CR Version Activation

I_CmplRqVersActiveActivation is a Basic CDS View that provides data about "Active CR Version Activation" in SAP S/4HANA. It reads from 1 data source (ehfndd_req_actv) and exposes 14 fields with key field CmplRqVersUUID. Part of development package EHFND_BO_COMPLIANCE_REQ.

Data Sources (1)

SourceAliasJoin Type
ehfndd_req_actv CmplRqVersActvtn from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Active CR Version Activation view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey CmplRqVersUUID view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CmplRqVersUUID ehfndd_req_actv crv_uuid Compl Req UUID
CreationDateTime ehfndd_req_actv crea_date_time Time Stamp
CreatedByUser ehfndd_req_actv crea_uname User Name
LastChangeDateTime ehfndd_req_actv lchg_date_time Time Stamp
LastChangedByUser ehfndd_req_actv lchg_uname User Name
CmplRqVersActivationStatus ehfndd_req_actv activation_status Active
CmplRqSourceURLStatus ehfndd_req_actv source_url_status URL Status
ChmlCompositionType ehfndd_req_actv composition_type Legal Area
CmplRqVersActivatedByUser ehfndd_req_actv activated_by Activated By
CmplRqVersActivationDate ehfndd_req_actv activated_on Activation Date
CmplRqVersDeactivatedByUser ehfndd_req_actv deactivated_by Deactivated By
CmplRqVersDeactivationDate ehfndd_req_actv deactivated_on Deactivated On
ValidityEndDate ehfndd_req_actv valid_to Validity End Time
_ChmlCompositionType _ChmlCompositionType

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 I_CmplRqVersActiveActivation.
-- 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 I_CmplRqVersActiveActivation AS
SELECT
  CmplRqVersActvtn.crv_uuid AS CmplRqVersUUID,
  CmplRqVersActvtn.crea_date_time AS CreationDateTime,
  CmplRqVersActvtn.crea_uname AS CreatedByUser,
  CmplRqVersActvtn.lchg_date_time AS LastChangeDateTime,
  CmplRqVersActvtn.lchg_uname AS LastChangedByUser,
  CmplRqVersActvtn.activation_status AS CmplRqVersActivationStatus,
  CmplRqVersActvtn.source_url_status AS CmplRqSourceURLStatus,
  CmplRqVersActvtn.composition_type AS ChmlCompositionType,
  CmplRqVersActvtn.activated_by AS CmplRqVersActivatedByUser,
  CmplRqVersActvtn.activated_on AS CmplRqVersActivationDate,
  CmplRqVersActvtn.deactivated_by AS CmplRqVersDeactivatedByUser,
  CmplRqVersActvtn.deactivated_on AS CmplRqVersDeactivationDate,
  CmplRqVersActvtn.valid_to AS ValidityEndDate
FROM ehfndd_req_actv AS CmplRqVersActvtn
;

Learn More