I_CUSTOMER_TO_BUSINESSPARTNER

CDS View

Customer to BusinessPartner Relationship

I_CUSTOMER_TO_BUSINESSPARTNER is a CDS View in S/4HANA. Customer to BusinessPartner Relationship. It contains 2 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 2 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
/SCMTMS/CV_BPOrgRelshp view inner BOPF: /SCMTMS/BuPa Org Relationship
C_Custprojcustomercontact view inner CONSUMPTION Customer contact details for Customer Projects
CIC_CustomerData view_entity inner Proj. View on Customer
FAC_DART_Z3_C_BP_ADDRESS view inner Business Partner Address for Customer
P_CN_CADECustomer view inner CONSUMPTION
P_JP_CentralBkPaytWithItems view left_outer CONSUMPTION View for Japan Central Bank Payment Detail Items

Fields (2)

KeyField CDS FieldsUsed in Views
KEY BusinessPartnerUUID BusinessPartnerUUID,partner_guid 2
AuthorizationGroup AuthorizationGroup 1 
@EndUserText.label: 'Customer to BusinessPartner Relationship'
@Analytics.dataCategory: #DIMENSION //or #CUBE or #FACT

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'BusinessPartnerUUID'
@Metadata.ignorePropagatedAnnotations:true 
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE , #CDS_MODELING_DATA_SOURCE , #CDS_MODELING_ASSOCIATION_TARGET]
@AbapCatalog.sqlViewName: 'ICVI_CUST_LINK'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm : #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@Metadata.allowExtensions: true
@AbapCatalog.preserveKey:true
define view I_Customer_to_BusinessPartner
  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  CVI_CUST_LINK.client,

  key partner_guid as BusinessPartnerUUID,
//    _BusinessPartner.BusinessPartner, 

      customer     as Customer,

      _Customer,
      _BusinessPartner.AuthorizationGroup,
      _BusinessPartner
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"CVI_CUST_LINK"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CUSTOMER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More