P_DEPRTRACESEGMENTAMOUNT
P_DEPRTRACESEGMENTAMOUNT is a CDS View in S/4HANA. It contains 160 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_DeprCalcCalculationDetail | view_entity | inner | CONSUMPTION | Depreciation Calculation: Calculation Details |
| C_DeprCalcCalculationParameter | view_entity | inner | CONSUMPTION | Depreciation Calculation: Calculation Parameters |
| C_DeprCalcCalculationTerm | view_entity | inner | CONSUMPTION | Depreciation Calculation: Calculation Terms |
| C_DeprCalcPeriodSetting | view_entity | inner | CONSUMPTION | Depreciation Calculation: Period Settings |
Fields (160)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | amount_type | DepreciationCalcValueType | 4 |
| KEY | curr_type | CurrencyRole | 4 |
| KEY | depr_area | AssetDepreciationArea | 4 |
| KEY | fisc_year | FiscalYear | 4 |
| KEY | period_to | ToFiscalPeriod | 3 |
| age_index_dt | RplcmtValueAgingIndexSers | 1 | |
| am_add | AdditionalAmountInDC | 1 | |
| am_add_prev | PYAAdditionalAmountInDspCrcy | 1 | |
| amount | CalculatedAmountInDspCrcy | 1 | |
| amount_factor | MltplShftUseShutdownCrrtnFctr | 1 | |
| amount_factor_dt | MltplShftUseShutdownCrrtnFctr | 1 | |
| amount_max | MaximumDepreciationAmountInDC | 1 | |
| amount_prev | PYACalculatedAmountInDspCrcy | 1 | |
| amount_reduced | AmountIsReduced | 1 | |
| amount_skipped | DepreciationCalcAmtIsSkipped | 1 | |
| assetclass_dt | AssetClass | 1 | |
| base_add | DeprCalcAddlBaseAmtInDspCrcy | 1 | |
| base_add_key | DeprCalcAddlBaseValKey | 1 | |
| base_add_key_dt | DeprCalcAddlBaseValKey | 1 | |
| base_add_prev | PYAAdditionalBaseAmtInDC | 1 | |
| baseval_fact_add | DeprCalcReducnOfBaseAmountInDC | 1 | |
| baseval_factor | DepreciationCalcBaseValueFctr | 1 | |
| baseval_key | DepreciationCalcBaseValueKey | 1 | |
| baseval_key_dt | DepreciationCalcBaseValueKey | 1 | |
| baseval_max | DepreciationCalcMaxBaseAmtInDC | 1 | |
| baseval_prev | PYABaseAmountInDspCurrency | 1 | |
| baseval_stated | DepreciationCalcExtBaseAmtInDC | 1 | |
| basevalue | DeprCalcBaseAmtInDC | 1 | |
| calc_inflation_dt | InflationCalcIsPerformed | 1 | |
| calc_perform_dt | DepreciationValueIsCalculated | 1 | |
| cap_date_dt | AssetCapitalizationDate | 1 | |
| changeover_ind_dt | ExactDayYearChangeOver | 1 | |
| changeover_prd | DeprKeyChangeoverPeriod | 1 | |
| changeover_prd_dt | DeprKeyChangeoverPeriod | 1 | |
| changeover_yr | DeprKeyChangeoverYear | 1 | |
| changeover_yr_dt | DeprKeyChangeoverYear | 1 | |
| check_amount | DepreciationCalcAmtIsChecked | 1 | |
| cur_apc | CurrentYearAcqnProdnAmtInDC | 1 | |
| cur_depr_o | CurrentYearOrdnryDeprAmtInDC | 1 | |
| cur_depr_s | CurrentYearSpecialDeprAmtInDC | 1 | |
| cur_depr_u | CurrentYearUnplndDeprAmtInDC | 1 | |
| cur_downp | CurrentYearDownPaymentAmtInDC | 1 | |
| cur_intr | CurrentYearInterestAmtInDC | 1 | |
| cur_invs | CurrentYearInvmtGrantAmtInDC | 1 | |
| cur_resv | CurrentYearTransfOfRsrvAmtInDC | 1 | |
| cur_revl | CurrentYearRplcmtRevalAmtInDC | 1 | |
| cur_revl_d | CYrRevaluationODeprAmtInDC | 1 | |
| currency | DisplayCurrency | 3 | |
| cutof_value_indx_dt | DepreciationCalcCtffIndex | 1 | |
| depr_key_dt | DepreciationKey | 1 | |
| exp_life | ExpiredUsefulLifeInPerds | 1 | |
| exp_life_dt | ExpiredUsefulLifeInPerds | 1 | |
| exp_life_new | ChgOvrYrExpiredUsflLifeInPerds | 1 | |
| exp_life_new_dt | ChgOvrYrExpiredUsflLifeInPerds | 1 | |
| exp_life_seg | ExpiredUsefulLifeInTimeSegment | 1 | |
| exp_life_seg_dt | ExpiredUsefulLifeInTimeSegment | 1 | |
| first_day_in_yr_dt | FiscalYearStartDate | 1 | |
| grp_asset_assgnd_dt | IsGroupAsset | 1 | |
| has_tddp_dt | AssetHasTimeDependentValnParam | 1 | |
| ignore_memval_dt | MemoValueIsNotConsidered | 1 | |
| ignore_short_yr | ShortenedFiscalYearIsIgnored | 1 | |
| initial_acq_dt | AcquisitionValueDate | 1 | |
| initial_acq_prd_dt | FirstAcquisitionFiscalPeriod | 1 | |
| initial_acq_yr_dt | FirstAcquisitionFiscalYear | 1 | |
| is_behind_ul_dt | PeriodIntervalIsAftUsflLifeEnd | 1 | |
| is_shortfiscyear_dt | FiscalYearIsShortened | 1 | |
| is_shutdown_dt | IsShutDown | 1 | |
| last_day_in_yr_dt | FiscalYearEndDate | 1 | |
| last_ret_date_dt | LastRetirementValueDate | 1 | |
| leas_adv_payment_dt | LeaseIsPayedInAdvance | 1 | |
| leas_intrst_rate_dt | InterestRateInPercent | 1 | |
| leas_no_payments_dt | NumberOfLeasePayments | 1 | |
| leas_paymt_cycle_dt | LeasePaymentCycle | 1 | |
| leas_per_payment_dt | PeriodicLeasePaymentAmtInDC | 1 | |
| minval_key | CutOffValueKey | 1 | |
| minval_memo | DepreciationCalcMemoAmountInDC | 1 | |
| minval_perc_used | CtffValueIsCalculated | 1 | |
| minval_percent | DeprCalcCtffValRateInPct | 1 | |
| minval_prev | PYACutoffAmountInDspCrcy | 1 | |
| minval_rnddecim | ScrapValNmbrOfRndngDcmlPlaces | 1 | |
| minval_rndmethod | DepreciationCalcRoundingMethod | 1 | |
| minval_stated | AssetScrapAmountInDspCrcy | 1 | |
| minval_tolerance | NetBookToleranceAmountInDC | 1 | |
| minvalue | DepreciationCalcCtffAmtInDC | 1 | |
| multi_level_indx_dt | DepreciationCalcStepIndex | 1 | |
| neg_values_dt | NegativeAmountIsAllowed | 1 | |
| netval_prev | PYANetBookValueAmtInDC | 1 | |
| netvalue | NetBookValueAmtInDspCrcy | 1 | |
| no_minval | NetBookValueCalcIsBelowZero | 2 | |
| orig_acq_date_dt | OriginalFixedAssetValueDate | 1 | |
| percent_factor | DeprCalcPercentageFctr | 1 | |
| percent_key | DepreciationCalcCalcMethod | 1 | |
| percent_key_dt | DepreciationCalcCalcMethod | 1 | |
| percent_max | DepreciationCalcMaxRateInPct | 1 | |
| percent_min | DepreciationCalcMinRateInPct | 1 | |
| percent_raw | DeprCalcBaseValuePercent | 1 | |
| percent_round | RoundingDecimalPlaces | 1 | |
| percent_stated | DepreciationCalcExtRateInPct | 1 | |
| percent_stated_dt | DepreciationCalcExtRateInPct | 1 | |
| perfactor_raw | DepreciationCalcPeriodFactor | 1 | |
| period_from_dt | FromFiscalPeriod | 1 | |
| periods_dt | NumberOfPeriodsInFiscalYear | 1 | |
| periods_short_fy_dt | NumberOfPerdsInShortenedFsclYr | 1 | |
| perseg_reduced | DeprCalcReducedPerdVal | 1 | |
| perseg_weighted | NumberOfWeightedPerdsInTmeSgmt | 1 | |
| peryear | NumberOfPeriodsInFiscalYear | 1 | |
| peryear_weighted | NumberOfWeightedPerdsInFsclYr | 1 | |
| phase_dt | DepreciationPhase | 1 | |
| prev_cur_apc | CurrentYearPYAAcqnProdnAmtInDC | 1 | |
| prev_cur_depr_o | CurYrPYAPrptnlODeprAmtInDC | 1 | |
| prev_cur_depr_s | CurYrPYAPrptnlSDeprAmtInDC | 1 | |
| prev_cur_depr_u | CurYrPYAPrptnlUDeprAmtInDC | 1 | |
| prev_cur_downp | CurrentYrPYADownPaymentAmtInDC | 1 | |
| prev_cur_intr | CurYrPYAPrptnlInterestAmtInDC | 1 | |
| prev_cur_invs | CurrentYrPYAInvmtGrantAmtInDC | 1 | |
| prev_cur_resv | CurrentYrPrptnlReserveAmtInDC | 1 | |
| prev_cur_revl | CurrentYearPrptnlRRVAmtInDC | 1 | |
| prev_cur_revl_d | CurYrPrptnlODeprRevalAmtInDC | 1 | |
| prev_prev_apc | PYAAcqnProdnAmtInDspCrcy | 1 | |
| prev_prev_depr_o | FYStrtPYAPrptnlODeprAmtInDC | 1 | |
| prev_prev_depr_s | FYStrtPYAPrptnlSDeprAmtInDC | 1 | |
| prev_prev_depr_u | FYStrtPYAPrptnlUDeprAmtInDC | 1 | |
| prev_prev_downp | FYStrtPYADownPaytAmtInDC | 1 | |
| prev_prev_intr | FYStrtPYAPrptnlInterestAmtInDC | 1 | |
| prev_prev_invs | FYStrtPYAInvmtGrantAmtInDC | 1 | |
| prev_prev_resv | FYStrtPYAPrptnlReserveAmtInDC | 1 | |
| prev_prev_revl | FYSPrptnRevalRplcmtAmtInDC | 1 | |
| prev_prev_revl_d | FYSPrptnlRevalODeprAmtInDC | 1 | |
| range_length_dt | SegmentGenerationIntvlInPerds | 1 | |
| revaltn_key_dt | AssetRevaluationKey | 1 | |
| rounding_off | RoundingIsDisabled | 1 | |
| rplcmntval_index_dt | ReplacementValueIndexSers | 1 | |
| scrapvalue_dt | AssetScrapAmountInDspCrcy | 1 | |
| scrapvalue_prctg_dt | AcqnProdnCostScrapPercent | 1 | |
| shift_fact_dt | ShiftOperationFactor | 1 | |
| short_yr_prds | NumberOfPeriodsInShortFiscalYr | 1 | |
| sign | Sign | 1 | |
| skip_amount | DepreciationCalcAmtIsSkipped | 1 | |
| sort_indicator_dt | DepreciationCalcSortKey | 1 | |
| start_date_dt | DepreciationStartDate | 1 | |
| start_prd_dt | DepreciationFiscalPeriod | 1 | |
| start_yr_dt | DepreciationStartYear | 1 | |
| subtract_minval | AssetScrapValueIsDeducted | 1 | |
| sum_apc | AccmltdAcqnProductionAmount | 1 | |
| sum_apc_prev | PYAAccmltdAcqnProdnAmtInDC | 1 | |
| to_date_of_tddp_dt | DepreciationCalcValidToDate | 1 | |
| usage_impact_ind_dt | MltplShftUseShutdownInflncFctr | 1 | |
| usage_object_dt | FixedAssetUsageObject | 1 | |
| use_alignment_dt | ValueTypeHasSamePerdIntervals | 1 | |
| use_days_dt | DepreciationCalcIsToExactDate | 1 | |
| use_exp_life_new_dt | UsefulLifeIsCalcdFrmChgOvrYr | 1 | |
| use_halfperiods | HalfPeriodIsUsed | 1 | |
| use_max_periods_dt | IndividualPerdCalcIsPerformed | 1 | |
| use_usage_data_dt | AssetUsageIsConsidered | 1 | |
| use_year_amount | DepreciationCalcAmtIsCumulated | 1 | |
| useful_life | UsefulLifeInPeriods | 1 | |
| useful_life_dt | UsefulLifeInPeriods | 1 | |
| useful_life_prds_dt | PlannedUsefulLifeInPeriods | 1 | |
| useful_life_yrs_dt | PlannedUsefulLifeInYears | 1 | |
| var_dep_portion_dt | VariableDeprPercent | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_DEPRTRACESEGMENTAMOUNT (
AMOUNT_TYPE,
CURR_TYPE,
DEPR_AREA,
FISC_YEAR,
PERIOD_TO,
AGE_INDEX_DT,
AM_ADD,
AM_ADD_PREV,
AMOUNT,
AMOUNT_FACTOR,
AMOUNT_FACTOR_DT,
AMOUNT_MAX,
AMOUNT_PREV,
AMOUNT_REDUCED,
AMOUNT_SKIPPED,
ASSETCLASS_DT,
BASE_ADD,
BASE_ADD_KEY,
BASE_ADD_KEY_DT,
BASE_ADD_PREV,
BASEVAL_FACT_ADD,
BASEVAL_FACTOR,
BASEVAL_KEY,
BASEVAL_KEY_DT,
BASEVAL_MAX,
BASEVAL_PREV,
BASEVAL_STATED,
BASEVALUE,
CALC_INFLATION_DT,
CALC_PERFORM_DT,
CAP_DATE_DT,
CHANGEOVER_IND_DT,
CHANGEOVER_PRD,
CHANGEOVER_PRD_DT,
CHANGEOVER_YR,
CHANGEOVER_YR_DT,
CHECK_AMOUNT,
CUR_APC,
CUR_DEPR_O,
CUR_DEPR_S,
CUR_DEPR_U,
CUR_DOWNP,
CUR_INTR,
CUR_INVS,
CUR_RESV,
CUR_REVL,
CUR_REVL_D,
CURRENCY,
CUTOF_VALUE_INDX_DT,
DEPR_KEY_DT,
EXP_LIFE,
EXP_LIFE_DT,
EXP_LIFE_NEW,
EXP_LIFE_NEW_DT,
EXP_LIFE_SEG,
EXP_LIFE_SEG_DT,
FIRST_DAY_IN_YR_DT,
GRP_ASSET_ASSGND_DT,
HAS_TDDP_DT,
IGNORE_MEMVAL_DT,
IGNORE_SHORT_YR,
INITIAL_ACQ_DT,
INITIAL_ACQ_PRD_DT,
INITIAL_ACQ_YR_DT,
IS_BEHIND_UL_DT,
IS_SHORTFISCYEAR_DT,
IS_SHUTDOWN_DT,
LAST_DAY_IN_YR_DT,
LAST_RET_DATE_DT,
LEAS_ADV_PAYMENT_DT,
LEAS_INTRST_RATE_DT,
LEAS_NO_PAYMENTS_DT,
LEAS_PAYMT_CYCLE_DT,
LEAS_PER_PAYMENT_DT,
MINVAL_KEY,
MINVAL_MEMO,
MINVAL_PERC_USED,
MINVAL_PERCENT,
MINVAL_PREV,
MINVAL_RNDDECIM,
MINVAL_RNDMETHOD,
MINVAL_STATED,
MINVAL_TOLERANCE,
MINVALUE,
MULTI_LEVEL_INDX_DT,
NEG_VALUES_DT,
NETVAL_PREV,
NETVALUE,
NO_MINVAL,
ORIG_ACQ_DATE_DT,
PERCENT_FACTOR,
PERCENT_KEY,
PERCENT_KEY_DT,
PERCENT_MAX,
PERCENT_MIN,
PERCENT_RAW,
PERCENT_ROUND,
PERCENT_STATED,
PERCENT_STATED_DT,
PERFACTOR_RAW,
PERIOD_FROM_DT,
PERIODS_DT,
PERIODS_SHORT_FY_DT,
PERSEG_REDUCED,
PERSEG_WEIGHTED,
PERYEAR,
PERYEAR_WEIGHTED,
PHASE_DT,
PREV_CUR_APC,
PREV_CUR_DEPR_O,
PREV_CUR_DEPR_S,
PREV_CUR_DEPR_U,
PREV_CUR_DOWNP,
PREV_CUR_INTR,
PREV_CUR_INVS,
PREV_CUR_RESV,
PREV_CUR_REVL,
PREV_CUR_REVL_D,
PREV_PREV_APC,
PREV_PREV_DEPR_O,
PREV_PREV_DEPR_S,
PREV_PREV_DEPR_U,
PREV_PREV_DOWNP,
PREV_PREV_INTR,
PREV_PREV_INVS,
PREV_PREV_RESV,
PREV_PREV_REVL,
PREV_PREV_REVL_D,
RANGE_LENGTH_DT,
REVALTN_KEY_DT,
ROUNDING_OFF,
RPLCMNTVAL_INDEX_DT,
SCRAPVALUE_DT,
SCRAPVALUE_PRCTG_DT,
SHIFT_FACT_DT,
SHORT_YR_PRDS,
SIGN,
SKIP_AMOUNT,
SORT_INDICATOR_DT,
START_DATE_DT,
START_PRD_DT,
START_YR_DT,
SUBTRACT_MINVAL,
SUM_APC,
SUM_APC_PREV,
TO_DATE_OF_TDDP_DT,
USAGE_IMPACT_IND_DT,
USAGE_OBJECT_DT,
USE_ALIGNMENT_DT,
USE_DAYS_DT,
USE_EXP_LIFE_NEW_DT,
USE_HALFPERIODS,
USE_MAX_PERIODS_DT,
USE_USAGE_DATA_DT,
USE_YEAR_AMOUNT,
USEFUL_LIFE,
USEFUL_LIFE_DT,
USEFUL_LIFE_PRDS_DT,
USEFUL_LIFE_YRS_DT,
VAR_DEP_PORTION_DT,
PRIMARY KEY (AMOUNT_TYPE, CURR_TYPE, DEPR_AREA, FISC_YEAR, PERIOD_TO)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA