@AbapCatalog.sqlViewName: 'PMFGORDEROFSPLIT'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #M, dataClass: #TRANSACTIONAL}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
define view P_MfgOrderSplitOrder
as
-- Select all Children
select distinct from I_MfgOrderSplitChildOrder as MfgOrderSplitChildOrder
{
key MfgOrderSplitChildOrder.MfgOrderSplitChildOrder as ManufacturingOrder,
MfgOrderSplitChildOrder.MfgOrderSplitParentOrder,
MfgOrderSplitChildOrder.MfgOrderSplitLeadingOrder
}
-- Select all Leading Orders
union all select distinct from I_MfgOrderSplitChildOrder as MfgOrderSplitChildOrder
{
key MfgOrderSplitChildOrder.MfgOrderSplitLeadingOrder as ManufacturingOrder,
cast(' ' as split_paufnr preserving type ) as MfgOrderSplitParentOrder,
MfgOrderSplitChildOrder.MfgOrderSplitLeadingOrder
}