FIRUD_TRT_RPITM
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_RU_TransportTaxItemLog | view | from | BASIC | Russia Transport Tax item Log |
Fields (31)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA