I_CollectionsDueDateGrid

@AbapCatalog: { sqlViewName: 'ICOLLSDDGR',
                compiler: { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #CHECK,
                  personalData:       { blocking: #BLOCKED_DATA_EXCLUDED } }
@EndUserText: { label: 'Due Date Grid' }
@VDM: { viewType: #COMPOSITE }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType: { serviceQuality: #X,
                             sizeCategory: #L,
                             dataClass: #TRANSACTIONAL },
                semanticKey: [ 'BusinessPartner', 'CollectionSegment', 'AgingPeriod' ],
                representativeKey: 'AgingPeriod' }
@Consumption: { dbHints: [ 'USE_HEX_PLAN' ] }

// This is a dummy view - The Calculation of the Due Data Grid will be performed via a code exit in ABAP on the

// Consumption View

define root view I_CollectionsDueDateGrid
  as select distinct from I_BPCollectionsSegmentAssgmt
{

      // VDM Fields

  key BusinessPartner,
  key CollectionSegment,
  key cast( 0 as integer )  as AgingPeriod,

      @Semantics: { amount: { currencyCode: 'CollStrgyCurrency' } }
      cast( 0 as wertv8 )   as AmountInCollsStrategyCurrency,

      @Semantics: { currencyCode: true }
      cast( '' as waers )   as CollStrgyCurrency,

      cast( '' as char1 )   as Criticality,
      cast( '' as boolean ) as IsHeadOffice,

      // Exposed Associations

      _BusinessPartner,
      _CollectionSegment
}