I_BPPROTECTEDADDRESS
Business Partner Protected Addresses
I_BPPROTECTEDADDRESS is a CDS View in S/4HANA. Business Partner Protected Addresses. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BPProtectedAddressGov | view_entity | union_all | Protected Address Governance |
@AbapCatalog.sqlViewName: 'IBPPROTADDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Business Partner Protected Addresses'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_BPProtectedAddress
as select from P_BPProtectedAddrUsageCount
association [1] to I_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
{
key BusinessPartner,
key AddressID,
case
when BPProtectedAddrUsageCount > 0
then cast('E' as bu_protected)
when BPProtectedAddrUsageCount = 0
then cast(' ' as bu_protected)
end as BPAddressIsProtected,
_BusinessPartner
}