I_BusPartScriptedOrgAddrGov

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Bus Partner Org Addr Vers for Gov'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
define view entity I_BusPartScriptedOrgAddrGov
  as select from I_BusPartScriptedOrgAddrProc
  association [1..1] to I_BusinessPartnerGov          as _BusinessPartnerGov      on  $projection.MasterDataChangeProcess = _BusinessPartnerGov.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _BusinessPartnerGov.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _BusinessPartnerGov.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _BusinessPartnerGov.MDChgProcessSrceObject
  association [0..1] to I_BusPartProtectedAddressProc as _BPProtectedAddress      on  $projection.MasterDataChangeProcess = _BPProtectedAddress.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _BPProtectedAddress.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _BPProtectedAddress.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _BPProtectedAddress.MDChgProcessSrceObject
  association [0..1] to I_MasterDataChangeProcess     as _MasterDataChangeProcess on  $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key AddressNumber,
  key AddressRepresentationCode,
      BusinessPartner,
      ValidityStartDate,
      ValidityEndDate,
      BusinessPartnerAddressUUID,
      CareOfName,
      AdditionalStreetSuffixName,
      CorrespondenceLanguage,
      PrfrdCommMediumType,
      POBox,
      POBoxIsWithoutNumber,
      POBoxPostalCode,
      POBoxLobbyName,
      POBoxDeviatingCityName,
      POBoxDeviatingRegion,
      POBoxDeviatingCountry,
      DeliveryServiceTypeCode,
      DeliveryServiceNumber,
      AddressTimeZone,
      CityFileTestStatus,
      FullName,
      CityName,
      DistrictName,
      HomeCityName,
      PostalCode,
      CompanyPostalCode,
      StreetName,
      StreetPrefixName,
      AdditionalStreetPrefixName,
      StreetSuffixName,
      HouseNumber,
      HouseNumberSupplementText,
      Building,
      Floor,
      RoomNumber,
      Country,
      Region,
      BPCountyText,
      BusinessPartnerName1,
      BusinessPartnerName2,
      BusinessPartnerName3,
      BusinessPartnerName4,
      TaxJurisdiction,
      TransportZone,
      FormOfAddress,
      SearchTerm1,
      SearchTerm2,

      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,

      /* Associations */
      _BPProtectedAddress,
      _BusinessPartnerGov
}
where
  MDChgProcessSourceModified <> 'D'

union all

select from I_BusPartScriptedOrgAddress
association [1..1] to I_BusinessPartnerGov          as _BusinessPartnerGov on  $projection.MasterDataChangeProcess = _BusinessPartnerGov.MasterDataChangeProcess
                                                                           and $projection.MDChgProcessStep        = _BusinessPartnerGov.MDChgProcessStep
                                                                           and $projection.MDChgProcessSrceSystem  = _BusinessPartnerGov.MDChgProcessSrceSystem
                                                                           and $projection.MDChgProcessSrceObject  = _BusinessPartnerGov.MDChgProcessSrceObject
association [0..1] to I_BusPartProtectedAddressProc as _BPProtectedAddress on  $projection.MasterDataChangeProcess = _BPProtectedAddress.MasterDataChangeProcess
                                                                           and $projection.MDChgProcessStep        = _BPProtectedAddress.MDChgProcessStep
                                                                           and $projection.MDChgProcessSrceSystem  = _BPProtectedAddress.MDChgProcessSrceSystem
                                                                           and $projection.MDChgProcessSrceObject  = _BPProtectedAddress.MDChgProcessSrceObject
{
  key '000000000000'                              as MasterDataChangeProcess,
  key '0000'                                      as MDChgProcessStep,
  key ''                                          as MDChgProcessSrceSystem,
  key BusinessPartner                             as MDChgProcessSrceObject,
  key AddressNumber,
  key AddressRepresentationCode,
      BusinessPartner,
      ValidityStartDateTime                       as ValidityStartDate,
      ValidityEndDateTime                         as ValidityEndDate,
      hextobin(BusinessPartnerAddressUUID)        as BusinessPartnerAddressUUID,
      CareOfName,
      AdditionalStreetSuffixName,
      CorrespondenceLanguage,
      PrfrdCommMediumType,
      POBox,
      POBoxIsWithoutNumber,
      POBoxPostalCode,
      POBoxLobbyName,
      POBoxDeviatingCityName,
      POBoxDeviatingRegion,
      POBoxDeviatingCountry,
      DeliveryServiceTypeCode,
      DeliveryServiceNumber,
      AddressTimeZone,
      CityFileTestStatus,
      FullName,
      CityName,
      DistrictName,
      HomeCityName,
      PostalCode,
      CompanyPostalCode,
      StreetName,
      StreetPrefixName,
      AdditionalStreetPrefixName,
      StreetSuffixName,
      HouseNumber,
      HouseNumberSupplementText,
      Building,
      Floor,
      RoomNumber,
      Country,
      Region,
      BPCountyText,
      BusinessPartnerName1,
      BusinessPartnerName2,
      BusinessPartnerName3,
      BusinessPartnerName4,
      TaxJurisdiction,
      TransportZone,
      FormOfAddress,
      SearchTerm1,
      SearchTerm2,
      
      cast( 'X' as abap_boolean preserving type ) as MasterDataIsCurrent,
      
      /* Associations */
      _BPProtectedAddress,
      _BusinessPartnerGov
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSPARTSCRIPTEDORGADDRESS",
"I_BUSPARTSCRIPTEDORGADDRPROC",
"I_MASTERDATACHANGEPROCESS"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERGOV",
"I_BUSPARTPROTECTEDADDRESSPROC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/