P_AssldReltdCompSFINoInstce

@AbapCatalog.sqlViewName: 'PMPEASSRLTDSFINO'
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_AssldReltdCompSFINoInstce
  -- Fetch the current reservation instance
  as select from           I_OpActyComponentAssignment    as OpActyComponentAssignment
    inner join             P_MfgOrderCompAssyWthoutInstce as ReltdResvnAssemblyAggrgn on  ReltdResvnAssemblyAggrgn.Reservation        = OpActyComponentAssignment.RelatedReservation
                                                                                      and ReltdResvnAssemblyAggrgn.ReservationItem    = OpActyComponentAssignment.RelatedReservationItem
                                                                                      and ReltdResvnAssemblyAggrgn.RecordType         = OpActyComponentAssignment.RelatedRecordType
                                                                                      and ReltdResvnAssemblyAggrgn.OpActyNtwkInstance = OpActyComponentAssignment.RelatedOpActyNtwkInstance
                                                                                      and ReltdResvnAssemblyAggrgn.OpActyNtwkElement  = OpActyComponentAssignment.RelatedOpActyNtwkElement
    left outer to one join P_MfgOrderCompAssyWthoutInstce as DisassembledSerialNumber on  DisassembledSerialNumber.Reservation               =  OpActyComponentAssignment.Reservation
                                                                                      and DisassembledSerialNumber.ReservationItem           =  OpActyComponentAssignment.ReservationItem
                                                                                      and DisassembledSerialNumber.RecordType                =  OpActyComponentAssignment.RecordType
                                                                                      and DisassembledSerialNumber.OpActyNtwkInstance        =  OpActyComponentAssignment.OpActyNtwkInstance
                                                                                      and DisassembledSerialNumber.OpActyNtwkElement         =  OpActyComponentAssignment.OpActyNtwkElement
                                                                                      and DisassembledSerialNumber.AssemblyShopFloorItem     =  ReltdResvnAssemblyAggrgn.AssemblyShopFloorItem
                                                                                      and DisassembledSerialNumber.ShopFloorItem             =  ReltdResvnAssemblyAggrgn.ShopFloorItem
                                                                                      and DisassembledSerialNumber.Batch                     =  ReltdResvnAssemblyAggrgn.Batch
                                                                                      and DisassembledSerialNumber.Material                  =  ReltdResvnAssemblyAggrgn.Material
                                                                                      and DisassembledSerialNumber.Plant                     =  ReltdResvnAssemblyAggrgn.Plant
                                                                                      and DisassembledSerialNumber.MaterialComponentQuantity <> 0
{
  key OpActyComponentAssignment.Reservation,
  key OpActyComponentAssignment.ReservationItem,
  key OpActyComponentAssignment.RecordType,
  key OpActyComponentAssignment.OpActyNtwkInstance,
  key OpActyComponentAssignment.OpActyNtwkElement,
  key ReltdResvnAssemblyAggrgn.AssemblyShopFloorItem,
  key ReltdResvnAssemblyAggrgn.ShopFloorItem,
  key cast(HEXTOBIN('00000000000000000000000000000000') as dmu_guid16 preserving type) as OriglDgtlMockUpCharcsUUID,
      cast(HEXTOBIN('00000000000000000000000000000000') as dmu_guid16 preserving type) as ReltdOriglDgtlMockUpCharcsUUID,
      ReltdResvnAssemblyAggrgn.Material,
      ReltdResvnAssemblyAggrgn.Plant,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      ReltdResvnAssemblyAggrgn.MaterialComponentQuantity,
      @Semantics.unitOfMeasure: true
      ReltdResvnAssemblyAggrgn.MaterialBaseUnit,
      cast('' as vmp_ref_des)                                                          as ReferenceDesignatorValue,
      ReltdResvnAssemblyAggrgn.Batch,

      OpActyComponentAssignment._ReservationHeader,
      OpActyComponentAssignment._OpActyNtwkInstance,
      OpActyComponentAssignment._OperationActivityInstance,
      ReltdResvnAssemblyAggrgn._ParentShopFloorItem,
      ReltdResvnAssemblyAggrgn._MaterialBaseUnit,
      ReltdResvnAssemblyAggrgn._ShopFloorItem,
      ReltdResvnAssemblyAggrgn._BatchDistinct
}
where
      ReltdResvnAssemblyAggrgn.ShopFloorItem                 <> 0            -- Only assembled SFIs
  and ReltdResvnAssemblyAggrgn.MaterialComponentQuantity     <> 0            -- SFI has been assembled
  and OpActyComponentAssignment.RelatedReservation           <> '0000000000' -- No unplanned assemblies
  and OpActyComponentAssignment.MatlCompInstceAssyIsRequired =  ''           -- Only components without instances
  and DisassembledSerialNumber.ShopFloorItem                 is null         -- SFI has not yet been reassembled
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPACTYCOMPONENTASSIGNMENT",
"P_MFGORDERCOMPASSYWTHOUTINSTCE"
],
"ASSOCIATED":
[
"I_BATCHDISTINCT",
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE",
"I_RESERVATIONDOCUMENTHEADER",
"I_SHOPFLOORITEM",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_OPACTYCOMPONENTASSIGNMENT",
"P_MFGORDERCOMPASSYWTHOUTINSTCE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/