I_CustomerToBusinessPartner

DDL: I_CUSTOMERTOBUSINESSPARTNER SQL: ICVICUSTLINK Type: view BASIC Package: VDM_MD_COMMON

Customer to BusinessPartner Relationship

I_CustomerToBusinessPartner is a Basic CDS View (Dimension) that provides data about "Customer to BusinessPartner Relationship" in SAP S/4HANA. It reads from 1 data source (cvi_cust_link) and exposes 4 fields with key field BusinessPartnerUUID. It has 2 associations to related views. Part of development package VDM_MD_COMMON.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
cvi_cust_link cvi_cust_link from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (19)

NameValueLevelField
EndUserText.label Customer to BusinessPartner Relationship view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.sapObjectNodeType.name CustomerBusinessPartner view
ObjectModel.representativeKey BusinessPartnerUUID view
AbapCatalog.sqlViewName ICVICUSTLINK view
AbapCatalog.preserveKey true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.personalData.blockingIndicator IsBusinessPurposeCompleted view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID partner_guid
Customer customer
_Customer _Customer
_BusinessPartner _BusinessPartner 
@EndUserText.label: 'Customer to BusinessPartner Relationship'
@Analytics: {
  dataCategory: #DIMENSION,
  dataExtraction: {
    enabled: true,
    delta.changeDataCapture: {
      automatic: true
    }
  }
}
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.sapObjectNodeType.name: 'CustomerBusinessPartner'
@ObjectModel.representativeKey: 'BusinessPartnerUUID'
@AbapCatalog.sqlViewName: 'ICVICUSTLINK'
@AbapCatalog.preserveKey:true
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET,
                                     #ANALYTICAL_DIMENSION,
                                     #EXTRACTION_DATA_SOURCE] 
@ObjectModel.modelingPattern:#ANALYTICAL_DIMENSION                                     
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm : #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.personalData.blockingIndicator: 'IsBusinessPurposeCompleted'
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations: true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_CustomerToBusinessPartner
  as select from cvi_cust_link
  association [1..1] to I_BusinessPartner as _BusinessPartner on $projection.BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID
  association [1..1] to I_Customer        as _Customer        on $projection.Customer = _Customer.Customer
{
  key partner_guid as BusinessPartnerUUID,
      customer     as Customer,
        
      _Customer,
      _BusinessPartner
}

Learn More