C_BPWebsiteURL

DDL: C_BPWEBSITEURL SQL: CBPWEBSITEURL Type: view CONSUMPTION Package: VDM_MD_BP

Consumption View for BP website

C_BPWebsiteURL is a Consumption CDS View that provides data about "Consumption View for BP website" in SAP S/4HANA. It reads from 1 data source (I_BPWebsiteURLTP) and exposes 14 fields with key fields BusinessPartner, AddressID, Person, OrdinalNumber, ValidityStartDate. It has 4 associations to related views. Part of development package VDM_MD_BP.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_BPWebsiteURLTP BPWebsiteURL from

Associations (4)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CBPWEBSITEURL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Consumption View for BP website 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_BPWebsiteURLTP BusinessPartner
KEY AddressID I_BPWebsiteURLTP AddressID
KEY Person I_BPWebsiteURLTP Person
KEY OrdinalNumber I_BPWebsiteURLTP OrdinalNumber
KEY ValidityStartDate I_BPWebsiteURLTP ValidityStartDate Valid From
KEY IsDefaultURLAddress I_BPWebsiteURLTP IsDefaultURLAddress
SearchURLAddress I_BPWebsiteURLTP SearchURLAddress
AddressCommunicationRemarkText I_BPWebsiteURLTP AddressCommunicationRemarkText
URLFieldLength I_BPWebsiteURLTP URLFieldLength
WebsiteURL I_BPWebsiteURLTP WebsiteURL
_BusinessPartnerAddress _BusinessPartnerAddress
_BusinessPartnerSupplier _BusinessPartnerSupplier
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'CBPWEBSITEURL'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Consumption View for BP website'

@Metadata.allowExtensions: true

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

@Search.searchable: true

@VDM.viewType: #CONSUMPTION
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view C_BPWebsiteURL
  as select from I_BPWebsiteURLTP as BPWebsiteURL

  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

{
  key BPWebsiteURL.BusinessPartner,
  key BPWebsiteURL.AddressID,
  key BPWebsiteURL.Person,
  key BPWebsiteURL.OrdinalNumber,
      @EndUserText.label: 'Valid From'
      @EndUserText.quickInfo: 'Validity Start Date'
      @ObjectModel.readOnly: true
      @UI.hidden: true
  key BPWebsiteURL.ValidityStartDate,
      @ObjectModel.readOnly: true
  key BPWebsiteURL.IsDefaultURLAddress,
      BPWebsiteURL.SearchURLAddress,
      BPWebsiteURL.AddressCommunicationRemarkText,
      @UI.hidden: true
      BPWebsiteURL.URLFieldLength,
      @ObjectModel.sort.enabled: false
      @ObjectModel.filter.enabled: false
      BPWebsiteURL.WebsiteURL as WebsiteURL,

      @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
}

Learn More