C_BPRelshpContactPersonTP_2

DDL: C_BPRELSHPCONTACTPERSONTP_2 Type: view_entity CONSUMPTION Package: MDC_BUPA_REL_BO
27 Fields 1 Data Sources 1 OData Services

Projection view for contact person

C_BPRelshpContactPersonTP_2 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 27 fields with key fields BusinessPartner1, BusinessPartner2, ValidityEndDate, RelationshipCategory. It is exposed through 1 OData service (C_BUSINESSPARTNERTP_2_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_BUSINESSPARTNERTP_2_SRV C_BUSINESSPARTNERTP_2_SRV V2 C1 NOT_RELEASED

Fields (27)

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
FormOfAddressPerson FormOfAddressPerson Title Key
FirstName FirstName First Name
LastName LastName Last Name
AcademicTitle AcademicTitle Academic Title
GenderCodeName GenderCodeName Sex
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_2.
-- 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_2 AS
SELECT
  BusinessPartner1,
  BusinessPartner2,
  ValidityEndDate,
  RelationshipCategory,
  RelationshipNumber,
  ContactPersonFunction,
  ContactPersonFunctionName,
  ContactPersonDepartment,
  ContactPersonDepartmentName,
  ContactPersonAuthorityType,
  ContactPersonVIPType,
  ContactPersonRemarkText,
  PhoneNumber,
  PhoneNumberExtension,
  FaxNumber,
  FaxNumberExtension,
  EmailAddress,
  FormOfAddressPerson,
  FirstName,
  LastName,
  AcademicTitle,
  GenderCodeName,
  _BPContactPersonAuthorityText.BPContactPersonAuthorityText : localized AS BPContactPersonAuthorityTextlocalized,
  _BPCntctPersnVIPIndicatorText.BPContactPersonVIPText : localized AS BPContactPersonVIPTextlocalized,
  BPRelshpCatIsInFwdDirection
FROM I_BPRelshpContactPersonTP
;

Learn More