C_HDMRelationTP

DDL: C_HDMRELATIONTP Type: view_entity CONSUMPTION
30 Fields 1 Data Sources

HDM Relation

C_HDMRelationTP is a Consumption CDS View that provides data about "HDM Relation" in SAP S/4HANA. It reads from 1 data source (I_HDMRelationTP) and exposes 30 fields with key fields SAPObjectNodeType, LinkedSAPObjectKey, BaseObjectType, BaseObjectKey.

Data Sources (1)

SourceAliasJoin Type
I_HDMRelationTP I_HDMRelationTP projection

Annotations (10)

NameValueLevelField
EndUserText.label HDM Relation view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name HDMRelation view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.query.implementedBy ABAP:CL_HDM_RELATION_QUERY view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY SAPObjectNodeType SAPObjectNodeType SONT Name
KEY LinkedSAPObjectKey LinkedSAPObjectKey SAP Object Key
KEY BaseObjectType BaseObjectType
KEY BaseObjectKey BaseObjectKey
HDMRelationIsLocked HDMRelationIsLocked
CreatedByUserName CreatedByUserName Person Resp.
HDMCreatedAtDateTime HDMCreatedAtDateTime Time Stamp
ChangedByUserName ChangedByUserName
HDMChangedAtDateTime HDMChangedAtDateTime Time Stamp
HDMObjectType _HarmonizedDocument HDMObjectType
HDMObjectName _HarmonizedDocument HDMObjectName
HDMVersionSeriesID _HarmonizedDocument HDMVersionSeriesID
HDMRevisionID _HarmonizedDocument HDMRevisionID
HDMObjectStatus _HarmonizedDocument HDMObjectStatus
HDMObjectSizeInByte _HarmonizedDocument HDMObjectSizeInByte
HDMMimeType _HarmonizedDocument HDMMimeType
HDMExtDocID _HarmonizedDocument HDMExtDocID
HDMObjIsMultiRef _HarmonizedDocument HDMObjIsMultiRef
HDMObjectURI _HarmonizedDocument HDMObjectURI
HDMObjectState _HarmonizedDocument HDMObjectState
CreatedByUserFullName _UserContactCard FullName Name
LastChangedByUserFullName _UserContactCard FullName Name
PhoneNumber _UserContactCard PhoneNumber Telephone no.
EmailAddress _UserContactCard EmailAddress E-Mail Address
FunctionalTitleName _UserContactCard FunctionalTitleName
virtualHDMObjectDescshdm_description
virtualHDMObjectTypeDescshdm_description
virtualDocumentUploadIsInProgressboole_d
virtualLinkedObjectToggleshdm_boolean
_UserContactCard _UserContactCard

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 C_HDMRelationTP.
-- 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 C_HDMRelationTP AS
SELECT
  SAPObjectNodeType,
  LinkedSAPObjectKey,
  BaseObjectType,
  BaseObjectKey,
  HDMRelationIsLocked,
  CreatedByUserName,
  HDMCreatedAtDateTime,
  ChangedByUserName,
  HDMChangedAtDateTime,
  _HarmonizedDocument.HDMObjectType AS HDMObjectType,
  _HarmonizedDocument.HDMObjectName AS HDMObjectName,
  _HarmonizedDocument.HDMVersionSeriesID AS HDMVersionSeriesID,
  _HarmonizedDocument.HDMRevisionID AS HDMRevisionID,
  _HarmonizedDocument.HDMObjectStatus AS HDMObjectStatus,
  _HarmonizedDocument.HDMObjectSizeInByte AS HDMObjectSizeInByte,
  _HarmonizedDocument.HDMMimeType AS HDMMimeType,
  _HarmonizedDocument.HDMExtDocID AS HDMExtDocID,
  _HarmonizedDocument.HDMObjIsMultiRef AS HDMObjIsMultiRef,
  _HarmonizedDocument.HDMObjectURI AS HDMObjectURI,
  _HarmonizedDocument.HDMObjectState AS HDMObjectState,
  _UserContactCard.FullName AS CreatedByUserFullName,
  _UserContactCard.FullName AS LastChangedByUserFullName,
  _UserContactCard.PhoneNumber AS PhoneNumber,
  _UserContactCard.EmailAddress AS EmailAddress,
  _UserContactCard.FunctionalTitleName AS FunctionalTitleName,
  virtual HDMObjectDesc : shdm_description AS virtualHDMObjectDescshdm_description,
  virtual HDMObjectTypeDesc : shdm_description AS virtualHDMObjectTypeDescshdm_description,
  virtual DocumentUploadIsInProgress : boole_d AS virtualDocumentUploadIsInProgressboole_d,
  virtual LinkedObjectToggle : shdm_boolean AS virtualLinkedObjectToggleshdm_boolean
FROM I_HDMRelationTP
;

Learn More