R_PhoneNumberTP

DDL: R_PHONENUMBERTP Type: view_entity TRANSACTIONAL Package: S_ADDRESS_RAP_BO

Phone Number - TP

R_PhoneNumberTP is a Transactional CDS View that provides data about "Phone Number - TP" in SAP S/4HANA. It reads from 1 data source (I_AddressPhoneNumber_2) and exposes 19 fields with key fields AddressID, AddressPersonID, CommMediumSequenceNumber. Part of development package S_ADDRESS_RAP_BO.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_AddressPhoneNumber_2 I_AddressPhoneNumber_2 from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Phone Number - 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
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY AddressID AddressID
KEY AddressPersonID AddressPersonID
KEY CommMediumSequenceNumber CommMediumSequenceNumber
PhoneNumberCountry PhoneNumberCountry
PhNmbrIsCurrentOverallDefault PhNmbrIsCurrentOverallDefault
CommLineNotForUnsolicitedCntct CommLineNotForUnsolicitedCntct
PhoneAreaCodeSubscriberNumber PhoneAreaCodeSubscriberNumber
PhoneExtensionNumber PhoneExtensionNumber
InternationalPhoneNumber InternationalPhoneNumber
PhoneIsSMSEnabled PhoneIsSMSEnabled
PhoneNumberType PhoneNumberType
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
CommunicationRemarkText
_AddressCommunicationRemark _AddressCommunicationRemark
_AddressCommunicationUsage _AddressCommunicationUsage
_PhoneNumberCountry _PhoneNumberCountry
_PhoneNumberType _PhoneNumberType
_Address _Address 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Phone Number - 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' ]
@AccessControl.personalData.blocking: #REQUIRED
@Metadata.ignorePropagatedAnnotations: true
define view entity R_PhoneNumberTP
  as select from I_AddressPhoneNumber_2
  association to parent R_AddressTP as _Address 
  on $projection.AddressID = _Address.AddressID
  and $projection.AddressPersonID = _Address.AddressPersonID                                                            
{
  key AddressID,
  key AddressPersonID,
  key CommMediumSequenceNumber,
      PhoneNumberCountry,
      PhNmbrIsCurrentOverallDefault,
      CommLineNotForUnsolicitedCntct,
      PhoneAreaCodeSubscriberNumber,
      PhoneExtensionNumber,
      InternationalPhoneNumber,
      PhoneIsSMSEnabled,
      PhoneNumberType,
      ValidityStartDate,
      ValidityEndDate,
      _AddressCommunicationRemark[ Language = $session.system_language ].CommunicationRemarkText,
      
      /* Associations */
      _AddressCommunicationRemark,
      _AddressCommunicationUsage,
      _PhoneNumberCountry,
      _PhoneNumberType,
      _Address
}

Learn More