C_BPContactPersonBasicTP

DDL: C_BPCONTACTPERSONBASICTP Type: view_entity CONSUMPTION
28 Fields 1 Data Sources 1 OData Services

Projection view for Contact Person data

C_BPContactPersonBasicTP is a Consumption CDS View that provides data about "Projection view for Contact Person data" in SAP S/4HANA. It reads from 1 data source (I_BPRelshpContactPersonTP) and exposes 28 fields with key fields BusinessPartner1, BusinessPartner2, ValidityEndDate, RelationshipCategory. It is exposed through 1 OData service (C_BUSINESSPARTNERTP_2_SRV).

Data Sources (1)

SourceAliasJoin Type
I_BPRelshpContactPersonTP I_BPRelshpContactPersonTP projection

Annotations (6)

NameValueLevelField
EndUserText.label Projection view for Contact Person data 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 (28)

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
AcademicTitleNamelocalized
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_BPContactPersonBasicTP.
-- 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_BPContactPersonBasicTP AS
SELECT
  BusinessPartner1,
  BusinessPartner2,
  ValidityEndDate,
  RelationshipCategory,
  RelationshipNumber,
  ContactPersonFunction,
  ContactPersonFunctionName,
  ContactPersonDepartment,
  ContactPersonDepartmentName,
  ContactPersonAuthorityType,
  ContactPersonVIPType,
  ContactPersonRemarkText,
  PhoneNumber,
  PhoneNumberExtension,
  FaxNumber,
  FaxNumberExtension,
  EmailAddress,
  FormOfAddressPerson,
  FirstName,
  LastName,
  AcademicTitle,
  _AcademicTitleValueHelp._Text.AcademicTitleName : localized AS AcademicTitleNamelocalized,
  GenderCodeName,
  _BPContactPersonAuthorityText.BPContactPersonAuthorityText : localized AS BPContactPersonAuthorityTextlocalized,
  _BPCntctPersnVIPIndicatorText.BPContactPersonVIPText : localized AS BPContactPersonVIPTextlocalized,
  BPRelshpCatIsInFwdDirection
FROM I_BPRelshpContactPersonTP
;

Learn More