FIRUD_CRQ_RPITM

Transparent Table Application Table

Storage for documents selected per report run (VATCRQ)

FIRUD_CRQ_RPITM is an SAP database table in S/4HANA. Storage for documents selected per report run (VATCRQ). It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RU_VATCRQITEMS view from BASIC

Fields (12)

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 requestid J_3RF_VATCRQ_N1 Request ID
KEY fiscalyear GJAHR Fiscal Year
KEY taxperiod J_3RVATDQMPERIOD Tax Period
KEY corrnumber J_3RVATDCORRNUM Corr.VAT Ret.Number
KEY linenumber J_3RF_VATCRQ_NUMLINE Line Item Number
KEY sectionnumber J_3RF_VATCRQ_SECT_NUM Section
KEY addflag FLAG Indicator
linestatus FIRU_VATCRQ_LINESTATUS Line Status

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.

-- Storage for documents selected per report run (VATCRQ)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIRUD_CRQ_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]
    REQUESTID,          -- Request ID [J_3RF_VATCRQ_N1]
    FISCALYEAR,         -- Fiscal Year [GJAHR]
    TAXPERIOD,          -- Tax Period [J_3RVATDQMPERIOD]
    CORRNUMBER,         -- Corr.VAT Ret.Number [J_3RVATDCORRNUM]
    LINENUMBER,         -- Line Item Number [J_3RF_VATCRQ_NUMLINE]
    SECTIONNUMBER,      -- Section [J_3RF_VATCRQ_SECT_NUM]
    ADDFLAG,            -- Indicator [FLAG]
    LINESTATUS,         -- Line Status [FIRU_VATCRQ_LINESTATUS]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, REQUESTID, FISCALYEAR, TAXPERIOD, CORRNUMBER, LINENUMBER, SECTIONNUMBER, ADDFLAG)
);