FINCS_RI_RT

Transparent Table Application Table

Runtime table for reporting item assignment

FINCS_RI_RT is an SAP database table in S/4HANA. Runtime table for reporting item assignment. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CnsldtnRptgRule view_entity from BASIC Consolidation Reporting Rule

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY uuid FINCS_UUID UUID
KEY posnr FINCS_RULE_POSNR Rule Sequence
rptid FINCS_RPTID Reporting Rule Variant
itclg FC_ITCLG Cons. COA
rihry FINCS_RIHRY Reporting Item Hierarchy
ritem FINCS_RITEM Reporting Item
item FC_ITEM FS Item
sityp FC_SITYP Subitem Category
sitem FC_SITEM Subitem
docty FC_DOCTY Document Type
bunit FC_BUNIT Cons. Unit
revsign FINCS_REVSIGN Reverse Sign (X)
rvers FC_RVERS Version
fromyearper FINCS_FISCYEARPER Period/Year
toyearper FINCS_FISCYEARPER Period/Year

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.

-- Runtime table for reporting item assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_RI_RT (
    MANDT,        -- Client [MANDT]
    UUID,         -- UUID [FINCS_UUID]
    POSNR,        -- Rule Sequence [FINCS_RULE_POSNR]
    RPTID,        -- Reporting Rule Variant [FINCS_RPTID]
    ITCLG,        -- Cons. COA [FC_ITCLG]
    RIHRY,        -- Reporting Item Hierarchy [FINCS_RIHRY]
    RITEM,        -- Reporting Item [FINCS_RITEM]
    ITEM,         -- FS Item [FC_ITEM]
    SITYP,        -- Subitem Category [FC_SITYP]
    SITEM,        -- Subitem [FC_SITEM]
    DOCTY,        -- Document Type [FC_DOCTY]
    BUNIT,        -- Cons. Unit [FC_BUNIT]
    REVSIGN,      -- Reverse Sign (X) [FINCS_REVSIGN]
    RVERS,        -- Version [FC_RVERS]
    FROMYEARPER,  -- Period/Year [FINCS_FISCYEARPER]
    TOYEARPER,    -- Period/Year [FINCS_FISCYEARPER]
    PRIMARY KEY (MANDT, UUID, POSNR)
);