I_BusPartProtectedAddressProc

DDL: I_BUSPARTPROTECTEDADDRESSPROC SQL: IBPPROTADDRPROC Type: view BASIC

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 4 data sources (but020_prc, but021_fs_prc, tb008s, tb008u) and exposes 5 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject.

4 data source(s) 5 fields

Data Sources (4)

SourceAliasJoin Type
but020_prc but020_prc from
but021_fs_prc but021_fs_prc left_outer
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 (5)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess but020_prc process_id
KEY MDChgProcessStep but020_prc process_step_no
KEY MDChgProcessSrceSystem but020_prc source_system
KEY MDChgProcessSrceObject but020_prc source_id
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    but020_prc
    left outer join but021_fs_prc on  but020_prc.process_id        = but021_fs_prc.process_id
                                  and but020_prc.process_step_no   = but021_fs_prc.process_step_no
                                  and but020_prc.source_system     = but021_fs_prc.source_system
                                  and but020_prc.source_id         = but021_fs_prc.source_id
                                  and but020_prc.source_addrnumber = but021_fs_prc.source_addrnumber
                                  and but020_prc.nation            = ' '
    left outer join tb008u        on tb008u.adr_kind = but021_fs_prc.adr_kind
    left outer join tb008s        on tb008s.operation = tb008u.operation
{
  key but020_prc.process_id        as MasterDataChangeProcess,
  key but020_prc.process_step_no   as MDChgProcessStep,
  key but020_prc.source_system     as MDChgProcessSrceSystem,
  key but020_prc.source_id         as MDChgProcessSrceObject,
      cast('E' as bu_protected)    as BPAddressIsProtected
}
group by
  but020_prc.process_id,
  but020_prc.process_step_no,
  but020_prc.source_system,
  but020_prc.source_id
having
  max(
    tb008s.protect
  ) = 'X'

Learn More