FIRUD_VAT2_RPITM

Transparent Table Application Table

VAT Reporting Items Log Table (additional data)

FIRUD_VAT2_RPITM is an SAP database table in S/4HANA. VAT Reporting Items Log Table (additional data). It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_VATReportingItemLogAddl view from BASIC VAT Reporting Items Log Additional Data

Fields (13)

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 originaldocument FIRU_ORIGINAL_DOCUMENT Original Document
KEY originaldocumentyear FIRU_ORIGINAL_DOCUMENT_YEAR Orig. Doc. Year
KEY itemid FIRU_VAT_REPORT_RUN_ITEM_ID Item ID
ru_vatexternalpaymentstext FIRU_VATEXTERNAL_PAYMENTS External Payments
ru_vatpaymentdatestext FIRU_VATPAYMENT_DATES Payment Dates
ru_vatmaterialreceiptdatestext FIRU_VATMATERIAL_RECEIPT_DATES Receipt Datates
ru_vatimpcustdeclndocnmbrstext FIRU_VATIMP_CUST_DECLN_NUMBRS ImpCustDeclnDocNmbrs
ru_vattrdclassfctnnmbrstext FIRU_VATTRD_CLASSFCTN_NMBRS Trd Classfctn Nmbrs

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.

-- VAT Reporting Items Log Table (additional data)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIRUD_VAT2_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]
    ORIGINALDOCUMENT,                -- Original Document [FIRU_ORIGINAL_DOCUMENT]
    ORIGINALDOCUMENTYEAR,            -- Orig. Doc. Year [FIRU_ORIGINAL_DOCUMENT_YEAR]
    ITEMID,                          -- Item ID [FIRU_VAT_REPORT_RUN_ITEM_ID]
    RU_VATEXTERNALPAYMENTSTEXT,      -- External Payments [FIRU_VATEXTERNAL_PAYMENTS]
    RU_VATPAYMENTDATESTEXT,          -- Payment Dates [FIRU_VATPAYMENT_DATES]
    RU_VATMATERIALRECEIPTDATESTEXT,  -- Receipt Datates [FIRU_VATMATERIAL_RECEIPT_DATES]
    RU_VATIMPCUSTDECLNDOCNMBRSTEXT,  -- ImpCustDeclnDocNmbrs [FIRU_VATIMP_CUST_DECLN_NUMBRS]
    RU_VATTRDCLASSFCTNNMBRSTEXT,     -- Trd Classfctn Nmbrs [FIRU_VATTRD_CLASSFCTN_NMBRS]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, COMPANYCODE, ORIGINALDOCUMENT, ORIGINALDOCUMENTYEAR, ITEMID)
);