I_FldLogsDocFlwInbDeliv

@AbapCatalog.sqlViewName: 'IFLDFIBD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Field Logistics : Inbound Delivery'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #M
define view I_FldLogsDocFlwInbDeliv
  as select from            I_PurchasingDocumentItem
//  Start - Added Performance Improvement

  left outer to one join  I_PurchaseRequisitionItemBasic as _requisition on I_PurchasingDocumentItem.PurchaseRequisition     = _requisition.PurchaseRequisition
                                                                        and I_PurchasingDocumentItem.PurchaseRequisitionItem = _requisition.PurchaseRequisitionItem
//  End - Added Performance Improvement  

  // Inbound delivery

    left outer to one join  I_DeliveryDocumentItem         as _DeliveryDocumentItem on  I_PurchasingDocumentItem.PurchasingDocument     = _DeliveryDocumentItem.ReferenceSDDocument
                                                                                    and I_PurchasingDocumentItem.PurchasingDocumentItem = substring(
      _DeliveryDocumentItem.ReferenceSDDocumentItem, 2, 5
    )
  //sp13 changes, I354124

//Start - Comment for performance

//    left outer to many join I_FldLogsExtLinksStkTranspReqn as mmdoc                 on  mmdoc.RefPurchaseRequisition     = I_PurchasingDocumentItem.PurchaseRequisition

//                                                                                    and mmdoc.RefPurchaseRequisitionItem = I_PurchasingDocumentItem.PurchaseRequisitionItem

//End - Comment for performance

//  Start - Added for Performance Improvement

    left outer to many join I_ExternalRefForPurgDoc as mmdoc on mmdoc.PurchasingDocumentUniqueID  = _requisition.PurchaseReqnItemUniqueID
                                                            and mmdoc.SAPObjectNodeType           = 'StockTransportRequisition'
                                                            and mmdoc.LinkType                    = 'SS'
                                                            and mmdoc.PurgDocExternalReference    is not initial
                                                            and mmdoc.PurgDocExtReferenceNodeType is initial
//  End - Added for Performance Improvement

{
  key  I_PurchasingDocumentItem.PurchasingDocument,
  key  I_PurchasingDocumentItem.PurchasingDocumentItem,
  key  DeliveryDocument,
  key  _DeliveryDocumentItem.DeliveryDocumentItem,
       I_PurchasingDocumentItem.PurchasingDocumentCategory,
       _PurchasingDocument.PurchasingProcessingStatus                      as PurchasingProcessingStatus,
       DeliveryDocumentItemCategory,
       _DeliveryDocumentItem ._DeliveryDocument.OverallGoodsMovementStatus as OverallGoodsMovementStatus,
       _DeliveryDocumentItem ._DeliveryDocument.DeliveryDocumentType       as DeliveryDocumentType,
//       I_PurchasingDocumentItem.PurchaseRequisition                        as ReferenceDocument,

//       I_PurchasingDocumentItem.PurchaseRequisitionItem                    as RefPurchaseRequisitionItem,

       I_PurchasingDocumentItem.PurchasingDocumentItemCategory,
       //Sp13changes, I354124

       case
// Start - Comment for performance       

//       when mmdoc.RefPurchaseRequisition is not initial

//       then cast (mmdoc.PurchaseRequisition as vdm_purchaserequisition preserving type )

// End - Comment for performance

// Start - Add for performance

       when mmdoc.PurchasingDocumentUniqueID is not initial
       then cast (substring( mmdoc.PurgDocExternalReference, 1, 10) as vdm_purchaserequisition preserving type )
// End - Add for performance       

       else cast(I_PurchasingDocumentItem.PurchaseRequisition as vdm_purchaserequisition preserving type )
       end                                                                 as ReferenceDocument,
       case
// Start - Comment for performance       

//       when mmdoc.RefPurchaseRequisitionItem is not initial

//       then cast (mmdoc.PurchaseRequisitionItem as vdm_purchaserequisitionitem preserving type )

// End - Comment for performance

// Start - Add for performance

       when mmdoc.PurchasingDocumentUniqueID is not initial
       then cast (substring( mmdoc.PurgDocExternalReference, 11, 15) as vdm_purchaserequisitionitem )
// Start - Add for performance       

       else cast(I_PurchasingDocumentItem.PurchaseRequisitionItem as vdm_purchaserequisitionitem preserving type )
       end                                                                 as RefPurchaseRequisitionItem
}
where
  DeliveryDocument is not null
//DeliveryDocumentItemCategory = 'ELN' // Inbound Delivery

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTITEM",
"I_EXTERNALREFFORPURGDOC",
"I_PURCHASEREQUISITIONITEMBASIC",
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/