I_HDMObject

DDL: I_HDMOBJECT Type: view_entity BASIC

Basic view for HDM Object Entity

I_HDMObject is a Basic CDS View that provides data about "Basic view for HDM Object Entity" in SAP S/4HANA. It reads from 1 data source (shdm_object) and exposes 26 fields with key fields BaseObjectType, BaseObjectKey.

Data Sources (1)

SourceAliasJoin Type
shdm_object shdm_object from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Basic view for HDM Object Entity view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.representativeKey BaseObjectKey view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY BaseObjectType baseobjecttype
KEY BaseObjectKey baseobjectkey
HDMVersionSeriesID versionseriesid
HDMRevisionID revisionid
HDMObjectType objecttype Type
HDMObjectName objectname Object name
HDMObjectStatus objectstatus Object Status
HDMObjectURI objecturi
HDMVersionID physicaldocumentid
HDMMimeType mimetype MIMETYPE
HDMObjectSizeInByte objectsize
HDMObjIsMultiRef ismultireferenced
HDMObjHasLtstRevsn islatestrevision
HDMObjectState objectstate
HDMParentFolderPathValue parentfolderpath
HDMParentFolderIdentifier parentfolderid
HDMFileShareIdentifier fileshareid
HDMFileShareItemIdentifier fileshareitemid
HDMExtDocID externaldocumentid Ext. Reference ID
CreatedByUserName createdby User Name
HDMCreatedAtDateTime createdat Time Stamp
ChangedByUserName changedby User Name
HDMChangedAtDateTime changedat Time Stamp
HDMCheckedOutByUser checkedoutby
HDMCheckedOutDateTime checkedoutat Time Stamp
ContentStreamBinary contentstream

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_HDMObject.
-- 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_HDMObject AS
SELECT
  BaseObjectType,
  BaseObjectKey,
  versionseriesid AS HDMVersionSeriesID,
  revisionid AS HDMRevisionID,
  objecttype AS HDMObjectType,
  objectname AS HDMObjectName,
  objectstatus AS HDMObjectStatus,
  objecturi AS HDMObjectURI,
  physicaldocumentid AS HDMVersionID,
  mimetype AS HDMMimeType,
  objectsize AS HDMObjectSizeInByte,
  ismultireferenced AS HDMObjIsMultiRef,
  islatestrevision AS HDMObjHasLtstRevsn,
  objectstate AS HDMObjectState,
  parentfolderpath AS HDMParentFolderPathValue,
  parentfolderid AS HDMParentFolderIdentifier,
  fileshareid AS HDMFileShareIdentifier,
  fileshareitemid AS HDMFileShareItemIdentifier,
  externaldocumentid AS HDMExtDocID,
  createdby AS CreatedByUserName,
  createdat AS HDMCreatedAtDateTime,
  changedby AS ChangedByUserName,
  changedat AS HDMChangedAtDateTime,
  checkedoutby AS HDMCheckedOutByUser,
  checkedoutat AS HDMCheckedOutDateTime,
  contentstream AS ContentStreamBinary
FROM shdm_object
;