FIRUD_PRT_RPITM

Transparent Table Application Table

Russia ACR Report Property Tax Log Table

FIRUD_PRT_RPITM is an SAP database table in S/4HANA. Russia ACR Report Property Tax Log Table. It contains 46 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_PropertyTaxItemLog view from BASIC Russia Property Tax Item Log

Fields (46)

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_prt_report_run_item_id Run Item ID
companycode bukrs Company Code
masterfixedasset anln1 Asset
fixedasset anln2 Sub-number
intervalstart adatu Valid From
intervalend bdatu Valid To
oktmo firu_oktmo OKTMO
propertytype j_3rfproptypen Property Type
nbv01 firu_prt_asset_nbv01 NBV as of 01.01
nbv02 firu_prt_asset_nbv02 NBV as of 01.02
nbv03 firu_prt_asset_nbv03 NBV as of 01.03
nbv04 firu_prt_asset_nbv04 NBV as of 01.04
nbv05 firu_prt_asset_nbv05 NBV as of 01.05
nbv06 firu_prt_asset_nbv06 NBV as of 01.06
nbv07 firu_prt_asset_nbv07 NBV as of 01.07
nbv08 firu_prt_asset_nbv08 NBV as of 01.08
nbv09 firu_prt_asset_nbv09 NBV as of 01.09
nbv10 firu_prt_asset_nbv10 NBV as of 01.10
nbv11 firu_prt_asset_nbv11 NBV as of 01.11
nbv12 firu_prt_asset_nbv12 NBV as of 01.12
nbv13 firu_prt_asset_nbv13 NBV as of 31.12
taxexemptionid firu_prt_tax_exemption_id Tax Exemption Code
taxexemptioncode firu_prt_tax_exemption_outcode TaxExemptionOutCode
taxexemptionvalue firu_prt_tax_exemption_value Value to Exemption
taxexemptionunitvalue firu_prt_tax_exemption_unitval UnitOfValueToExemp
taxratereducnid firu_prt_tax_rate_rdcn_id Tax Reduction Code
taxratereducncode firu_prt_tax_rate_rdcn_outcode TaxRateReducnOutCode
taxrate firu_prt_tax_rate Property Tax Rate
taxbaseamt firu_prt_tax_base_amount Tax Base Amount
taxamtperiod firu_prt_tax_amount_period TaxAmountPeriod
taxamtdownpayment firu_prt_tax_amount_down_paym Amount of Down Paym
taxamtreducnid firu_prt_tax_amt_rdcn_id Tax Amount Red.Code
taxamtreducncode firu_prt_tax_amt_rdcn_outcode TaxAmtReducnOutCode
taxamtreducn firu_prt_tax_amount_reduction TaxAmountReduction
cadastralvalue firu_prt_cadastral_value Cadastral Value
ownershipmonths firu_prt_ownership_months Months of Ownership
cadastralvaluemonths firu_prt_cadastral_val_months Months of Cad. Value
taxamtpaidabroad firu_prt_tax_amt_paid_abroad Tax Paid Abroad
region regio Region
ismovableproperty firu_asset_is_movable_property Is Movable Property
szpk firu_prt_szpk_attribute SZPK Attribute
statryrptrunidref srf_report_run_id Report Run ID

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.

-- Russia ACR Report Property Tax Log Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIRUD_PRT_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,                 -- Run Item ID [firu_prt_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]
    PROPERTYTYPE,           -- Property Type [j_3rfproptypen]
    NBV01,                  -- NBV as of 01.01 [firu_prt_asset_nbv01]
    NBV02,                  -- NBV as of 01.02 [firu_prt_asset_nbv02]
    NBV03,                  -- NBV as of 01.03 [firu_prt_asset_nbv03]
    NBV04,                  -- NBV as of 01.04 [firu_prt_asset_nbv04]
    NBV05,                  -- NBV as of 01.05 [firu_prt_asset_nbv05]
    NBV06,                  -- NBV as of 01.06 [firu_prt_asset_nbv06]
    NBV07,                  -- NBV as of 01.07 [firu_prt_asset_nbv07]
    NBV08,                  -- NBV as of 01.08 [firu_prt_asset_nbv08]
    NBV09,                  -- NBV as of 01.09 [firu_prt_asset_nbv09]
    NBV10,                  -- NBV as of 01.10 [firu_prt_asset_nbv10]
    NBV11,                  -- NBV as of 01.11 [firu_prt_asset_nbv11]
    NBV12,                  -- NBV as of 01.12 [firu_prt_asset_nbv12]
    NBV13,                  -- NBV as of 31.12 [firu_prt_asset_nbv13]
    TAXEXEMPTIONID,         -- Tax Exemption Code [firu_prt_tax_exemption_id]
    TAXEXEMPTIONCODE,       -- TaxExemptionOutCode [firu_prt_tax_exemption_outcode]
    TAXEXEMPTIONVALUE,      -- Value to Exemption [firu_prt_tax_exemption_value]
    TAXEXEMPTIONUNITVALUE,  -- UnitOfValueToExemp [firu_prt_tax_exemption_unitval]
    TAXRATEREDUCNID,        -- Tax Reduction Code [firu_prt_tax_rate_rdcn_id]
    TAXRATEREDUCNCODE,      -- TaxRateReducnOutCode [firu_prt_tax_rate_rdcn_outcode]
    TAXRATE,                -- Property Tax Rate [firu_prt_tax_rate]
    TAXBASEAMT,             -- Tax Base Amount [firu_prt_tax_base_amount]
    TAXAMTPERIOD,           -- TaxAmountPeriod [firu_prt_tax_amount_period]
    TAXAMTDOWNPAYMENT,      -- Amount of Down Paym [firu_prt_tax_amount_down_paym]
    TAXAMTREDUCNID,         -- Tax Amount Red.Code [firu_prt_tax_amt_rdcn_id]
    TAXAMTREDUCNCODE,       -- TaxAmtReducnOutCode [firu_prt_tax_amt_rdcn_outcode]
    TAXAMTREDUCN,           -- TaxAmountReduction [firu_prt_tax_amount_reduction]
    CADASTRALVALUE,         -- Cadastral Value [firu_prt_cadastral_value]
    OWNERSHIPMONTHS,        -- Months of Ownership [firu_prt_ownership_months]
    CADASTRALVALUEMONTHS,   -- Months of Cad. Value [firu_prt_cadastral_val_months]
    TAXAMTPAIDABROAD,       -- Tax Paid Abroad [firu_prt_tax_amt_paid_abroad]
    REGION,                 -- Region [regio]
    ISMOVABLEPROPERTY,      -- Is Movable Property [firu_asset_is_movable_property]
    SZPK,                   -- SZPK Attribute [firu_prt_szpk_attribute]
    STATRYRPTRUNIDREF,      -- Report Run ID [srf_report_run_id]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, ITEMID)
);