P_FxdAstTransInPreviousQuarter

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

CREATE VIEW P_FxdAstTransInPreviousQuarter AS
SELECT
  P_FixedAssetTransactionOvw.CompanyCode AS CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  AssetDepreciationArea,
  P_FixedAssetTransactionOvw.Ledger AS Ledger,
  cast ('TRANS_ACQ' as faa_asset_transaction_type) AS AssetAccountingKeyFigureSet,
  CurrencyRole,
  CompanyCodeName,
  AssetCostCenter,
  AssetClass,
  AssetPlant,
  BusinessArea,
  Segment,
  AssetProfitCenter,
  cast('PQ' 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_FiscalCalendarDateForLedger AS _QuarterPeriod ON I_FiscalYearPeriodForLedger.FiscalPeriodStartDate = _QuarterPeriod.CalendarDate AND P_FixedAssetTransactionOvw.CompanyCode = _QuarterPeriod.CompanyCode AND P_FixedAssetTransactionOvw.Ledger = _QuarterPeriod.Ledger  -- association [1..1]
-- UNION with additional select branch(es): P_FixedAssetTransactionOvw
;