P_BPPartnerFunctionNumber

DDL: P_BPPARTNERFUNCTIONNUMBER SQL: PBPPFNUMBER Type: view COMPOSITE Package: VDM_MD_BP
28 Fields 4 Data Sources

Union view of various partner types

P_BPPartnerFunctionNumber is a Composite CDS View that provides data about "Union view of various partner types" in SAP S/4HANA. It reads from 4 data sources (I_ContactPerson, I_Customer, I_PersWrkAgrmtSrchHelp_1, I_Supplier) and exposes 28 fields with key fields BusinessPartner, PartnerFunctionType, PartnerFunctionType, PartnerFunctionType, PartnerFunctionType. Part of development package VDM_MD_BP.

Data Sources (4)

SourceAliasJoin Type
I_ContactPerson I_ContactPerson union
I_Customer I_Customer from
I_PersWrkAgrmtSrchHelp_1 I_PersWrkAgrmtSrchHelp_1 union
I_Supplier I_Supplier union

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PBPPFNUMBER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #REQUIRED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_Customer Customer Sold-to Party
KEY PartnerFunctionType
BusinessPartnerName Full Name
OrganizationBPName1 I_Customer OrganizationBPName1 Last Name
BusinessPartnerName1 I_Customer BusinessPartnerName1 Last Name
OrganizationBPName2 I_Customer OrganizationBPName2 First Name
BusinessPartnerName2 I_Customer BusinessPartnerName2 First Name
SupplierasBusinessPartner
KEY PartnerFunctionType
BusinessPartnerName Full Name
OrganizationBPName1 I_Supplier OrganizationBPName1 Last Name
BusinessPartnerName1 I_Supplier BusinessPartnerName1 Last Name
OrganizationBPName2 I_Supplier OrganizationBPName2 First Name
BusinessPartnerName2 I_Supplier BusinessPartnerName2 First Name
KEY PartnerFunctionType
BusinessPartnerName PersonFullName Full Name
OrganizationBPName1 LastName Last Name
BusinessPartnerName1 LastName Last Name
OrganizationBPName2 FirstName First Name
BusinessPartnerName2 FirstName First Name
ContactPersonasBusinessPartner
KEY PartnerFunctionType
BusinessPartnerName Full Name
OrganizationBPName1 I_ContactPerson LastName Last Name
BusinessPartnerName1 I_ContactPerson LastName Last Name
OrganizationBPName2 I_ContactPerson FirstName First Name
BusinessPartnerName2 I_ContactPerson FirstName First Name
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed

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_BPPartnerFunctionNumber.
-- 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: PBPPFNUMBER

CREATE VIEW P_BPPartnerFunctionNumber AS
SELECT
  I_Customer.Customer AS BusinessPartner,
  cast ( 'KU' as char2 ) AS PartnerFunctionType,
  I_Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  I_Customer.OrganizationBPName1 AS OrganizationBPName1,
  I_Customer.BusinessPartnerName1 AS BusinessPartnerName1,
  I_Customer.OrganizationBPName2 AS OrganizationBPName2,
  I_Customer.BusinessPartnerName2 AS BusinessPartnerName2,
  I_Customer.IsBusinessPurposeCompleted AS SupplierasBusinessPartner,
  IsBusinessPurposeCompleted AS ContactPersonasBusinessPartner,
  IsBusinessPurposeCompleted
FROM I_Customer
-- UNION with additional select branch(es): I_Supplier, I_PersWrkAgrmtSrchHelp_1, I_ContactPerson
;

Learn More