I_VarCnfHistlCstrtNetBasic

DDL: I_VARCNFHISTLCSTRTNETBASIC Type: view_entity BASIC
16 Fields 1 Data Sources

Histl Constraint Net Basic Attributes

I_VarCnfHistlCstrtNetBasic is a Basic CDS View that provides data about "Histl Constraint Net Basic Attributes" in SAP S/4HANA. It reads from 1 data source (cukb) and exposes 16 fields with key fields VarCnfConstraintNet, TimeIntervalNumber.

Data Sources (1)

SourceAliasJoin Type
cukb cukb from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Histl Constraint Net Basic Attributes view
ObjectModel.representativeKey VarCnfConstraintNet 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 VarCnfConstraintNet knnum Int.no.
KEY TimeIntervalNumber adzhl Int. counter
VarCnfConstraintNetName 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.
LastChangeDateTime 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_VarCnfHistlCstrtNetBasic.
-- 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_VarCnfHistlCstrtNetBasic AS
SELECT
  knnum AS VarCnfConstraintNet,
  adzhl AS TimeIntervalNumber,
  knnam AS VarCnfConstraintNetName,
  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 LastChangeDateTime
FROM cukb
;

Learn More