I_BusPartProtectedAddressProc

DDL: I_BUSPARTPROTECTEDADDRESSPROC SQL: IBPPROTADDRPROC Type: view BASIC Package: MDC_BUPA_GOV_BO

Core View: Protected Address (Process)

I_BusPartProtectedAddressProc is a Basic CDS View that provides data about "Core View: Protected Address (Process)" in SAP S/4HANA. It reads from 3 data sources (but021_fs_prc, tb008s, tb008u) and exposes 6 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. Part of development package MDC_BUPA_GOV_BO.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
but021_fs_prc but021_fs_prc from
tb008s tb008s left_outer
tb008u tb008u left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBPPROTADDRPROC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
EndUserText.label Core View: Protected Address (Process) view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess but021_fs_prc process_id
KEY MDChgProcessStep but021_fs_prc process_step_no
KEY MDChgProcessSrceSystem but021_fs_prc source_system
KEY MDChgProcessSrceObject but021_fs_prc source_id
KEY AddressNumber but021_fs_prc source_addrnumber
BPAddressIsProtected 
@AbapCatalog.sqlViewName: 'IBPPROTADDRPROC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #BASIC
@EndUserText.label: 'Core View: Protected Address (Process)'
define view I_BusPartProtectedAddressProc
  as select from    but021_fs_prc
    left outer join tb008u on tb008u.adr_kind = but021_fs_prc.adr_kind
    left outer join tb008s on tb008s.operation = tb008u.operation
{
  key but021_fs_prc.process_id                   as MasterDataChangeProcess,
  key but021_fs_prc.process_step_no              as MDChgProcessStep,
  key but021_fs_prc.source_system                as MDChgProcessSrceSystem,
  key but021_fs_prc.source_id                    as MDChgProcessSrceObject,
  key but021_fs_prc.source_addrnumber            as AddressNumber,
      cast('E' as bu_protected preserving type ) as BPAddressIsProtected
}
where
  tb008s.protect = 'X'
group by
  but021_fs_prc.process_id,
  but021_fs_prc.process_step_no,
  but021_fs_prc.source_system,
  but021_fs_prc.source_id,
  but021_fs_prc.source_addrnumber

Learn More