I_FixedAssetValWithTmpPlanVal

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_FixedAssetValWithTmpPlanVal.
-- 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_CompanyCode : bukrs, P_MasterFixedAsset : anln1, P_FixedAsset : anln2, P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_CreationDateTime : timestampl, P_UserID : username, P_FirstFiscalYear : gjahr

CREATE VIEW I_FixedAssetValWithTmpPlanVal AS
SELECT
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  FiscalYear,
  FiscalPeriod,
  cast('0' as faa_use_val_ty) AS PlannedValueIsInclusive,
  ChartOfDepreciation,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AssetKeyFigureSetSpec.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  LedgerCompanyCodeCrcyRole.CompanyCodeCurrencyRole AS CompanyCodeCurrencyRole,
  LedgerCompanyCodeCrcyRole.GlobalCurrencyRole AS GlobalCurrencyRole,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency2Role AS FreeDefinedCurrency2Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency3Role AS FreeDefinedCurrency3Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency4Role AS FreeDefinedCurrency4Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency5Role AS FreeDefinedCurrency5Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency6Role AS FreeDefinedCurrency6Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency7Role AS FreeDefinedCurrency7Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency8Role AS FreeDefinedCurrency8Role,
  P_FixedAssetLineItem.CompanyCode AS CompanyCode,
  P_FixedAssetLineItem.Ledger AS Ledger,
  _AssetDepreciationArea.LedgerGroup AS LedgerGroup
FROM P_FixedAssetLineItem
INNER JOIN I_AssetKeyFigureSetSpec AS AssetKeyFigureSetSpec ON /* join condition not captured in parsed metadata */
INNER JOIN I_AssetKeyFigureSpecification AS AssetKeyFigureSpec ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRoles AS LedgerCompanyCodeCrcyRole ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AssetDepreciationArea AS _AssetDepreciationArea ON ChartOfDepreciation = _AssetDepreciationArea.ChartOfDepreciation AND AssetDepreciationArea = _AssetDepreciationArea.AssetDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_DepreciationAreaForLedger AS _DepreciationArea ON CompanyCode = _DepreciationArea.CompanyCode AND Ledger = _DepreciationArea.Ledger AND AssetDepreciationArea = _DepreciationArea.AssetDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_LedgerGroup AS _LedgerGroup ON ledgergroup = _LedgerGroup.LedgerGroup  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalPeriod ON FiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod AND CompanyCode = _FiscalPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AssetKeyFigure AS _AssetKeyFigure ON AssetAccountingKeyFigure = _AssetKeyFigure.AssetAccountingKeyFigure  -- association [0..1]
LEFT OUTER JOIN I_ChartOfDepreciation AS _ChartOfDepreciation ON ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency1 ON FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency2 ON FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency3 ON FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency4 ON FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency5 ON FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency6 ON FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency7 ON FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency8 ON FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _CompanyCodeCurrencyRole ON CompanyCodeCurrencyRole = _CompanyCodeCurrencyRole.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _GlobalCurrencyRole ON GlobalCurrencyRole = _GlobalCurrencyRole.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency1Role ON FreeDefinedCurrency1Role = _FreeDefinedCurrency1Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency2Role ON FreeDefinedCurrency2Role = _FreeDefinedCurrency2Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency3Role ON FreeDefinedCurrency3Role = _FreeDefinedCurrency3Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency4Role ON FreeDefinedCurrency4Role = _FreeDefinedCurrency4Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency5Role ON FreeDefinedCurrency5Role = _FreeDefinedCurrency5Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency6Role ON FreeDefinedCurrency6Role = _FreeDefinedCurrency6Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency7Role ON FreeDefinedCurrency7Role = _FreeDefinedCurrency7Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _FreeDefinedCurrency8Role ON FreeDefinedCurrency8Role = _FreeDefinedCurrency8Role.CurrencyRole  -- association [0..1]
-- UNION ALL with additional select branch(es): P_FxdAstPlanValWithTmpPlanVal
;