C_BPMobilePhoneNumber

DDL: C_BPMOBILEPHONENUMBER SQL: CBPMOBILEPHNO Type: view CONSUMPTION
14 Fields 1 Data Sources 5 Associations

Consumption view for BP Mobile number

C_BPMobilePhoneNumber is a Consumption CDS View that provides data about "Consumption view for BP Mobile number" in SAP S/4HANA. It reads from 1 data source (I_BPMobilePhoneNumberTP) and exposes 14 fields with key fields BusinessPartner, AddressID, Person, OrdinalNumber. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPMobilePhoneNumberTP BPMobilePhoneNumber from

Associations (5)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartnerAddress _BusinessPartnerAddress $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner and $projection.AddressID = _BusinessPartnerAddress.AddressNumber
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BusinessPartnerSupplier _BusinessPartnerSupplier $projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner
[0..1] C_TelephoneCountryVHTemp _MblCountryText $projection.MobilePhoneCountry = _MblCountryText.Country

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CBPMOBILEPHNO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Consumption view for BP Mobile number view
Metadata.allowExtensions true view
ObjectModel.type #CONSUMPTION view
ObjectModel.writeEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPMobilePhoneNumberTP BusinessPartner Issuing Authority
KEY AddressID I_BPMobilePhoneNumberTP AddressID Ship-to address
KEY Person I_BPMobilePhoneNumberTP Person Person/ Farm/ Field
KEY OrdinalNumber I_BPMobilePhoneNumberTP OrdinalNumber Sequence Number
MobilePhoneCountry I_BPMobilePhoneNumberTP MobilePhoneCountry Country/Region
TelephoneCountryPrefix _MblCountryText TelephoneCountryPrefix Tel. to
MobilePhoneNumber I_BPMobilePhoneNumberTP MobilePhoneNumber Telephone
IsDefaultPhoneNumber I_BPMobilePhoneNumberTP IsDefaultPhoneNumber TRUE
AddressCommunicationRemarkText I_BPMobilePhoneNumberTP AddressCommunicationRemarkText Notes
_BusinessPartnerAddress _BusinessPartnerAddress
_BusinessPartnerSupplier _BusinessPartnerSupplier
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_MblCountryText _MblCountryText

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_BPMobilePhoneNumber.
-- 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: CBPMOBILEPHNO

CREATE VIEW C_BPMobilePhoneNumber AS
SELECT
  BPMobilePhoneNumber.BusinessPartner AS BusinessPartner,
  BPMobilePhoneNumber.AddressID AS AddressID,
  BPMobilePhoneNumber.Person AS Person,
  BPMobilePhoneNumber.OrdinalNumber AS OrdinalNumber,
  BPMobilePhoneNumber.MobilePhoneCountry AS MobilePhoneCountry,
  _MblCountryText.TelephoneCountryPrefix AS TelephoneCountryPrefix,
  BPMobilePhoneNumber.MobilePhoneNumber AS MobilePhoneNumber,
  BPMobilePhoneNumber.IsDefaultPhoneNumber AS IsDefaultPhoneNumber,
  BPMobilePhoneNumber.AddressCommunicationRemarkText AS AddressCommunicationRemarkText
FROM I_BPMobilePhoneNumberTP AS BPMobilePhoneNumber
LEFT OUTER JOIN C_BusinessPartnerAddress AS _BusinessPartnerAddress ON BusinessPartner = _BusinessPartnerAddress.BusinessPartner AND AddressID = _BusinessPartnerAddress.AddressNumber  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerSupplier AS _BusinessPartnerSupplier ON BusinessPartner = _BusinessPartnerSupplier.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_TelephoneCountryVHTemp AS _MblCountryText ON MobilePhoneCountry = _MblCountryText.Country  -- association [0..1]
;

Learn More