R_AddressPhoneNumberTP

DDL: R_ADDRESSPHONENUMBERTP Type: view_entity

Phone Number - TP

R_AddressPhoneNumberTP is a CDS View that provides data about "Phone Number - TP" in SAP S/4HANA. It reads from 1 data source (I_AddressPhoneNumber_2) and exposes 18 fields with key fields AddressID, AddressPersonID, CommMediumSequenceNumber.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_AddressPhoneNumber_2 I_AddressPhoneNumber_2 from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Phone Number - TP view

Fields (18)

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
_AddressCommunicationRemark _AddressCommunicationRemark
_AddressCommunicationUsage _AddressCommunicationUsage
_PhoneNumberCountry _PhoneNumberCountry
_PhoneNumberType _PhoneNumberType
_OrganizationAddress _OrganizationAddress 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Phone Number - TP'
define view entity R_AddressPhoneNumberTP
  as select from I_AddressPhoneNumber_2
  association to parent R_OrganizationAddressTP as _OrganizationAddress on $projection.AddressID = _OrganizationAddress.AddressID
{
  key AddressID,
  key AddressPersonID,
  key CommMediumSequenceNumber,
      PhoneNumberCountry,
      PhNmbrIsCurrentOverallDefault,
      CommLineNotForUnsolicitedCntct,
      PhoneAreaCodeSubscriberNumber,
      PhoneExtensionNumber,
      InternationalPhoneNumber,
      PhoneIsSMSEnabled,
      PhoneNumberType,
      ValidityStartDate,
      ValidityEndDate,
      /* Associations */
      _AddressCommunicationRemark,
      _AddressCommunicationUsage,
      _PhoneNumberCountry,
      _PhoneNumberType,
      _OrganizationAddress
}

Learn More