R_COLLECTIONSBPQUICKVIEW

CDS View

Business Partner Quick View

R_COLLECTIONSBPQUICKVIEW is a CDS View in S/4HANA. Business Partner Quick View. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CollectionsBPQuickView view_entity projection CONSUMPTION Collections Business Partner Quick View 
@AbapCatalog: { sqlViewName: 'RCOLLSBPQCKVW',
                compiler:    { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #CHECK,
                  personalData: { blocking: #BLOCKED_DATA_EXCLUDED } }
@EndUserText: { label: 'Business Partner Quick View' }
@VDM: { viewType:  #COMPOSITE,
        lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType:         { serviceQuality: #X,
                                     sizeCategory:   #L,
                                     dataClass:      #TRANSACTIONAL },
                representativeKey: 'BusinessPartner' }
@Consumption: { dbHints: [ 'USE_HEX_PLAN' ] }

/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK", "KEY_CHECK" ]  } */
define root view R_CollectionsBPQuickView
  as select distinct from I_CollectionsAccount

  // VDM Associations

  // Business Partner

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

  // Collections Contact

  association [0..1] to I_CollectionsMainContact as _CollectionsMainContact on  $projection.BusinessPartner   = _CollectionsMainContact.BusinessPartner
                                                                            and $projection.CollectionSegment = _CollectionsMainContact.CollectionSegment

{

      // VDM Fields

  key BusinessPartner,
  key CollectionSegment,
  key CompanyCode,

      _BusinessPartner.BusinessPartnerCategory      as BusinessPartnerCategory,
      _CollectionsMainContact.BusinessPartnerPerson as BusinessPartnerPerson,

      // Exposed Associations

      _CollectionsMainContact,
      _BusinessPartner

}

Learn More