I_BPRelshpContactPersonTP

DDL: I_BPRELSHPCONTACTPERSONTP Type: view_entity TRANSACTIONAL Package: MDC_BUPA_REL_BO
32 Fields 1 Data Sources

RAP BO view for BP contact person data

I_BPRelshpContactPersonTP is a Transactional CDS View that provides data about "RAP BO view for BP contact person data" in SAP S/4HANA. It reads from 1 data source (P_BPConToFuncAndDeptUnion) and exposes 32 fields with key fields BusinessPartner1, BusinessPartner2, ValidityEndDate, RelationshipCategory. Part of development package MDC_BUPA_REL_BO.

Data Sources (1)

SourceAliasJoin Type
P_BPConToFuncAndDeptUnion P_BPConToFuncAndDeptUnion from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label RAP BO view for BP contact person data view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner1 BusinessPartnerCompany Busn. Partner
KEY BusinessPartner2 BusinessPartnerPerson Busn. Partner
KEY 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
BPRelshpCatIsInFwdDirection BPRelshpCatIsInFwdDirection Boolean Variable (X = True, - = False, Space = Unknown)
FormOfAddressPerson _BusinessPartnerPerson FormOfAddress Title Key
FirstName _BusinessPartnerPerson FirstName First Name
LastName _BusinessPartnerPerson LastName Last Name
AcademicTitle _BusinessPartnerPerson AcademicTitle Academic Title
GenderCodeName _BusinessPartnerPerson GenderCodeName Sex
_BusinessPartner1 _BusinessPartnerCompany
_BusinessPartner2 _BusinessPartnerPerson
_BusPartRelationship _BusPartRelationship
_ContactPersonDepartmentText _ContactPersonDepartmentText
_ContactPersonFunctionText _ContactPersonFunctionText
_BPContactPersonAuthorityText _BPContactPersonAuthorityText
_BPCntctPersnVIPIndicatorText _BPCntctPersnVIPIndicatorText
_AcademicTitleValueHelp _BusinessPartnerPerson _AcademicTitleValueHelp
_AcademicTitleText _BusinessPartnerPerson _AcademicTitleText

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_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 I_BPRelshpContactPersonTP AS
SELECT
  BusinessPartnerCompany AS BusinessPartner1,
  BusinessPartnerPerson AS BusinessPartner2,
  cast( ValidityEndDate as abap.char( 17 )) AS ValidityEndDate,
  RelationshipCategory,
  RelationshipNumber,
  ContactPersonFunction,
  ContactPersonFunctionName,
  ContactPersonDepartment,
  ContactPersonDepartmentName,
  ContactPersonAuthorityType,
  ContactPersonVIPType,
  ContactPersonRemarkText,
  PhoneNumber,
  PhoneNumberExtension,
  FaxNumber,
  FaxNumberExtension,
  EmailAddress,
  BPRelshpCatIsInFwdDirection,
  _BusinessPartnerPerson.FormOfAddress AS FormOfAddressPerson,
  _BusinessPartnerPerson.FirstName AS FirstName,
  _BusinessPartnerPerson.LastName AS LastName,
  _BusinessPartnerPerson.AcademicTitle AS AcademicTitle,
  _BusinessPartnerPerson.GenderCodeName AS GenderCodeName,
  _BusinessPartnerPerson._AcademicTitleValueHelp AS _AcademicTitleValueHelp,
  _BusinessPartnerPerson._AcademicTitleText AS _AcademicTitleText
FROM P_BPConToFuncAndDeptUnion
;

Learn More