R_BPCollectionsSgmtQuickView

DDL: R_BPCOLLECTIONSSGMTQUICKVIEW Type: view COMPOSITE

BP Quick View in Colls Segment

R_BPCollectionsSgmtQuickView is a Composite CDS View that provides data about "BP Quick View in Colls Segment" in SAP S/4HANA. It has 2 associations to related views.

7 fields

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_CollectionsMainContact _CollectionsMainContact $projection.BusinessPartner = _CollectionsMainContact.BusinessPartner and $projection.CollectionSegment = _CollectionsMainContact.CollectionSegment and _CollectionsMainContact.BusinessPartnerPerson is not initial

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName RCOLLSBPQCKVWSG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label BP Quick View in Colls Segment view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey BusinessPartner view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY CollectionSegment CollectionSegment
BusinessPartnerCategory _BusinessPartner BusinessPartnerCategory
BusinessPartnerPerson _CollectionsMainContact BusinessPartnerPerson
_CollectionsMainContact _CollectionsMainContact
_BusinessPartner _BusinessPartner
_CollectionSegment _CollectionSegment 
@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 }

/*+[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

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

Learn More