FIRUD_FSTM_RPITM

Transparent Table Application Table

ACR Financial Statement Russia Reported Item Log Table

FIRUD_FSTM_RPITM is an SAP database table in S/4HANA. ACR Financial Statement Russia Reported Item Log Table. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_RU_FinStmntRptgItems view from BASIC Storage for Financial Statement (ACR)
P_RU_FinStmntRptgItems view from BASIC Logging Documents for Financial Statement

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY statryrptgentity srf_reporting_entity Reporting Entity
KEY statryrptcategory srf_rep_cat_id Report ID
KEY statryrptrunid srf_report_run_id Report Run ID
KEY formcode versn_011 FS Version
KEY companycode bukrs Company Code
KEY accountingdocument belnr_d Document Number
KEY ledgergllineitem docln6 G/L Line Item
KEY fiscalyear gjahr Fiscal Year
KEY financialstatementleafitem hrynode Node
KEY invoicenumber firu_invoice_number Invoice Number
KEY invoiceyear gjahr Fiscal Year
KEY invoiceitem docln6 G/L Line Item
KEY offsettingitem docln6 G/L Line Item
periodbalamt firu_period_bal_amt PerBalAmt
yearopeningbalamt firu_period_bal_amt PerBalAmt
openingperiodbalamt firu_period_bal_amt PerBalAmt
endingperiodbalamt firu_period_bal_amt PerBalAmt
creditperiodbalamt firu_period_bal_amt PerBalAmt
debitperiodbalamt firu_period_bal_amt PerBalAmt
currency waers Currency

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.

-- ACR Financial Statement Russia Reported Item Log Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIRUD_FSTM_RPITM (
    MANDT,                       -- Client [mandt]
    STATRYRPTGENTITY,            -- Reporting Entity [srf_reporting_entity]
    STATRYRPTCATEGORY,           -- Report ID [srf_rep_cat_id]
    STATRYRPTRUNID,              -- Report Run ID [srf_report_run_id]
    FORMCODE,                    -- FS Version [versn_011]
    COMPANYCODE,                 -- Company Code [bukrs]
    ACCOUNTINGDOCUMENT,          -- Document Number [belnr_d]
    LEDGERGLLINEITEM,            -- G/L Line Item [docln6]
    FISCALYEAR,                  -- Fiscal Year [gjahr]
    FINANCIALSTATEMENTLEAFITEM,  -- Node [hrynode]
    INVOICENUMBER,               -- Invoice Number [firu_invoice_number]
    INVOICEYEAR,                 -- Fiscal Year [gjahr]
    INVOICEITEM,                 -- G/L Line Item [docln6]
    OFFSETTINGITEM,              -- G/L Line Item [docln6]
    PERIODBALAMT,                -- PerBalAmt [firu_period_bal_amt]
    YEAROPENINGBALAMT,           -- PerBalAmt [firu_period_bal_amt]
    OPENINGPERIODBALAMT,         -- PerBalAmt [firu_period_bal_amt]
    ENDINGPERIODBALAMT,          -- PerBalAmt [firu_period_bal_amt]
    CREDITPERIODBALAMT,          -- PerBalAmt [firu_period_bal_amt]
    DEBITPERIODBALAMT,           -- PerBalAmt [firu_period_bal_amt]
    CURRENCY,                    -- Currency [waers]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, FORMCODE, COMPANYCODE, ACCOUNTINGDOCUMENT, LEDGERGLLINEITEM, FISCALYEAR, FINANCIALSTATEMENTLEAFITEM, INVOICENUMBER, INVOICEYEAR, INVOICEITEM, OFFSETTINGITEM)
);