I_BPSupplierContactLink

DDL: I_BPSUPPLIERCONTACTLINK SQL: IBPSUPLRCNTCLINK Type: view BASIC
9 Fields 1 Data Sources 3 Associations

Business Partner Supplier Contact Link

I_BPSupplierContactLink (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Database & Data Management

I_BPSupplierContactLink is a Basic CDS View that provides data about "Business Partner Supplier Contact Link" in SAP S/4HANA. It reads from 1 data source (cvi_vend_ct_link) and exposes 9 fields with key fields BusinessPartnerUUID, PersonUUID, SupplierContact. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for Business Partner
Purpose
This CDS view is designed to provide a structured representation of the relationships between suppliers and their contact persons. It extracts and organizes data from the underlying table, facilitating the integration and analysis of supplier contact information within a business context. This CDS view provides the data to answer the following business questions: Which contact persons are associated with specific suppliers? What are the unique identifiers for supplier business partners (business partner GUID) and their associated contact persons? Who created the supplier contact person and when was it created?

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: BEGRU_LFA1 – Authorization Group for Suppliers EKORG – Purchasing Organization B_BUP_DCPD – Business Partner Processing

Structure
Important Fields Important fields in this view include the following: Field Name Description BusinessPartnerUUID GUID of Business Partner PersonUUID GUID of Business Partner who is a person SupplierContact Number of SupplierContact Person CreatedByUser User who created the supplier contact person CreationDate CreationTime Time at which the supplier contact person was linked

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessDatabase & Data Management
Application ComponentLO-MD-BP
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
PackageDatabase & Data Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
cvi_vend_ct_link BPSupplierContactLink from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartnerCompany $projection.BusinessPartnerUUID = _BusinessPartnerCompany.BusinessPartnerUUID
[1..1] I_BusinessPartner _BusinessPartnerPerson $projection.PersonUUID = _BusinessPartnerPerson.BusinessPartnerUUID
[1..1] I_ContactPerson _ContactPerson $projection.SupplierContact = _ContactPerson.ContactPerson

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBPSUPLRCNTCLINK view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Partner Supplier Contact Link view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID cvi_vend_ct_link partner_guid Business Partner GUID
KEY PersonUUID cvi_vend_ct_link person_guid Business Partner GUID
KEY SupplierContact cvi_vend_ct_link vendor_cont Number of Contact Person
CreatedByUser cvi_vend_ct_link cruser User who created the object
CreationDate cvi_vend_ct_link crdat Date on which the object was created
CreationTime cvi_vend_ct_link crtim Time at which the object was created
_BusinessPartnerCompany _BusinessPartnerCompany
_BusinessPartnerPerson _BusinessPartnerPerson
_ContactPerson _ContactPerson

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BPSupplierContactLink.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IBPSUPLRCNTCLINK

CREATE VIEW I_BPSupplierContactLink AS
SELECT
  BPSupplierContactLink.partner_guid AS BusinessPartnerUUID,
  BPSupplierContactLink.person_guid AS PersonUUID,
  BPSupplierContactLink.vendor_cont AS SupplierContact,
  BPSupplierContactLink.cruser AS CreatedByUser,
  BPSupplierContactLink.crdat AS CreationDate,
  BPSupplierContactLink.crtim AS CreationTime
FROM cvi_vend_ct_link AS BPSupplierContactLink
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartnerCompany ON BusinessPartnerUUID = _BusinessPartnerCompany.BusinessPartnerUUID  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartnerPerson ON PersonUUID = _BusinessPartnerPerson.BusinessPartnerUUID  -- association [1..1]
LEFT OUTER JOIN I_ContactPerson AS _ContactPerson ON SupplierContact = _ContactPerson.ContactPerson  -- association [1..1]
;

Learn More