I_BkPOACompanyCodeVH

DDL: I_BKPOACOMPANYCODEVH Type: view_entity COMPOSITE Package: FCLM_POA

Company Code

I_BkPOACompanyCodeVH is a Composite CDS View that provides data about "Company Code" in SAP S/4HANA. It reads from 2 data sources (fclmpoa_c_authgr, I_CompanyCodeVH) and exposes 22 fields with key field CompanyCode. It is exposed through 1 OData service (UI_BANKPOWEROFATTORNEY_MNG). It is used in 1 Fiori application: Manage Powers of Attorney for Banking Transactions. Part of development package FCLM_POA.

2 data source(s) Exposed by 1 service(s) Used in 1 Fiori app(s) 22 fields

Data Sources (2)

SourceAliasJoin Type
fclmpoa_c_authgr authgr inner
I_CompanyCodeVH cc from

Parameters (1)

NameTypeDefault
P_BkPOAAuthorizationGroup fclm_poa_auth_group

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Company Code view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey CompanyCode view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view

OData Services (1)

ServiceBindingVersionContractRelease
UI_BANKPOWEROFATTORNEY_MNG UI_BANKPOWEROFATTORNEY_MNG V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F5742 Manage Powers of Attorney for Banking Transactions Transactional With this app, you can represent and manage the powers of attorney for banking transactions for your company codes. A power of attorney for banking transactions represents the legal power of attorney that a company has granted to one or more persons to carry out banking transactions on behalf of the company. In the power of attorney, you assign the principals, the authorized representatives, the bank accounts, and the permitted activities.

Manage Powers of Attorney for Banking Transactions

Business Role: Cash Manager

With is feature, you can represent and manage the powers of attorney for banking transactions for your company codes. A power of attorney for banking transactions represents the legal power of attorney that a company has granted to one or more persons to carry out banking transactions on behalf of the company. In the power of attorney, you assign the principals, the authorized representatives, the bank accounts, and the permitted activities.

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCodeVH CompanyCode
CompanyCodeName I_CompanyCodeVH CompanyCodeName
BkPOAAuthorizationGroup fclmpoa_c_authgr poa_auth_group
ControllingArea I_CompanyCodeVH ControllingArea
CityName I_CompanyCodeVH CityName
Country I_CompanyCodeVH Country
Currency I_CompanyCodeVH Currency
Language I_CompanyCodeVH Language
ChartOfAccounts I_CompanyCodeVH ChartOfAccounts
FiscalYearVariant I_CompanyCodeVH FiscalYearVariant
Company I_CompanyCodeVH Company
CreditControlArea I_CompanyCodeVH CreditControlArea
CountryChartOfAccounts I_CompanyCodeVH CountryChartOfAccounts
FinancialManagementArea I_CompanyCodeVH FinancialManagementArea
_ChartOfAccounts I_CompanyCodeVH _ChartOfAccounts
_ControllingArea I_CompanyCodeVH _ControllingArea
_Country I_CompanyCodeVH _Country
_CountryChartOfAccounts I_CompanyCodeVH _CountryChartOfAccounts
_CreditControlArea I_CompanyCodeVH _CreditControlArea
_Currency I_CompanyCodeVH _Currency
_FiscalYearVariant I_CompanyCodeVH _FiscalYearVariant
_Language I_CompanyCodeVH _Language 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@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 one join  fclmpoa_c_authcc as authcc on authcc.company_code  = cc.CompanyCode
                                                      and authcc.poa_auth_group = $parameters.P_BkPOAAuthorizationGroup
{
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
  key cc.CompanyCode        as CompanyCode,
      cc.CompanyCodeName,
      @UI.hidden: true
      authgr.poa_auth_group as BkPOAAuthorizationGroup,
      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

Learn More