P_BPCustSuppContactLink

DDL: P_BPCUSTSUPPCONTACTLINK SQL: PCUSTSUPPCTLINK Type: view COMPOSITE
6 Fields 2 Data Sources

View for Customer Supplier Contact Link

P_BPCustSuppContactLink is a Composite CDS View that provides data about "View for Customer Supplier Contact Link" in SAP S/4HANA. It reads from 2 data sources (I_BPCustomerContactLink, I_BPSupplierContactLink) and exposes 6 fields with key fields BusinessPartnerUUID, PersonUUID, PersonUUID.

Data Sources (2)

SourceAliasJoin Type
I_BPCustomerContactLink I_BPCustomerContactLink from
I_BPSupplierContactLink I_BPSupplierContactLink union

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCUSTSUPPCTLINK view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label View for Customer Supplier Contact Link view
ObjectModel.usageType.serviceQuality C view
ObjectModel.usageType.sizeCategory #L view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID BusinessPartnerUUID UUID
KEY PersonUUID PersonUUID BP GUID
CustSuplrContact CustomerContact Contact Person
KEY PersonUUID PersonUUID BP GUID
CustSuplrContact SupplierContact Contact Person
_BusinessPartnerPerson _BusinessPartnerPerson

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 P_BPCustSuppContactLink.
-- 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: PCUSTSUPPCTLINK

CREATE VIEW P_BPCustSuppContactLink AS
SELECT
  BusinessPartnerUUID,
  PersonUUID,
  CustomerContact AS CustSuplrContact
FROM I_BPCustomerContactLink
-- UNION with additional select branch(es): I_BPSupplierContactLink
;

Learn More