I_BusinessPartnerSourceProcess

DDL: I_BUSINESSPARTNERSOURCEPROCESS SQL: IBPSRCPRC Type: view BASIC Package: MDC_BUPA_GOV_BO

Core View: Business Partner Source In Process Status

I_BusinessPartnerSourceProcess is a Basic CDS View that provides data about "Core View: Business Partner Source In Process Status" in SAP S/4HANA. It reads from 2 data sources (I_BPSourceRecordInProcess, I_MDChangeProcessSource) and exposes 3 fields with key fields MDChgProcessSrceSystem, MDChgProcessSrceFilter. Part of development package MDC_BUPA_GOV_BO.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
I_BPSourceRecordInProcess I_BPSourceRecordInProcess inner
I_MDChangeProcessSource I_MDChangeProcessSource from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBPSRCPRC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Core View: Business Partner Source In Process Status view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessSrceSystem I_MDChangeProcessSource MDChgProcessSrceSystem
KEY MDChgProcessSrceFilter I_MDChangeProcessSource MDChgProcessSrceFilter
MDChgProcNmbrOfSrceInProcess I_BPSourceRecordInProcess MDChgProcNmbrOfSrceInProcess 
@AbapCatalog.sqlViewName: 'IBPSRCPRC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Core View: Business Partner Source In Process Status'
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #BASIC 
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_BusinessPartnerSourceProcess
  as select from I_MDChangeProcessSource
  inner join I_BPSourceRecordInProcess on I_BPSourceRecordInProcess.MDChgProcessSrceSystem = I_MDChangeProcessSource.MDChgProcessSrceSystem
                                          and I_BPSourceRecordInProcess.MDChgProcessSrceFilter = I_MDChangeProcessSource.MDChgProcessSrceFilter
{
  key I_MDChangeProcessSource.MDChgProcessSrceSystem,
  key I_MDChangeProcessSource.MDChgProcessSrceFilter,
      I_BPSourceRecordInProcess.MDChgProcNmbrOfSrceInProcess
}
where
      I_MDChangeProcessSource.MDChgProcessSrceObjectTypeCode                =  '147'
  and I_MDChangeProcessSource.MDChgProcessSrceFilter                        is not initial
  and I_MDChangeProcessSource._MasterDataChangeProcess.MDChgProcessStatus   <> 'F'
  and I_MDChangeProcessSource._MasterDataChangeProcess.MDChgProcessIsErased =  ' '
group by
  I_MDChangeProcessSource.MDChgProcessSrceSystem,
  I_MDChangeProcessSource.MDChgProcessSrceFilter,
  I_BPSourceRecordInProcess.MDChgProcNmbrOfSrceInProcess

Learn More