FINS_TRR_OBADM

Transparent Table Application Table
22 Fields 2 CDS Views

Event based rev. rec.: admin of life cycle of objects

FINS_TRR_OBADM is an SAP database table in S/4HANA. Event based rev. rec.: admin of life cycle of objects. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FINS_REV_REC_EVAL_AREA_USED view inner Used classical Accounting Principles for EBRR
I_EvtBsdRevnRecgnLifecycleObj view from BASIC EBRR admin of life cycle objects

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY acc_principle tbrr_eval_area Evaluation area EBRR
KEY pspnr ps_posnr WBS Element
KEY aufnr aufnr Order
KEY vbeln vbeln_va Sales Document
KEY posnr posnr_va Item
KEY service_doc_type fco_srvdoc_type Service Doc. Type
KEY service_doc_id fco_srvdoc_id Service Document
KEY service_doc_item_id fco_srvdoc_item_id Service Doc. Item
KEY vtkey vtkey_kk Contract
KEY vtpos vtpos_kk Contract Item
fiscyearper_join fins_trr_join_period Period joining RevRe
fiscyearper_block fins_trr_block_period Per. block re-eval.
fiscyearper_clear fins_trr_clear_period Period clear RevRec
fiscyearper_decouple fins_trr_decouple_period Per. decouple RevRec
fiscyearper_last_eval fins_trr_last_eval_period Last evaluation per.
last_evaldat fins_trr_last_evaldat Last evaluation
fiscyearper_last_change fins_trr_last_change_period Last per with change
last_poc fins_trr_last_poc Last POC (%)
lastrecalc_targetrev fins_trr_lastrecalc_targetrev RecalcTargetRev
expected_cputime fins_trr_expected_cputime Likely CPUTime in ms
plan_cost_corr_factor fins_trr_plan_cost_corr_factor Plan cost correction

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.

-- Event based rev. rec.: admin of life cycle of objects
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_TRR_OBADM (
    MANDT,                    -- Client [mandt]
    ACC_PRINCIPLE,            -- Evaluation area EBRR [tbrr_eval_area]
    PSPNR,                    -- WBS Element [ps_posnr]
    AUFNR,                    -- Order [aufnr]
    VBELN,                    -- Sales Document [vbeln_va]
    POSNR,                    -- Item [posnr_va]
    SERVICE_DOC_TYPE,         -- Service Doc. Type [fco_srvdoc_type]
    SERVICE_DOC_ID,           -- Service Document [fco_srvdoc_id]
    SERVICE_DOC_ITEM_ID,      -- Service Doc. Item [fco_srvdoc_item_id]
    VTKEY,                    -- Contract [vtkey_kk]
    VTPOS,                    -- Contract Item [vtpos_kk]
    FISCYEARPER_JOIN,         -- Period joining RevRe [fins_trr_join_period]
    FISCYEARPER_BLOCK,        -- Per. block re-eval. [fins_trr_block_period]
    FISCYEARPER_CLEAR,        -- Period clear RevRec [fins_trr_clear_period]
    FISCYEARPER_DECOUPLE,     -- Per. decouple RevRec [fins_trr_decouple_period]
    FISCYEARPER_LAST_EVAL,    -- Last evaluation per. [fins_trr_last_eval_period]
    LAST_EVALDAT,             -- Last evaluation [fins_trr_last_evaldat]
    FISCYEARPER_LAST_CHANGE,  -- Last per with change [fins_trr_last_change_period]
    LAST_POC,                 -- Last POC (%) [fins_trr_last_poc]
    LASTRECALC_TARGETREV,     -- RecalcTargetRev [fins_trr_lastrecalc_targetrev]
    EXPECTED_CPUTIME,         -- Likely CPUTime in ms [fins_trr_expected_cputime]
    PLAN_COST_CORR_FACTOR,    -- Plan cost correction [fins_trr_plan_cost_corr_factor]
    PRIMARY KEY (MANDT, ACC_PRINCIPLE, PSPNR, AUFNR, VBELN, POSNR, SERVICE_DOC_TYPE, SERVICE_DOC_ID, SERVICE_DOC_ITEM_ID, VTKEY, VTPOS)
);

Learn More