I_BPRelshpCntctPersnEmlAddrTP

DDL: I_BPRELSHPCNTCTPERSNEMLADDRTP Type: view_entity TRANSACTIONAL
19 Fields 2 Data Sources 2 Associations

RAP BO Contact Person Email Address

I_BPRelshpCntctPersnEmlAddrTP is a Transactional CDS View that provides data about "RAP BO Contact Person Email Address" in SAP S/4HANA. It reads from 2 data sources (P_BPContactToAddress, I_AddressEmailAddress_2) and exposes 19 fields with key fields BusinessPartner1, BusinessPartner2, ValidityEndDate, RelationshipCategory, AddressID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
P_BPContactToAddress ContactPerson from
I_AddressEmailAddress_2 EmailAddress inner

Associations (2)

CardinalityTargetAliasCondition
[1] I_BusPartRelationshipTP _BusPartRelationship $projection.BusinessPartner1 = _BusPartRelationship.BusinessPartner1 and $projection.BusinessPartner2 = _BusPartRelationship.BusinessPartner2 and $projection.ValidityEndDate = _BusPartRelationship.ValidityEndDate and $projection.RelationshipCategory = _BusPartRelationship.RelationshipCategory and $projection.BPRelshpCatIsInFwdDirection = _BusPartRelationship.BPRelshpCatIsInFwdDirection
[0..1] I_BPRelshpContactPersonTP _BPRelshpContactPerson $projection.BusinessPartner1 = _BPRelshpContactPerson.BusinessPartner1 and $projection.BusinessPartner2 = _BPRelshpContactPerson.BusinessPartner2 and $projection.ValidityEndDate = _BPRelshpContactPerson.ValidityEndDate and $projection.RelationshipCategory = _BPRelshpContactPerson.RelationshipCategory

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label RAP BO Contact Person Email Address view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner1 P_BPContactToAddress BusinessPartnerCompany Busn. Partner
KEY BusinessPartner2 P_BPContactToAddress BusinessPartnerPerson Busn. Partner
KEY ValidityEndDate
KEY RelationshipCategory P_BPContactToAddress RelationshipCategory Relationsh.Cat.
KEY AddressID P_BPContactToAddress AddressID Ship-to address
KEY OrdinalNumber I_AddressEmailAddress_2 CommMediumSequenceNumber Sequence Number
KEY BPRelshpCatIsInFwdDirection P_BPContactToAddress BPRelshpCatIsInFwdDirection Boolean Variable (X = True, - = False, Space = Unknown)
OrdinalNumberForEdit I_AddressEmailAddress_2 CommMediumSequenceNumber Sequence Number
RelationshipNumber P_BPContactToAddress RelationshipNumber BP Rel. Number
EmailAddress I_AddressEmailAddress_2 EmailAddress E-Mail Address
IsDefaultEmailAddress I_AddressEmailAddress_2 EmailAddressIsCurrentDefault
CommNumberIsNotUsed I_AddressEmailAddress_2 CommLineNotForUnsolicitedCntct
IsHomeEmailAddress
AddressCommunicationRemarkText
_BusinessPartner1 P_BPContactToAddress _BusinessPartnerCompany
_BusinessPartner2 P_BPContactToAddress _BusinessPartnerPerson
_BPRelshpCntctPersnAddress _BPRelshpCntctPersnAddress
_BPRelshpContactPerson _BPRelshpContactPerson
_BusPartRelationship _BusPartRelationship

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_BPRelshpCntctPersnEmlAddrTP.
-- 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_BPRelshpCntctPersnEmlAddrTP AS
SELECT
  ContactPerson.BusinessPartnerCompany AS BusinessPartner1,
  ContactPerson.BusinessPartnerPerson AS BusinessPartner2,
  cast( ContactPerson.ValidityEndDate as abap.char( 17 )) AS ValidityEndDate,
  ContactPerson.RelationshipCategory AS RelationshipCategory,
  ContactPerson.AddressID AS AddressID,
  EmailAddress.CommMediumSequenceNumber AS OrdinalNumber,
  ContactPerson.BPRelshpCatIsInFwdDirection AS BPRelshpCatIsInFwdDirection,
  EmailAddress.CommMediumSequenceNumber AS OrdinalNumberForEdit,
  ContactPerson.RelationshipNumber AS RelationshipNumber,
  EmailAddress.EmailAddress AS EmailAddress,
  EmailAddress.EmailAddressIsCurrentDefault AS IsDefaultEmailAddress,
  EmailAddress.CommLineNotForUnsolicitedCntct AS CommNumberIsNotUsed,
  cast ('' as ad_flghome ) AS IsHomeEmailAddress,
  EmailAddress._AddressCommunicationRemark.CommunicationRemarkText AS AddressCommunicationRemarkText,
  ContactPerson._BusinessPartnerCompany AS _BusinessPartner1,
  ContactPerson._BusinessPartnerPerson AS _BusinessPartner2
FROM P_BPContactToAddress AS ContactPerson
INNER JOIN I_AddressEmailAddress_2 AS EmailAddress ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusPartRelationshipTP AS _BusPartRelationship ON BusinessPartner1 = _BusPartRelationship.BusinessPartner1 AND BusinessPartner2 = _BusPartRelationship.BusinessPartner2 AND ValidityEndDate = _BusPartRelationship.ValidityEndDate AND RelationshipCategory = _BusPartRelationship.RelationshipCategory AND BPRelshpCatIsInFwdDirection = _BusPartRelationship.BPRelshpCatIsInFwdDirection  -- association [1]
LEFT OUTER JOIN I_BPRelshpContactPersonTP AS _BPRelshpContactPerson ON BusinessPartner1 = _BPRelshpContactPerson.BusinessPartner1 AND BusinessPartner2 = _BPRelshpContactPerson.BusinessPartner2 AND ValidityEndDate = _BPRelshpContactPerson.ValidityEndDate AND RelationshipCategory = _BPRelshpContactPerson.RelationshipCategory  -- association [0..1]
;

Learn More