I_BPWEBSITEURLTP
Business Partner Website
I_BPWEBSITEURLTP is a CDS View in S/4HANA. Business Partner Website. It contains 10 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_BPWebsiteURL | view | from | CONSUMPTION | Consumption View for BP website |
Fields (10)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AddressID | AddressID | 1 |
| KEY | BusinessPartner | BusinessPartner | 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: 'IBPWEBSITEURLTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business Partner Website'
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.writeEnabled: true
@ObjectModel.writeDraftPersistence: 'BUPA_WEBURL_D'
@ObjectModel.draftEnabled:true
@ObjectModel.semanticKey: ['BusinessPartner','AddressID','Person', 'OrdinalNumber', 'ValidityStartDate', 'IsDefaultURLAddress' ] // Need to check
@ObjectModel.createEnabled
@ObjectModel.updateEnabled
@ObjectModel.deleteEnabled
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
define view I_BPWebsiteURLTP as select from I_BPWebsiteURL as BPWebsiteURL
association [1..1] to I_BusinessPartnerTP as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
association [1..1] to I_BusinessPartnerAddressTP as _BusinessPartnerAddress on $projection.AddressID = _BusinessPartnerAddress.AddressNumber
and $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner
{
key BPWebsiteURL.BusinessPartner,
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
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
BPWebsiteURL.WebsiteURL,
@ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
_BusinessPartner,
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
_BusinessPartnerAddress
}