C_BPRelshpContactPersonTP

DDL: C_BPRELSHPCONTACTPERSONTP Type: view_entity CONSUMPTION Package: MDC_BUPA_REL_BO
22 Fields 1 Data Sources 1 OData Services

Projection view for contact person

C_BPRelshpContactPersonTP is a Consumption CDS View that provides data about "Projection view for contact person" in SAP S/4HANA. It reads from 1 data source (I_BPRelshpContactPersonTP) and exposes 22 fields with key fields BusinessPartner1, BusinessPartner2, ValidityEndDate, RelationshipCategory. It is exposed through 1 OData service (C_BUSPARTRELATIONSHIPTP_SRV). Part of development package MDC_BUPA_REL_BO.

Data Sources (1)

SourceAliasJoin Type
I_BPRelshpContactPersonTP I_BPRelshpContactPersonTP projection

Annotations (6)

NameValueLevelField
EndUserText.label Projection view for contact person view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
C_BUSPARTRELATIONSHIPTP_SRV C_BUSPARTRELATIONSHIPTPSRV V2 C1 NOT_RELEASED

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner1 BusinessPartner1 Partner
KEY BusinessPartner2 BusinessPartner2 Partner
KEY ValidityEndDate ValidityEndDate ValidTo
KEY RelationshipCategory RelationshipCategory Relationsh.Cat.
RelationshipNumber RelationshipNumber BP Rel. Number
ContactPersonFunction ContactPersonFunction Function
ContactPersonFunctionName ContactPersonFunctionName Function
ContactPersonDepartment ContactPersonDepartment Department
ContactPersonDepartmentName ContactPersonDepartmentName Company dept.
ContactPersonAuthorityType ContactPersonAuthorityType Authority
ContactPersonVIPType ContactPersonVIPType VIP
ContactPersonRemarkText ContactPersonRemarkText Note
PhoneNumber PhoneNumber Telephone no.
PhoneNumberExtension PhoneNumberExtension Extension
FaxNumber FaxNumber Fax Number
FaxNumberExtension FaxNumberExtension Extension
EmailAddress EmailAddress E-Mail Address
BPContactPersonAuthorityTextlocalized
BPContactPersonVIPTextlocalized
BPRelshpCatIsInFwdDirection BPRelshpCatIsInFwdDirection Boolean Variable (X = True, - = False, Space = Unknown)
_BusinessPartner1 _BusinessPartner1
_BusinessPartner2 _BusinessPartner2

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 C_BPRelshpContactPersonTP.
-- 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.

CREATE VIEW C_BPRelshpContactPersonTP AS
SELECT
  BusinessPartner1,
  BusinessPartner2,
  ValidityEndDate,
  RelationshipCategory,
  RelationshipNumber,
  ContactPersonFunction,
  ContactPersonFunctionName,
  ContactPersonDepartment,
  ContactPersonDepartmentName,
  ContactPersonAuthorityType,
  ContactPersonVIPType,
  ContactPersonRemarkText,
  PhoneNumber,
  PhoneNumberExtension,
  FaxNumber,
  FaxNumberExtension,
  EmailAddress,
  _BPContactPersonAuthorityText.BPContactPersonAuthorityText : localized AS BPContactPersonAuthorityTextlocalized,
  _BPCntctPersnVIPIndicatorText.BPContactPersonVIPText : localized AS BPContactPersonVIPTextlocalized,
  BPRelshpCatIsInFwdDirection
FROM I_BPRelshpContactPersonTP
;

Learn More