I_BusinessPartnerGov

@AbapCatalog.sqlViewName: 'IBPARTNERGOV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
//@Analytics.dataCategory: #DIMENSION

@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Business Partner (Governance)'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
@AbapCatalog.viewEnhancementCategory: [ #PROJECTION_LIST, #UNION ]
define root view I_BusinessPartnerGov
  as select from I_BusinessPartnerProcess
  association [0..1] to I_MasterDataChangeProcess as _MasterDataChangeProcess on $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess
  association [0..1] to I_BusinessPartner         as _ActiveBusinessPartner   on $projection.BusinessPartnerUUID = _ActiveBusinessPartner.BusinessPartnerUUID

{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,

      BusinessPartner,
      BusinessPartnerCategory,
      AuthorizationGroup,
      BusinessPartnerUUID,
      PersonNumber,
      ETag,
      BusinessPartnerName,
      BusinessPartnerFullName,
      CreatedByUser,
      CreationDate,
      CreationTime,
      LastChangedByUser,
      LastChangeDate,
      LastChangeTime,
      BusinessPartnerIsBlocked,
      IsBusinessPurposeCompleted,
      FirstName,
      LastName,
      PersonFullName,
      OrganizationBPName1,
      OrganizationBPName2,
      OrganizationBPName3,
      OrganizationBPName4,
      InternationalLocationNumber1,
      InternationalLocationNumber2,
      InternationalLocationNumber3,
      LegalForm,
      OrganizationFoundationDate,
      OrganizationLiquidationDate,
      Industry,
      IsNaturalPerson,
      IsFemale,
      IsMale,
      IsSexUnknown,
      GenderCodeName,
      FormOfAddress,
      AcademicTitle,
      AcademicTitle2,
      NameFormat,
      NameCountry,
      BusinessPartnerGrouping,
      //GroupType,

      BusinessPartnerType,
      MiddleName,
      AdditionalLastName,
      BusinessPartnerBirthName,
      BusinessPartnerSupplementName,
      //Salutation,

      GroupBusinessPartnerName1,
      GroupBusinessPartnerName2,
      BusinessPartnerGroupType,
      CorrespondenceLanguage,
      Language,
      SearchTerm1,
      SearchTerm2,
      //PhoneticSortField,

      BPLastNameSearchHelp,
      BPFirstNameSearchHelp,
      BusinessPartnerNicknameLabel,
      LastNamePrefix,
      LastNameSecondPrefix,
      Initials,
      IndependentAddressID,
      BirthDate,
      BusinessPartnerBirthplaceName,
      BusinessPartnerDeathDate,
      BusinessPartnerBirthDateStatus,
      NaturalPersonEmployerName,
      BusinessPartnerOccupation,
      BusPartMaritalStatus,
      BusPartNationality,
      IsMarkedForArchiving,
      //CentralBlock,

      ContactPermission,
      BusinessPartnerIDByExtSystem,
      NonResidentCompanyOriginCntry,
      LegalEntityOfOrganization,
      BusinessPartnerPrintFormat,
      BusinessPartnerDataOriginType,
      BusinessPartnerIsNotReleased,
      IsNotContractuallyCapable,

      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,
      _MasterDataChangeProcess.MDChgProcessGoal  as MDChgProcessGoal,
      _ActiveBusinessPartner.AuthorizationGroup  as ActiveAuthorizationGroup,
      DataControllerSet,
      DataController1,
      DataController2,
      DataController3,
      DataController4,
      DataController5,
      DataController6,
      DataController7,
      DataController8,
      DataController9,
      DataController10,
      BPDataControllerIsNotRequired,
      cast( 'P' as abap.char(1) )                as Origin
}

union all

select from I_BusinessPartner as BusinessPartner
association [0..1] to I_BPCountryAddressVariants as _AddressVariants on _AddressVariants.BPCountryDepdntAddressVariant = _AddressVariants.BPCountryDepdntAddressVariant
{
  key '000000000000'                              as MasterDataChangeProcess,
  key '0000'                                      as MDChgProcessStep,
  key ''                                          as MDChgProcessSrceSystem,
  key BusinessPartner                             as MDChgProcessSrceObject,

      BusinessPartner,
      BusinessPartnerCategory,
      AuthorizationGroup,
      BusinessPartnerUUID,
      PersonNumber,
      ETag,
      BusinessPartnerName,
      case BusinessPartnerCategory
            when '1' then
                        case   _AddressVariants.BPCountryDepdntAddressVariant
                          when  '013' then concat_with_space( LastName, FirstName, 1)
                        else case PersonFullName
                          when '' then concat_with_space( FirstName, LastName, 1)
                        else PersonFullName
                         end
                        end
           when '2' then concat_with_space( OrganizationBPName1, OrganizationBPName2, 1)
            else concat_with_space( GroupBusinessPartnerName1, GroupBusinessPartnerName2, 1)
          end                                     as BusinessPartnerFullName,

      CreatedByUser,
      CreationDate,
      CreationTime,
      LastChangedByUser,
      LastChangeDate,
      LastChangeTime,
      BusinessPartnerIsBlocked,
      IsBusinessPurposeCompleted,
      FirstName,
      LastName,
      PersonFullName,
      OrganizationBPName1,
      OrganizationBPName2,
      OrganizationBPName3,
      OrganizationBPName4,
      InternationalLocationNumber1,
      InternationalLocationNumber2,
      InternationalLocationNumber3,
      LegalForm,
      OrganizationFoundationDate,
      OrganizationLiquidationDate,
      Industry,
      IsNaturalPerson,
      IsFemale,
      IsMale,
      IsSexUnknown,
      GenderCodeName,
      //      @ObjectModel.foreignKey.association: '_FormOfAddress'

      //      FormOfAddress                    as FormOfAddressPerson,

      //      @ObjectModel.foreignKey.association: '_FormOfAddress'

      //      FormOfAddress                    as FormOfAddressOrganization,

      FormOfAddress,
      AcademicTitle,
      AcademicTitle2,
      NameFormat,
      NameCountry,
      BusinessPartnerGrouping,
      BusinessPartnerType,
      MiddleName,
      AdditionalLastName,
      BusinessPartnerBirthName,
      BusinessPartnerSupplementName,
      GroupBusinessPartnerName1,
      GroupBusinessPartnerName2,
      BusinessPartnerGroupType,
      CorrespondenceLanguage,
      Language,
      SearchTerm1,
      SearchTerm2,
      BPLastNameSearchHelp,
      BPFirstNameSearchHelp,
      BusinessPartnerNicknameLabel,
      LastNamePrefix,
      LastNameSecondPrefix,
      Initials,
      IndependentAddressID,
      BirthDate,
      BusinessPartnerBirthplaceName,
      BusinessPartnerDeathDate,
      BusinessPartnerBirthDateStatus,
      NaturalPersonEmployerName,
      BusinessPartnerOccupation,
      BusPartMaritalStatus,
      BusPartNationality,
      IsMarkedForArchiving,
      ContactPermission,
      BusinessPartnerIDByExtSystem,
      NonResidentCompanyOriginCntry,
      LegalEntityOfOrganization,
      //TrdCmplncLicenseIsMilitarySctr,

      //TrdCmplncLicenseIsNuclearSctr,

      BusinessPartnerPrintFormat,
      BusinessPartnerDataOriginType,
      BusinessPartnerIsNotReleased,
      IsNotContractuallyCapable,

      cast( 'X' as abap_boolean preserving type ) as MasterDataIsCurrent,
      cast( 'G' as char1 preserving type )        as MDChgProcessGoal,
      AuthorizationGroup                          as ActiveAuthorizationGroup,
      DataControllerSet,
      DataController1,
      DataController2,
      DataController3,
      DataController4,
      DataController5,
      DataController6,
      DataController7,
      DataController8,
      DataController9,
      DataController10,
      BPDataControllerIsNotRequired,

      cast( 'A' as abap.char(1) )                 as Origin
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCOUNTRYADDRESSVARIANTS",
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERPROCESS",
"I_MASTERDATACHANGEPROCESS"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_MASTERDATACHANGEPROCESS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/