I_CUSTOMERTOBUSINESSPARTNER

CDS View

Customer to BusinessPartner Relationship

I_CUSTOMERTOBUSINESSPARTNER is a CDS View in S/4HANA. Customer to BusinessPartner Relationship. It contains 3 fields. 20 CDS views read from this table.

Used by 20 CDS view(s) 3 fields

CDS Views using this table (20)

ViewTypeJoinVDMDescription
C_EntProjCustomerContactCard view_entity from CONSUMPTION Enterprise Project Customer Details
C_NL_SAFTJournalItemBP view_entity inner CONSUMPTION Audit File NL Journal Item BP
C_NL_SAFTSubLedgerLine view left_outer CONSUMPTION SAFT NL Sub Ledger Line
I_BPCustomerTaxGroupingTP view inner TRANSACTIONAL BO view for Customer Tax Grouping
I_BusinessPartnerCustomerVH view from COMPOSITE Bussiness Partner VH for Customers
I_BusinessPartnerCustSuplrVH view union COMPOSITE Business Partner VH for Cust and Supp
I_CO_BPRelationshipRole view_entity inner COMPOSITE Provides Business Partners Roles
I_Fr_Strpwhldgtaxitem view_entity inner COMPOSITE WHT Item For Statutory Reporting France
I_MX_BPRelationshipRole view_entity inner COMPOSITE Provides Business Partners Roles
I_NL_SAFTBusinessPartner view inner COMPOSITE SAF-T NL Business Partner
I_NO_SAFTCustomerMasterData view_entity inner COMPOSITE Master data of customers for SAFT
I_NO_SAFTCustomersInPeriod view_entity inner COMPOSITE List of all customers in report period
I_RblsMgmtBPToCustomer view_entity inner COMPOSITE Business Partner to Customer Mapping
P_BPCreditRiskClass view inner COMPOSITE Business partner credit risk class
P_CollsAcctColl view_entity inner COMPOSITE Collections Account - FI
P_CollsAcctFI view_entity inner COMPOSITE Collections Account - FI
P_CustomerBPDeliveryAddr view_entity from COMPOSITE Delivery Addresses of Customer Business Partner
P_IN_CustomerTaxNumber view_entity inner COMPOSITE Customer Tax Number
P_SAFTJournalItemBP view inner COMPOSITE SAFT Journal Item Business Partner
SHSM_BusinessPartnerCustomer view from Business partner customer search help

Fields (3)

KeyField CDS FieldsUsed in Views
KEY BusinessPartnerUUID BusinessPartnerUUID,CustomerUUID 3
KEY Customer Customer 5
_BusinessPartner _BusinessPartner 1 
@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