R_BPCOLLECTIONSSGMTQUICKVIEW

CDS View

BP Quick View in Colls Segment

R_BPCOLLECTIONSSGMTQUICKVIEW is a CDS View in S/4HANA. BP Quick View in Colls Segment. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_BPCollectionsSgmtQuickView view_entity projection CONSUMPTION Business Partner Quick View 
@AbapCatalog: { sqlViewName: 'RCOLLSBPQCKVWSG',
                compiler:    { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #CHECK,
                  personalData: { blocking: #BLOCKED_DATA_EXCLUDED } }
@EndUserText: { label: 'BP Quick View in Colls Segment' }
@VDM: { viewType:  #COMPOSITE,
        lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType:         { serviceQuality: #C,
                                     sizeCategory:   #L,
                                     dataClass:      #TRANSACTIONAL },
                semanticKey: [ 'BusinessPartner',
                               'CollectionSegment' ],
                representativeKey: 'BusinessPartner' }
@Metadata: { ignorePropagatedAnnotations: true }
@Consumption: { dbHints: [ 'USE_HEX_PLAN' ] }

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

  // 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
                                                                            and _CollectionsMainContact.BusinessPartnerPerson is not initial

{


  key BusinessPartner,

      @ObjectModel: { foreignKey: { association: '_CollectionSegment' } }
  key CollectionSegment,

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

      // Exposed Associations

      _CollectionsMainContact,
      _BusinessPartner,
      _CollectionSegment

}

Learn More