FIRUD_TRT_RPITM

Transparent Table Application Table

ACT Reported Items Table for RU Tranport Tax

FIRUD_TRT_RPITM is an SAP database table in S/4HANA. ACT Reported Items Table for RU Tranport Tax. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_TransportTaxItemLog view from BASIC Russia Transport Tax item Log

Fields (31)

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 itemid firu_trt_report_run_item_id Number
companycode bukrs Company Code
masterfixedasset anln1 Asset
fixedasset anln2 Sub-number
intervalstart adatu Valid From
intervalend bdatu Valid To
oktmo firu_oktmo OKTMO
licensenum license_num License Plate
ownershipmonths firu_trt_ownership_months Months of Ownership
taxrate j_3rtval Tax Rate
taxbase j_3rtxbunit Tax Base Unit
taxbase_unit j_3r_ttaxbunit Tax base unit
ownershipshare j_3r_transport_own_right_share Share in Ownership
coeff_kp j_3r_ttax_ecoeff CoefficientExpVeh
taxexemptionid firu_trt_concession_id Tax Concession ID
taxexmpreducamt firu_trt_tax_amount_exmp_red Exemption Amount
taxexemptionmonths firu_trt_ownership_months Months of Ownership
taxratereducid firu_trt_concession_id Tax Concession ID
taxratereducamt firu_trt_tax_amount_rate_red Tax Rate Reduction
taxratereducmonths firu_trt_ownership_months Months of Ownership
taxamtreducid firu_trt_concession_id Tax Concession ID
taxamtreducamt firu_trt_tax_amount_tax_red Tax Amount Reduction
taxamtreducmonths firu_trt_ownership_months Months of Ownership
taxamtdownpmnt_q1 firu_trt_tax_amount_downpmnt Downpayment Amnt
taxamtdownpmnt_q2 firu_trt_tax_amount_downpmnt Downpayment Amnt
taxamtdownpmnt_q3 firu_trt_tax_amount_downpmnt Downpayment Amnt
taxamount firu_trt_tax_amount Tax Amount

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.

-- ACT Reported Items Table for RU Tranport Tax
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIRUD_TRT_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]
    ITEMID,              -- Number [firu_trt_report_run_item_id]
    COMPANYCODE,         -- Company Code [bukrs]
    MASTERFIXEDASSET,    -- Asset [anln1]
    FIXEDASSET,          -- Sub-number [anln2]
    INTERVALSTART,       -- Valid From [adatu]
    INTERVALEND,         -- Valid To [bdatu]
    OKTMO,               -- OKTMO [firu_oktmo]
    LICENSENUM,          -- License Plate [license_num]
    OWNERSHIPMONTHS,     -- Months of Ownership [firu_trt_ownership_months]
    TAXRATE,             -- Tax Rate [j_3rtval]
    TAXBASE,             -- Tax Base Unit [j_3rtxbunit]
    TAXBASE_UNIT,        -- Tax base unit [j_3r_ttaxbunit]
    OWNERSHIPSHARE,      -- Share in Ownership [j_3r_transport_own_right_share]
    COEFF_KP,            -- CoefficientExpVeh [j_3r_ttax_ecoeff]
    TAXEXEMPTIONID,      -- Tax Concession ID [firu_trt_concession_id]
    TAXEXMPREDUCAMT,     -- Exemption Amount [firu_trt_tax_amount_exmp_red]
    TAXEXEMPTIONMONTHS,  -- Months of Ownership [firu_trt_ownership_months]
    TAXRATEREDUCID,      -- Tax Concession ID [firu_trt_concession_id]
    TAXRATEREDUCAMT,     -- Tax Rate Reduction [firu_trt_tax_amount_rate_red]
    TAXRATEREDUCMONTHS,  -- Months of Ownership [firu_trt_ownership_months]
    TAXAMTREDUCID,       -- Tax Concession ID [firu_trt_concession_id]
    TAXAMTREDUCAMT,      -- Tax Amount Reduction [firu_trt_tax_amount_tax_red]
    TAXAMTREDUCMONTHS,   -- Months of Ownership [firu_trt_ownership_months]
    TAXAMTDOWNPMNT_Q1,   -- Downpayment Amnt [firu_trt_tax_amount_downpmnt]
    TAXAMTDOWNPMNT_Q2,   -- Downpayment Amnt [firu_trt_tax_amount_downpmnt]
    TAXAMTDOWNPMNT_Q3,   -- Downpayment Amnt [firu_trt_tax_amount_downpmnt]
    TAXAMOUNT,           -- Tax Amount [firu_trt_tax_amount]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, ITEMID)
);