I_ShiftNoteAttachment

DDL: I_SHIFTNOTEATTACHMENT Type: view_entity COMPOSITE
28 Fields 2 Data Sources

Shift Note Attachment

I_ShiftNoteAttachment is a Composite CDS View that provides data about "Shift Note Attachment" in SAP S/4HANA. It reads from 2 data sources (I_DocumentInfoRecordAttachment, I_ShiftNoteDocumentLink) and exposes 28 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocVersion, DocumentInfoRecordDocNumber, DocumentInfoRecordDocPart, DocumentIndex.

Data Sources (2)

SourceAliasJoin Type
I_DocumentInfoRecordAttachment attachm inner
I_ShiftNoteDocumentLink doclink from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Shift Note Attachment view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType I_DocumentInfoRecordAttachment DocumentInfoRecordDocType Document Type
KEY DocumentInfoRecordDocVersion I_DocumentInfoRecordAttachment DocumentInfoRecordDocVersion Doc. Version
KEY DocumentInfoRecordDocNumber I_DocumentInfoRecordAttachment DocumentInfoRecordDocNumber Document
KEY DocumentInfoRecordDocPart I_DocumentInfoRecordAttachment DocumentInfoRecordDocPart Document Part
KEY DocumentIndex I_DocumentInfoRecordAttachment DocumentIndex Counter
KEY FileUUID
KEY PhysicalDocument I_DocumentInfoRecordAttachment PhysicalDocument Phys. Document
CreationDateTime
CreatedByUser I_DocumentInfoRecordAttachment CreatedByUser User Name
ChangedDateTime
LastChangedByUser I_DocumentInfoRecordAttachment LastChangedByUser User Name
OriginalCheckedOutDateTime I_DocumentInfoRecordAttachment OriginalCheckedOutTime Time Stamp
OriginalCheckedOutUser I_DocumentInfoRecordAttachment OriginalCheckedOutUser Agent
FileName
FileSize I_DocumentInfoRecordAttachment FileSize Safety Data Sheet File Size
WorkstationApplication I_DocumentInfoRecordAttachment WorkstationApplication Applic.
MimeType I_DocumentInfoRecordAttachment MimeType MIMETYPE
StorageCategory I_DocumentInfoRecordAttachment StorageCategory Category
OriginalIsProtected
DocumentTitle I_DocumentInfoRecordAttachment DocumentTitle Title
DocumentFormat I_DocumentInfoRecordAttachment DocumentFormat Document format
LogicalDocument I_DocumentInfoRecordAttachment LogicalDocument Log. document
LogicalDocumentClass I_DocumentInfoRecordAttachment LogicalDocumentClass LOIO class
PhysicalDocumentClass I_DocumentInfoRecordAttachment PhysicalDocumentClass
LogicalDocumentIsReference I_DocumentInfoRecordAttachment LogicalDocumentIsReference
OriginalType I_DocumentInfoRecordAttachment OriginalType Original type
PhysicalDocTechnicalStatus I_DocumentInfoRecordAttachment PhysicalDocTechnicalStatus Tech. Status
InternalComment I_DocumentInfoRecordAttachment InternalComment Comment

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_ShiftNoteAttachment.
-- 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 I_ShiftNoteAttachment AS
SELECT
  attachm.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  attachm.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  attachm.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  attachm.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  attachm.DocumentIndex AS DocumentIndex,
  cast(attachm.FileUUID as edoc_file_guid preserving type) AS FileUUID,
  attachm.PhysicalDocument AS PhysicalDocument,
  cast(attachm.CreationDateTime as hp_created_at preserving type) AS CreationDateTime,
  attachm.CreatedByUser AS CreatedByUser,
  cast(attachm.ChangedDateTime as hp_changed_at preserving type) AS ChangedDateTime,
  attachm.LastChangedByUser AS LastChangedByUser,
  attachm.OriginalCheckedOutTime AS OriginalCheckedOutDateTime,
  attachm.OriginalCheckedOutUser AS OriginalCheckedOutUser,
  cast(attachm.FileName as filen_type preserving type) AS FileName,
  attachm.FileSize AS FileSize,
  attachm.WorkstationApplication AS WorkstationApplication,
  attachm.MimeType AS MimeType,
  attachm.StorageCategory AS StorageCategory,
  cast(attachm.OriginalIsProtected as pp_cvflag preserving type) AS OriginalIsProtected,
  attachm.DocumentTitle AS DocumentTitle,
  attachm.DocumentFormat AS DocumentFormat,
  attachm.LogicalDocument AS LogicalDocument,
  attachm.LogicalDocumentClass AS LogicalDocumentClass,
  attachm.PhysicalDocumentClass AS PhysicalDocumentClass,
  attachm.LogicalDocumentIsReference AS LogicalDocumentIsReference,
  attachm.OriginalType AS OriginalType,
  attachm.PhysicalDocTechnicalStatus AS PhysicalDocTechnicalStatus,
  attachm.InternalComment AS InternalComment
FROM I_ShiftNoteDocumentLink AS doclink
INNER JOIN I_DocumentInfoRecordAttachment AS attachm ON /* join condition not captured in parsed metadata */
;

Learn More