C_BPAddlCustWebsiteURL

DDL: C_BPADDLCUSTWEBSITEURL SQL: CBPADDCWEBURL Type: view CONSUMPTION

C view for Web URL of MLTAS Customers

C_BPAddlCustWebsiteURL is a Consumption CDS View that provides data about "C view for Web URL of MLTAS Customers" in SAP S/4HANA. It reads from 1 data source (I_BPAddlCustWebsiteURLTP) and exposes 14 fields with key fields BusinessPartner, Customer, AddressID, Person, OrdinalNumber. It has 3 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_BPAddlCustWebsiteURLTP BPCustWebsiteURL from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BPAdditionalCustomer _BPAdditionalCustomer $projection.BusinessPartner = _BPAdditionalCustomer.BusinessPartner and $projection.Customer = _BPAdditionalCustomer.Customer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CBPADDCWEBURL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label C view for Web URL of MLTAS Customers view
Metadata.allowExtensions 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_BPAddlCustWebsiteURLTP BusinessPartner
KEY Customer I_BPAddlCustWebsiteURLTP Customer
KEY AddressID I_BPAddlCustWebsiteURLTP AddressID
KEY Person I_BPAddlCustWebsiteURLTP Person
KEY OrdinalNumber I_BPAddlCustWebsiteURLTP OrdinalNumber
KEY ValidityStartDate I_BPAddlCustWebsiteURLTP ValidityStartDate
KEY IsDefaultURLAddress I_BPAddlCustWebsiteURLTP IsDefaultURLAddress
SearchURLAddress I_BPAddlCustWebsiteURLTP SearchURLAddress
AddressCommunicationRemarkText I_BPAddlCustWebsiteURLTP AddressCommunicationRemarkText
URLFieldLength I_BPAddlCustWebsiteURLTP URLFieldLength
WebsiteURL I_BPAddlCustWebsiteURLTP WebsiteURL
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_BPAdditionalCustomer _BPAdditionalCustomer 
@AbapCatalog.sqlViewName: 'CBPADDCWEBURL'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@EndUserText.label: 'C view for Web URL of MLTAS Customers'

@Metadata.allowExtensions: true 

@ObjectModel: {
    semanticKey: ['BusinessPartner', 'Customer', 'AddressID', 'Person', 'OrdinalNumber' ]
}
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true

@VDM.viewType: #CONSUMPTION

define view C_BPAddlCustWebsiteURL
  as select from I_BPAddlCustWebsiteURLTP as BPCustWebsiteURL
  
  association [1..1]  to C_BusinessPartner         as _BusinessPartner         on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
   
  association [1..1] to C_BusinessPartnerCustomer as _BusinessPartnerCustomer on  $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner

  association [1..1] to C_BPAdditionalCustomer    as _BPAdditionalCustomer    on  $projection.BusinessPartner = _BPAdditionalCustomer.BusinessPartner
                                                                              and $projection.Customer        = _BPAdditionalCustomer.Customer 
  
{
  key BPCustWebsiteURL.BusinessPartner,
  key BPCustWebsiteURL.Customer,
  key BPCustWebsiteURL.AddressID,
  key BPCustWebsiteURL.Person,
  key BPCustWebsiteURL.OrdinalNumber,
  key BPCustWebsiteURL.ValidityStartDate,
      @ObjectModel.readOnly: true
  key BPCustWebsiteURL.IsDefaultURLAddress,
      @ObjectModel.readOnly: true
      BPCustWebsiteURL.SearchURLAddress,
      @ObjectModel.readOnly: true
      BPCustWebsiteURL.AddressCommunicationRemarkText,
      @ObjectModel.readOnly: true
      BPCustWebsiteURL.URLFieldLength,
      @ObjectModel.readOnly: true
      BPCustWebsiteURL.WebsiteURL, 

      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _BusinessPartnerCustomer,
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _BusinessPartner,
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _BPAdditionalCustomer
     
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPADDLCUSTWEBSITEURLTP"
],
"ASSOCIATED":
[
"C_BPADDITIONALCUSTOMER",
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERCUSTOMER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More