I_VarCnfHistlConstraintBasic

DDL: I_VARCNFHISTLCONSTRAINTBASIC Type: view_entity BASIC Package: VCH_VDM_MD_CNET
16 Fields 1 Data Sources

Historical Constraint Basic Attributes

I_VarCnfHistlConstraintBasic is a Basic CDS View that provides data about "Historical Constraint Basic Attributes" in SAP S/4HANA. It reads from 1 data source (cukb) and exposes 16 fields with key fields VarCnfConstraint, TimeIntervalNumber. Part of development package VCH_VDM_MD_CNET.

Data Sources (1)

SourceAliasJoin Type
cukb cukb from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Historical Constraint Basic Attributes view
ObjectModel.representativeKey VarCnfConstraint view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY VarCnfConstraint knnum Int.no.
KEY TimeIntervalNumber adzhl Int. counter
VarCnfConstraintName knnam Dependency
ChangeNumber aennr Change Number
ObjectDependencyStatus knsta Status
ObjectDependencyGroup kngrp Dependency Grp
ObjDpndcyAuthorizationGroup knbeo Maint. Auth.
ObjectDependencyType knart Dependency Type
CreationDate knedt Created On
CreatedByUser kneus Created By
LastChangeDate knadt Changed On
LastChangedByUser knaus Changed By
ValidityStartDate datuv Valid-from date
ValidityEndDate datub Valid to
IsDeleted lkenz Deletion Ind.
LocalLastChangeDateTime chtim Time Stamp

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_VarCnfHistlConstraintBasic.
-- 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_VarCnfHistlConstraintBasic AS
SELECT
  knnum AS VarCnfConstraint,
  adzhl AS TimeIntervalNumber,
  knnam AS VarCnfConstraintName,
  aennr AS ChangeNumber,
  knsta AS ObjectDependencyStatus,
  kngrp AS ObjectDependencyGroup,
  knbeo AS ObjDpndcyAuthorizationGroup,
  knart AS ObjectDependencyType,
  knedt AS CreationDate,
  kneus AS CreatedByUser,
  knadt AS LastChangeDate,
  knaus AS LastChangedByUser,
  datuv AS ValidityStartDate,
  datub AS ValidityEndDate,
  lkenz AS IsDeleted,
  chtim AS LocalLastChangeDateTime
FROM cukb
;

Learn More