I_FldLogsPrdcssrDocRemote

@AbapCatalog.sqlViewName: 'IFLPREDOC_R'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Field Logistics Predecessor documents'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #M
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
define view I_FldLogsPrdcssrDocRemote
  as select from           I_PurchasingDocumentItem       as STO
    left outer to one join I_FldLogsExtLinksForPurDocs    as doclinks              on  doclinks.StockTransportOrder     = STO.PurchasingDocument
                                                                                   and doclinks.StockTransportOrderItem = STO.PurchasingDocumentItem
    left outer to one join I_FldLogsSuplrReceiptItem      as _SupplierItem         on  STO.PurchasingDocument     = _SupplierItem.PurchasingDocument
                                                                                   and STO.PurchasingDocumentItem = substring(
      _SupplierItem.FldLogsPurOrdItem, 12, 16
    )
  // Delivery

    left outer to one join I_FldLogsDeliveryDocItem       as _DeliveryDocumentItem on  STO.PurchasingDocument     = _DeliveryDocumentItem.ReferenceSDDocument
                                                                                   and STO.PurchasingDocumentItem = _DeliveryDocumentItem.PurchasingDocumentItem
  // EWM Delivery

    left outer to one join I_FldLogsEWMOutbDelivOrdItm    as _EWM_OUTBDELIV        on  _DeliveryDocumentItem.DeliveryDocument     = _EWM_OUTBDELIV.DeliveryDocument
                                                                                   and _DeliveryDocumentItem.DeliveryDocumentItem = _EWM_OUTBDELIV.DeliveryDocumentItem
  // EWM Delivery Warehouse Task

    left outer to one join I_FldLogsWarehouseTask         as _EWM_WarehouseTask    on  _EWM_WarehouseTask.EWMWarehouse              = _EWM_OUTBDELIV.EWMWarehouse
                                                                                   and _EWM_WarehouseTask.ReferenceDocumentUUID     = _EWM_OUTBDELIV.OutboundDeliveryOrderUUID
                                                                                   and _EWM_WarehouseTask.ReferenceDocumentItemUUID = _EWM_OUTBDELIV.OutboundDeliveryOrderItemUUID
                                                                                   and _EWM_WarehouseTask.SourceHandlingUnit        is initial
    left outer to one join I_FldLogsExtLinksStkTranspReqn as _SP13                 on  STO.PurchaseRequisition     is not initial
                                                                                   and STO.PurchaseRequisition     = _SP13.RefPurchaseRequisition
                                                                                   and STO.PurchaseRequisitionItem = _SP13.RefPurchaseRequisitionItem
    left outer to one join I_MaterialDocumentRecord       as _IBD                  on  _IBD.MaterialDocument     = doclinks.MaterialDocument
                                                                                   and _IBD.MaterialDocumentItem = doclinks.MaterialDocumentItem
                                                                                   and _IBD.MaterialDocumentYear = doclinks.MaterialDocumentYear
    left outer to one join I_FldLogsEWMDelivDocItem       as _EWM_InbDeliveryItem  on  _IBD.DeliveryDocument     = _EWM_InbDeliveryItem.DeliveryDocument
                                                                                   and _IBD.DeliveryDocumentItem = _EWM_InbDeliveryItem.DeliveryDocumentItem

  // EWM Inbound Delivery - Reference Document

  //    left outer to one join I_EWM_DeliveryReferenceDoc_2   as _EWM_RefDoc           on  _EWM_RefDoc.EWMRefDeliveryDocumentNumber = _DeliveryDocumentItem.DeliveryDocument

  //                                                                                   and _EWM_RefDoc.EWMRefDeliveryDocumentItem   = _DeliveryDocumentItem.EWMRefDeliveryDocumentItem

  //                                                                                   and _EWM_RefDoc.EWMReferenceDocumentCategory = 'ERO'

  //                                                                                   and _EWM_RefDoc.EWMDeliveryDocumentCategory  = 'PDI'


    left outer to one join I_FldLogsEWMRefDoc             as _FldLogsEWMRefDoc     on  _FldLogsEWMRefDoc.EWMRefDeliveryDocumentNumber = _DeliveryDocumentItem.DeliveryDocument
                                                                                   and _FldLogsEWMRefDoc.EWMRefDeliveryDocumentItem   = _DeliveryDocumentItem.EWMRefDeliveryDocumentItem
                                                                                   and _FldLogsEWMRefDoc.EWMDeliveryDocumentCategory  = 'PDI'

    left outer to one join I_FldLogsEWMDelivDocItem       as _EWM_InbDel           on  _EWM_InbDel.InboundDeliveryUUID     = _FldLogsEWMRefDoc.DeliveryUUID
                                                                                   and _EWM_InbDel.InboundDeliveryItemUUID = _FldLogsEWMRefDoc.DeliveryItemUUID
  //EWM Inbound Delivery Number

  //    left outer to one join I_EWM_InbDeliveryItem          as _EWM_IBD              on  STO.PurchasingDocument     = substring(_EWM_IBD.PurchasingDocument, 26, 10)

  //    left outer to one join I_EWM_InbDeliveryItem          as _EWM_IBD              on  STO.PurchasingDocument     = _EWM_IBD.PurchasingDocument

  //                                                                                   and STO.PurchasingDocumentItem = substring(_EWM_IBD.PurchasingDocumentItem, 6, 5 )

  // EWM Delivery Warehouse Task

    left outer to one join I_FldLogsWarehouseTask         as _WarehouseTask        on  _EWM_InbDeliveryItem.EWMWarehouse        = _WarehouseTask.EWMWarehouse
                                                                                   and _WarehouseTask.ReferenceDocumentUUID     = _EWM_InbDeliveryItem.InboundDeliveryUUID
                                                                                   and _WarehouseTask.ReferenceDocumentItemUUID = _EWM_InbDeliveryItem.InboundDeliveryItemUUID
                                                                                   and _WarehouseTask.SourceHandlingUnit        is initial
  association [0..1] to I_FldLogsProcRcptMaintOrd as _Order on(
    _Order.PurchaseRequisition                                                                   = $projection.ReferenceDocument
    and _Order.PurchaseRequisitionItem                                                           = $projection.RefPurchaseRequisitionItem
  )
                                                            or(
                                                              _Order.PurchaseRequisition         = $projection.PurchaseRequisition
                                                              and _Order.PurchaseRequisitionItem = $projection.PurchaseRequisitionItem
                                                            )


{
      //STO number

  key STO.PurchasingDocument,
  key STO.PurchasingDocumentItem,
  key case
        when _SupplierItem.DeliveryDocument is not null
        then _SupplierItem.DeliveryDocument
        else   _DeliveryDocumentItem.DeliveryDocument       end  as OutboundDelivery,
  key case
        when _SupplierItem.DeliveryDocumentItem is not null
          //then cast('000000'  as posnr_vl )

          then _SupplierItem.DeliveryDocumentItem
        else  _DeliveryDocumentItem.DeliveryDocumentItem  end    as OutboundDeliveryItem,
  key case
        when _SupplierItem.DeliveryDocumentItem is not null
          then  _SupplierItem.FldLogsSuplrItemUUID
        else  hextobin( '00000000000000000000000000000000' ) end as FldLogsSuplrItemUUID,
      case
        when _SupplierItem.PurchaseRequisition is not null
          then _SupplierItem.PurchaseRequisition
        else STO.PurchaseRequisition end                         as PurchaseRequisition,
      STO.PurchaseRequisitionItem,
      // End of  New Addition

      case when _SupplierItem.DeliveryDocument is not null
      then _SupplierItem.DeliveryDocument
      else _IBD.DeliveryDocument end                             as DeliveryDocument,
      //_IBD.DeliveryDocumentItem,

      case when _SupplierItem.DeliveryDocumentItem is not null
      then _SupplierItem.DeliveryDocumentItem
      else _IBD.DeliveryDocumentItem end                             as DeliveryDocumentItem,
      _IBD.MaterialDocument,
      _IBD.MaterialDocumentItem,
      _IBD.MaterialDocumentYear,
      case when _IBD.MaterialDocument is not initial
      then _IBD._PurchaseOrderItem.PurchaseRequisition
      else _SP13.PurchaseRequisition end                         as ReferenceDocument,
      _IBD._PurchaseOrderItem.PurchaseRequisitionItem            as RefPurchaseRequisitionItem,
      _EWM_OUTBDELIV.EWMOutboundDeliveryOrder,
      _EWM_WarehouseTask.WarehouseTask                           as FldLogsPickingWrhsTask,
      _IBD.PurchaseOrder                                         as PurchaseOrder,
      _IBD.PurchaseOrderItem,
      STO.PurchasingDocument                                     as StockTransportOrder,
      STO._PurchasingDocument.SupplyingPlant,
      //           _IBD.PurchasingDocumentItem,

      _EWM_InbDeliveryItem.InboundDeliveryUUID,
      _EWM_InbDeliveryItem.InboundDeliveryItemUUID,
      _WarehouseTask.WarehouseTask,
      _PurchasingDocument.PurchasingDocumentSubtype,
      _SupplierItem.MaintenanceOrder,
      _SupplierItem.Project,
      _SupplierItem.ProjectDemand,
      _SupplierItem._PPMTask.TaskName                            as ProjectDescription,
      _SupplierItem._ProjectDemand.ProjectDemandName,
      //EWM Inbound Delivery Details

      ltrim(_EWM_InbDel.EWMInboundDelivery, '0')                 as EWMInboundDelivery,
      _EWM_InbDel.EWMInboundDeliveryItem,
      //      ltrim(cast(_EWM_InbDel.DeliveryDocument as /scdl/dl_docno), '0')                   as EWMInboundDelivery,

      //      _EWM_RefDoc.EWMRefDeliveryDocumentItem                                             as EWMInboundDeliveryItem,

      //      _EWM_IBD.EWMInboundDelivery,

      //      _EWM_IBD.EWMInboundDeliveryItem,

      _Order
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FLDLOGSDELIVERYDOCITEM",
"I_FLDLOGSEWMDELIVDOCITEM",
"I_FLDLOGSEWMOUTBDELIVORDITM",
"I_FLDLOGSEWMREFDOC",
"I_FLDLOGSEXTLINKSFORPURDOCS",
"I_FLDLOGSEXTLINKSSTKTRANSPREQN",
"I_FLDLOGSSUPLRRECEIPTITEM",
"I_FLDLOGSWAREHOUSETASK",
"I_MATERIALDOCUMENTRECORD",
"I_PPM_TASK",
"I_PROJECTDEMAND",
"I_PURCHASEORDERITEM",
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_FLDLOGSPROCRCPTMAINTORD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/