FAC_CDS_FH_COMPANYCODE

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 FAC_CDS_FH_COMPANYCODE.
-- 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.
-- SQL view name: FACV_FH_COCD

CREATE VIEW FAC_CDS_FH_COMPANYCODE AS
SELECT
  t001.bukrs AS CompanyCode,
  t001.land1 AS Country,
  t001.ort01 AS CityName,
  t001.waers AS Currency,
  t001.spras AS Language,
  t001.ktopl AS ChartOfAccounts,
  t001.ktop2 AS CountryChartOfAccounts,
  t001.rcomp AS Company,
  t001.fikrs AS FinancialManagementArea,
  t001.kkber AS CreditControlArea,
  t001.periv AS FiscalYearVariant,
  t001.xprod AS IsProductive,
  t001.buvar AS ScreenVariant,
  t001.fstva AS FieldStatusVariant,
  t001.opvar AS PostingPeriodVariant,
  t001.wfvar AS WorkflowVariant,
  t001.xcos AS CostOfSalesAccountingStatus,
  t001.adrnr AS AddressID,
  t001.butxt AS CompanyCode_T,
  _Currency._Text[1:Language = $session.system_language].CurrencyName AS Currency_T,
  _Language._Text[1:Language = $session.system_language].LanguageName AS Language_T,
  _Country._Text[1:Language = $session.system_language].CountryName AS Country_T,
  _ChartOfAccounts._Text[1:Language = $session.system_language].ChartOfAccountsName AS ChartOfAccounts_T,
  _FiscalYearVariant._Text[1:Language = $session.system_language].FiscalYearVariantDescription AS FiscalYearVariant_T,
  _CountryChartOfAccounts._Text[1:Language = $session.system_language].ChartOfAccountsName AS CountryChartOfAccounts_T,
  _CreditControlArea._Text[1:Language = $session.system_language].CreditControlAreaName AS CreditControlArea_T,
  _FieldStatusVariant._Text[1:Language = $session.system_language].FieldStatusVariantName AS FieldStatusVariant_T,
  _GlobalCompany.CompanyName AS Company_T,
  cast(concat(bukrs, concat(concat (' (', t001.butxt ), ')') ) as fac_fh_char60) AS CompanyCode_L_T,
  cast(concat(waers, concat(concat (' (', _Currency._Text[1:Language = $session.system_language].CurrencyName ), ')')) as fac_fh_char60) AS Currency_L_T,
  cast(concat(spras, concat(concat (' (', _Language._Text[1:Language = $session.system_language].LanguageName ), ')')) as fac_fh_char60) AS Language_L_T,
  cast(concat(land1, concat(concat (' (', _Country._Text[1:Language = $session.system_language].CountryName ), ')')) as fac_fh_char60) AS Country_L_T,
  cast(concat(ktopl, concat(concat (' (', _ChartOfAccounts._Text[1:Language = $session.system_language].ChartOfAccountsName ), ')')) as fac_fh_char60) AS ChartOfAccounts_L_T,
  cast(concat(periv, concat(concat (' (', _FiscalYearVariant._Text[1:Language = $session.system_language].FiscalYearVariantDescription ), ')')) as fac_fh_char60) AS FiscalYearVariant_L_T,
  cast(concat(ktop2, concat(concat (' (', _CountryChartOfAccounts._Text[1:Language = $session.system_language].ChartOfAccountsName ), ')')) as fac_fh_char60) AS CountryChartOfAccounts_L_T,
  cast(concat(kkber, concat(concat (' (', _CreditControlArea._Text[1:Language = $session.system_language].CreditControlAreaName ), ')')) as fac_fh_char60) AS CreditControlArea_L_T,
  cast(concat(fstva, concat(concat (' (', _FieldStatusVariant._Text[1:Language = $session.system_language].FieldStatusVariantName ), ')')) as fac_fh_char60) AS FieldStatusVariant_L_T,
  cast(concat(rcomp, concat(concat (' (', _GlobalCompany.CompanyName ), ')') ) as fac_fh_char60) AS Company_L_T,
  cast(upper(t001.butxt) as butxt ) AS NodeTextUpper
FROM t001
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CountryChartOfAccounts ON CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CreditControlArea AS _CreditControlArea ON CreditControlArea = _CreditControlArea.CreditControlArea  -- association [0..1]
LEFT OUTER JOIN I_FieldStatusVariant AS _FieldStatusVariant ON FieldStatusVariant = _FieldStatusVariant.FieldStatusVariant  -- association [0..1]
LEFT OUTER JOIN I_Globalcompany AS _GlobalCompany ON Company = _GlobalCompany.Company  -- association [0..1]
;