C_DeprCalcCalculationTerm

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_DeprCalcCalculationTerm.
-- 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: CDCCALCTERM
-- 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_DeprCalcCalculationTerm 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,
  SgmntAmt.period_to AS ToFiscalPeriod,
  SgmntAmt.period_from_dt AS FromFiscalPeriod,
  SgmntAmt.periods_dt AS NumberOfPeriodsInFiscalYear,
  SgmntAmt.periods_short_fy_dt AS NumberOfPerdsInShortenedFsclYr,
  SgmntAmt.depr_key_dt AS DepreciationKey,
  SgmntAmt.phase_dt AS DepreciationPhase,
  SgmntAmt.start_date_dt AS DepreciationStartDate,
  SgmntAmt.start_prd_dt AS DepreciationFiscalPeriod,
  SgmntAmt.start_yr_dt AS DepreciationStartYear,
  SgmntAmt.leas_paymt_cycle_dt AS LeasePaymentCycle,
  SgmntAmt.leas_no_payments_dt AS NumberOfLeasePayments,
  SgmntAmt.leas_intrst_rate_dt AS InterestRateInPercent,
  SgmntAmt.leas_per_payment_dt AS PeriodicLeasePaymentAmtInDC,
  SgmntAmt.leas_adv_payment_dt AS LeaseIsPayedInAdvance,
  SgmntAmt.useful_life_dt AS UsefulLifeInPeriods,
  SgmntAmt.useful_life_prds_dt AS PlannedUsefulLifeInPeriods,
  SgmntAmt.useful_life_yrs_dt AS PlannedUsefulLifeInYears,
  SgmntAmt.exp_life_dt AS ExpiredUsefulLifeInPerds,
  SgmntAmt.exp_life_seg_dt AS ExpiredUsefulLifeInTimeSegment,
  SgmntAmt.exp_life_new_dt AS ChgOvrYrExpiredUsflLifeInPerds,
  SgmntAmt.age_index_dt AS RplcmtValueAgingIndexSers,
  SgmntAmt.rplcmntval_index_dt AS ReplacementValueIndexSers,
  SgmntAmt.revaltn_key_dt AS AssetRevaluationKey,
  SgmntAmt.scrapvalue_dt AS AssetScrapAmountInDspCrcy,
  SgmntAmt.scrapvalue_prctg_dt AS AcqnProdnCostScrapPercent,
  SgmntAmt.neg_values_dt AS NegativeAmountIsAllowed,
  SgmntAmt.changeover_yr_dt AS DeprKeyChangeoverYear,
  SgmntAmt.changeover_prd_dt AS DeprKeyChangeoverPeriod,
  SgmntAmt.changeover_ind_dt AS ExactDayYearChangeOver,
  SgmntAmt.var_dep_portion_dt AS VariableDeprPercent,
  SgmntAmt.shift_fact_dt AS ShiftOperationFactor,
  SgmntAmt.is_shutdown_dt AS IsShutDown,
  SgmntAmt.assetclass_dt AS AssetClass,
  SgmntAmt.cap_date_dt AS AssetCapitalizationDate,
  SgmntAmt.initial_acq_dt AS AcquisitionValueDate,
  SgmntAmt.initial_acq_yr_dt AS FirstAcquisitionFiscalYear,
  SgmntAmt.initial_acq_prd_dt AS FirstAcquisitionFiscalPeriod,
  SgmntAmt.orig_acq_date_dt AS OriginalFixedAssetValueDate,
  SgmntAmt.last_ret_date_dt AS LastRetirementValueDate,
  SgmntAmt.usage_impact_ind_dt AS MltplShftUseShutdownInflncFctr,
  SgmntAmt.sort_indicator_dt AS DepreciationCalcSortKey,
  SgmntAmt.multi_level_indx_dt AS DepreciationCalcStepIndex,
  SgmntAmt.cutof_value_indx_dt AS DepreciationCalcCtffIndex,
  SgmntAmt.ignore_memval_dt AS MemoValueIsNotConsidered,
  SgmntAmt.has_tddp_dt AS AssetHasTimeDependentValnParam,
  SgmntAmt.to_date_of_tddp_dt AS DepreciationCalcValidToDate,
  SgmntAmt.grp_asset_assgnd_dt AS IsGroupAsset,
  SgmntAmt.use_usage_data_dt AS AssetUsageIsConsidered,
  SgmntAmt.range_length_dt AS SegmentGenerationIntvlInPerds,
  SgmntAmt.calc_inflation_dt AS InflationCalcIsPerformed,
  SgmntAmt.calc_perform_dt AS DepreciationValueIsCalculated,
  SgmntAmt.use_alignment_dt AS ValueTypeHasSamePerdIntervals,
  SgmntAmt.use_max_periods_dt AS IndividualPerdCalcIsPerformed,
  SgmntAmt.use_days_dt AS DepreciationCalcIsToExactDate,
  SgmntAmt.first_day_in_yr_dt AS FiscalYearStartDate,
  SgmntAmt.last_day_in_yr_dt AS FiscalYearEndDate,
  SgmntAmt.is_shortfiscyear_dt AS FiscalYearIsShortened,
  SgmntAmt.is_behind_ul_dt AS PeriodIntervalIsAftUsflLifeEnd,
  SgmntAmt.amount_factor_dt AS MltplShftUseShutdownCrrtnFctr,
  SgmntAmt.use_exp_life_new_dt AS UsefulLifeIsCalcdFrmChgOvrYr,
  SgmntAmt.currency AS DisplayCurrency,
  SgmntAmt.baseval_key_dt AS DepreciationCalcBaseValueKey,
  SgmntAmt.base_add_key_dt AS DeprCalcAddlBaseValKey,
  SgmntAmt.percent_key_dt AS DepreciationCalcCalcMethod,
  SgmntAmt.percent_stated_dt AS DepreciationCalcExtRateInPct,
  SgmntAmt.usage_object_dt AS FixedAssetUsageObject
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]
;