R_AddressFaxNumberTP

DDL: R_ADDRESSFAXNUMBERTP Type: view_entity
15 Fields 1 Data Sources

Fax Number - TP

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

Data Sources (1)

SourceAliasJoin Type
I_ADDRESSFAXNUMBER_2 I_ADDRESSFAXNUMBER_2 from

Annotations (2)

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

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY AddressID AddressID Ship-to address
KEY AddressPersonID AddressPersonID Person Number
KEY CommMediumSequenceNumber CommMediumSequenceNumber Sequence Number
FaxNumberCountry FaxNumberCountry Country/Region
CommLineNotForUnsolicitedCntct CommLineNotForUnsolicitedCntct Do not use
FaxAreaCodeSubscriberNumber FaxAreaCodeSubscriberNumber Fax
FaxExtensionNumber FaxExtensionNumber Extension
InternationalFaxNumber InternationalFaxNumber Fax Number
FaxNumberIsCurrentDefault FaxNumberIsCurrentDefault Fax is Cur Dflt
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
_AddressCommunicationRemark _AddressCommunicationRemark
_AddressCommunicationUsage _AddressCommunicationUsage
_FaxNumberCountry _FaxNumberCountry
_OrganizationAddress _OrganizationAddress

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_AddressFaxNumberTP.
-- 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_AddressFaxNumberTP AS
SELECT
  AddressID,
  AddressPersonID,
  CommMediumSequenceNumber,
  FaxNumberCountry,
  CommLineNotForUnsolicitedCntct,
  FaxAreaCodeSubscriberNumber,
  FaxExtensionNumber,
  InternationalFaxNumber,
  FaxNumberIsCurrentDefault,
  ValidityStartDate,
  ValidityEndDate
FROM I_ADDRESSFAXNUMBER_2
;

Learn More