P_SFINotAssldTrcblComponent1

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'SFI Not Assembled Traceable Components'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_SFINotAssldTrcblComponent1
  as select from           I_OpActyInstanceComponent     as OpActyInstanceComponent
    inner join             I_ShopFloorItemStatus         as ShopFloorItemStatus       on  ShopFloorItemStatus.OpActyNtwkInstance = OpActyInstanceComponent.OpActyNtwkInstance
                                                                                      and ShopFloorItemStatus.OpActyNtwkElement  = OpActyInstanceComponent.OpActyNtwkElement
    inner join             I_MatlPlntCompAssembleControl as MfgOrderProductPlant      on  MfgOrderProductPlant.Product = OpActyInstanceComponent.Material
                                                                                      and MfgOrderProductPlant.Plant   = OpActyInstanceComponent.Plant
    inner to one join      I_OrderOperation              as OrderOperation            on  OrderOperation.OrderInternalID          = OpActyInstanceComponent.OrderInternalBillOfOperations
                                                                                      and OrderOperation.OrderOperationInternalID = OpActyInstanceComponent.OrderIntBillOfOperationsItem
    inner join             I_OpActyNtwkInstanceBasic     as OpActyNtwkInstanceBasic   on OpActyNtwkInstanceBasic.OpActyNtwkInstance = OpActyInstanceComponent.OpActyNtwkInstance
    left outer to one join I_SFIAtOpActyAssyByComponent  as MfgOrderComponentAssembly on  MfgOrderComponentAssembly.OpActyNtwkInstance    = OpActyInstanceComponent.OpActyNtwkInstance
                                                                                      and MfgOrderComponentAssembly.OpActyNtwkElement     = OpActyInstanceComponent.OpActyNtwkElement
                                                                                      and MfgOrderComponentAssembly.Reservation           = OpActyInstanceComponent.Reservation
                                                                                      and MfgOrderComponentAssembly.ReservationItem       = OpActyInstanceComponent.ReservationItem
                                                                                      and MfgOrderComponentAssembly.RecordType            = OpActyInstanceComponent.RecordType
                                                                                      and MfgOrderComponentAssembly.AssemblyShopFloorItem = ShopFloorItemStatus.ShopFloorItem
    left outer to one join I_OrderComponent              as OrderComponent            on  OrderComponent.Reservation     = OpActyInstanceComponent.Reservation
                                                                                      and OrderComponent.ReservationItem = OpActyInstanceComponent.ReservationItem
                                                                                      and OrderComponent.RecordType      = OpActyInstanceComponent.RecordType
{
      @ObjectModel.foreignKey.association: '_ShopFloorItem'
  key ShopFloorItemStatus.ShopFloorItem                                                                                     as ShopFloorItem,
      @ObjectModel.foreignKey.association: '_OpActyNtwkInstance'
  key OpActyInstanceComponent.OpActyNtwkInstance                                                                            as OpActyNtwkInstance,
      @ObjectModel.foreignKey.association: '_OperationActivityInstance'
  key OpActyInstanceComponent.OpActyNtwkElement                                                                             as OpActyNtwkElement,
      @ObjectModel.foreignKey.association: '_ReservationHeader'
  key OpActyInstanceComponent.Reservation                                                                                   as Reservation,
  key OpActyInstanceComponent.ReservationItem                                                                               as ReservationItem,
  key OpActyInstanceComponent.RecordType                                                                                    as RecordType,
      OpActyInstanceComponent.Material                                                                                      as Material,
      OpActyInstanceComponent._Material._Text[1: Language=$session.system_language].MaterialName                            as MaterialName,
      OpActyInstanceComponent.Plant                                                                                         as Plant,
      OpActyInstanceComponent.StorageLocation                                                                               as StorageLocation,
      OpActyInstanceComponent.MatlCompInstceAssyIsRequired                                                                  as MatlCompInstceAssyIsRequired,
      OpActyInstanceComponent.BaseUnit                                                                                      as BaseUnit,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      cast(round(fltp_to_dec( OpActyInstanceComponent.MfgOrderComponentUsageNetQty as abap.dec(13,4) ), 3)
        as bdmng )                                                                                                          as RequiredQuantity,
      OpActyInstanceComponent.EntryUnit                                                                                     as EntryUnit,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      cast( case when  MfgOrderComponentAssembly.MaterialComponentQuantity is null
            then 0
            else MfgOrderComponentAssembly.MaterialComponentQuantity
            end as bdmng )                                                                                                  as MaterialComponentQuantity,
      OpActyInstanceComponent.Batch                                                                                         as Batch,
      MfgOrderProductPlant.MatlCompAssembleControl                                                                          as MatlCompAssembleControl,
      MfgOrderProductPlant._MatlCompAssembleControl._Text[1: Language=$session.system_language].MatlCompAssembleControlName as MatlCompAssembleControlName,
      OpActyInstanceComponent.ManufacturingOrder                                                                            as ManufacturingOrder,
      ---Operation details
      OpActyInstanceComponent.OrderInternalBillOfOperations                                                                 as OrderInternalBillOfOperations,
      OpActyInstanceComponent.OrderIntBillOfOperationsItem                                                                  as OrderIntBillOfOperationsItem,
      OrderOperation.Operation_2                                                                                            as ManufacturingOrderOperation,
      OrderOperation.OperationText                                                                                          as MfgOrderOperationText,
      ShopFloorItemStatus._ShopFloorItem._MfgOrder.EffectivityParameterVariant                                              as EffectivityParameterVariant,
      ---Operation Activity details
      OpActyNtwkInstanceBasic.OperationActivityNetwork                                                                      as OperationActivityNetwork,
      OpActyNtwkInstanceBasic.OpActyNtwkVersionCounter                                                                      as OpActyNtwkVersionCounter,
      ShopFloorItemStatus.StatusAndActionSchema                                                                             as StatusAndActionSchema,
      ShopFloorItemStatus.StatusAndActionSchemaStatus                                                                       as StatusAndActionSchemaStatus,
      ShopFloorItemStatus.SFIOpActyStsLastChgdByDoc                                                                         as SFIOpActyStsLastChgdByDoc,
      ShopFloorItemStatus._SASStatus.SASStatusCategory                                                                      as SASStatusCategory,
      ShopFloorItemStatus._SASStatus._Text[1: Language=$session.system_language].SASStatusName                              as SASStatusName,
      ---BOM details
      OpActyInstanceComponent.BillOfMaterialCategory                                                                        as BillOfMaterialCategory,
      cast( OpActyInstanceComponent.BillOfMaterialInternalID as mpe_exec_stnum preserving type )                            as BillOfMaterialInternalID,
      OpActyInstanceComponent.BOMItem                                                                                       as BOMItem,
      OpActyInstanceComponent.BOMItemInternalChangeCount                                                                    as BOMItemInternalChangeCount,
      OpActyInstanceComponent.BillOfMaterialVariant                                                                         as BillOfMaterialVariant,
      OpActyInstanceComponent.BillOfMaterialVersion                                                                         as BillOfMaterialVersion,
      cast('' as stlan preserving type )                                                                                    as BillOfMaterialVariantUsage,
      OpActyInstanceComponent.BOMItemCategory                                                                               as BOMItemCategory,
      OpActyInstanceComponent.InheritedBOMItemNode                                                                          as InheritedBOMItemNode,
      OrderComponent._BillOfMaterialItem.BillOfMaterialItemUUID                                                             as BillOfMaterialItemUUID,
      OpActyInstanceComponent.BillOfMaterialItemNumber                                                                      as BillOfMaterialItemNumber,
      ---MRS details
      OpActyInstanceComponent.MfgRefStrucBOMLeafAssgmtUUID                                                                  as MfgRefStrucBOMLeafAssgmtUUID,
      OpActyInstanceComponent.MfgRefStructureItemDetailUUID                                                                 as MfgRefStructureItemDetailUUID,
      OpActyInstanceComponent.MfgRefStrucItmDetIsContextual                                                                 as MfgRefStrucItmDetIsContextual,

      ---Associations
      OpActyInstanceComponent._OpActyNtwkInstance,
      OpActyInstanceComponent._OpActyNtwkInstanceBasic,
      OpActyInstanceComponent._OperationActivityInstance,
      OpActyInstanceComponent._ReservationHeader,
      ShopFloorItemStatus._ShopFloorItem,
      ShopFloorItemStatus._SASSchema,
      ShopFloorItemStatus._SASStatus,
      ShopFloorItemStatus._SASStatusText,
      ShopFloorItemStatus._SFIOpActyStsLastChgdByDoc
}
where
  (
        ShopFloorItemStatus._SASStatus.SASStatusCategory     =  3 --Completed
    or  ShopFloorItemStatus._SASStatus.SASStatusCategory     =  4 --Skipped
  )
  and(
        OpActyInstanceComponent.MatlCompIsMarkedForBackflush <> 'X'
    and OpActyInstanceComponent.IsBulkMaterialComponent      <> 'X'
  )