R_PhoneNumberTP

DDL: R_PHONENUMBERTP Type: view_entity TRANSACTIONAL Package: S_ADDRESS_RAP_BO
19 Fields 1 Data Sources

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.

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 Ship-to address
KEY AddressPersonID AddressPersonID Person Number
KEY CommMediumSequenceNumber CommMediumSequenceNumber Sequence Number
PhoneNumberCountry PhoneNumberCountry Venue: Ctry/Reg
PhNmbrIsCurrentOverallDefault PhNmbrIsCurrentOverallDefault
CommLineNotForUnsolicitedCntct CommLineNotForUnsolicitedCntct
PhoneAreaCodeSubscriberNumber PhoneAreaCodeSubscriberNumber Telephone
PhoneExtensionNumber PhoneExtensionNumber Extension
InternationalPhoneNumber InternationalPhoneNumber Telephone no.
PhoneIsSMSEnabled PhoneIsSMSEnabled SMS-Enab.
PhoneNumberType PhoneNumberType Phone number type
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
CommunicationRemarkText
_AddressCommunicationRemark _AddressCommunicationRemark
_AddressCommunicationUsage _AddressCommunicationUsage
_PhoneNumberCountry _PhoneNumberCountry
_PhoneNumberType _PhoneNumberType
_Address _Address

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_PhoneNumberTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_PhoneNumberTP AS
SELECT
  AddressID,
  AddressPersonID,
  CommMediumSequenceNumber,
  PhoneNumberCountry,
  PhNmbrIsCurrentOverallDefault,
  CommLineNotForUnsolicitedCntct,
  PhoneAreaCodeSubscriberNumber,
  PhoneExtensionNumber,
  InternationalPhoneNumber,
  PhoneIsSMSEnabled,
  PhoneNumberType,
  ValidityStartDate,
  ValidityEndDate,
  _AddressCommunicationRemark[ Language = $session.system_language ].CommunicationRemarkText AS CommunicationRemarkText
FROM I_AddressPhoneNumber_2
;

Learn More