P_AstKeyFigBalWthAllAreasCube1

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 P_AstKeyFigBalWthAllAreasCube1.
-- 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: PASTKEYFIGBALCB1
-- Parameters: P_CompanyCode : bukrs, P_MasterFixedAsset : anln1, P_FixedAsset : anln2, P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_Ledger : fins_ledger, P_CurrencyRole : fis_curtp, P_CreationDateTime : timestampl, P_UserID : username

CREATE VIEW P_AstKeyFigBalWthAllAreasCube1 AS
SELECT
  Values.CompanyCode AS CompanyCode,
  DepreciationAreaForLedger.AssetDepreciationArea AS AssetDepreciationArea,
  Values.Ledger AS Ledger,
  Values.MasterFixedAsset AS MasterFixedAsset,
  Values.FixedAsset AS FixedAsset,
  Values.FiscalYear AS FiscalYear,
  Values.CurrencyRole AS CurrencyRole,
  Values.AssetAccountingValueType AS AssetAccountingValueType,
  Values.AssetValuationView AS AssetValuationView,
  Values.DisplayCurrency AS DisplayCurrency,
  Values.StartingBalAmtInDspCrcy AS StartingBalAmtInDspCrcy,
  Values.PlannedAmountInDisplayCurrency AS PlannedAmountInDisplayCurrency,
  Values.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  Values.Criticality AS Criticality,
  Values._CompanyCode AS _CompanyCode,
  Values._MasterFixedAsset AS _MasterFixedAsset,
  Values._FixedAsset AS _FixedAsset,
  Values._Ledger AS _Ledger,
  Values._AssetAccountingValueType AS _AssetAccountingValueType,
  Values._Currency AS _Currency,
  Values._CurrencyRole AS _CurrencyRole
FROM I_DepreciationAreaForLedger AS DepreciationAreaForLedger
INNER JOIN I_AssetValuation AS AssetValuation ON /* join condition not captured in parsed metadata */
INNER JOIN P_AstKeyFigBalWthAllAreasCube2 ON /* join condition not captured in parsed metadata */
;