I_VarCnfHistlObjDpndcyBasic

DDL: I_VARCNFHISTLOBJDPNDCYBASIC Type: view BASIC Package: VCH_VDM_MD_OD
16 Fields 1 Data Sources

Histl Object Dependency basic attributes

I_VarCnfHistlObjDpndcyBasic is a Basic CDS View that provides data about "Histl Object Dependency basic attributes" in SAP S/4HANA. It reads from 1 data source (cukb) and exposes 16 fields with key fields ObjectDependency, TimeIntervalNumber. Part of development package VCH_VDM_MD_OD.

Data Sources (1)

SourceAliasJoin Type
cukb cukb from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IVCHODBSC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Histl Object Dependency basic attributes view
ObjectModel.representativeKey ObjectDependency 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 ObjectDependency knnum Int.no.
KEY TimeIntervalNumber adzhl Int. counter
ObjectDependencyName 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_VarCnfHistlObjDpndcyBasic.
-- 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_VarCnfHistlObjDpndcyBasic AS
SELECT
  knnum AS ObjectDependency,
  adzhl AS TimeIntervalNumber,
  knnam AS ObjectDependencyName,
  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