I_FldLogsDocFlwPurDocs

@AbapCatalog.sqlViewName: 'IFLDFPR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #M
@EndUserText.label: 'Field Logistics:DocFlow Purchasing Document'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
define view I_FldLogsDocFlwPurDocs
  // Purchase Requisition

  as select from            eban                           as Purchaserequisitionitem
  // Purchase Order Item

    left outer to many join ekpo                           as PurchaseOrderItem on  Purchaserequisitionitem.banfn = PurchaseOrderItem.banfn
                                                                                and Purchaserequisitionitem.bnfpo = PurchaseOrderItem.bnfpo
  // Purchase Order

    left outer to many join ekko                           as PurchaseOrder     on Purchaserequisitionitem.ebeln = PurchaseOrder.ebeln

  //sp13 changes, I354124

// Start - Commented for performance

//    left outer to many join I_FldLogsExtLinksStkTranspReqn as mmdoc             on  mmdoc.RefPurchaseRequisition     = Purchaserequisitionitem.banfn

//                                                                                and mmdoc.RefPurchaseRequisitionItem = Purchaserequisitionitem.bnfpo

// End - Commented for performance

//  Start - Added for Performance Improvement

    left outer to many join I_ExternalRefForPurgDoc as mmdoc on mmdoc.PurchasingDocumentUniqueID  = Purchaserequisitionitem.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       cast (Purchaserequisitionitem.banfn as vdm_purchaserequisition preserving type )     as PurchaseRequisition,
  key       cast (Purchaserequisitionitem.bnfpo as vdm_purchaserequisitionitem preserving type ) as PurchaseRequisitionItem,
  key       PurchaseOrderItem.ebeln                                                              as PurchasingDocument,
  key       PurchaseOrderItem.ebelp                                                              as PurchasingDocumentItem,
            Purchaserequisitionitem.bstyp                                                        as PurchasingDocumentCategory,
            Purchaserequisitionitem.bsart                                                        as PurchaseRequisitionType,
            Purchaserequisitionitem.pstyp                                                        as PurchasingDocumentItemCategory,
            Purchaserequisitionitem.matnr                                                        as Material,
            Purchaserequisitionitem.fldlogssupplyprocess                                         as FldLogsSupplyProcess,
            cast(PurchaseOrder.bstyp as char4)                                                   as SubsequentDocumentCategory,
            Purchaserequisitionitem.banpr                                                        as PurReqnReleaseStatus,
            PurchaseOrder.procstat                                                               as PurchasingProcessingStatus,
            Purchaserequisitionitem.iseopblocked                                                 as IsEndOfPurposeBlocked,
            //Sp13changes, I354124

            case
// Start - Commented for performance            

//            when mmdoc.RefPurchaseRequisition is not initial

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

// End - Commented for performance

// Start - Add for performance

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

            else cast(Purchaserequisitionitem.banfn as vdm_purchaserequisition preserving type )
            end                                                                                  as ReferenceDocument,
            case
// Start - Commented for performance            

//            when mmdoc.RefPurchaseRequisitionItem is not initial

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

// End - Commented 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(Purchaserequisitionitem.bnfpo as vdm_purchaserequisitionitem preserving type )
            end                                                                                  as RefPurchaseRequisitionItem
}

//where

//  PurchaseOrder.bsart = 'NB'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EXTERNALREFFORPURGDOC",
"EBAN",
"EKKO",
"EKPO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/