P_SLSORDFLFMTPROCESSFLOW2

@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PSOFProcFlow2'

define view P_SlsOrdFlfmtProcessFlow2
as select from
P_SlsOrdFlfmtProcessFlow1 as Level1
inner join
I_SDDocumentProcessFlow as Level2
on 
     Level1.Level1Document = Level2.PrecedingDocument
and  Level1.Level1DocumentCategory = Level2.PrecedingDocumentCategory
and  Level1.Level1DocumentItem = Level2.PrecedingDocumentItem
and (
       Level2.SubsequentDocumentCategory = 'J' or    --> Delivery
       Level2.SubsequentDocumentCategory = 'M' or    --> Invoice
       Level2.SubsequentDocumentCategory = 'O' or    --> Credit Memo
       Level2.SubsequentDocumentCategory = 'P'       --> Debit Memo
      )  
  
{
   //Key

   key Level2.SubsequentDocument as Level2Document,
   key Level2.SubsequentDocumentItem as Level2DocumentItem,
   key Level1Document,
   key Level1DocumentItem,
       
   //SalesOrder

   key SalesOrder,
   SalesOrderType,   
   
   //Category

   Level2.SubsequentDocumentCategory as Level2DocumentCategory,
   Level1DocumentCategory,
   
   //Organization

   SalesOrganization,
   DistributionChannel,
   OrganizationDivision,
   
   //Partner 

   SoldToParty,
   SoldToPartyName         
 };