P_SOFAProcFlow31

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

define view P_SOFAProcFlow31 
  as select distinct from P_SOFAProcFlow20  as Level2
  inner join
  I_AccountingDocument as AccountingDocument
  on   Level2.Level2Document                    = AccountingDocument.OriginalReferenceDocument
  and  AccountingDocument.ReferenceDocumentType = 'VBRK'    
  and  LedgerGroup                              = ''
{
   key SalesDocument,
   key SDDocumentCategory,

   key Level2Document,
   key Level2DocumentCategory,
   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


}
where ( Level2DocumentCategory = 'M'   --> Invoice  
  or    Level2DocumentCategory = 'P' ) --> Debit Memo       
  and   Level2.BillingDocumentIsCancelled   != 'X' -- Don't consider Acc docs for cancelled inv                                                     
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTINGDOCUMENT",
"P_SOFAPROCFLOW20"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/