I_ControllingArea

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_ControllingArea.
-- 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: IFICONTAREA

CREATE VIEW I_ControllingArea AS
SELECT
  cast( tka01.kokrs as fis_kokrs preserving type ) AS ControllingArea,
  cast( tka01.lmona as fis_periv preserving type ) AS FiscalYearVariant,
  cast( tka01.bezei as fis_kokrs_name preserving type ) AS ControllingAreaName,
  cast( tka01.waers as fis_kwaer preserving type ) AS ControllingAreaCurrency,
  cast( tka01.ktopl as fis_ktopl preserving type ) AS ChartOfAccounts,
  cast( tka01.khinr as fis_ksthi preserving type ) AS CostCenterStandardHierarchy,
  tka01.erkrs AS OperatingConcern,
  cast( tka01.phinr as fis_prctr_std_hier preserving type ) AS ProfitCenterStandardHierarchy,
  cast( tka01.bphinr as fis_co_bphinr preserving type ) AS BusinessProcessStandardHier,
  cast( tka01.kstar_fin as fis_kstar_fin preserving type ) AS CreditDownPaymentDefaultGLAcct,
  cast( tka01.kstar_fid as fis_kstar_fid preserving type ) AS DebitDownPaymentDefaultGLAcct,
  cast( tka01.ctyp as fis_co_ctyp preserving type ) AS ControllingAreaCurrencyRole,
  tka01.fikrs AS FinancialManagementArea,
  cast( tka01.vname as fis_co_vname preserving type ) AS ControllingAreaResponsibleUser,
  cast( tka01.defprctr as fis_defprctr preserving type ) AS DefaultProfitCenter,
  cast( tka01.leading_fsv as fis_leading_fsv preserving type ) AS CtrlgStdFinStatementVersion
FROM tka01
LEFT OUTER JOIN I_SAPClient ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_FinancialStatementHier AS _FinancialStatementVersion ON CtrlgStdFinStatementVersion = _FinancialStatementVersion.FinancialStatementHierarchy  -- association [0..*]
LEFT OUTER JOIN I_FinancialStatementHierT AS _FinancialStatementVersionText ON CtrlgStdFinStatementVersion = _FinancialStatementVersionText.FinancialStatementHierarchy  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _Currency ON ControllingAreaCurrency = _Currency.Currency  -- association [1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [1]
;