C_FaxNumberTP

DDL: C_FAXNUMBERTP Type: view_entity CONSUMPTION Package: S_ADDRESS_RAP_BO
16 Fields 1 Data Sources 1 OData Services

Projection view for R_FaxNumberTP

C_FaxNumberTP is a Consumption CDS View that provides data about "Projection view for R_FaxNumberTP" in SAP S/4HANA. It reads from 1 data source (R_FaxNumberTP) and exposes 16 fields with key fields AddressID, AddressPersonID, CommMediumSequenceNumber. It is exposed through 1 OData service (UI_ADDRESS). Part of development package S_ADDRESS_RAP_BO.

Data Sources (1)

SourceAliasJoin Type
R_FaxNumberTP R_FaxNumberTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Projection view for R_FaxNumberTP view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_ADDRESS UI_ADDRESS V4 C1 NOT_RELEASED

Fields (16)

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

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

Learn More