I_BPProtectedAddressGov

DDL: I_BPPROTECTEDADDRESSGOV Type: view_entity Package: MDC_BUPA_GOV_BO

Protected Address Governance

I_BPProtectedAddressGov is a CDS View that provides data about "Protected Address Governance" in SAP S/4HANA. It reads from 2 data sources (I_BPProtectedAddress, I_BusPartProtectedAddressProc) and exposes 10 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. Part of development package MDC_BUPA_GOV_BO.

Data Sources (2)

SourceAliasJoin Type
I_BPProtectedAddress I_BPProtectedAddress union_all
I_BusPartProtectedAddressProc I_BusPartProtectedAddressProc from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Protected Address Governance view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY AddressNumber AddressNumber
KEY MDChgProcessStep
KEY MDChgProcessSrceSystem
KEY MDChgProcessSrceObject BusinessPartner
KEY AddressNumber AddressID
BPAddressIsProtected BPAddressIsProtected
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Protected Address Governance'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPProtectedAddressGov
  as select from I_BusPartProtectedAddressProc
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key AddressNumber,
      BPAddressIsProtected
}
union all

select from I_BPProtectedAddress
{
  key '000000000000'  as MasterDataChangeProcess,
  key '0000'          as MDChgProcessStep,
  key ''              as MDChgProcessSrceSystem,
  key BusinessPartner as MDChgProcessSrceObject,
  key AddressID       as AddressNumber,
      BPAddressIsProtected
}
where
  BPAddressIsProtected = 'E'