C_BPCntctPersnFaxNumberTP

DDL: C_BPCNTCTPERSNFAXNUMBERTP Type: view_entity CONSUMPTION
18 Fields 1 Data Sources 1 OData Services

Projection for Contact Fax Number

C_BPCntctPersnFaxNumberTP is a Consumption CDS View that provides data about "Projection for Contact Fax Number" in SAP S/4HANA. It reads from 1 data source (I_BPRelshpCntctPersnFaxNmbrTP) and exposes 18 fields with key fields BusinessPartner1, BusinessPartner2, ValidityEndDate, RelationshipCategory, AddressID. It is exposed through 1 OData service (C_BUSINESSPARTNERTP_2_SRV).

Data Sources (1)

SourceAliasJoin Type
I_BPRelshpCntctPersnFaxNmbrTP I_BPRelshpCntctPersnFaxNmbrTP projection

Annotations (6)

NameValueLevelField
EndUserText.label Projection for Contact Fax Number view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
C_BUSINESSPARTNERTP_2_SRV C_BUSINESSPARTNERTP_2_SRV V2 C1 NOT_RELEASED

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner1 BusinessPartner1 Partner
KEY BusinessPartner2 BusinessPartner2 Partner
KEY ValidityEndDate ValidityEndDate ValidTo
KEY RelationshipCategory RelationshipCategory Relationsh.Cat.
KEY AddressID AddressID Ship-to address
KEY OrdinalNumber OrdinalNumber Sequence Number
KEY BPRelshpCatIsInFwdDirection BPRelshpCatIsInFwdDirection Boolean Variable (X = True, - = False, Space = Unknown)
RelationshipNumber RelationshipNumber BP Rel. Number
FaxCountry FaxCountry Country/Region
TelephoneCountryPrefix TelephoneCountryPrefix Tel. to
IsDefaultFaxNumber IsDefaultFaxNumber Standard No.
CommNumberIsNotUsed CommNumberIsNotUsed Do not use
FaxNumber FaxNumber Fax Number
FaxNumberExtension FaxNumberExtension Extension
AddressCommunicationRemarkText AddressCommunicationRemarkText Notes
CountryNameasCountryNamelocalized
_BusinessPartner1 _BusinessPartner1
_BusinessPartner2 _BusinessPartner2

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_BPCntctPersnFaxNumberTP.
-- 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_BPCntctPersnFaxNumberTP AS
SELECT
  BusinessPartner1,
  BusinessPartner2,
  ValidityEndDate,
  RelationshipCategory,
  AddressID,
  OrdinalNumber,
  BPRelshpCatIsInFwdDirection,
  RelationshipNumber,
  FaxCountry,
  TelephoneCountryPrefix,
  IsDefaultFaxNumber,
  CommNumberIsNotUsed,
  FaxNumber,
  FaxNumberExtension,
  AddressCommunicationRemarkText,
  _CountryPrefix._CountryText.CountryName as CountryName : localized AS CountryNameasCountryNamelocalized
FROM I_BPRelshpCntctPersnFaxNmbrTP
;

Learn More