I_MfgOrderDocumentDataList

@AbapCatalog.sqlViewName: 'IPPMORDOCDATA'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Mfg Order Document (Data List)'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE

define view I_MfgOrderDocumentDataList
  as select from P_MfgOrderDocInfoRecdObjLink   as docl
    inner join   I_DocumentInfoRecordAttachment as orig on  orig.DocumentInfoRecordDocType    = docl.DocumentType
                                                        and orig.DocumentInfoRecordDocPart    = docl.DocumentPart
                                                        and orig.DocumentInfoRecordDocNumber  = docl.DocumentInfoRecord
                                                        and orig.DocumentInfoRecordDocVersion = docl.DocumentVersion

{
  key docl.ManufacturingOrder,
  key docl.DocumentType,
  key docl.DocumentInfoRecord,
  key docl.DocumentPart,
  key docl.DocumentVersion,
      // Original Key

  key orig.DocumentIndex,
  key orig.FileUUID,

      // Document Data

      docl.InternalDocumentStatus,

      // Original Data

      orig.InternalComment,
      orig.FileName,
      orig.WorkstationApplication,
      orig.MimeType,
      orig.FileSize,
      orig.StorageCategory,
      orig.OriginalType,
      orig.IsOriginalVersionActive,
      orig.OriginalIsProtected,

      // Mfg Order Data

      docl.MfgOrderLinkedObjType,
      docl.ManufacturingOrderCategory,
      docl.ManufacturingOrderItem,
      docl.ManufacturingOrderSequence,
      docl.ManufacturingOrderOperation,
      docl.OrderOperationInternalID
}