I_CmplRqVersActvtnTP

DDL: I_CMPLRQVERSACTVTNTP SQL: ICRVACTVTNTP Type: view TRANSACTIONAL Package: EHFND_BO_COMPLIANCE_REQ
15 Fields 1 Data Sources 4 OData Services

CR Version Activation

I_CmplRqVersActvtnTP is a Transactional CDS View that provides data about "CR Version Activation" in SAP S/4HANA. It reads from 1 data source (I_CmplRqVersActvtn) and exposes 15 fields with key field CmplRqVersUUID. It is exposed through 4 OData services (ASQL_F3439, ASQL_F8002, ASQL_F8003, ...). Part of development package EHFND_BO_COMPLIANCE_REQ.

Data Sources (1)

SourceAliasJoin Type
I_CmplRqVersActvtn CmplRqVersActvtn from

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName ICRVACTVTNTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CR Version Activation view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name ComplianceRqmtVersActvtn view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled false view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.writeActivePersistence ehfndv_req_actv view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.entityChangeStateId LastChangeDateTime view
ClientHandling.algorithm #SESSION_VARIABLE view

OData Services (4)

ServiceBindingVersionContractRelease
ASQL_F3439 ASQL_F3439 C2 NOT_RELEASED
ASQL_F8002 ASQL_F8002 C2 NOT_RELEASED
ASQL_F8003 ASQL_F8003 C2 NOT_RELEASED
ASQL_F8004 ASQL_F8004 C2 NOT_RELEASED

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CmplRqVersUUID I_CmplRqVersActvtn CmplRqVersUUID NodeID
CreationDateTime I_CmplRqVersActvtn CreationDateTime Timestamp
CreatedByUser I_CmplRqVersActvtn CreatedByUser User Name
LastChangeDateTime I_CmplRqVersActvtn LastChangeDateTime Timestamp
LastChangedByUser I_CmplRqVersActvtn LastChangedByUser User Name
CmplRqVersActivationStatus I_CmplRqVersActvtn CmplRqVersActivationStatus Activation Status
CmplRqSourceURLStatus I_CmplRqVersActvtn CmplRqSourceURLStatus URL Status
ChmlCompositionType I_CmplRqVersActvtn ChmlCompositionType Legal Area
CmplRqVersBuildDate I_CmplRqVersActvtn CmplRqVersBuildDate Build Date
CmplRqVersActivatedByUser I_CmplRqVersActvtn CmplRqVersActivatedByUser Activated By
CmplRqVersActivationDate I_CmplRqVersActvtn CmplRqVersActivationDate Activated On
CmplRqVersDeactivatedByUser I_CmplRqVersActvtn CmplRqVersDeactivatedByUser Deactivated By
CmplRqVersDeactivationDate I_CmplRqVersActvtn CmplRqVersDeactivationDate Deactivated On
ValidityEndDate I_CmplRqVersActvtn ValidityEndDate ValidTo
CmplRqDomain I_CmplRqVersActvtn CmplRqDomain Requirement Domain

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_CmplRqVersActvtnTP.
-- 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.
-- SQL view name: ICRVACTVTNTP

CREATE VIEW I_CmplRqVersActvtnTP AS
SELECT
  CmplRqVersActvtn.CmplRqVersUUID AS CmplRqVersUUID,
  CmplRqVersActvtn.CreationDateTime AS CreationDateTime,
  CmplRqVersActvtn.CreatedByUser AS CreatedByUser,
  CmplRqVersActvtn.LastChangeDateTime AS LastChangeDateTime,
  CmplRqVersActvtn.LastChangedByUser AS LastChangedByUser,
  CmplRqVersActvtn.CmplRqVersActivationStatus AS CmplRqVersActivationStatus,
  CmplRqVersActvtn.CmplRqSourceURLStatus AS CmplRqSourceURLStatus,
  CmplRqVersActvtn.ChmlCompositionType AS ChmlCompositionType,
  CmplRqVersActvtn.CmplRqVersBuildDate AS CmplRqVersBuildDate,
  CmplRqVersActvtn.CmplRqVersActivatedByUser AS CmplRqVersActivatedByUser,
  CmplRqVersActvtn.CmplRqVersActivationDate AS CmplRqVersActivationDate,
  CmplRqVersActvtn.CmplRqVersDeactivatedByUser AS CmplRqVersDeactivatedByUser,
  CmplRqVersActvtn.CmplRqVersDeactivationDate AS CmplRqVersDeactivationDate,
  CmplRqVersActvtn.ValidityEndDate AS ValidityEndDate,
  CmplRqVersActvtn.CmplRqDomain AS CmplRqDomain
FROM I_CmplRqVersActvtn AS CmplRqVersActvtn
;

Learn More