I_BPCurrentDefaultAddressGov

DDL: I_BPCURRENTDEFAULTADDRESSGOV SQL: IBPCURRDEFADRGOV Type: view COMPOSITE Package: MDC_BUPA_GOV_BO

BP Current Default Address (Governance)

I_BPCurrentDefaultAddressGov is a Composite CDS View that provides data about "BP Current Default Address (Governance)" in SAP S/4HANA. It reads from 2 data sources (I_BPCurrentDefaultAddress, I_BPCurrentDefaultAddressProc) and exposes 15 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 2 associations to related views. Part of development package MDC_BUPA_GOV_BO.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
I_BPCurrentDefaultAddress I_BPCurrentDefaultAddress union_all
I_BPCurrentDefaultAddressProc I_BPCurrentDefaultAddressProc from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerGov _BusinessPartner $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartner.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject
[0..1] I_MasterDataChangeProcess _MasterDataChangeProcess $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBPCURRDEFADRGOV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label BP Current Default Address (Governance) view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY AddressNumber AddressNumber
ValidityStartDateTime ValidityStartDateTime
ValidityEndDateTime ValidityEndDateTime
KEY MDChgProcessStep
KEY MDChgProcessSrceSystem
KEY MDChgProcessSrceObject BusinessPartner
KEY AddressNumber AddressID
ValidityStartDateTime ValidityStartDateTime
ValidityEndDateTime ValidityEndDateTime
MasterDataIsCurrent
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'IBPCURRDEFADRGOV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'BP Current Default Address (Governance)'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #COMPOSITE
define view I_BPCurrentDefaultAddressGov
  as select from I_BPCurrentDefaultAddressProc
  association [1..1] to I_BusinessPartnerGov      as _BusinessPartner         on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                              and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                              and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                              and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to I_MasterDataChangeProcess as _MasterDataChangeProcess on  $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key AddressNumber,
      ValidityStartDateTime,
      ValidityEndDateTime,

      cast(
        case when MDChgProcessStep = _MasterDataChangeProcess.MDChgProcessCurrentStepNumber and _MasterDataChangeProcess.MDChgProcessCurrentStepNumber <> '0000' or
                  MDChgProcessStep = '0001' and  _MasterDataChangeProcess.MDChgProcessCurrentStepNumber = '0000' then 'X'
//             else ' '

        end as abap_boolean preserving type
      ) as MasterDataIsCurrent,

      _BusinessPartner
}

union all

select from I_BPCurrentDefaultAddress
association [1..1] to I_BusinessPartnerGov as _BusinessPartner on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                               and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                               and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                               and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject
{
  key '000000000000'                              as MasterDataChangeProcess,
  key '0000'                                      as MDChgProcessStep,
  key ''                                          as MDChgProcessSrceSystem,
  key BusinessPartner                             as MDChgProcessSrceObject,
  key AddressID                                   as AddressNumber,
      ValidityStartDateTime,
      ValidityEndDateTime,

      cast( 'X' as abap_boolean preserving type ) as MasterDataIsCurrent,

      _BusinessPartner
}

Learn More