I_BPAddressIndependentFax

DDL: I_BPADDRESSINDEPENDENTFAX SQL: I_BPADDINDFAX Type: view BASIC Package: MDC_BUPA_BO
17 Fields 1 Data Sources 1 Associations

BP Address independent Fax

I_BPAddressIndependentFax (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Database & Data Management

I_BPAddressIndependentFax is a Basic CDS View that provides data about "BP Address independent Fax" in SAP S/4HANA. It reads from 1 data source (I_AddressFaxNumber_2) and exposes 17 fields with key fields BusinessPartner, AddressID, AddressPersonID, CommMediumSequenceNumber. It has 1 association to related views. Part of development package MDC_BUPA_BO.

SAP Help Documentation

CategoryCDS Views for Business Partner
Purpose
This CDS view is designed to provide a structured representation of fax number information associated with business partners. It focuses on address-independent fax numbers, that is, it captures fax details that are not associated with a specific address. This CDS view provides the data to answer the following business questions: What are the fax numbers associated with each business partner, independent of their physical address? Which fax numbers are currently set as the default for communication with a business partner? What are the validity periods for each fax number associated with a business partner? How can we access additional communication remarks or usage details related to a business partner's fax number? What is the international format of the fax numbers for business partners?

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: BEGRU_BUPA_GRP – Authorization Group for Business Partners RLTYP – Business Partner Role

Structure
Important Fields Important fields in this view include the following: Field Name Description BusinessPartner Business Partner AddressID Address Number Person Person Number CommMediumSequenceNumber Sequence Number FaxNumberCountry Country/Region FaxAreaCodeSubscriberNumber Fax FaxExtensionNumber Extension InternationalFaxNumber Fax Number FaxNumberIsCurrentDefault Default fax number ValidityStartDateTime Date from when validity starts. ValidityEndDateTime Date when validity ends.

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessDatabase & Data Management
Application ComponentAP-MD-BP-RAP
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageDatabase and Data Management for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view is designed to provide a structured representation of fax number information associated with business partners. It focuses on address-independent fax numbers, that is, it captures fax details that are not associated with a specific address.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the fax numbers associated with each business partner, independent of their physical address?</p></li> <li><p>Which fax numbers are currently set as the default for communication with a business partner?</p></li> <li><p>What are the validity periods for each fax number associated with a business partner?</p></li> <li><p>How can we access additional communication remarks or usage details related to a business partner's fax number?</p></li> <li><p>What is the international format of the fax numbers for business partners?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_AddressFaxNumber_2 I_AddressFaxNumber_2 from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.AddressID = _BusinessPartner.IndependentAddressID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName I_BPADDINDFAX view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
EndUserText.label BP Address independent Fax view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner _BusinessPartner BusinessPartner Business Partner Number
KEY AddressID AddressID Ship-to address
KEY AddressPersonID AddressPersonID Person Number
KEY CommMediumSequenceNumber CommMediumSequenceNumber Sequence Number
FaxNumberCountry FaxNumberCountry Country/Region for Telephone/Fax Number
FaxAreaCodeSubscriberNumber FaxAreaCodeSubscriberNumber Fax Number: Dialing Code and Number
FaxExtensionNumber FaxExtensionNumber Fax no.: Extension
InternationalFaxNumber InternationalFaxNumber Complete Number: Dialing Code+Number+Extension
FaxNumberIsCurrentDefault FaxNumberIsCurrentDefault Indicator : Current Default Fax Number
ValidityStartDateTime Communication Data: Valid From (YYYYMMDDHHMMSS)
ValidityEndDateTime Communication Data: Valid To (YYYYMMDDHHMMSS)
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
_AddressCommunicationRemark _AddressCommunicationRemark
_AddressCommunicationUsage _AddressCommunicationUsage
_FaxNumberCountry _FaxNumberCountry
_BusinessPartner _BusinessPartner

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 I_BPAddressIndependentFax.
-- 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.
-- SQL view name: I_BPADDINDFAX

CREATE VIEW I_BPAddressIndependentFax AS
SELECT
  _BusinessPartner.BusinessPartner AS BusinessPartner,
  AddressID,
  AddressPersonID,
  CommMediumSequenceNumber,
  FaxNumberCountry,
  FaxAreaCodeSubscriberNumber,
  FaxExtensionNumber,
  InternationalFaxNumber,
  FaxNumberIsCurrentDefault,
  cast ( ValidityStartDate as ad_valfrom ) AS ValidityStartDateTime,
  cast ( ValidityEndDate as ad_valto ) AS ValidityEndDateTime,
  ValidityStartDate,
  ValidityEndDate
FROM I_AddressFaxNumber_2
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON AddressID = _BusinessPartner.IndependentAddressID  -- association [1..1]
;

Learn More