I_APARWorklist

@AbapCatalog: {sqlViewName: 'IAPARWORKLIST', preserveKey: true}
@EndUserText.label: 'Open items which are not cleared in session of Write off'

@ObjectModel: {
    usageType.serviceQuality: #C,
    usageType.sizeCategory: #XXL,
    usageType.dataClass: #TRANSACTIONAL
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AbapCatalog.compiler.compareFilter:true

@VDM.viewType:  #COMPOSITE
//This view only support to get not cleared open items for customer!


define view I_APARWorklist
  as select from I_OperationalAcctgDocItem as open_items
{ 
  key open_items.CompanyCode,
  key open_items.AccountingDocument,
  key open_items.FiscalYear,
  key open_items.AccountingDocumentItem,
      
      open_items.DebitCreditCode,
      open_items.Customer as APARAccount,      
      open_items.FinancialAccountType,      
      open_items.Customer,
      open_items._Customer.AuthorizationGroup as CustomerBasicAuthorizationGrp,
      open_items._CustomerCompany.AuthorizationGroup as CustomerFinsAuthorizationGrp,
      open_items.Supplier,
//      Since the authorization group will be deprecated from lower CDS view.

//      open_items.SupplierBasicAuthorizationGrp,

//      open_items._SupplierCompany.AuthorizationGroup  as SupplierFinsAuthorizationGrp, 

      cast( '' as brgru)  as  SupplierBasicAuthorizationGrp,
      cast( '' as brgru)  as  SupplierFinsAuthorizationGrp, 
      
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'     
      open_items.AmountInCompanyCodeCurrency as TotalAmountInCoCodeCrcy,
      open_items.CompanyCodeCurrency,
      open_items._CustomerText.CustomerName  as CustomerName, 
      
      open_items.PostingDate, 
      open_items.FollowOnDocumentType,        //rebzt

      open_items.SpecialGLTransactionType,    //umsks

      open_items.IsUsedInPaymentTransaction,  //xzahl

      open_items.SpecialGLCode                //umskz

      
} where open_items.ClearingJournalEntry = ''
  and open_items.ClearingDate = '00000000'
  and open_items.FinancialAccountType = 'D'
  and open_items.AccountingDocumentCategory != 'D'
  and open_items.AccountingDocumentCategory != 'M' 
  and open_items.AccountingDocumentCategory != 'S' 
           
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_CUSTOMERCOMPANY",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/