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)
);