I_DocInfoRecdAttchDetForBusObj

DDL: I_DOCINFORECDATTCHDETFORBUSOBJ SQL: ICVOBJFILES Type: view COMPOSITE
16 Fields 2 Data Sources 4 Associations

Documents with files for Business Object

I_DocInfoRecdAttchDetForBusObj is a Composite CDS View that provides data about "Documents with files for Business Object" in SAP S/4HANA. It reads from 2 data sources (I_DocInfoRecdObjTypeToDocType, I_DocumentInfoRecordAttachment) and exposes 16 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart, DocumentIndex. It has 4 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_DocInfoRecdObjTypeToDocType _DocType right_outer
I_DocumentInfoRecordAttachment Attachment from

Associations (4)

CardinalityTargetAliasCondition
[1] I_DocumentInfoRecordLgclDocID AttachmentDescr Attachment.LogicalDocument = AttachmentDescr.LogicalDocument and AttachmentDescr.Language = $session.system_language --
[1..1] I_DocumentInfoRecordCntntMgmt _Document $projection.DocumentInfoRecordDocType = _Document.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocPart = _Document.DocumentInfoRecordDocPart and $projection.DocumentInfoRecordDocNumber = _Document.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _Document.DocumentInfoRecordDocVersion
[0..*] I_DocumentInfoRecordDocTypeT _DocumentTypeText $projection.DocumentInfoRecordDocType = _DocumentTypeText.DocumentInfoRecordDocType
[1..1] I_DocumentInfoRecord _DocInfo $projection.DocumentInfoRecordDocType = _DocInfo.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocPart = _DocInfo.DocumentInfoRecordDocPart and $projection.DocumentInfoRecordDocNumber = _DocInfo.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _DocInfo.DocumentInfoRecordDocVersion

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICVOBJFILES view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Documents with files for Business Object view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType I_DocInfoRecdObjTypeToDocType DocumentInfoRecordDocType Document Type
KEY DocumentInfoRecordDocNumber I_DocumentInfoRecordAttachment DocumentInfoRecordDocNumber Document
KEY DocumentInfoRecordDocVersion I_DocumentInfoRecordAttachment DocumentInfoRecordDocVersion Doc. Version
KEY DocumentInfoRecordDocPart I_DocumentInfoRecordAttachment DocumentInfoRecordDocPart Document Part
KEY DocumentIndex I_DocumentInfoRecordAttachment DocumentIndex Counter
KEY FileUUID I_DocumentInfoRecordAttachment FileUUID UUID
KEY PhysicalDocument I_DocumentInfoRecordAttachment PhysicalDocument Phys. Document
KEY LinkedSAPObject I_DocInfoRecdObjTypeToDocType LinkedSAPObject Object
FileName I_DocumentInfoRecordAttachment FileName URL or Filenam Path
FileDescription AttachmentDescr FileDescription Description
WorkstationApplication I_DocumentInfoRecordAttachment WorkstationApplication Applic.
DocumentDescription _Document DocumentDescription Doc. Name
DocumentInfoRecord _DocInfo DocumentInfoRecord Document
_DocumentTypeText _DocumentTypeText
_Document _Document
_DocInfo _DocInfo

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_DocInfoRecdAttchDetForBusObj.
-- 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: ICVOBJFILES

CREATE VIEW I_DocInfoRecdAttchDetForBusObj AS
SELECT
  _DocType.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  Attachment.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  Attachment.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  Attachment.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  Attachment.DocumentIndex AS DocumentIndex,
  Attachment.FileUUID AS FileUUID,
  Attachment.PhysicalDocument AS PhysicalDocument,
  _DocType.LinkedSAPObject AS LinkedSAPObject,
  Attachment.FileName AS FileName,
  AttachmentDescr.FileDescription AS FileDescription,
  Attachment.WorkstationApplication AS WorkstationApplication,
  _Document.DocumentDescription AS DocumentDescription,
  _DocInfo.DocumentInfoRecord AS DocumentInfoRecord
FROM I_DocumentInfoRecordAttachment AS Attachment
RIGHT OUTER JOIN I_DocInfoRecdObjTypeToDocType AS _DocType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DocumentInfoRecordLgclDocID AS AttachmentDescr ON Attachment.LogicalDocument = AttachmentDescr.LogicalDocument AND AttachmentDescr.Language = $session.system_language  -- association [1]
LEFT OUTER JOIN I_DocumentInfoRecordCntntMgmt AS _Document ON DocumentInfoRecordDocType = _Document.DocumentInfoRecordDocType AND DocumentInfoRecordDocPart = _Document.DocumentInfoRecordDocPart AND DocumentInfoRecordDocNumber = _Document.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _Document.DocumentInfoRecordDocVersion  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocTypeT AS _DocumentTypeText ON DocumentInfoRecordDocType = _DocumentTypeText.DocumentInfoRecordDocType  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecord AS _DocInfo ON DocumentInfoRecordDocType = _DocInfo.DocumentInfoRecordDocType AND DocumentInfoRecordDocPart = _DocInfo.DocumentInfoRecordDocPart AND DocumentInfoRecordDocNumber = _DocInfo.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _DocInfo.DocumentInfoRecordDocVersion  -- association [1..1]
;

Learn More