I_BusPartTelephoneNumberGov

@AbapCatalog.sqlViewName: 'IBPPHONENUMGOV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'BP Governance Telephone Number'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
define view I_BusPartTelephoneNumberGov
  as select from I_BusPartTelephoneNumberProc

  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
  association [0..1] to I_MasterDataChangeProcess   as _MasterDataChangeProcess on  $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess
  association [0..1] to I_BPProtectedAddress        as _BPProtectedAddress      on  $projection.MDChgProcessSrceObject = _BPProtectedAddress.BusinessPartner
                                                                                and $projection.AddressNumber          = _BPProtectedAddress.AddressID
{
      //I_BusPartTelephoneNumberProc

  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key AddressNumber,
  key OrdinalNumber,
      DestinationLocationCountry,
      IsDefaultPhoneNumber,
      //CommNumberIsNotUsed,

      PhoneNumber,
      PhoneNumberExtension,
      InternationalPhoneNumber,
      PhoneIsSMSEnabled,
      PhoneNumberType,
      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,
      _BPProtectedAddress
//      _BPContactPersonAddr

}
where
  MDChgProcessSourceModified <> 'D'
union all

select from       I_BPTelephoneNumber
  left outer join but020 on AddressID = but020.addrnumber

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

association [0..1] to I_BPProtectedAddress        as _BPProtectedAddress  on  $projection.MDChgProcessSrceObject = _BPProtectedAddress.BusinessPartner
                                                                          and $projection.AddressNumber          = _BPProtectedAddress.AddressID
{
  key '000000000000'                              as MasterDataChangeProcess,
  key '0000'                                      as MDChgProcessStep,
  key ''                                          as MDChgProcessSrceSystem,
  key BusinessPartner                             as MDChgProcessSrceObject,
  key AddressID                                   as AddressNumber,
  key OrdinalNumber,

      //BusinessPartner,

      //AddressID,

      DestinationLocationCountry,
      IsDefaultPhoneNumber,
      PhoneNumber,
      PhoneNumberExtension,
      InternationalPhoneNumber,
      PhoneIsSMSEnabled,
      PhoneNumberType,
      ValidityStartDateTime,
      ValidityEndDateTime,
      cast( 'X' as abap_boolean preserving type ) as MasterDataIsCurrent,

      _BusinessPartner,
      _BPProtectedAddress
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPTELEPHONENUMBER",
"I_BUSPARTTELEPHONENUMBERPROC",
"I_MASTERDATACHANGEPROCESS",
"BUT020"
],
"ASSOCIATED":
[
"I_BPPROTECTEDADDRESS",
"I_BUSINESSPARTNERGOV",
"I_MASTERDATACHANGEPROCESS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/