FINS_TRR_CONS

Transparent Table Application Table
11 Fields 4 CDS Views

Consistency of Accounting Principle and Ledger Group

FINS_TRR_CONS is an SAP database table in S/4HANA. Consistency of Accounting Principle and Ledger Group. It contains 11 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
Fins_Rev_Rec_Ap_Isn_Check view_entity left_outer check for intersections
Fins_Rev_Rec_Ap_Val_Check view_entity left_outer Check accounting principles for Rev. Rec. valuation
FINS_REV_REC_EVAL_AREA view_entity left_outer Evaluation area and ledger for EBRR
I_EBRRConstcyAcctgPrncpLdgrGrp view_entity from BASIC Consistency AccountingPrinciple Ledger

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY acc_principle accounting_principle Accounting Principle
KEY timestamp timestamp Time Stamp
ldgrp fagl_ldgrp Ledger Group
represent_rldnr fins_trr_representative_ledger RepresentativeLedger
additional_rldnr fins_trr_add_rldnr List add. ledger
first_date_used fins_trr_first_used_date First use date
last_date_used fins_trr_last_used_date Last use date
check_deactivated fins_trr_deactivated Check deactivated
check_deact_name usnam User Name
check_deact_date datum Date

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.

-- Consistency of Accounting Principle and Ledger Group
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_TRR_CONS (
    MANDT,              -- Client [mandt]
    ACC_PRINCIPLE,      -- Accounting Principle [accounting_principle]
    TIMESTAMP,          -- Time Stamp [timestamp]
    LDGRP,              -- Ledger Group [fagl_ldgrp]
    REPRESENT_RLDNR,    -- RepresentativeLedger [fins_trr_representative_ledger]
    ADDITIONAL_RLDNR,   -- List add. ledger [fins_trr_add_rldnr]
    FIRST_DATE_USED,    -- First use date [fins_trr_first_used_date]
    LAST_DATE_USED,     -- Last use date [fins_trr_last_used_date]
    CHECK_DEACTIVATED,  -- Check deactivated [fins_trr_deactivated]
    CHECK_DEACT_NAME,   -- User Name [usnam]
    CHECK_DEACT_DATE,   -- Date [datum]
    PRIMARY KEY (MANDT, ACC_PRINCIPLE, TIMESTAMP)
);

Learn More