C_DeprCalcCalculationResult

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_DeprCalcCalculationResult.
-- 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: CDCCALCRSLT
-- Parameters: P_MasterFixedAsset : anln1, P_FixedAsset : anln2, P_CompanyCode : bukrs, P_AssetDepreciationArea : fis_afabe, P_Ledger : fins_ledger, P_FiscalYear : fis_gjahr, P_FixedAssetDraftUUID : sdraft_key, P_CurrencyRole : fis_curtp

CREATE VIEW C_DeprCalcCalculationResult AS
SELECT
  Header.comp_code AS CompanyCode,
  Header.asset_no AS MasterFixedAsset,
  Header.asset_subno AS FixedAsset,
  YearAmt.depr_area AS AssetDepreciationArea,
  YearAmt.fisc_year AS FiscalYear,
  YearAmt.curr_type AS CurrencyRole,
  YearAmt.currency AS DisplayCurrency,
  YearAmt.cum_apc AS FYSAccmltdAcqnProdnAmtInDC,
  YearAmt.cum_revl AS FYSAccmltdRRVAmtInDspCrcy,
  YearAmt.cum_invs AS FYSAccmltdInvmtGrantAmtInDC,
  YearAmt.cum_depr_o AS FYSAccmltdOrdnryDeprAmtInDC,
  YearAmt.cum_depr_s AS FYSAccmltdSpecialDeprAmtInDC,
  YearAmt.cum_depr_u AS FYSAccmltdUnplndDeprAmtInDC,
  YearAmt.cum_resv AS FYSAccmltdTransfOfRsrvAmtInDC,
  YearAmt.cum_intr AS FYSAccmltdInterestAmountInDC,
  YearAmt.cum_revl_d AS FYSAccmltdODeprRevalAmtInDC,
  YearAmt.cum_downp AS FYSAccmltdDownPaymentAmtInDC,
  YearAmt.cur_apc AS CurrentYearAcqnProdnAmtInDC,
  YearAmt.cur_revl AS CurrentYearRplcmtRevalAmtInDC,
  YearAmt.cur_invs AS CurrentYearInvmtGrantAmtInDC,
  YearAmt.cur_depr_o AS CurrentYearOrdnryDeprAmtInDC,
  YearAmt.cur_depr_s AS CurrentYearSpecialDeprAmtInDC,
  YearAmt.cur_depr_u AS CurrentYearUnplndDeprAmtInDC,
  YearAmt.cur_resv AS CurrentYearTransfOfRsrvAmtInDC,
  YearAmt.cur_intr AS CurrentYearInterestAmtInDC,
  YearAmt.cur_revl_d AS CYrRevaluationODeprAmtInDC,
  YearAmt.cur_downp AS CurrentYearDownPaymentAmtInDC,
  YearAmt.prev_prev_apc AS FsclYrStrtPYAAcqnProdnAmtInDC,
  YearAmt.prev_prev_revl AS FYSPrptnRevalRplcmtAmtInDC,
  YearAmt.prev_prev_invs AS FYStrtPYAInvmtGrantAmtInDC,
  YearAmt.prev_prev_depr_o AS FYStrtPYAPrptnlODeprAmtInDC,
  YearAmt.prev_prev_depr_s AS FYStrtPYAPrptnlSDeprAmtInDC,
  YearAmt.prev_prev_depr_u AS FYStrtPYAPrptnlUDeprAmtInDC,
  YearAmt.prev_prev_resv AS FYStrtPYAPrptnlReserveAmtInDC,
  YearAmt.prev_prev_intr AS FYStrtPYAPrptnlInterestAmtInDC,
  YearAmt.prev_prev_revl_d AS FYSPrptnlRevalODeprAmtInDC,
  YearAmt.prev_prev_downp AS FYStrtPYADownPaytAmtInDC,
  YearAmt.prev_cur_revl AS CurrentYearPrptnlRRVAmtInDC,
  YearAmt.prev_cur_depr_o AS CurYrPYAPrptnlODeprAmtInDC,
  YearAmt.prev_cur_depr_s AS CurYrPYAPrptnlSDeprAmtInDC,
  YearAmt.prev_cur_depr_u AS CurYrPYAPrptnlUDeprAmtInDC,
  YearAmt.prev_cur_intr AS CurYrPYAPrptnlInterestAmtInDC,
  YearAmt.prev_cur_revl_d AS CurYrPrptnlODeprRevalAmtInDC,
  YearAmt.total_apc AS AccmltdAcqnProductionAmount,
  YearAmt.total_revl AS AccmltdReplacementRevalAmtInDC,
  YearAmt.total_invs AS AccmltdInvestmentGrantAmtInDC,
  YearAmt.total_depr_o AS AccumulatedOrdinaryDeprAmount,
  YearAmt.total_depr_s AS AccumulatedSpecialDeprAmount,
  YearAmt.total_depr_u AS AccumulatedUnplannedDeprAmount,
  YearAmt.total_resv AS AccumulatedTrnsfdRsrvAmtInDC,
  YearAmt.total_intr AS AccumulatedInterestAmountInDC,
  YearAmt.total_revl_d AS AccmltdRevalOrdinaryDeprAmount,
  YearAmt.total_downp AS AccumulatedDownPaymentAmtInDC,
  YearAmt.prev_apc AS PYAAcqnProdnAmtInDspCrcy,
  YearAmt.prev_revl AS PYARevalRplcmtValueAmountInDC,
  YearAmt.prev_invs AS PYAInvestmentGrantAmtInDC,
  YearAmt.prev_depr_o AS PYAOrdinaryDeprAmtInDspCrcy,
  YearAmt.prev_depr_s AS PYASpecialDeprAmtInDspCrcy,
  YearAmt.prev_depr_u AS PYAUnplannedDeprAmtInDspCrcy,
  YearAmt.prev_resv AS PYATransferredReserveAmtInDC,
  YearAmt.prev_intr AS PYAInterestAmountInDspCrcy,
  YearAmt.prev_revl_d AS PYAOrdnryDeprPlndRevalAmtInDC,
  YearAmt.prev_downp AS PYADownPaymentAmountInDspCrcy,
  YearAmt.shortened_depr_o AS OrdinaryDeprReducedAmtInDC,
  YearAmt.shortened_depr_s AS SpecialDeprReducedAmtInDC
FROM P_DeprTraceHeader AS Header
INNER JOIN P_DeprTraceYearAmount AS YearAmt ON /* join condition not captured in parsed metadata */
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_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [0..1]
;