I_BPAddressIndependentEmail

DDL: I_BPADDRESSINDEPENDENTEMAIL SQL: IBPADDRINDEMAIL Type: view BASIC Package: VDM_MD_BP_BASE
18 Fields 1 Data Sources 1 Associations

Root View for Address Independent Email for BP app

I_BPAddressIndependentEmail (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Database & Data Management

I_BPAddressIndependentEmail is a Basic CDS View that provides data about "Root View for Address Independent Email for BP app" in SAP S/4HANA. It reads from 1 data source (I_AddressEmailAddress_2) and exposes 18 fields with key fields BusinessPartner, AddressID, Person, OrdinalNumber. It has 1 association to related views. Part of development package VDM_MD_BP_BASE.

SAP Help Documentation

CategoryCDS Views for Business Partner
Purpose
This CDS view provides access to email address information for business partners that is independent of the main address structure. It contains email addresses associated with business partners and persons, including validity periods, default indicators, and usage flags. The view enables retrieval of both current and historical email address data with time-dependent validity information. This CDS view provides the data to answer the following business questions: What are all the email addresses maintained for address-independent communication? Which address-independent email address is currently set as the default for a business partner? What is the validity period for each address-independent email address assigned to a business partner? What address-independent email addresses were valid for a business partner during a specific time period? Which persons are associated with specific address-independent email addresses in the system? What notes or remarks have been recorded for specific address-independent email addresses? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: RESTRICTION_TYPE_ID RESTRICTION_TYPE B_BUP_DCPD Business Partner Processing BEGRU_BUPA_GRP Authorization Group for Business Partners

Structure
Important Fields Important fields in this view include the following: Field Name Description BUSINESSPARTNER Business Partner ADDRESSID Internal key for identifying an address in Business Address Services. ORDINALNUMBER The number which identifies a specific email address data, if there are more than one email addresses. ISDEFAULTEMAILADDRESS Identifies the default email address VALIDITYENDDATETIME Time on a specific date until when the email address is valid in the system. VALIDITYSTARTDATE Date from when the email address is valid in the system. VALIDITYENDDATE Date until when the email address is valid in the system. ADDRESSCOMMUNICATIONREMARKTEXT Additional information about the email address

Data Extraction
Data Extraction Type This CDS view is not enabled for data extraction.

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessDatabase & Data Management
Application ComponentAP-MD-BP
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageDatabase and Data Management for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_AddressEmailAddress_2 I_AddressEmailAddress_2 from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.AddressID = _BusinessPartner.IndependentAddressID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBPADDRINDEMAIL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Root View for Address Independent Email for BP app view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner _BusinessPartner BusinessPartner Business Partner Number
KEY AddressID I_AddressEmailAddress_2 AddressID Ship-to address
KEY Person I_AddressEmailAddress_2 AddressPersonID Person Number
KEY OrdinalNumber I_AddressEmailAddress_2 CommMediumSequenceNumber Sequence Number
AddressIDForEdit I_AddressEmailAddress_2 AddressID Ship-to address
OrdinalNumberForEdit I_AddressEmailAddress_2 CommMediumSequenceNumber Sequence Number
IsDefaultEmailAddress I_AddressEmailAddress_2 EmailAddressIsCurrentDefault Indicator : Current Default Email Address
EmailAddress I_AddressEmailAddress_2 EmailAddress E-Mail Address
SearchEmailAddress E-Mail Address Search Field
IsHomeEmailAddress Recipient address in this communication type (mail sys.grp)
CommNumberIsNotUsed Flag: This Communication Number is Not Used
ValidityStartDateTime Communication Data: Valid From (YYYYMMDDHHMMSS)
ValidityEndDateTime Communication Data: Valid To (YYYYMMDDHHMMSS)
ValidityStartDate I_AddressEmailAddress_2 ValidityStartDate Validity Start Date
ValidityEndDate I_AddressEmailAddress_2 ValidityEndDate ValidTo
_BusinessPartner _BusinessPartner
AuthorizationGroup _BusinessPartner AuthorizationGroup Authorization Group
AddressCommunicationRemarkText _AddressCommunicationRemark CommunicationRemarkText Communication link notes

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_BPAddressIndependentEmail.
-- 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: IBPADDRINDEMAIL

CREATE VIEW I_BPAddressIndependentEmail AS
SELECT
  _BusinessPartner.BusinessPartner AS BusinessPartner,
  I_AddressEmailAddress_2.AddressID AS AddressID,
  I_AddressEmailAddress_2.AddressPersonID AS Person,
  I_AddressEmailAddress_2.CommMediumSequenceNumber AS OrdinalNumber,
  I_AddressEmailAddress_2.AddressID AS AddressIDForEdit,
  I_AddressEmailAddress_2.CommMediumSequenceNumber AS OrdinalNumberForEdit,
  I_AddressEmailAddress_2.EmailAddressIsCurrentDefault AS IsDefaultEmailAddress,
  I_AddressEmailAddress_2.EmailAddress AS EmailAddress,
  cast('' as ad_smtpad2) AS SearchEmailAddress,
  cast('' as ad_flghome) AS IsHomeEmailAddress,
  cast('' as ad_flnouse) AS CommNumberIsNotUsed,
  cast ( I_AddressEmailAddress_2.ValidityStartDate as ad_valfrom ) AS ValidityStartDateTime,
  cast ( I_AddressEmailAddress_2.ValidityEndDate as ad_valto ) AS ValidityEndDateTime,
  I_AddressEmailAddress_2.ValidityStartDate AS ValidityStartDate,
  I_AddressEmailAddress_2.ValidityEndDate AS ValidityEndDate,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  _AddressCommunicationRemark.CommunicationRemarkText AS AddressCommunicationRemarkText
FROM I_AddressEmailAddress_2
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON AddressID = _BusinessPartner.IndependentAddressID  -- association [1..1]
;

Learn More