P_DEPRTRACEYEARAMOUNT

CDS View
62 Fields 1 CDS Views

P_DEPRTRACEYEARAMOUNT is a CDS View in S/4HANA. It contains 62 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_DeprCalcCalculationResult view_entity inner CONSUMPTION Depreciation Calculation: Calculation Result

Fields (62)

KeyField CDS FieldsUsed in Views
KEY curr_type CurrencyRole 1
KEY depr_area AssetDepreciationArea 1
KEY fisc_year FiscalYear 1
cum_apc FYSAccmltdAcqnProdnAmtInDC 1
cum_depr_o FYSAccmltdOrdnryDeprAmtInDC 1
cum_depr_s FYSAccmltdSpecialDeprAmtInDC 1
cum_depr_u FYSAccmltdUnplndDeprAmtInDC 1
cum_downp FYSAccmltdDownPaymentAmtInDC 1
cum_intr FYSAccmltdInterestAmountInDC 1
cum_invs FYSAccmltdInvmtGrantAmtInDC 1
cum_resv FYSAccmltdTransfOfRsrvAmtInDC 1
cum_revl FYSAccmltdRRVAmtInDspCrcy 1
cum_revl_d FYSAccmltdODeprRevalAmtInDC 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 1
prev_apc PYAAcqnProdnAmtInDspCrcy 1
prev_cur_depr_o CurYrPYAPrptnlODeprAmtInDC 1
prev_cur_depr_s CurYrPYAPrptnlSDeprAmtInDC 1
prev_cur_depr_u CurYrPYAPrptnlUDeprAmtInDC 1
prev_cur_intr CurYrPYAPrptnlInterestAmtInDC 1
prev_cur_revl CurrentYearPrptnlRRVAmtInDC 1
prev_cur_revl_d CurYrPrptnlODeprRevalAmtInDC 1
prev_depr_o PYAOrdinaryDeprAmtInDspCrcy 1
prev_depr_s PYASpecialDeprAmtInDspCrcy 1
prev_depr_u PYAUnplannedDeprAmtInDspCrcy 1
prev_downp PYADownPaymentAmountInDspCrcy 1
prev_intr PYAInterestAmountInDspCrcy 1
prev_invs PYAInvestmentGrantAmtInDC 1
prev_prev_apc FsclYrStrtPYAAcqnProdnAmtInDC 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
prev_resv PYATransferredReserveAmtInDC 1
prev_revl PYARevalRplcmtValueAmountInDC 1
prev_revl_d PYAOrdnryDeprPlndRevalAmtInDC 1
shortened_depr_o OrdinaryDeprReducedAmtInDC 1
shortened_depr_s SpecialDeprReducedAmtInDC 1
total_apc AccmltdAcqnProductionAmount 1
total_depr_o AccumulatedOrdinaryDeprAmount 1
total_depr_s AccumulatedSpecialDeprAmount 1
total_depr_u AccumulatedUnplannedDeprAmount 1
total_downp AccumulatedDownPaymentAmtInDC 1
total_intr AccumulatedInterestAmountInDC 1
total_invs AccmltdInvestmentGrantAmtInDC 1
total_resv AccumulatedTrnsfdRsrvAmtInDC 1
total_revl AccmltdReplacementRevalAmtInDC 1
total_revl_d AccmltdRevalOrdinaryDeprAmount 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_DEPRTRACEYEARAMOUNT (
    CURR_TYPE,
    DEPR_AREA,
    FISC_YEAR,
    CUM_APC,
    CUM_DEPR_O,
    CUM_DEPR_S,
    CUM_DEPR_U,
    CUM_DOWNP,
    CUM_INTR,
    CUM_INVS,
    CUM_RESV,
    CUM_REVL,
    CUM_REVL_D,
    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,
    PREV_APC,
    PREV_CUR_DEPR_O,
    PREV_CUR_DEPR_S,
    PREV_CUR_DEPR_U,
    PREV_CUR_INTR,
    PREV_CUR_REVL,
    PREV_CUR_REVL_D,
    PREV_DEPR_O,
    PREV_DEPR_S,
    PREV_DEPR_U,
    PREV_DOWNP,
    PREV_INTR,
    PREV_INVS,
    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,
    PREV_RESV,
    PREV_REVL,
    PREV_REVL_D,
    SHORTENED_DEPR_O,
    SHORTENED_DEPR_S,
    TOTAL_APC,
    TOTAL_DEPR_O,
    TOTAL_DEPR_S,
    TOTAL_DEPR_U,
    TOTAL_DOWNP,
    TOTAL_INTR,
    TOTAL_INVS,
    TOTAL_RESV,
    TOTAL_REVL,
    TOTAL_REVL_D,
    PRIMARY KEY (CURR_TYPE, DEPR_AREA, FISC_YEAR)
);

Learn More