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 left_outer check for intersections
Fins_Rev_Rec_Ap_Val_Check view left_outer Check accounting principles for Rev. Rec. valuation
FINS_REV_REC_EVAL_AREA view left_outer Evaluation area and ledger for EBRR
I_EBRRConstcyAcctgPrncpLdgrGrp view 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