C_BPContactTelNmbr

DDL: C_BPCONTACTTELNMBR SQL: CBPCPTELNUM Type: view CONSUMPTION Package: VDM_MD_BP
25 Fields 1 Data Sources 4 Associations

C View for BP Contact Telephone number

C_BPContactTelNmbr is a Consumption CDS View that provides data about "C View for BP Contact Telephone number" in SAP S/4HANA. It reads from 1 data source (I_BPContactTelNmbrTP) and exposes 25 fields with key fields BusinessPartner1, BusinessPartner2, RelationshipNumber, ValidityEndDate, AddressID. It has 4 associations to related views. Part of development package VDM_MD_BP.

Data Sources (1)

SourceAliasJoin Type
I_BPContactTelNmbrTP TelNumber from

Associations (4)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner1 = _BusinessPartner.BusinessPartner
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner1 = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BusinessPartnerSupplier _BusinessPartnerSupplier $projection.BusinessPartner1 = _BusinessPartnerSupplier.BusinessPartner
[1..1] C_BPContactAddress _BPContactAddress $projection.BusinessPartner1 = _BPContactAddress.BusinessPartner1 and $projection.BusinessPartner2 = _BPContactAddress.BusinessPartner2 and $projection.RelationshipNumber = _BPContactAddress.RelationshipNumber and $projection.ValidityEndDate = _BPContactAddress.ValidityEndDate and $projection.AddressID = _BPContactAddress.AddressID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CBPCPTELNUM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label C View for BP Contact Telephone number view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true 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 (25)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner1 I_BPContactTelNmbrTP BusinessPartner1 Partner
KEY BusinessPartner2 I_BPContactTelNmbrTP BusinessPartner2 Partner
KEY RelationshipNumber I_BPContactTelNmbrTP RelationshipNumber BP Rel. Number
KEY ValidityEndDate I_BPContactTelNmbrTP ValidityEndDate ValidTo
KEY AddressID I_BPContactTelNmbrTP AddressID Ship-to address
KEY OrdinalNumber I_BPContactTelNmbrTP OrdinalNumber Sequence Number
BusinessPartner1ForEdit I_BPContactTelNmbrTP BusinessPartner1ForEdit Busn. Partner
BusinessPartner2ForEdit I_BPContactTelNmbrTP BusinessPartner2ForEdit Busn. Partner
ValidityEndDateForEdit I_BPContactTelNmbrTP ValidityEndDateForEdit Valid To
AddressIDForEdit I_BPContactTelNmbrTP AddressIDForEdit Address Number
OrdinalNumberForEdit I_BPContactTelNmbrTP OrdinalNumberForEdit Sequence Number
RelationshipNumberForEdit I_BPContactTelNmbrTP RelationshipNumberForEdit BP Rel. Number
DestinationLocationCountry I_BPContactTelNmbrTP DestinationLocationCountry Country/Region
CountryDialingCode I_BPContactTelNmbrTP CountryDialingCode Tel. to
IsDefaultPhoneNumber I_BPContactTelNmbrTP IsDefaultPhoneNumber TRUE
CommNumberIsNotUsed I_BPContactTelNmbrTP CommNumberIsNotUsed Do not use
PhoneNumber I_BPContactTelNmbrTP PhoneNumber Telephone no.
PhoneNumberExtension I_BPContactTelNmbrTP PhoneNumberExtension Extension
PhoneIsSMSEnabled
PhoneNumberType I_BPContactTelNmbrTP PhoneNumberType Phone number type
AddressCommunicationRemarkText I_BPContactTelNmbrTP AddressCommunicationRemarkText Notes
_BusinessPartner _BusinessPartner
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartnerSupplier _BusinessPartnerSupplier
_BPContactAddress _BPContactAddress

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_BPContactTelNmbr.
-- 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: CBPCPTELNUM

CREATE VIEW C_BPContactTelNmbr AS
SELECT
  TelNumber.BusinessPartner1 AS BusinessPartner1,
  TelNumber.BusinessPartner2 AS BusinessPartner2,
  TelNumber.RelationshipNumber AS RelationshipNumber,
  TelNumber.ValidityEndDate AS ValidityEndDate,
  TelNumber.AddressID AS AddressID,
  TelNumber.OrdinalNumber AS OrdinalNumber,
  TelNumber.BusinessPartner1ForEdit AS BusinessPartner1ForEdit,
  TelNumber.BusinessPartner2ForEdit AS BusinessPartner2ForEdit,
  TelNumber.ValidityEndDateForEdit AS ValidityEndDateForEdit,
  TelNumber.AddressIDForEdit AS AddressIDForEdit,
  TelNumber.OrdinalNumberForEdit AS OrdinalNumberForEdit,
  TelNumber.RelationshipNumberForEdit AS RelationshipNumberForEdit,
  TelNumber.DestinationLocationCountry AS DestinationLocationCountry,
  TelNumber.CountryDialingCode AS CountryDialingCode,
  TelNumber.IsDefaultPhoneNumber AS IsDefaultPhoneNumber,
  TelNumber.CommNumberIsNotUsed AS CommNumberIsNotUsed,
  TelNumber.PhoneNumber AS PhoneNumber,
  TelNumber.PhoneNumberExtension AS PhoneNumberExtension,
  cast( TelNumber.PhoneIsSMSEnabled as abap_boolean) AS PhoneIsSMSEnabled,
  TelNumber.PhoneNumberType AS PhoneNumberType,
  TelNumber.AddressCommunicationRemarkText AS AddressCommunicationRemarkText
FROM I_BPContactTelNmbrTP AS TelNumber
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner1 = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner1 = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerSupplier AS _BusinessPartnerSupplier ON BusinessPartner1 = _BusinessPartnerSupplier.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BPContactAddress AS _BPContactAddress ON BusinessPartner1 = _BPContactAddress.BusinessPartner1 AND BusinessPartner2 = _BPContactAddress.BusinessPartner2 AND RelationshipNumber = _BPContactAddress.RelationshipNumber AND ValidityEndDate = _BPContactAddress.ValidityEndDate AND AddressID = _BPContactAddress.AddressID  -- association [1..1]
;

Learn More