I_BPContactPersonVH

DDL: I_BPCONTACTPERSONVH SQL: IBPCPVH Type: view COMPOSITE Package: VDM_MD_BP_BASE
13 Fields 1 Data Sources

Value help for BP contact person

I_BPContactPersonVH is a Composite CDS View that provides data about "Value help for BP contact person" in SAP S/4HANA. It reads from 1 data source (I_BPContactToFuncAndDept) and exposes 13 fields with key fields BusinessPartner, ContactPerson. Part of development package VDM_MD_BP_BASE.

Data Sources (1)

SourceAliasJoin Type
I_BPContactToFuncAndDept BPContactPerson from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IBPCPVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Value help for BP contact person view
Search.searchable true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.representativeKey ContactPerson view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPContactToFuncAndDept BusinessPartnerCompany Sold-to Party
KEY ContactPerson I_BPContactToFuncAndDept BusinessPartnerPerson Contact
OrganizationBPName1
OrganizationBPName2
BusinessPartnerFullName Sold-to Party Name
FirstName
LastName
ContactPersonFullName Contact Name
EmailAddress I_BPContactToFuncAndDept EmailAddress Email Address
PhoneNumber I_BPContactToFuncAndDept PhoneNumber Telephone
PhoneNumberExtension I_BPContactToFuncAndDept PhoneNumberExtension Extension
_BusinessPartnerCompany I_BPContactToFuncAndDept _BusinessPartnerCompany
_BusinessPartnerPerson I_BPContactToFuncAndDept _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 I_BPContactPersonVH.
-- 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: IBPCPVH

CREATE VIEW I_BPContactPersonVH AS
SELECT
  BPContactPerson.BusinessPartnerCompany AS BusinessPartner,
  BPContactPerson.BusinessPartnerPerson AS ContactPerson,
  BPContactPerson._BusinessPartnerCompany.OrganizationBPName1 AS OrganizationBPName1,
  BPContactPerson._BusinessPartnerCompany.OrganizationBPName2 AS OrganizationBPName2,
  BPContactPerson._BusinessPartnerCompany.BusinessPartnerFullName AS BusinessPartnerFullName,
  BPContactPerson._BusinessPartnerPerson.FirstName AS FirstName,
  BPContactPerson._BusinessPartnerPerson.LastName AS LastName,
  BPContactPerson._BusinessPartnerPerson.BusinessPartnerFullName AS ContactPersonFullName,
  BPContactPerson.EmailAddress AS EmailAddress,
  BPContactPerson.PhoneNumber AS PhoneNumber,
  BPContactPerson.PhoneNumberExtension AS PhoneNumberExtension,
  BPContactPerson._BusinessPartnerCompany AS _BusinessPartnerCompany,
  BPContactPerson._BusinessPartnerPerson AS _BusinessPartnerPerson
FROM I_BPContactToFuncAndDept AS BPContactPerson
;

Learn More