C_BPTelephoneNumber

DDL: C_BPTELEPHONENUMBER SQL: CBPTELEPHONENO Type: view CONSUMPTION

BP Telephone Number Consumption view

C_BPTelephoneNumber is a Consumption CDS View that provides data about "BP Telephone Number Consumption view" in SAP S/4HANA. It reads from 1 data source (I_BPTelephoneNumberTP) and exposes 15 fields with key fields BusinessPartner, AddressID, Person, OrdinalNumber. It has 5 associations to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_BPTelephoneNumberTP BPTelephoneNumber from

Associations (5)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CBPTELEPHONENO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label BP Telephone Number Consumption view 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 (15)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPTelephoneNumberTP BusinessPartner
KEY AddressID I_BPTelephoneNumberTP AddressID
KEY Person I_BPTelephoneNumberTP Person
KEY OrdinalNumber I_BPTelephoneNumberTP OrdinalNumber
DestinationLocationCountry I_BPTelephoneNumberTP DestinationLocationCountry
TelephoneCountryPrefix _TelCntryPrefixValueHelp TelephoneCountryPrefix
PhoneNumber I_BPTelephoneNumberTP PhoneNumber
PhoneNumberExtension I_BPTelephoneNumberTP PhoneNumberExtension
IsDefaultPhoneNumber I_BPTelephoneNumberTP IsDefaultPhoneNumber
AddressCommunicationRemarkText I_BPTelephoneNumberTP AddressCommunicationRemarkText
_BusinessPartnerAddress _BusinessPartnerAddress
_BusinessPartnerSupplier _BusinessPartnerSupplier
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_TelCntryPrefixValueHelp _TelCntryPrefixValueHelp 
@AbapCatalog.sqlViewName: 'CBPTELEPHONENO'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'BP Telephone Number Consumption view'

@Metadata.allowExtensions: true

@ObjectModel.type: #CONSUMPTION
@ObjectModel.writeEnabled: true
@ObjectModel: {
    semanticKey: ['BusinessPartner','AddressID','Person','OrdinalNumber' ],
    createEnabled,
    updateEnabled,
    deleteEnabled
}
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true

@VDM.viewType: #CONSUMPTION

define view C_BPTelephoneNumber
  as select from I_BPTelephoneNumberTP as BPTelephoneNumber

  association [1..1] to C_BusinessPartnerAddress  as _BusinessPartnerAddress  on  $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner
                                                                              and $projection.AddressID       = _BusinessPartnerAddress.AddressNumber

  association [1..1] to C_BusinessPartnerCustomer as _BusinessPartnerCustomer on  $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner

  association [1..1] to C_BusinessPartner         as _BusinessPartner         on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner

  association [1..1] to C_BusinessPartnerSupplier as _BusinessPartnerSupplier on  $projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner

  association [0..1] to C_TelephoneCountryVHTemp  as _TelCntryPrefixValueHelp on  $projection.DestinationLocationCountry = _TelCntryPrefixValueHelp.Country

{
  key BPTelephoneNumber.BusinessPartner,
  key BPTelephoneNumber.AddressID,
  key BPTelephoneNumber.Person,
  key BPTelephoneNumber.OrdinalNumber,
      //@ObjectModel: {

      //      foreignKey.association: '_TelCntryPrefixValueHelp'

      //    }

      @Consumption.valueHelp: '_TelCntryPrefixValueHelp'
      BPTelephoneNumber.DestinationLocationCountry,
      @ObjectModel.readOnly: true
      _TelCntryPrefixValueHelp.TelephoneCountryPrefix,
      BPTelephoneNumber.PhoneNumber,
      BPTelephoneNumber.PhoneNumberExtension,
      @ObjectModel.readOnly: true
      BPTelephoneNumber.IsDefaultPhoneNumber,
      BPTelephoneNumber.AddressCommunicationRemarkText,

      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _BusinessPartnerAddress,
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _BusinessPartnerSupplier,
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _BusinessPartnerCustomer,
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _BusinessPartner,
      _TelCntryPrefixValueHelp
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_TELEPHONECOUNTRYVHTEMP",
"I_BPTELEPHONENUMBERTP"
],
"ASSOCIATED":
[
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERADDRESS",
"C_BUSINESSPARTNERCUSTOMER",
"C_BUSINESSPARTNERSUPPLIER",
"C_TELEPHONECOUNTRYVHTEMP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More