I_BPADDLCUSTWEBSITEURLTP

CDS View

BO view for Website URL of MLTAS Customers

I_BPADDLCUSTWEBSITEURLTP is a CDS View in S/4HANA. BO view for Website URL of MLTAS Customers. It contains 11 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 11 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_BPAddlCustWebsiteURL view from CONSUMPTION C view for Web URL of MLTAS Customers

Fields (11)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 1
KEY BusinessPartner BusinessPartner 1
KEY Customer Customer 1
KEY IsDefaultURLAddress IsDefaultURLAddress 1
KEY OrdinalNumber OrdinalNumber 1
KEY Person Person 1
KEY ValidityStartDate ValidityStartDate 1
AddressCommunicationRemarkText AddressCommunicationRemarkText 1
SearchURLAddress SearchURLAddress 1
URLFieldLength URLFieldLength 1
WebsiteURL WebsiteURL 1 
@AbapCatalog.sqlViewName: 'IBPADDCWEBURLTP'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.writeEnabled: true
@AccessControl.authorizationCheck: #CHECK 
@AccessControl.personalData.blocking: #REQUIRED

@ObjectModel.writeDraftPersistence: 'BPADDCWEBURL_D'
@ObjectModel.draftEnabled:true

@EndUserText.label: 'BO view for Website URL of MLTAS Customers'
@ObjectModel.semanticKey: ['BusinessPartner', 'Customer', 'AddressID', 'Person', 'OrdinalNumber' ]
@ObjectModel.createEnabled
@ObjectModel.updateEnabled
@ObjectModel.deleteEnabled

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true

define view I_BPAddlCustWebsiteURLTP as select from I_BPWebsiteURL as BPWebsiteURL inner join I_BPMultipleAssignment as BPMultipleAssignment on BPWebsiteURL.AddressID = BPMultipleAssignment.AddressNumber inner join I_Customer as Customer on BPMultipleAssignment.BPObjectID = Customer.Customer
association [1..1] to I_BusinessPartnerTP as _BusinessPartner on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
association [1..1] to I_BPAdditionalCustomerTP as _BPAdditionalCustomer on $projection.BusinessPartner = _BPAdditionalCustomer.BusinessPartner
                                                                         and $projection.Customer = _BPAdditionalCustomer.Customer 

 {
    key BPMultipleAssignment.BusinessPartner,
    key Customer.Customer as Customer,
    key BPWebsiteURL.AddressID,
    key BPWebsiteURL.Person,
    key BPWebsiteURL.OrdinalNumber,
    key BPWebsiteURL.ValidityStartDate,
    key BPWebsiteURL.IsDefaultURLAddress,
    BPWebsiteURL.SearchURLAddress,
    _AddressCommunicationRemark.AddressCommunicationRemarkText,  
    BPWebsiteURL.URLFieldLength,
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.8
    @Search.ranking: #HIGH
    BPWebsiteURL.WebsiteURL,
    
    @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
    _BusinessPartner,
    @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
    _BPAdditionalCustomer
  
}
where BPMultipleAssignment.IsStandardAssignment <> 'X' and BPMultipleAssignment.BPAssignmentCategory = 'CUST'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSCOMMUNICATIONREMARK",
"I_BPMULTIPLEASSIGNMENT",
"I_BPWEBSITEURL",
"I_CUSTOMER"
],
"ASSOCIATED":
[
"I_BPADDITIONALCUSTOMERTP",
"I_BUSINESSPARTNERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More