P_SlsOrdProcFlowM1

@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PSLSORDPROCFM1'
@AbapCatalog.preserveKey:true 

define view P_SlsOrdProcFlowM1
  as select distinct from P_SlsOrdProcFlow0   as Level0  --> Level 0
    inner join   I_SDDocumentProcessFlow    as LevelM1 --> Level Minus1
    on Level0.SalesOrder                    = LevelM1.SubsequentDocument
    and(  LevelM1.PrecedingDocumentCategory = 'C'   --> Order
    or    LevelM1.PrecedingDocumentCategory = 'B'   --> Quote
    or    LevelM1.PrecedingDocumentCategory = 'H'   --> Returns
    or    LevelM1.PrecedingDocumentCategory = 'G'   --> Contract
    or    LevelM1.PrecedingDocumentCategory = 'SOLO'--> Solution Order
    )
{
      //Key

  key PrecedingDocument     as LevelM1Document,
  key case 
    when PrecedingDocumentCategory = 'C' 
        then 'CREF'   --> allow assignmet to 'Reference' lane
    when PrecedingDocumentCategory = 'H' 
        then 'HREF'   --> allow assignmet to 'Reference' lane        
    else 
      PrecedingDocumentCategory
    end as LevelM1DocumentCategory,   
  
      //SalesOrder

  key SalesOrder,
      SalesOrderType,

      //Category

      SalesOrderCategory,

      //Organization

      SalesOrganization,
      DistributionChannel,
      OrganizationDivision

}
  
  where Level0.SalesOrderCategory  = 'C'    --> Order
  or    Level0.SalesOrderCategory  = 'I'    --> Order w/o charge            
  or    Level0.SalesOrderCategory  = 'ICSO' --> Intercompany Sales Order
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SDDOCUMENTPROCESSFLOW",
"P_SLSORDPROCFLOW0"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/