I_BkPOACompanyCodeVH

DDL: I_BKPOACOMPANYCODEVH Type: view_entity COMPOSITE
22 Fields 2 Data Sources

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.

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 #NOT_REQUIRED 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

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCodeVH CompanyCode Receiver Company Code
CompanyCodeName I_CompanyCodeVH CompanyCodeName Company Name
BkPOAAuthorizationGroup fclmpoa_c_authgr poa_auth_group Authorization Group
ControllingArea I_CompanyCodeVH ControllingArea Controlling Area
CityName I_CompanyCodeVH CityName Name
Country I_CompanyCodeVH Country Venue: Ctry/Reg
Currency I_CompanyCodeVH Currency Valuation Crcy
Language I_CompanyCodeVH Language Report Text Language
ChartOfAccounts I_CompanyCodeVH ChartOfAccounts Node Class
FiscalYearVariant I_CompanyCodeVH FiscalYearVariant FY Variant
Company I_CompanyCodeVH Company Owner
CreditControlArea I_CompanyCodeVH CreditControlArea Credit Control Area
CountryChartOfAccounts I_CompanyCodeVH CountryChartOfAccounts Chart of Accts
FinancialManagementArea I_CompanyCodeVH FinancialManagementArea FM Area
_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BkPOACompanyCodeVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_BkPOAAuthorizationGroup : fclm_poa_auth_group

CREATE VIEW I_BkPOACompanyCodeVH AS
SELECT
  cc.CompanyCode AS CompanyCode,
  cc.CompanyCodeName AS CompanyCodeName,
  authgr.poa_auth_group AS BkPOAAuthorizationGroup,
  cc.ControllingArea AS ControllingArea,
  cc.CityName AS CityName,
  cc.Country AS Country,
  cc.Currency AS Currency,
  cc.Language AS Language,
  cc.ChartOfAccounts AS ChartOfAccounts,
  cc.FiscalYearVariant AS FiscalYearVariant,
  cc.Company AS Company,
  cc.CreditControlArea AS CreditControlArea,
  cc.CountryChartOfAccounts AS CountryChartOfAccounts,
  cc.FinancialManagementArea AS FinancialManagementArea,
  cc._ChartOfAccounts AS _ChartOfAccounts,
  cc._ControllingArea AS _ControllingArea,
  cc._Country AS _Country,
  cc._CountryChartOfAccounts AS _CountryChartOfAccounts,
  cc._CreditControlArea AS _CreditControlArea,
  cc._Currency AS _Currency,
  cc._FiscalYearVariant AS _FiscalYearVariant,
  cc._Language AS _Language
FROM I_CompanyCodeVH AS cc
INNER JOIN fclmpoa_c_authgr AS authgr ON /* join condition not captured in parsed metadata */
;

Learn More