FIRUD_UTNP_RPITM

Transparent Table Application Table
16 Fields 1 CDS Views

DRC Log Table for Unified Tax Notice and Payment

FIRUD_UTNP_RPITM is an SAP database table in S/4HANA. DRC Log Table for Unified Tax Notice and Payment. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_UnifiedTaxNtcPaytRptgItem view from BASIC UTNP Log items

Fields (16)

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 accountingdocumentitem buzei Item
duecalculationbasedate dzfbdt Baseline Date
ru_unifiedtaxnoticepaymentvers firu_utnp_version Unf Tax Notice Vers
ru_budgetclassificationcode j_3rf_104 KBK
ru_supplierkpp j_3rfinv_seller_kpp Seller KPP
ru_territoryclassfctnoktmo firu_oktmo OKTMO
ru_unifiedtaxnoticeperiodcode firu_utnp_period_code Period Code
fiscalperiod firu_utnp_period_number Month or Quarter No.
inputfiscalyear gjahr Fiscal 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.

-- DRC Log Table for Unified Tax Notice and Payment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIRUD_UTNP_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]
    ACCOUNTINGDOCUMENTITEM,          -- Item [buzei]
    DUECALCULATIONBASEDATE,          -- Baseline Date [dzfbdt]
    RU_UNIFIEDTAXNOTICEPAYMENTVERS,  -- Unf Tax Notice Vers [firu_utnp_version]
    RU_BUDGETCLASSIFICATIONCODE,     -- KBK [j_3rf_104]
    RU_SUPPLIERKPP,                  -- Seller KPP [j_3rfinv_seller_kpp]
    RU_TERRITORYCLASSFCTNOKTMO,      -- OKTMO [firu_oktmo]
    RU_UNIFIEDTAXNOTICEPERIODCODE,   -- Period Code [firu_utnp_period_code]
    FISCALPERIOD,                    -- Month or Quarter No. [firu_utnp_period_number]
    INPUTFISCALYEAR,                 -- Fiscal Year [gjahr]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, COMPANYCODE, ACCOUNTINGDOCUMENT, FISCALYEAR, ACCOUNTINGDOCUMENTITEM)
);

Learn More