P_FxdAstTransInPreviousYear

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_FxdAstTransInPreviousYear.
-- 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: PFASSETTRNPY
-- Parameters: P_KeyDate : fagl_keydate, P_TodayDate : fagl_keydate, P_AssetAccountingKeyFigureSet : faa_key_figure_set

CREATE VIEW P_FxdAstTransInPreviousYear AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  AssetDepreciationArea,
  Ledger,
  cast ('TRANS_ACQ' as faa_asset_transaction_type) AS AssetAccountingKeyFigureSet,
  CurrencyRole,
  CompanyCodeName,
  AssetCostCenter,
  AssetClass,
  AssetPlant,
  Segment,
  AssetProfitCenter,
  cast('PY' as faa_period_type) AS PeriodType,
  SelectedCurrencyBranch,
  DisplayCurrency,
  sum (AcqnProdnAmtInDspCrcy) AS AcqnProdnAmtInDspCrcy,
  sum (ValueAdjustmentAmtInDspCrcy) AS ValueAdjustmentAmtInDspCrcy,
  sum (RtrmtNetBookValueAmtInDspCrcy) AS RtrmtNetBookValueAmtInDspCrcy,
  cast((sum (AcqnProdnAmtInDspCrcy)) as farp_amount_display_crcy) AS AmountInDisplayCurrency,
  P_AssetAccountingKeyFigureSet: 'TRANS_RET' AS P_AssetAccountingKeyFigureSetTRANS_RET
FROM P_FixedAssetTransactionOvw
LEFT OUTER JOIN P_FixedAssetTransactionType AS _AssetTransactionType ON _AssetTransactionType.AssetTransactionType = AssetAccountingKeyFigureSet AND _AssetTransactionType.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_AssetClass AS _AssetClass ON AssetClass = _AssetClass.AssetClass  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetAssgmt AS _FixedAssetAssgmt ON _FixedAssetAssgmt.CompanyCode = CompanyCode AND _FixedAssetAssgmt.MasterFixedAsset = MasterFixedAsset AND _FixedAssetAssgmt.FixedAsset = FixedAsset  -- association [0..*]
LEFT OUTER JOIN P_FixedAssetOvwFiscalPeriod AS _FiscalPeriod ON P_FixedAssetTransactionOvw.FiscalYearVariant = _FiscalPeriod.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriodForVariant ON _FiscalPeriodForVariant.FiscalYearVariant = P_FixedAssetTransactionOvw.FiscalYearVariant AND _FiscalPeriodForVariant.FiscalYear = P_FixedAssetTransactionOvw.FiscalYear AND _FiscalPeriodForVariant.FiscalPeriod = P_FixedAssetTransactionOvw.FiscalPeriod  -- association [0..1]
-- UNION with additional select branch(es): P_FixedAssetTransactionOvw
;