I_BkPOACompanyCodeVH

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Company Code'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: { usageType:{ serviceQuality: #C, 
                            sizeCategory: #S,
                            dataClass: #ORGANIZATIONAL },
                dataCategory: #VALUE_HELP,
                representativeKey: 'CompanyCode'  }
@Search.searchable: true
@VDM:{ lifecycle.contract.type: #PUBLIC_LOCAL_API,
       viewType: #COMPOSITE }
define view entity I_BkPOACompanyCodeVH
// version with parameter see below: more elegant, but binding to consumption view not working

  as select from    I_CompanyCodeVH  as cc
    inner join fclmpoa_c_authcc as authcc on cc.CompanyCode = authcc.company_code
{
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
  key cc.CompanyCode as CompanyCode,
      authcc.poa_auth_group as BkPOAAuthorizationGroup,
      cc.CompanyCodeName,
      cc.ControllingArea,
      cc.CityName, 
      cc.Country,
      cc.Currency,
      cc.Language,
      cc.ChartOfAccounts,
      cc.FiscalYearVariant,
      cc.Company,
      cc.CreditControlArea,
      cc.CountryChartOfAccounts,
      cc.FinancialManagementArea,
      cc._ChartOfAccounts,
      cc._ControllingArea,
      cc._Country,
      cc._CountryChartOfAccounts,
      cc._CreditControlArea,
      cc._Currency,
      cc._FiscalYearVariant,
      cc._Language     
}

union

select from I_CompanyCodeVH  as cc
 inner join fclmpoa_c_authgr as authgr on  authgr.all_cocodes  = 'X'
{
  key cc.CompanyCode as CompanyCode,  
      authgr.poa_auth_group as BkPOAAuthorizationGroup,
      cc.CompanyCodeName,
      cc.ControllingArea,
      cc.CityName,
      cc.Country,
      cc.Currency,
      cc.Language,
      cc.ChartOfAccounts,
      cc.FiscalYearVariant,
      cc.Company,
      cc.CreditControlArea,
      cc.CountryChartOfAccounts,
      cc.FinancialManagementArea,
      cc._ChartOfAccounts,
      cc._ControllingArea,
      cc._Country,
      cc._CountryChartOfAccounts,
      cc._CreditControlArea,
      cc._Currency,
      cc._FiscalYearVariant,
      cc._Language
}


//  with parameters

//    P_BkPOAAuthorizationGroup : fclm_poa_auth_group

//  as select from    I_CompanyCodeVH  as cc

//    inner join              fclmpoa_c_authgr as authgr on authgr.poa_auth_group = $parameters.P_BkPOAAuthorizationGroup

//    left outer to many join fclmpoa_c_authcc as authcc on authcc.poa_auth_group = $parameters.P_BkPOAAuthorizationGroup

//{

//      @Search.defaultSearchElement: true

//      @Search.ranking: #HIGH

//  key cc.CompanyCode as CompanyCode,

//      cc.CompanyCodeName,

//      cc.ControllingArea,

//      cc.CityName,

//      cc.Country,

//      cc.Currency,

//      cc.Language,

//      cc.ChartOfAccounts,

//      cc.FiscalYearVariant,

//      cc.Company,

//      cc.CreditControlArea,

//      cc.CountryChartOfAccounts,

//      cc.FinancialManagementArea,

//      cc._ChartOfAccounts,

//      cc._ControllingArea,

//      cc._Country,

//      cc._CountryChartOfAccounts,

//      cc._CreditControlArea,

//      cc._Currency,

//      cc._FiscalYearVariant,

//      cc._Language

//}

//

//where

//     authgr.all_cocodes  = 'X'

//  or authcc.company_code = cc.CompanyCode

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODEVH",
"FCLMPOA_C_AUTHCC",
"FCLMPOA_C_AUTHGR"
],
"ASSOCIATED":
[
"I_CHARTOFACCOUNTS",
"I_CONTROLLINGAREA",
"I_COUNTRY",
"I_CREDITCONTROLAREA",
"I_CURRENCY",
"I_FISCALYEARVARIANT",
"I_LANGUAGE"
],
"BASE":
[
"I_COMPANYCODEVH"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/