P_DeprTraceSegmentAmount

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_DeprTraceSegmentAmount.
-- 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: PDTSEGAMT

CREATE VIEW P_DeprTraceSegmentAmount AS
SELECT
  comp_code,
  asset_no,
  asset_subno,
  depr_area,
  fisc_year,
  amount_type,
  curr_type,
  period_to,
  currency,
  basevalue,
  baseval_prev,
  percent_raw,
  amount,
  amount_prev,
  minvalue,
  cur_apc,
  cur_revl,
  cur_invs,
  cur_depr_o,
  cur_depr_s,
  cur_depr_u,
  cur_resv,
  cur_intr,
  cur_revl_d,
  cur_downp,
  prev_cur_apc,
  base_add,
  minval_prev,
  netvalue,
  netval_prev,
  sum_apc,
  sum_apc_prev,
  am_add,
  am_add_prev,
  sign,
  useful_life,
  exp_life,
  exp_life_new,
  exp_life_seg,
  peryear,
  baseval_key,
  base_add_key,
  baseval_max,
  percent_key,
  percent_max,
  percent_min,
  amount_max,
  skip_amount,
  check_amount,
  minval_memo,
  no_minval,
  minval_key,
  rounding_off,
  use_days,
  fyear_dt,
  area_dt,
  curr_type_dt,
  period_to_dt,
  periods_dt,
  depr_key_dt,
  phase_dt,
  start_prd_dt,
  start_yr_dt,
  exp_life_dt,
  age_index_dt,
  cap_date_dt,
  has_tddp_dt,
  use_days_dt,
  currency_dt
FROM faat_dctr_segamt
;