I_DocInfoRecdObjLinkAttchDet

DDL: I_DOCINFORECDOBJLINKATTCHDET SQL: ICVDOCOBJATTCHDE Type: view COMPOSITE Package: CV_VDM
41 Fields 1 Data Sources 2 Associations

DocumentInfoRecord ObjLink Attach Detail

I_DocInfoRecdObjLinkAttchDet is a Composite CDS View that provides data about "DocumentInfoRecord ObjLink Attach Detail" in SAP S/4HANA. It reads from 1 data source (I_DocumentInfoRecordObjectLink) and exposes 41 fields with key fields LinkedSAPObjectKey, LinkedSAPObject, DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion. It has 2 associations to related views. Part of development package CV_VDM.

Data Sources (1)

SourceAliasJoin Type
I_DocumentInfoRecordObjectLink ObjLink from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_DocumentInfoRecord _Document $projection.DocumentInfoRecordDocType = _Document.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _Document.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _Document.DocumentInfoRecordDocVersion and $projection.DocumentInfoRecordDocPart = _Document.DocumentInfoRecordDocPart --Original
[0..*] I_DocumentInfoRecordAttachment _Attachment $projection.DocumentInfoRecordDocType = _Attachment.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _Attachment.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _Attachment.DocumentInfoRecordDocVersion and $projection.DocumentInfoRecordDocPart = _Attachment.DocumentInfoRecordDocPart

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICVDOCOBJATTCHDE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
EndUserText.label DocumentInfoRecord ObjLink Attach Detail view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY LinkedSAPObjectKey I_DocumentInfoRecordObjectLink LinkedSAPObjectKey SAP Object Key
KEY LinkedSAPObject I_DocumentInfoRecordObjectLink LinkedSAPObject Object
KEY DocumentInfoRecordDocType I_DocumentInfoRecordObjectLink DocumentInfoRecordDocType Document Type
KEY DocumentInfoRecordDocNumber I_DocumentInfoRecordObjectLink DocumentInfoRecordDocNumber Document
KEY DocumentInfoRecordDocVersion I_DocumentInfoRecordObjectLink DocumentInfoRecordDocVersion Doc. Version
KEY DocumentInfoRecordDocPart I_DocumentInfoRecordObjectLink DocumentInfoRecordDocPart Document Part
KEY FileUUID _Attachment FileUUID UUID
KEY PhysicalDocument _Attachment PhysicalDocument Phys. Document
DocumentDescription
ObjectDescription
InternalDocumentStatus _Document InternalDocumentStatus Status
ExternalDocumentStatus
DocInfoRecdIsMarkedForDeletion _Document DocInfoRecdIsMarkedForDeletion Deletion ind.
DocumentStatusName
DocLinkDirectionIsActive
FileName _Attachment FileName URL or Filenam Path
FileSize _Attachment FileSize Safety Data Sheet File Size
WorkstationApplication _Attachment WorkstationApplication Applic.
MimeType _Attachment MimeType MIMETYPE
StorageCategory _Attachment StorageCategory Category
IsOriginalVersionActive _Attachment IsOriginalVersionActive Applic.
OriginalIsProtected _Attachment OriginalIsProtected Flag
DocumentTitle _Attachment DocumentTitle Title
DocumentFormat _Attachment DocumentFormat Document format
LogicalDocument _Attachment LogicalDocument Log. document
LogicalDocumentClass _Attachment LogicalDocumentClass LOIO class
PhysicalDocumentClass _Attachment PhysicalDocumentClass
CreationDateTime _Attachment CreationDateTime Timestamp
CreatedByUser _Attachment CreatedByUser User Name
ChangedDateTime _Attachment ChangedDateTime Time Stamp
LastChangedByUser _Attachment LastChangedByUser User Name
OriginalCheckedOutTime _Attachment OriginalCheckedOutTime Time Stamp
OriginalCheckedOutUser _Attachment OriginalCheckedOutUser Agent
LogicalDocumentIsReference _Attachment LogicalDocumentIsReference
PhysicalDocTechnicalStatus _Attachment PhysicalDocTechnicalStatus Tech. Status
OriginalType _Attachment OriginalType Original type
DocumentIndex _Attachment DocumentIndex Counter
InternalComment _Attachment InternalComment Comment
DocumentInfoRecord _Document DocumentInfoRecord Document
_Document _Document
_Attachment _Attachment

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_DocInfoRecdObjLinkAttchDet.
-- 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: ICVDOCOBJATTCHDE

CREATE VIEW I_DocInfoRecdObjLinkAttchDet AS
SELECT
  ObjLink.LinkedSAPObjectKey AS LinkedSAPObjectKey,
  ObjLink.LinkedSAPObject AS LinkedSAPObject,
  ObjLink.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  ObjLink.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  ObjLink.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  ObjLink.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  _Attachment.FileUUID AS FileUUID,
  _Attachment.PhysicalDocument AS PhysicalDocument,
  _Document._DocDesc[1:Language = $session.system_language].DocumentDescription AS DocumentDescription,
  ObjLink._Text[1:Language = $session.system_language].ObjectDescription AS ObjectDescription,
  _Document.InternalDocumentStatus AS InternalDocumentStatus,
  _Document._DocStatus._Text[1:Language = $session.system_language].ExternalDocumentStatus AS ExternalDocumentStatus,
  _Document.DocInfoRecdIsMarkedForDeletion AS DocInfoRecdIsMarkedForDeletion,
  _Document._DocStatus._Text[1:Language = $session.system_language].DocumentStatusName AS DocumentStatusName,
  cast( ObjLink.DocLinkDirectionIsActive as char1 preserving type ) AS DocLinkDirectionIsActive,
  _Attachment.FileName AS FileName,
  _Attachment.FileSize AS FileSize,
  _Attachment.WorkstationApplication AS WorkstationApplication,
  _Attachment.MimeType AS MimeType,
  _Attachment.StorageCategory AS StorageCategory,
  _Attachment.IsOriginalVersionActive AS IsOriginalVersionActive,
  _Attachment.OriginalIsProtected AS OriginalIsProtected,
  _Attachment.DocumentTitle AS DocumentTitle,
  _Attachment.DocumentFormat AS DocumentFormat,
  _Attachment.LogicalDocument AS LogicalDocument,
  _Attachment.LogicalDocumentClass AS LogicalDocumentClass,
  _Attachment.PhysicalDocumentClass AS PhysicalDocumentClass,
  _Attachment.CreationDateTime AS CreationDateTime,
  _Attachment.CreatedByUser AS CreatedByUser,
  _Attachment.ChangedDateTime AS ChangedDateTime,
  _Attachment.LastChangedByUser AS LastChangedByUser,
  _Attachment.OriginalCheckedOutTime AS OriginalCheckedOutTime,
  _Attachment.OriginalCheckedOutUser AS OriginalCheckedOutUser,
  _Attachment.LogicalDocumentIsReference AS LogicalDocumentIsReference,
  _Attachment.PhysicalDocTechnicalStatus AS PhysicalDocTechnicalStatus,
  _Attachment.OriginalType AS OriginalType,
  _Attachment.DocumentIndex AS DocumentIndex,
  _Attachment.InternalComment AS InternalComment,
  _Document.DocumentInfoRecord AS DocumentInfoRecord
FROM I_DocumentInfoRecordObjectLink AS ObjLink
LEFT OUTER JOIN I_DocumentInfoRecord AS _Document ON DocumentInfoRecordDocType = _Document.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _Document.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _Document.DocumentInfoRecordDocVersion AND DocumentInfoRecordDocPart = _Document.DocumentInfoRecordDocPart  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordAttachment AS _Attachment ON DocumentInfoRecordDocType = _Attachment.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _Attachment.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _Attachment.DocumentInfoRecordDocVersion AND DocumentInfoRecordDocPart = _Attachment.DocumentInfoRecordDocPart  -- association [0..*]
;

Learn More