P_SOFAProcFlow41

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

@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PSOFAPROCF41'

define view P_SOFAProcFlow41
  as select distinct from P_SOFAPROCFLOW30  as Level3
  inner join
  I_AccountingDocument as AccountingDocument
  on   Level3.Level3Document                    = AccountingDocument.OriginalReferenceDocument
  and  AccountingDocument.ReferenceDocumentType = 'VBRK'    
  and  LedgerGroup                              = ''
{
   key SalesDocument,
   key SDDocumentCategory,

   key Level3Document,
   key Level3DocumentCategory,
   key AccountingDocument.AccountingDocument,
   
   SalesDocumentType,
   
    //Organization

   SalesOrganization,
   DistributionChannel,
   OrganizationDivision,     
   
   OverallSDProcessStatus,
   OverallTotalDeliveryStatus,
   OverallOrdReltdBillgStatus,   
   
   //Misc

   RequestedDeliveryDate,
   --OverallSDProcessStatus,
   SalesDocumentDate,
   SalesGroup,
   SalesOffice,
   SoldToParty,
   PurchaseOrderByCustomer,
   
   //AccountingDocument additional keys

   AccountingDocument.CompanyCode,
   AccountingDocument.FiscalYear,

   //Category

   Level2DocumentCategory
}
where ( Level3DocumentCategory = 'M'   --> Invoice  
  or    Level3DocumentCategory = 'P' ) --> Debit Memo       
  and   Level3.BillingDocumentIsCancelled   != 'X' -- Don't consider Acc docs for cancelled inv