I_FldLogsDocFlwGIForWrkOrd

@AbapCatalog.sqlViewName: 'IFLDFGIWO'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Field Logistics Doc Flow GI WorkOrder'
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_FldLogsDocFlwGIForWrkOrd
  as select from
  // Material document

                           I_MaterialDocumentRecord  as MatDoc
    left outer to one join I_FldLogsMaintenanceOrder as WO on  WO.MaintenanceOrder = MatDoc.OrderID
                                                           and WO.Reservation      = MatDoc.Reservation
                                                           and WO.ReservationItem  = MatDoc.ReservationItem

//     //Sp13 changes

//         left outer to many join I_FldLogsExtLinksStkTranspReqn as mmdoc                 on  mmdoc.RefPurchaseRequisition     = WO.ReferenceDocument

//                                                                                      and mmdoc.RefPurchaseRequisitionItem = WO.RefPurchaseRequisitionItem

//  

{
  key MaterialDocument              as MaterialDocument,
  key MaterialDocumentItem          as MaterialDocumentItem,
  key MaterialDocumentYear          as MaterialDocumentYear,
      WO.MaintenanceOrder           as MaintenanceOrder,
      WO.MaintenanceOrderComponent  as MaintenanceOrderComponent,
      WO.MaintenanceOrderOperation  as MaintenanceOrderOperation,
      WO.MaintenanceProcessingPhase,
      WO.ReferenceDocument          as PurchaseRequisition,
      WO.RefPurchaseRequisitionItem as PurchaseRequisitionItem,
//             case

//             when mmdoc.RefPurchaseRequisition is not initial

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

//             else cast( WO.ReferenceDocument as vdm_purchaserequisition preserving type )

//             end                                                                 as ReferenceDocument,

//             case

//             when mmdoc.RefPurchaseRequisitionItem is not initial

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

//             else cast(WO.RefPurchaseRequisitionItem as vdm_purchaserequisitionitem preserving type )

//             end                                                                 as RefPurchaseRequisitionItem,

      WO.PurchasingDocumentItemCategory,
      WO.PurchaseRequisitionType    as PurchaseRequisitionType,
      GoodsMovementType             as GoodsMovementType
}
// Issue to Workorder

where
  GoodsMovementType = '261';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FLDLOGSMAINTENANCEORDER",
"I_MATERIALDOCUMENTRECORD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/