R_COLLECTIONSACCOUNTKEYFIGURE

CDS View

Collections Account Key Figure

R_COLLECTIONSACCOUNTKEYFIGURE is a CDS View in S/4HANA. Collections Account Key Figure. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CollectionsAccountKeyFigure view_entity projection CONSUMPTION Collections Account Key Figure 
@AbapCatalog: { sqlViewName: 'RCOLLSACCTKF',
                compiler:    { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #CHECK,
                  personalData: { blocking: #BLOCKED_DATA_EXCLUDED } }
@EndUserText: { label: 'Collections Account Key Figure' }
@VDM: { viewType:  #COMPOSITE,
        lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType:         { serviceQuality: #B,
                                     sizeCategory:   #L,
                                     dataClass:      #MIXED },
                semanticKey: [ 'BusinessPartner',
                               'CollectionSegment' ],
                representativeKey: 'CollectionSegment' }

define root view R_CollectionsAccountKeyFigure
  as select from P_CollsLatestWLItem
    inner join   I_CollectionWorklistItem on  P_CollsLatestWLItem.BusinessPartner       = I_CollectionWorklistItem.BusinessPartner
                                          and P_CollsLatestWLItem.CollectionSegment     = I_CollectionWorklistItem.CollectionSegment
                                          and P_CollsLatestWLItem.CollectionWorklistRun = I_CollectionWorklistItem.CollectionWorklistRun

  // VDM Associations

  // Business Partner

  association [0..1] to I_BusinessPartner   as _BusinessPartner   on $projection.BusinessPartner = _BusinessPartner.BusinessPartner

  // Collection Segment

  association [0..1] to I_CollectionSegment as _CollectionSegment on $projection.CollectionSegment = _CollectionSegment.CollectionSegment

{

      // VDM Fields

  key I_CollectionWorklistItem.BusinessPartner            as BusinessPartner,
  key I_CollectionWorklistItem.CollectionSegment          as CollectionSegment,
      I_CollectionWorklistItem.CollectionStrategy         as CollectionStrategy,
      I_CollectionWorklistItem.CollectionsStrategyVersion as CollectionsStrategyVersion,
      I_CollectionWorklistItem.CollectionWorklistRun      as CollectionWorklistRun,
      I_CollectionWorklistItem.WorklistItemCreationDate   as WorklistItemCreationDate,
      I_CollectionWorklistItem.CollectionWorklistItemUUID as CollectionWorklistItemUUID,

      @Semantics: { currencyCode: true }
      I_CollectionWorklistItem.Currency                   as Currency,

      @Semantics: { amount: { currencyCode: 'Currency' } }
      I_CollectionWorklistItem.CollectableAmount          as OutstandingAmount,

      // Exposed Associations

      _BusinessPartner,
      _CollectionSegment,
      _CollectionsStrategy,
      _Currency

}

Learn More