R_AddressEmailAddressTP

DDL: R_ADDRESSEMAILADDRESSTP Type: view_entity Package: S_ADDRESS_RAP_BO

Email Address - TP

R_AddressEmailAddressTP is a CDS View that provides data about "Email Address - TP" in SAP S/4HANA. It reads from 1 data source (I_AddressEmailAddress_2) and exposes 12 fields with key fields AddressID, AddressPersonID, CommMediumSequenceNumber. Part of development package S_ADDRESS_RAP_BO.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_AddressEmailAddress_2 I_AddressEmailAddress_2 from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Email Address - TP view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY AddressID AddressID
KEY AddressPersonID AddressPersonID
KEY CommMediumSequenceNumber CommMediumSequenceNumber
EmailAddress EmailAddress
EmailAddressIsCurrentDefault EmailAddressIsCurrentDefault
CommLineNotForUnsolicitedCntct CommLineNotForUnsolicitedCntct
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
CommunicationRemarkText
_AddressCommunicationRemark _AddressCommunicationRemark
_AddressCommunicationUsage _AddressCommunicationUsage
_OrganizationAddress _OrganizationAddress 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Email Address - TP'
define view entity R_AddressEmailAddressTP
  as select from I_AddressEmailAddress_2
  association to parent R_OrganizationAddressTP as _OrganizationAddress on $projection.AddressID = _OrganizationAddress.AddressID
{
  key AddressID,
  key AddressPersonID,
  key CommMediumSequenceNumber,
      EmailAddress,
      EmailAddressIsCurrentDefault,
      CommLineNotForUnsolicitedCntct,
      ValidityStartDate,
      ValidityEndDate,
      _AddressCommunicationRemark[ Language = $session.system_language ].CommunicationRemarkText,
      /* Associations */
      _AddressCommunicationRemark,
      _AddressCommunicationUsage,
      _OrganizationAddress
}

Learn More