I_BPCurrentDefaultAddressProc

DDL: I_BPCURRENTDEFAULTADDRESSPROC SQL: IBPCRRDFADDRPROC Type: view BASIC

BP current default address in Process

I_BPCurrentDefaultAddressProc is a Basic CDS View that provides data about "BP current default address in Process" in SAP S/4HANA. It reads from 1 data source (P_BPCurrentDefaultAddressProc) and exposes 8 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
P_BPCurrentDefaultAddressProc P_BPCurrentDefaultAddressProc from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerAddressProc _BusinessPartnerAddress $projection.MasterDataChangeProcess = _BusinessPartnerAddress.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartnerAddress.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartnerAddress.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartnerAddress.MDChgProcessSrceObject and $projection.AddressNumber = _BusinessPartnerAddress.AddressNumber
[1..1] I_BusinessPartnerProcess _BusinessPartner $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartner.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBPCRRDFADDRPROC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label BP current default address in Process view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.preserveKey true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
AddressNumber AddressNumber
ValidityStartDateTime _BusinessPartnerAddress ValidityStartDate
ValidityEndDateTime _BusinessPartnerAddress ValidityEndDate
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'IBPCRRDFADDRPROC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@EndUserText.label: 'BP current default address in Process'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.preserveKey:true
define view I_BPCurrentDefaultAddressProc
  as select from P_BPCurrentDefaultAddressProc
  association [1..1] to I_BusinessPartnerAddressProc as _BusinessPartnerAddress on  $projection.MasterDataChangeProcess = _BusinessPartnerAddress.MasterDataChangeProcess
                                                                                and $projection.MDChgProcessStep        = _BusinessPartnerAddress.MDChgProcessStep
                                                                                and $projection.MDChgProcessSrceSystem  = _BusinessPartnerAddress.MDChgProcessSrceSystem
                                                                                and $projection.MDChgProcessSrceObject  = _BusinessPartnerAddress.MDChgProcessSrceObject
                                                                                and $projection.AddressNumber           = _BusinessPartnerAddress.AddressNumber
  association [1..1] to I_BusinessPartnerProcess     as _BusinessPartner        on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                                and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                                and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                                and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject
  //TODO protected address

{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
      AddressNumber,
      _BusinessPartnerAddress.ValidityStartDate as ValidityStartDateTime,
      _BusinessPartnerAddress.ValidityEndDate   as ValidityEndDateTime,

      _BusinessPartner
}

Learn More