C_BPFaxNumber

DDL: C_BPFAXNUMBER SQL: CBPFAXNUMBER Type: view CONSUMPTION

Consumption view for BP Fax Numbers

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

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_BPFaxNumberTP BPFaxNumber 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_BusinessPartnerSupplier _BusinessPartnerSupplier $projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] C_TelephoneCountryVHTemp _FaxCountryPrefixValueHelp $projection.FaxCountry = _FaxCountryPrefixValueHelp.Country

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CBPFAXNUMBER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Consumption view for BP Fax Numbers 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 (16)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPFaxNumberTP BusinessPartner
KEY AddressID I_BPFaxNumberTP AddressID
KEY Person I_BPFaxNumberTP Person
KEY OrdinalNumber I_BPFaxNumberTP OrdinalNumber
FaxCountry I_BPFaxNumberTP FaxCountry
TelephoneCountryPrefix _FaxCountryPrefixValueHelp TelephoneCountryPrefix
FaxNumber I_BPFaxNumberTP FaxNumber
FaxNumberExtension I_BPFaxNumberTP FaxNumberExtension
IsDefaultFaxNumber I_BPFaxNumberTP IsDefaultFaxNumber
InternationalFaxNumber I_BPFaxNumberTP InternationalFaxNumber
AddressCommunicationRemarkText I_BPFaxNumberTP AddressCommunicationRemarkText
_BusinessPartnerAddress _BusinessPartnerAddress
_BusinessPartnerSupplier _BusinessPartnerSupplier
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_FaxCountryPrefixValueHelp _FaxCountryPrefixValueHelp 
@AbapCatalog.sqlViewName: 'CBPFAXNUMBER'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Consumption view for BP Fax Numbers'

@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_BPFaxNumber
  as select from I_BPFaxNumberTP as BPFaxNumber

  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_BusinessPartnerSupplier as _BusinessPartnerSupplier   on  $projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner

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

  association [0..1] to C_TelephoneCountryVHTemp  as _FaxCountryPrefixValueHelp on  $projection.FaxCountry = _FaxCountryPrefixValueHelp.Country

{
      @ObjectModel.readOnly: true
  key BPFaxNumber.BusinessPartner,
      @ObjectModel.readOnly: true
  key BPFaxNumber.AddressID,
      @ObjectModel.readOnly: true
  key BPFaxNumber.Person,
      @ObjectModel.readOnly: true
  key BPFaxNumber.OrdinalNumber,
      //@ObjectModel: {

      //      foreignKey.association: '_FaxCountryPrefixValueHelp'

      //    }

      @Consumption.valueHelp: '_FaxCountryPrefixValueHelp'
      BPFaxNumber.FaxCountry,
      @ObjectModel.readOnly: true
      _FaxCountryPrefixValueHelp.TelephoneCountryPrefix,
      BPFaxNumber.FaxNumber,
      BPFaxNumber.FaxNumberExtension,
      @ObjectModel.readOnly: true
      BPFaxNumber.IsDefaultFaxNumber,
      @ObjectModel.readOnly: true
      BPFaxNumber.InternationalFaxNumber,
      BPFaxNumber.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,
      _FaxCountryPrefixValueHelp
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_TELEPHONECOUNTRYVHTEMP",
"I_BPFAXNUMBERTP"
],
"ASSOCIATED":
[
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERADDRESS",
"C_BUSINESSPARTNERCUSTOMER",
"C_BUSINESSPARTNERSUPPLIER",
"C_TELEPHONECOUNTRYVHTEMP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More