I_DocumentInfoRecordObjectLink

DDL: I_DOCUMENTINFORECORDOBJECTLINK SQL: ICVDOCOBJECTLINK Type: view BASIC
26 Fields 1 Data Sources 4 Associations

Document Info Record Object Link

I_DocumentInfoRecordObjectLink is a Basic CDS View that provides data about "Document Info Record Object Link" in SAP S/4HANA. It reads from 1 data source (P_DocumentInfoRecordObjectLink) and exposes 26 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart, LinkedSAPObject. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_DocumentInfoRecordObjectLink ObjLink from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_DocumentInfoRecordObjLinkT _Text $projection.LinkedSAPObject = _Text.LinkedSAPObject --Get DocumentInfoRecord created user full name
[1..1] I_DocumentInfoRecordUserVH _CreatedUser $projection.DocumentInfoRecordDocType = _CreatedUser.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocPart = _CreatedUser.DocumentInfoRecordDocPart and $projection.DocumentInfoRecordDocNumber = _CreatedUser.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _CreatedUser.DocumentInfoRecordDocVersion and $projection.CreatedByUser = _CreatedUser.ResponsiblePersonName --Get DocumentInfoRecord changed user full name
[1..1] I_DocumentInfoRecordUserVH _ChangedUser $projection.DocumentInfoRecordDocType = _ChangedUser.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocPart = _ChangedUser.DocumentInfoRecordDocPart and $projection.DocumentInfoRecordDocNumber = _ChangedUser.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _ChangedUser.DocumentInfoRecordDocVersion and $projection.LastChangedByUser = _ChangedUser.LastChangedByUser
[0..*] I_DocumentInfoRecordDesc _DocumentInfoRecordDesc $projection.DocumentInfoRecordDocNumber = _DocumentInfoRecordDesc.DocumentInfoRecordDocNumber

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICVDOCOBJECTLINK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Document Info Record Object Link view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType P_DocumentInfoRecordObjectLink DocumentInfoRecordDocType Document Type
KEY DocumentInfoRecordDocNumber P_DocumentInfoRecordObjectLink DocumentInfoRecordDocNumber Document
KEY DocumentInfoRecordDocVersion P_DocumentInfoRecordObjectLink DocumentInfoRecordDocVersion Doc. Version
KEY DocumentInfoRecordDocPart P_DocumentInfoRecordObjectLink DocumentInfoRecordDocPart Document Part
KEY LinkedSAPObject P_DocumentInfoRecordObjectLink LinkedSAPObject Object
KEY LinkedSAPObjectKey P_DocumentInfoRecordObjectLink LinkedSAPObjectKey SAP Object Key
KEY DocObjectLinkCounter P_DocumentInfoRecordObjectLink DocObjectLinkCounter Obj.Ctr
CreationDateTime P_DocumentInfoRecordObjectLink CreationDateTime Timestamp
CreatedByUser P_DocumentInfoRecordObjectLink CreatedByUser User Name
ChangedDateTime P_DocumentInfoRecordObjectLink ChangedDateTime Time Stamp
LastChangedByUser P_DocumentInfoRecordObjectLink LastChangedByUser User Name
DocInfoRecdLinkStatus P_DocumentInfoRecordObjectLink DocInfoRecdLinkStatus Link status
DocInfoRecdObjectLinkStatus P_DocumentInfoRecordObjectLink DocInfoRecdObjectLinkStatus Object link status
ObjectTypeDatabaseTable P_DocumentInfoRecordObjectLink ObjectTypeDatabaseTable Table
DocInfoRecdAdditionalObjectKey P_DocumentInfoRecordObjectLink DocInfoRecdAdditionalObjectKey Object Key
DocLinkDirectionIsActive P_DocumentInfoRecordObjectLink DocLinkDirectionIsActive Active
IsDefaultDocument P_DocumentInfoRecordObjectLink IsDefaultDocument View indocator
DocInfoRecdIsMarkedForDeletion P_DocumentInfoRecordObjectLink DocInfoRecdIsMarkedForDeletion Deletion ind.
DocInfoRecdLongTextUUID P_DocumentInfoRecordObjectLink DocInfoRecdLongTextUUID UUID
IsDocInfoRecdCreatedFromCAD P_DocumentInfoRecordObjectLink IsDocInfoRecdCreatedFromCAD CAD Indicator
DocInfoRecdConfignMgmtFixed P_DocumentInfoRecordObjectLink DocInfoRecdConfignMgmtFixed Fixed
IsArchived P_DocumentInfoRecordObjectLink IsArchived Archiving
_CreatedUser _CreatedUser
_ChangedUser _ChangedUser
_Text _Text
_DocumentInfoRecordDesc _DocumentInfoRecordDesc

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_DocumentInfoRecordObjectLink.
-- 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: ICVDOCOBJECTLINK

CREATE VIEW I_DocumentInfoRecordObjectLink AS
SELECT
  ObjLink.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  ObjLink.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  ObjLink.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  ObjLink.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  ObjLink.LinkedSAPObject AS LinkedSAPObject,
  ObjLink.LinkedSAPObjectKey AS LinkedSAPObjectKey,
  ObjLink.DocObjectLinkCounter AS DocObjectLinkCounter,
  ObjLink.CreationDateTime AS CreationDateTime,
  ObjLink.CreatedByUser AS CreatedByUser,
  ObjLink.ChangedDateTime AS ChangedDateTime,
  ObjLink.LastChangedByUser AS LastChangedByUser,
  ObjLink.DocInfoRecdLinkStatus AS DocInfoRecdLinkStatus,
  ObjLink.DocInfoRecdObjectLinkStatus AS DocInfoRecdObjectLinkStatus,
  ObjLink.ObjectTypeDatabaseTable AS ObjectTypeDatabaseTable,
  ObjLink.DocInfoRecdAdditionalObjectKey AS DocInfoRecdAdditionalObjectKey,
  ObjLink.DocLinkDirectionIsActive AS DocLinkDirectionIsActive,
  ObjLink.IsDefaultDocument AS IsDefaultDocument,
  ObjLink.DocInfoRecdIsMarkedForDeletion AS DocInfoRecdIsMarkedForDeletion,
  ObjLink.DocInfoRecdLongTextUUID AS DocInfoRecdLongTextUUID,
  ObjLink.IsDocInfoRecdCreatedFromCAD AS IsDocInfoRecdCreatedFromCAD,
  ObjLink.DocInfoRecdConfignMgmtFixed AS DocInfoRecdConfignMgmtFixed,
  ObjLink.IsArchived AS IsArchived
FROM P_DocumentInfoRecordObjectLink AS ObjLink
LEFT OUTER JOIN I_DocumentInfoRecordObjLinkT AS _Text ON LinkedSAPObject = _Text.LinkedSAPObject  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordUserVH AS _CreatedUser ON DocumentInfoRecordDocType = _CreatedUser.DocumentInfoRecordDocType AND DocumentInfoRecordDocPart = _CreatedUser.DocumentInfoRecordDocPart AND DocumentInfoRecordDocNumber = _CreatedUser.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _CreatedUser.DocumentInfoRecordDocVersion AND CreatedByUser = _CreatedUser.ResponsiblePersonName  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordUserVH AS _ChangedUser ON DocumentInfoRecordDocType = _ChangedUser.DocumentInfoRecordDocType AND DocumentInfoRecordDocPart = _ChangedUser.DocumentInfoRecordDocPart AND DocumentInfoRecordDocNumber = _ChangedUser.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _ChangedUser.DocumentInfoRecordDocVersion AND LastChangedByUser = _ChangedUser.LastChangedByUser  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordDesc AS _DocumentInfoRecordDesc ON DocumentInfoRecordDocNumber = _DocumentInfoRecordDesc.DocumentInfoRecordDocNumber  -- association [0..*]
;

Learn More