I_ObjectDependency

DDL: I_OBJECTDEPENDENCY SQL: IOBJDEPENDENCY Type: view BASIC Package: ODATA_LO_VCHCLF_OVP_MODELER
16 Fields 2 Data Sources

Object Dependency

I_ObjectDependency is a Basic CDS View that provides data about "Object Dependency" in SAP S/4HANA. It reads from 2 data sources (cukb, cukbt) and exposes 16 fields with key fields ObjectDependency, TimeIntervalNumber. Part of development package ODATA_LO_VCHCLF_OVP_MODELER.

Data Sources (2)

SourceAliasJoin Type
cukb Dependency from
cukbt DependencyText left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IOBJDEPENDENCY view
EndUserText.label Object Dependency view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ObjectDependency cukb knnum Int.no.
KEY TimeIntervalNumber cukb adzhl Int. counter
ObjectDependencyName cukb knnam Dependency
ObjectDependencyType cukb knart Dependency Type
ObjectDependencyStatus cukb knsta Status
CreationDate cukb knedt Created On
CreatedByUser cukb kneus Created By
knadtendasLastChangeDate
knausendasLastChangedByUser
ObjectDependencyGroup cukb kngrp Dependency Grp
AuthznToMntnObjDpndcyForObj cukb knbeo Maint. Auth.
IsDeleted cukb lkenz Deletion Ind.
ChangeNumber cukb aennr Change Number
ValidityStartDate cukb datuv Valid-from date
ValidityEndDate cukb datub Valid to
ObjectDependencyDescription cukbt knktx Description

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_ObjectDependency.
-- 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: IOBJDEPENDENCY

CREATE VIEW I_ObjectDependency AS
SELECT
  Dependency.knnum AS ObjectDependency,
  Dependency.adzhl AS TimeIntervalNumber,
  Dependency.knnam AS ObjectDependencyName,
  Dependency.knart AS ObjectDependencyType,
  Dependency.knsta AS ObjectDependencyStatus,
  Dependency.knedt AS CreationDate,
  Dependency.kneus AS CreatedByUser,
  case when Dependency.knadt is null or Dependency.knadt = '00000000' then Dependency.knedt else Dependency.knadt end as LastChangeDate AS knadtendasLastChangeDate,
  case when Dependency.knadt is null or Dependency.knadt = '00000000' then Dependency.kneus else Dependency.knaus end as LastChangedByUser AS knausendasLastChangedByUser,
  Dependency.kngrp AS ObjectDependencyGroup,
  Dependency.knbeo AS AuthznToMntnObjDpndcyForObj,
  Dependency.lkenz AS IsDeleted,
  Dependency.aennr AS ChangeNumber,
  Dependency.datuv AS ValidityStartDate,
  Dependency.datub AS ValidityEndDate,
  DependencyText.knktx AS ObjectDependencyDescription
FROM cukb AS Dependency
LEFT OUTER JOIN cukbt AS DependencyText ON /* join condition not captured in parsed metadata */
;

Learn More