P_SLSORDFLFMTPROCESSFLOW3

@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: 'PSOFProcFlow3'

define view P_SlsOrdFlfmtProcessFlow3
as select from
P_SlsOrdFlfmtProcessFlow2 as Level2
inner join
I_SDDocumentProcessFlow  as Level3
on 
     Level2.Level2Document = Level3.PrecedingDocument
and  Level2.Level2DocumentCategory = Level3.PrecedingDocumentCategory
and  Level2.Level2DocumentItem = Level3.PrecedingDocumentItem
and (
       Level3.SubsequentDocumentCategory = 'M' or    --> Invoice
       Level3.SubsequentDocumentCategory = 'O' or    --> Credit Memo
       Level3.SubsequentDocumentCategory = 'P'       --> Debit Memo
      )  
  
{
   //Key

   key Level3.SubsequentDocument as Level3Document,
   key Level3.SubsequentDocumentItem as Level3DocumentItem,
   key Level2Document,
   key Level2DocumentItem,
   
   //SalesOrder

   key SalesOrder,
   SalesOrderType,
   
   //Category

   Level3.SubsequentDocumentCategory as Level3DocumentCategory,
   Level2DocumentCategory,
         
   //Organization

   SalesOrganization,
   DistributionChannel,
   OrganizationDivision,
   
   //Partner 

   SoldToParty,
   SoldToPartyName          
 };