I_BUSPARTADDRESSUSAGEPROC

CDS View

Core View: Bus Part Addr Usage (Process)

I_BUSPARTADDRESSUSAGEPROC is a CDS View in S/4HANA. Core View: Bus Part Addr Usage (Process). It contains 8 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 8 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BPAddressUsageProcessChanges view from TRANSACTIONAL Business Partner Process Changes
I_BPAddressUsageProcessChanges view union_all TRANSACTIONAL Business Partner Process Changes
I_BusPartAddressUsageGov view from COMPOSITE Basic view for BP address usage
I_BusPartAddressUsageProcTP view_entity from TRANSACTIONAL Business Partner Addr Usage (Proc Data)

Fields (8)

KeyField CDS FieldsUsed in Views
KEY AddressNumber AddressNumber 1
KEY AddressUsage AddressUsage 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
KEY ValidityEndDate ValidityEndDate 1
MDChgProcessSourceModified MDChgProcessSourceModified 1 
@AbapCatalog.sqlViewName: 'IBPADDRUSAGEPROC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm : #SESSION_VARIABLE
@EndUserText.label: 'Core View: Bus Part Addr Usage (Process)'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_BusPartAddressUsageProc
  as select from but021_fs_prc
  association [1..1] to I_BusinessPartnerProcess as _BusinessPartner    on  but021_fs_prc.process_id      = _BusinessPartner.MasterDataChangeProcess
                                                                        and but021_fs_prc.process_step_no = _BusinessPartner.MDChgProcessStep
                                                                        and but021_fs_prc.source_system   = _BusinessPartner.MDChgProcessSrceSystem
                                                                        and but021_fs_prc.source_id       = _BusinessPartner.MDChgProcessSrceObject
  association [0..1] to I_BPProtectedAddress     as _BPProtectedAddress on  but021_fs_prc.source_id         = _BPProtectedAddress.BusinessPartner
                                                                        and but021_fs_prc.source_addrnumber = _BPProtectedAddress.AddressID
{
      //but021_fs_prc

  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key valid_to                 as ValidityEndDate,
  key adr_kind                 as AddressUsage,
  key source_addrnumber        as AddressNumber,
      partner                  as BusinessPartner,
      valid_from               as ValidityStartDate,
      xdfadu                   as StandardUsage,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      source_recency           as MDChgProcSrceLastChgdDateTime,

      _BusinessPartner,
      _BPProtectedAddress
}

Learn More