I_DocInfoRecdObjLinkChgRecd

DDL: I_DOCINFORECDOBJLINKCHGRECD SQL: IDIROBJCHGREC Type: view COMPOSITE
17 Fields 1 Data Sources

DIR Object Link Change Record

I_DocInfoRecdObjLinkChgRecd is a Composite CDS View that provides data about "DIR Object Link Change Record" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordBsc) and exposes 17 fields with key field ChangeRecordUUID.

Data Sources (1)

SourceAliasJoin Type
I_ChangeRecordBsc ChangeRecord from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDIROBJCHGREC view
AbapCatalog.compiler.compareFilter true view
EndUserText.label DIR Object Link Change Record view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordUUID
ChangeRecord I_ChangeRecordBsc ChangeRecord Char20
ChangeRecordType I_ChangeRecordBsc ChangeRecordType Record Type
ParentChangeRecordUUID I_ChangeRecordBsc ParentChangeRecordUUID NodeID
RootChangeRecordUUID I_ChangeRecordBsc RootChangeRecordUUID NodeID
ChangeRecordPriority I_ChangeRecordBsc ChangeRecordPriority Workflow priority
ChangeRecordStatus I_ChangeRecordBsc ChangeRecordStatus
ChangeNumber I_ChangeRecordBsc ChangeNumber Change Number
ChangeRecordCategory I_ChangeRecordBsc ChangeRecordCategory Issue Cat.
ChgRecordApplication I_ChangeRecordBsc ChgRecordApplication UI Application
CreatedByUser I_ChangeRecordBsc CreatedByUser User Name
CreationDateTime I_ChangeRecordBsc CreationDateTime Timestamp
LastChangedByUser I_ChangeRecordBsc LastChangedByUser User Name
LastChangeDateTime I_ChangeRecordBsc LastChangeDateTime Timestamp
ChangeRecordLifecycleStatus I_ChangeRecordBsc ChangeRecordLifecycleStatus Issue Lifecycle
Partner I_ChangeRecordBsc Partner With Partner
ChgRecordDescriptionText I_ChangeRecordBsc ChgRecordDescriptionText

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_DocInfoRecdObjLinkChgRecd.
-- 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: IDIROBJCHGREC

CREATE VIEW I_DocInfoRecdObjLinkChgRecd AS
SELECT
  cast (bintohex(ChangeRecord.ChangeRecordUUID) as char90 ) AS ChangeRecordUUID,
  ChangeRecord.ChangeRecord AS ChangeRecord,
  ChangeRecord.ChangeRecordType AS ChangeRecordType,
  ChangeRecord.ParentChangeRecordUUID AS ParentChangeRecordUUID,
  ChangeRecord.RootChangeRecordUUID AS RootChangeRecordUUID,
  ChangeRecord.ChangeRecordPriority AS ChangeRecordPriority,
  ChangeRecord.ChangeRecordStatus AS ChangeRecordStatus,
  ChangeRecord.ChangeNumber AS ChangeNumber,
  ChangeRecord.ChangeRecordCategory AS ChangeRecordCategory,
  ChangeRecord.ChgRecordApplication AS ChgRecordApplication,
  ChangeRecord.CreatedByUser AS CreatedByUser,
  ChangeRecord.CreationDateTime AS CreationDateTime,
  ChangeRecord.LastChangedByUser AS LastChangedByUser,
  ChangeRecord.LastChangeDateTime AS LastChangeDateTime,
  ChangeRecord.ChangeRecordLifecycleStatus AS ChangeRecordLifecycleStatus,
  ChangeRecord.Partner AS Partner,
  ChangeRecord.ChgRecordDescriptionText AS ChgRecordDescriptionText
FROM I_ChangeRecordBsc AS ChangeRecord
;

Learn More