I_BPContactEmlAddrTP

DDL: I_BPCONTACTEMLADDRTP SQL: IBPCPEMLTP Type: view TRANSACTIONAL
21 Fields 2 Data Sources 2 Associations

TP View BP Contact Person Email Address

I_BPContactEmlAddrTP is a Transactional CDS View that provides data about "TP View BP Contact Person Email Address" in SAP S/4HANA. It reads from 2 data sources (I_BpContactToAddress, I_AddressEmailAddress_2) and exposes 21 fields with key fields BusinessPartner1, BusinessPartner2, RelationshipNumber, ValidityEndDate, AddressID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_BpContactToAddress ContactPerson from
I_AddressEmailAddress_2 EmailAddress inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner1 = _BusinessPartner.BusinessPartner
[1..1] I_BPContactAddressTP _BPContactAddress $projection.BusinessPartner1 = _BPContactAddress.BusinessPartner1 and $projection.BusinessPartner2 = _BPContactAddress.BusinessPartner2 and $projection.RelationshipNumber = _BPContactAddress.RelationshipNumber and $projection.ValidityEndDate = _BPContactAddress.ValidityEndDate and $projection.AddressID = _BPContactAddress.AddressID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IBPCPEMLTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
EndUserText.label TP View BP Contact Person Email Address view
ObjectModel.writeDraftPersistence BPCP_EML_D view
ObjectModel.writeEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner1 I_BpContactToAddress BusinessPartnerCompany Busn. Partner
KEY BusinessPartner2 I_BpContactToAddress BusinessPartnerPerson Busn. Partner
KEY RelationshipNumber I_BpContactToAddress RelationshipNumber BP Rel. Number
KEY ValidityEndDate I_BpContactToAddress ValidityEndDate ValidTo
KEY AddressID I_BpContactToAddress AddressID Ship-to address
KEY OrdinalNumber I_AddressEmailAddress_2 CommMediumSequenceNumber Sequence Number
BusinessPartner1ForEdit I_BpContactToAddress BusinessPartnerCompany Busn. Partner
BusinessPartner2ForEdit I_BpContactToAddress BusinessPartnerPerson Busn. Partner
ValidityEndDateForEdit I_BpContactToAddress ValidityEndDate ValidTo
AddressIDForEdit I_BpContactToAddress AddressID Ship-to address
OrdinalNumberForEdit I_AddressEmailAddress_2 CommMediumSequenceNumber Sequence Number
RelationshipNumberForEdit I_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 _BusinessPartnerCompany
_BusinessPartner2 _BusinessPartnerPerson
_BusinessPartner _BusinessPartner
_BPContactAddress _BPContactAddress

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_BPContactEmlAddrTP.
-- 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.
-- SQL view name: IBPCPEMLTP

CREATE VIEW I_BPContactEmlAddrTP AS
SELECT
  ContactPerson.BusinessPartnerCompany AS BusinessPartner1,
  ContactPerson.BusinessPartnerPerson AS BusinessPartner2,
  ContactPerson.RelationshipNumber AS RelationshipNumber,
  ContactPerson.ValidityEndDate AS ValidityEndDate,
  ContactPerson.AddressID AS AddressID,
  EmailAddress.CommMediumSequenceNumber AS OrdinalNumber,
  ContactPerson.BusinessPartnerCompany AS BusinessPartner1ForEdit,
  ContactPerson.BusinessPartnerPerson AS BusinessPartner2ForEdit,
  ContactPerson.ValidityEndDate AS ValidityEndDateForEdit,
  ContactPerson.AddressID AS AddressIDForEdit,
  EmailAddress.CommMediumSequenceNumber AS OrdinalNumberForEdit,
  ContactPerson.RelationshipNumber AS RelationshipNumberForEdit,
  EmailAddress.EmailAddress AS EmailAddress,
  EmailAddress.EmailAddressIsCurrentDefault AS IsDefaultEmailAddress,
  EmailAddress.CommLineNotForUnsolicitedCntct AS CommNumberIsNotUsed,
  cast ('' as ad_flgdfad ) AS IsHomeEmailAddress,
  EmailAddress._AddressCommunicationRemark.CommunicationRemarkText AS AddressCommunicationRemarkText
FROM I_BpContactToAddress AS ContactPerson
INNER JOIN I_AddressEmailAddress_2 AS EmailAddress ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner1 = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BPContactAddressTP AS _BPContactAddress ON BusinessPartner1 = _BPContactAddress.BusinessPartner1 AND BusinessPartner2 = _BPContactAddress.BusinessPartner2 AND RelationshipNumber = _BPContactAddress.RelationshipNumber AND ValidityEndDate = _BPContactAddress.ValidityEndDate AND AddressID = _BPContactAddress.AddressID  -- association [1..1]
;

Learn More