R_DISPUTECASELINKEDINVOICE

CDS View

Invoices linked to a Dispute Case

R_DISPUTECASELINKEDINVOICE is a CDS View in S/4HANA. Invoices linked to a Dispute Case. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_DisputeCaseLinkedInvoice view_entity projection CONSUMPTION Linked Invoice to Dispute Case
@AbapCatalog: { sqlViewName: 'RDCLINKIVTP',
                compiler:    { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #CHECK }
@EndUserText: { label: 'Invoices linked to a Dispute Case' }
@VDM: { viewType:  #COMPOSITE,
        lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType:         { serviceQuality: #A,
                                     sizeCategory:   #L,
                                     dataClass:      #TRANSACTIONAL }, 
                semanticKey:       [ 'DisputeCaseUUID' ],
                representativeKey: 'DisputeCaseUUID' }

define root view R_DisputeCaseLinkedInvoice
  as select from R_DisputeCase

  // VDM associations

  association [0..*] to R_CollectionsInvoiceTP as _Invoice on  $projection.Customer        = _Invoice.BranchAccount
                                                           and $projection.CompanyCode     = _Invoice.CompanyCode
                                                           and $projection.DisputeCaseUUID = _Invoice.CaseUniqueID

{
      // VDM Fields

  key DisputeCaseUUID,
      Customer,
      CompanyCode,
      CaseType,
      CasePlannedCloseDate,
      CaseProcessingDeadlineDate,
      CaseSystemStatus,
      CaseStatusProfile,
      DisputedAmount,
      DisputeCaseCurrency,
      CaseReason,
      CaseID,

      // Exposed Associations

      _Invoice,
      _Customer,
      _CompanyCode,
      _Reasons

}