R_AddressEmailAddressTP

DDL: R_ADDRESSEMAILADDRESSTP Type: view_entity

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 11 fields with key fields AddressID, AddressPersonID, CommMediumSequenceNumber.

1 data source(s) 11 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 (11)

KeyFieldSource TableSource FieldDescription
KEY AddressID AddressID
KEY AddressPersonID AddressPersonID
KEY CommMediumSequenceNumber CommMediumSequenceNumber
EmailAddress EmailAddress
EmailAddressIsCurrentDefault EmailAddressIsCurrentDefault
CommLineNotForUnsolicitedCntct CommLineNotForUnsolicitedCntct
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
_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,
      /* Associations */
      _AddressCommunicationRemark,
      _AddressCommunicationUsage,
      _OrganizationAddress
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSEMAILADDRESS_2"
],
"ASSOCIATED":
[
"I_ADDRESSCOMMUNICATIONREMARK_2",
"I_ADDRESSCOMMUNICATIONUSAGE",
"R_ORGANIZATIONADDRESSTP"
],
"BASE":
[
"I_ADDRESSEMAILADDRESS_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More