C_AssetKeyFigBalanceComparison

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 C_AssetKeyFigBalanceComparison.
-- 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: CASTKEYFIGBALCMP
-- Parameters: P_MasterFixedAsset : anln1, P_FixedAsset : anln2, P_CompanyCode : bukrs, P_CurrencyRole : fis_curtp, P_Valuation : faa_md_avt_valuation, P_CreationDateTime : timestampl

CREATE VIEW C_AssetKeyFigBalanceComparison AS
SELECT
  AssetDepreciationArea,
  CompanyCode,
  Ledger,
  MasterFixedAsset,
  FixedAsset,
  FiscalYear,
  CurrencyRole,
  cast(AssetAccountingValueType as faa_md_avt_ast_acnt_value_type preserving type ) AS AssetAccountingValueType,
  DisplayCurrency,
  AmountInDisplayCurrency,
  cast('' as faa_md_avt_key_figure_currency) AS AstKeyFigure1DisplayCurrency,
  cast('' as faa_md_avt_key_figure_currency) AS AstKeyFigure2DisplayCurrency,
  cast('' as faa_md_avt_key_figure_currency) AS AstKeyFigure3DisplayCurrency,
  cast('' as faa_md_avt_key_figure_currency) AS AstKeyFigure4DisplayCurrency,
  cast('' as faa_md_avt_key_figure_currency) AS AstKeyFigure5DisplayCurrency,
  cast('' as faa_md_avt_key_figure_currency) AS AstKeyFigure6DisplayCurrency,
  cast('' as faa_md_avt_key_figure_currency) AS AstKeyFigure7DisplayCurrency,
  cast('' as faa_md_avt_key_figure_currency) AS AstKeyFigure8DisplayCurrency,
  cast('' as faa_md_avt_key_figure_currency) AS AstKeyFigure9DisplayCurrency,
  cast('' as faa_md_avt_key_figure_currency) AS AstKeyFigure10DisplayCurrency,
  cast(0 as faa_md_avt_key_figure_value) AS AstKeyFigureAmount1InDspCrcy,
  cast(0 as faa_md_avt_key_figure_value) AS AstKeyFigureAmount2InDspCrcy,
  cast(0 as faa_md_avt_key_figure_value) AS AstKeyFigureAmount3InDspCrcy,
  cast(0 as faa_md_avt_key_figure_value) AS AstKeyFigureAmount4InDspCrcy,
  cast(0 as faa_md_avt_key_figure_value) AS AstKeyFigureAmount5InDspCrcy,
  cast(0 as faa_md_avt_key_figure_value) AS AstKeyFigureAmount6InDspCrcy,
  cast(0 as faa_md_avt_key_figure_value) AS AstKeyFigureAmount7InDspCrcy,
  cast(0 as faa_md_avt_key_figure_value) AS AstKeyFigureAmount8InDspCrcy,
  cast(0 as faa_md_avt_key_figure_value) AS AstKeyFigureAmount9InDspCrcy,
  cast(0 as faa_md_avt_key_figure_value) AS AstKeyFigureAmount10InDspCrcy,
  Criticality
FROM P_AssetKeyFigBalanceComparison
;