C_DeprCalcCalculationDetail

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_DeprCalcCalculationDetail.
-- 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: CDCCALCDET
-- 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_DeprCalcCalculationDetail AS
SELECT
  Header.comp_code AS CompanyCode,
  Header.asset_no AS MasterFixedAsset,
  Header.asset_subno AS FixedAsset,
  SgmntAmt.depr_area AS AssetDepreciationArea,
  SgmntAmt.fisc_year AS FiscalYear,
  SgmntAmt.amount_type AS DepreciationCalcValueType,
  SgmntAmt.curr_type AS CurrencyRole,
  cast(SgmntAmt.period_to as faa_md_dt_period_to preserving type) AS ToFiscalPeriod,
  SgmntAmt.currency AS DisplayCurrency,
  SgmntAmt.basevalue AS DeprCalcBaseAmtInDC,
  SgmntAmt.baseval_prev AS PYABaseAmountInDspCurrency,
  SgmntAmt.perfactor_raw AS DepreciationCalcPeriodFactor,
  SgmntAmt.percent_raw AS DeprCalcBaseValuePercent,
  SgmntAmt.amount AS CalculatedAmountInDspCrcy,
  SgmntAmt.amount_prev AS PYACalculatedAmountInDspCrcy,
  SgmntAmt.amount_skipped AS DepreciationCalcAmtIsSkipped,
  SgmntAmt.minvalue AS DepreciationCalcCtffAmtInDC,
  SgmntAmt.no_minval AS NetBookValueCalcIsBelowZero,
  SgmntAmt.cur_apc AS CurrentYearAcqnProdnAmtInDC,
  SgmntAmt.cur_revl AS CurrentYearRplcmtRevalAmtInDC,
  SgmntAmt.cur_invs AS CurrentYearInvmtGrantAmtInDC,
  SgmntAmt.cur_depr_o AS CurrentYearOrdnryDeprAmtInDC,
  SgmntAmt.cur_depr_s AS CurrentYearSpecialDeprAmtInDC,
  SgmntAmt.cur_depr_u AS CurrentYearUnplndDeprAmtInDC,
  SgmntAmt.cur_resv AS CurrentYearTransfOfRsrvAmtInDC,
  SgmntAmt.cur_intr AS CurrentYearInterestAmtInDC,
  SgmntAmt.cur_revl_d AS CYrRevaluationODeprAmtInDC,
  SgmntAmt.cur_downp AS CurrentYearDownPaymentAmtInDC,
  SgmntAmt.prev_prev_apc AS PYAAcqnProdnAmtInDspCrcy,
  SgmntAmt.prev_prev_revl AS FYSPrptnRevalRplcmtAmtInDC,
  SgmntAmt.prev_prev_invs AS FYStrtPYAInvmtGrantAmtInDC,
  SgmntAmt.prev_prev_depr_o AS FYStrtPYAPrptnlODeprAmtInDC,
  SgmntAmt.prev_prev_depr_s AS FYStrtPYAPrptnlSDeprAmtInDC,
  SgmntAmt.prev_prev_depr_u AS FYStrtPYAPrptnlUDeprAmtInDC,
  SgmntAmt.prev_prev_resv AS FYStrtPYAPrptnlReserveAmtInDC,
  SgmntAmt.prev_prev_intr AS FYStrtPYAPrptnlInterestAmtInDC,
  SgmntAmt.prev_prev_revl_d AS FYSPrptnlRevalODeprAmtInDC,
  SgmntAmt.prev_prev_downp AS FYStrtPYADownPaytAmtInDC,
  SgmntAmt.prev_cur_apc AS CurrentYearPYAAcqnProdnAmtInDC,
  SgmntAmt.prev_cur_revl AS CurrentYearPrptnlRRVAmtInDC,
  SgmntAmt.prev_cur_invs AS CurrentYrPYAInvmtGrantAmtInDC,
  SgmntAmt.prev_cur_depr_o AS CurYrPYAPrptnlODeprAmtInDC,
  SgmntAmt.prev_cur_depr_s AS CurYrPYAPrptnlSDeprAmtInDC,
  SgmntAmt.prev_cur_depr_u AS CurYrPYAPrptnlUDeprAmtInDC,
  SgmntAmt.prev_cur_resv AS CurrentYrPrptnlReserveAmtInDC,
  SgmntAmt.prev_cur_intr AS CurYrPYAPrptnlInterestAmtInDC,
  SgmntAmt.prev_cur_revl_d AS CurYrPrptnlODeprRevalAmtInDC,
  SgmntAmt.prev_cur_downp AS CurrentYrPYADownPaymentAmtInDC,
  SgmntAmt.base_add AS DeprCalcAddlBaseAmtInDspCrcy,
  SgmntAmt.base_add_prev AS PYAAdditionalBaseAmtInDC,
  SgmntAmt.minval_prev AS PYACutoffAmountInDspCrcy,
  SgmntAmt.minval_perc_used AS CtffValueIsCalculated,
  SgmntAmt.netvalue AS NetBookValueAmtInDspCrcy,
  SgmntAmt.netval_prev AS PYANetBookValueAmtInDC,
  SgmntAmt.sum_apc AS AccmltdAcqnProductionAmount,
  SgmntAmt.sum_apc_prev AS PYAAccmltdAcqnProdnAmtInDC,
  SgmntAmt.am_add AS AdditionalAmountInDC,
  SgmntAmt.am_add_prev AS PYAAdditionalAmountInDspCrcy,
  SgmntAmt.sign AS Sign,
  SgmntAmt.perseg_reduced AS DeprCalcReducedPerdVal,
  SgmntAmt.amount_reduced AS AmountIsReduced
FROM P_DeprTraceHeader AS Header
INNER JOIN P_DeprTraceSegmentAmount AS SgmntAmt 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]
;