R_COLLECTIONSCUSTOMERQUICKVIEW

CDS View

Customer Quick View

R_COLLECTIONSCUSTOMERQUICKVIEW is a CDS View in S/4HANA. Customer Quick View. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CollectionsCustomerQuickView view_entity projection CONSUMPTION Collections Customer Quick View 
@AbapCatalog: { sqlViewName: 'RCOLLSCSTQKVW',
                compiler:    { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #CHECK,
                  personalData: { blocking: #BLOCKED_DATA_EXCLUDED } }
@EndUserText: { label: 'Customer Quick View' }
@VDM: { viewType:  #COMPOSITE,
        lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType:         { serviceQuality: #X,
                                     sizeCategory:   #L,
                                     dataClass:      #TRANSACTIONAL },
                 representativeKey: 'Customer' }

/*+[hideWarning] { "IDS" : [ "KEY_CHECK", "CARDINALITY_CHECK" ]  } */
define root view R_CollectionsCustomerQuickView
  as select distinct from I_CustomerCompany
    inner join            I_BusinessPartnerCustomer    on I_CustomerCompany.Customer = I_BusinessPartnerCustomer.Customer
    left outer to one join(
                          I_CollsSgmtCompanyCodeAssgmt
        inner join        I_BPCollectionsSegmentAssgmt on  I_CollsSgmtCompanyCodeAssgmt.CollectionSegment             = I_BPCollectionsSegmentAssgmt.CollectionSegment
                                                       and I_BPCollectionsSegmentAssgmt.BPCollSgmtAssignmentValidFrom <= $session.system_date
                                                       and I_BPCollectionsSegmentAssgmt.BPCollSgmtAssignmentValidTo   >= $session.system_date
    )
    on  I_CustomerCompany.CompanyCode             = I_CollsSgmtCompanyCodeAssgmt.CompanyCode
    and I_BusinessPartnerCustomer.BusinessPartner = I_BPCollectionsSegmentAssgmt.BusinessPartner

  // 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

  // Customer

  association [0..1] to I_Customer               as _Customer               on  $projection.Customer = _Customer.Customer

{

  key I_CustomerCompany.Customer                     as Customer,
  key I_CustomerCompany.CompanyCode                  as CompanyCode,
      I_BusinessPartnerCustomer.BusinessPartner      as BusinessPartner,
      I_BPCollectionsSegmentAssgmt.CollectionSegment as CollectionSegment,
      _BusinessPartner.BusinessPartnerCategory       as BusinessPartnerCategory,
      _CollectionsMainContact.BusinessPartnerPerson  as BusinessPartnerPerson,

      // Exposed Associations

      _BusinessPartner,
      _Customer,
      _CollectionsMainContact

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCOLLECTIONSSEGMENTASSGMT",
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERCUSTOMER",
"I_COLLECTIONSMAINCONTACT",
"I_COLLSSGMTCOMPANYCODEASSGMT",
"I_CUSTOMERCOMPANY"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_COLLECTIONSMAINCONTACT",
"I_CUSTOMER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More