FIRUD_ACCT_RPITM

Transparent Table Application Table
14 Fields 1 CDS Views

Information for documents selected per report run

FIRUD_ACCT_RPITM is an SAP database table in S/4HANA. Information for documents selected per report run. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_StRpJournalEntryLog view from BASIC ACR Reported Tax Items Log Table

Fields (14)

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 companycode BUKRS Company Code
KEY accountingdocument BELNR_D Document Number
KEY fiscalyear GJAHR Fiscal Year
KEY revisionnumber J_3RFINV_REVNO Revision Number
KEY sectiontype FIRU_VATSECTYPE Section Type
KEY originaldocument FIRU_ORIGINAL_DOCUMENT Original Document
KEY originaldocumentyear FIRU_ORIGINAL_DOCUMENT_YEAR Orig. Doc. Year
KEY ru_vatsubscenario FIRU_VATSUBSC Subscenario
KEY accountingdocumentitem BUZEI Item
_dataaging DATA_TEMPERATURE Data Aging

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.

-- Information for documents selected per report run
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIRUD_ACCT_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]
    COMPANYCODE,             -- Company Code [BUKRS]
    ACCOUNTINGDOCUMENT,      -- Document Number [BELNR_D]
    FISCALYEAR,              -- Fiscal Year [GJAHR]
    REVISIONNUMBER,          -- Revision Number [J_3RFINV_REVNO]
    SECTIONTYPE,             -- Section Type [FIRU_VATSECTYPE]
    ORIGINALDOCUMENT,        -- Original Document [FIRU_ORIGINAL_DOCUMENT]
    ORIGINALDOCUMENTYEAR,    -- Orig. Doc. Year [FIRU_ORIGINAL_DOCUMENT_YEAR]
    RU_VATSUBSCENARIO,       -- Subscenario [FIRU_VATSUBSC]
    ACCOUNTINGDOCUMENTITEM,  -- Item [BUZEI]
    _DATAAGING,              -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, COMPANYCODE, ACCOUNTINGDOCUMENT, FISCALYEAR, REVISIONNUMBER, SECTIONTYPE, ORIGINALDOCUMENT, ORIGINALDOCUMENTYEAR, RU_VATSUBSCENARIO, ACCOUNTINGDOCUMENTITEM)
);

Learn More