P_MfgOrdOpSerialNumberForSplit

DDL: P_MFGORDOPSERIALNUMBERFORSPLIT SQL: PMPEORDOPSERSPLT Type: view CONSUMPTION Package: MPE_EXEC_SFI

Serial Number that can be split at an Order Operation

P_MfgOrdOpSerialNumberForSplit is a Consumption CDS View that provides data about "Serial Number that can be split at an Order Operation" in SAP S/4HANA. It reads from 4 data sources (I_LogisticsOrderBasic, I_MfgOrdOpActiveInitialSFI, I_OrderOperationBasic, I_SerialNumberManufacturingOrd) and exposes 17 fields with key fields OrderInternalID, OrderOperationInternalID, ShopFloorItem, Material, SerialNumber. Part of development package MPE_EXEC_SFI.

4 data source(s) 17 fields

Data Sources (4)

SourceAliasJoin Type
I_LogisticsOrderBasic LogisticsOrderBasic inner
I_MfgOrdOpActiveInitialSFI MfgOrdOpActiveInitialSFI from
I_OrderOperationBasic OrderOperationBasic inner
I_SerialNumberManufacturingOrd SerialNumberManufacturingOrd union_all

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PMPEORDOPSERSPLT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Serial Number that can be split at an Order Operation view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID I_MfgOrdOpActiveInitialSFI OrderInternalID
KEY OrderOperationInternalID I_MfgOrdOpActiveInitialSFI OrderOperationInternalID
KEY ShopFloorItem I_MfgOrdOpActiveInitialSFI ShopFloorItem
KEY Material
KEY SerialNumber
ManufacturingOrder
ManufacturingOrderOperation I_MfgOrdOpActiveInitialSFI ManufacturingOrderOperation
Plant I_MfgOrdOpActiveInitialSFI Plant
OrderInternalID
KEY OrderOperationInternalID I_OrderOperationBasic OrderOperationInternalID
KEY ShopFloorItem
KEY Material I_SerialNumberManufacturingOrd Material
KEY SerialNumber I_SerialNumberManufacturingOrd SerialNumber
ManufacturingOrder I_SerialNumberManufacturingOrd ManufacturingOrder
ManufacturingOrderOperation I_OrderOperationBasic Operation
Plant I_OrderOperationBasic Plant
_OrderInternalID I_LogisticsOrderBasic _OrderInternalID 
@AbapCatalog.sqlViewName: 'PMPEORDOPSERSPLT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@EndUserText.label: 'Serial Number that can be split at an Order Operation'
define view P_MfgOrdOpSerialNumberForSplit
  as select from I_MfgOrdOpActiveInitialSFI as MfgOrdOpActiveInitialSFI
{
  key MfgOrdOpActiveInitialSFI.OrderInternalID,
  key MfgOrdOpActiveInitialSFI.OrderOperationInternalID,
  key MfgOrdOpActiveInitialSFI.ShopFloorItem,
  key MfgOrdOpActiveInitialSFI._ShopFloorItem.Material,
  key MfgOrdOpActiveInitialSFI._ShopFloorItem.SerialNumber,
      MfgOrdOpActiveInitialSFI._ShopFloorItem.ManufacturingOrder,
      MfgOrdOpActiveInitialSFI.ManufacturingOrderOperation,
      MfgOrdOpActiveInitialSFI.Plant,

      MfgOrdOpActiveInitialSFI._OrderInternalID
}

union all

select from               I_SerialNumberManufacturingOrd as SerialNumberManufacturingOrd
  inner join              I_LogisticsOrderBasic          as LogisticsOrderBasic on LogisticsOrderBasic.OrderID = SerialNumberManufacturingOrd.ManufacturingOrder
  inner join              I_OrderOperationBasic          as OrderOperationBasic on OrderOperationBasic.OrderInternalID = LogisticsOrderBasic.OrderInternalID
  left outer to many join I_ShopFloorItem                as ShopFloorItem       on ShopFloorItem.ManufacturingOrder = SerialNumberManufacturingOrd.ManufacturingOrder
{
  key LogisticsOrderBasic.OrderInternalID,
  key OrderOperationBasic.OrderOperationInternalID,
  key cast( 0 as mpe_sfi_id  )      as ShopFloorItem,
  key SerialNumberManufacturingOrd.Material,
  key SerialNumberManufacturingOrd.SerialNumber,
      SerialNumberManufacturingOrd.ManufacturingOrder,
      OrderOperationBasic.Operation as ManufacturingOrderOperation,
      OrderOperationBasic.Plant,

      LogisticsOrderBasic._OrderInternalID
}
where
  ShopFloorItem.ManufacturingOrder is null

Learn More