R_EmailAddressTP

DDL: R_EMAILADDRESSTP Type: view_entity TRANSACTIONAL Package: S_ADDRESS_RAP_BO

Email Address - TP

R_EmailAddressTP is a Transactional 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 (9)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Email Address - TP view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true 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
_Address _Address 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Email Address - TP'
@Metadata.allowExtensions: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.semanticKey: [ 'AddressID', 'AddressPersonID', 'CommMediumSequenceNumber' ]
@Metadata.ignorePropagatedAnnotations: true
define view entity R_EmailAddressTP
  as select from I_AddressEmailAddress_2
  association to parent R_AddressTP as _Address 
   on $projection.AddressID = _Address.AddressID     
  and $projection.AddressPersonID = _Address.AddressPersonID                                                                                        
{
  key AddressID,
  key AddressPersonID,
  key CommMediumSequenceNumber,
      EmailAddress,
      EmailAddressIsCurrentDefault,
      CommLineNotForUnsolicitedCntct, 
      ValidityStartDate,
      ValidityEndDate,
      _AddressCommunicationRemark[ Language = $session.system_language ].CommunicationRemarkText,
      /* Associations */
      _AddressCommunicationRemark,
      _AddressCommunicationUsage,
      _Address
}

Learn More