I_RU_PropertyTaxItemCube

Russia Property Tax Return: Cube | view: IRUPRTITEMCUBE | TRAN | Extraction: Not supported | Component: Financials Russia
Tables used: FIRUD_PRT_RPITM, ANLA, FAAT_MD, FAAT_MD_ROOT, T001, ANLZ, FAAT_MD_TDD, TKA02, GLOFAAASSETDATA, GLOFAATMDPNDNT
Column Name Description
StatryRptgEntity Reporting Entity
StatryRptCategory Report Category ID
StatryRptRunID Report Run ID
PositionID Russia Statutory Report Property Tax, Run Item ID
Column Name Description
💲 Currency Key (Currency):
NetBookValueAmt01InLoclCrcy Property Tax, Asset Net Book Value as of 01.01
NetBookValueAmt02InLoclCrcy Property Tax, Asset Net Book Value as of 01.02
NetBookValueAmt03InLoclCrcy Property Tax, Asset Net Book Value as of 01.03
NetBookValueAmt04InLoclCrcy Property Tax, Asset Net Book Value as of 01.04
NetBookValueAmt05InLoclCrcy Property Tax, Asset Net Book Value as of 01.05
NetBookValueAmt06InLoclCrcy Property Tax, Asset Net Book Value as of 01.06
NetBookValueAmt07InLoclCrcy Property Tax, Asset Net Book Value as of 01.07
NetBookValueAmt08InLoclCrcy Property Tax, Asset Net Book Value as of 01.08
NetBookValueAmt09InLoclCrcy Property Tax, Asset Net Book Value as of 01.09
NetBookValueAmt10InLoclCrcy Property Tax, Asset Net Book Value as of 01.10
NetBookValueAmt11InLoclCrcy Property Tax, Asset Net Book Value as of 01.11
NetBookValueAmt12InLoclCrcy Property Tax, Asset Net Book Value as of 01.12
NetBookValueAmt13InLoclCrcy Property Tax, Asset Net Book Value as of 31.12
NetBookValAmtExmp01InLoclCrcy Property Tax, Asset Net Book Value Exempt as of 01.01
NetBookValAmtExmp02InLoclCrcy Property Tax, Asset Net Book Value Exempt as of 01.02
NetBookValAmtExmp03InLoclCrcy Property Tax, Asset Net Book Value Exempt as of 01.03
NetBookValAmtExmp04InLoclCrcy Property Tax, Asset Net Book Value Exempt as of 01.04
NetBookValAmtExmp05InLoclCrcy Property Tax, Asset Net Book Value Exempt as of 01.05
NetBookValAmtExmp06InLoclCrcy Property Tax, Asset Net Book Value Exempt as of 01.06
NetBookValAmtExmp07InLoclCrcy Property Tax, Asset Net Book Value Exempt as of 01.07
NetBookValAmtExmp08InLoclCrcy Property Tax, Asset Net Book Value Exempt as of 01.08
NetBookValAmtExmp09InLoclCrcy Property Tax, Asset Net Book Value Exempt as of 01.09
NetBookValAmtExmp10InLoclCrcy Property Tax, Asset Net Book Value Exempt as of 01.10
NetBookValAmtExmp11InLoclCrcy Property Tax, Asset Net Book Value Exempt as of 01.11
NetBookValAmtExmp12InLoclCrcy Property Tax, Asset Net Book Value Exempt as of 01.12
NetBookValAmtExmp13InLoclCrcy Property Tax, Asset Net Book Value Exempt as of 31.12
NetBookValueAmtAvgInLoclCrcy Asset Net Book Value Average
NetBookValAmtExmpAvgInLoclCrcy Asset Net Book Value Average Exempt
TaxBaseAmountInCountryCrcy Property Tax Base Amount
TaxAmount Annual Property Tax Amount
DownPaymentAmount Amount of Down Payment for Property Tax
RU_PrptyTaxReducnAmtInLoclCrcy Property Tax Amount Reduction with Tax Concession
PaidAbroadTaxAmountInLoclCrcy Property Tax Amount Paid Abroad (output)
TotalTaxAmount Payable Property Tax Amount
NetBookValueAmount Property Tax, Asset Net Book Value as of 31.12
RU_PrptyCadastrAmtInLoclCrcy Property Cadastral Value
RU_CadastrAmtExmpInLoclCrcy Exempt Cadastral Value
Column Name Description
Column Name Description
ValidityStartDate Date for Beginning of Validity
ValidityEndDate Date Validity Ends
RU_PropertyOwnershipRegnDate Registration Date of Real Estate Ownership Rights
RU_PropertyOwnershipTermnDate Termination Date of Real Estate Ownership Rights
Column Name Description
RU_PropertyTaxObjectNumberType Real Estate Number Type Show values
IsShutDown Asset shutdown Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
MasterFixedAsset Main Asset Number ANLN1
FixedAsset Asset Subnumber ANLN2
FixedAssetDescription Asset Description TEXT50
AssetAdditionalDescription Additional Asset Description TEXT50
RU_PropertyTaxOKTMO OKTMO Internal Code FIRU_OKTMO_INT
RU_AssetPropertyType Property Type CHAR2
RU_PropertyTaxExemption Property Tax Exemption Code FIRU_PRT_CONCESSION_ID
RU_PropertyTaxExemptionDesc Tax Exemption Output Code (Legal Code & Law Article)
RU_PropertyTaxRateReduction Property Tax Reduction Code FIRU_PRT_CONCESSION_ID
RU_PropertyTaxRateReducnDesc Tax Rate Reduction Output Code (Legal Code & Law Article)
TaxRate Property Tax Rate Output CHAR10
RU_PropertyTaxAmtReduction Property Tax Amount Reduction Code
RU_PropertyTaxAmtReductionDesc Tax Amount Reduction Output Code
RU_PropertyTaxObjectNumber Real Estate Number FIRU_PRT_PROPERTY_NUMBER
Inventory Inventory Number INVNR_ANLA
RU_AssetOKOF OKOF Code
RU_AssetCommonPropertyShare Share in Common Property CHAR21
RU_RoomFloorAreaInSquareMeter Room Area J_3R_LOC_AREA
RU_RoomBuildFloorAreaInSqMtr Area J_3R_TOTAL_AREA
MonthInFirstInterval Months of Property Ownership FIRU_PRT_OWNERSHIP_MONTHS
MonthInSecondInterval Months of Cadastral Value Validity FIRU_PRT_CADASTRAL_VAL_MONTHS
Region Region (State, Province, County) REGIO
TaxSection null
VehicleLicensePlateNumber License Plate No. of Vehicle AM_KFZKZ
CostCenter Cost Center KOSTL
Room Room CHAR8
CostCtrActivityType Activity Type LSTAR
ResponsibleCostCenter Cost Center Responsible for Asset KOSTL
PersonnelNumber Personnel Number PERNR
Fund Fund BP_GEBER
RealEstateObject Internal Key for Real Estate Object IMKEY
ProfitCenter Profit Center PRCTR
FunctionalArea Functional Area FKBER
GrantID Grant GM_GRANT_NBR
BudgetPeriod Budget Period FM_BUDGET_PERIOD
FundsCenter Funds Center FISTL
FunctionalLocation Functional Location TPLNR
Master Data Relations Join Conditions
Asset location
  • Asset location
  • Client
  • Plant
  • I_RU_PROPERTYTAXITEMCUBE.ASSETLOCATION == T499S.STAND
  • I_RU_PROPERTYTAXITEMCUBE.MANDT == T499S.MANDT
  • I_RU_PROPERTYTAXITEMCUBE.PLANT == T499S.WERKS
Business Area
  • Client
  • Business Area
  • I_RU_PROPERTYTAXITEMCUBE.MANDT == TGSB.MANDT
  • I_RU_PROPERTYTAXITEMCUBE.BUSINESSAREA == TGSB.GSBER
Controlling Area
  • Client
  • Controlling Area
  • I_RU_PROPERTYTAXITEMCUBE.MANDT == TKA01.MANDT
  • I_RU_PROPERTYTAXITEMCUBE.CONTROLLINGAREA == TKA01.KOKRS
Currency Key
  • Client
  • Currency Key
  • I_RU_PROPERTYTAXITEMCUBE.MANDT == TCURC.MANDT
  • I_RU_PROPERTYTAXITEMCUBE.CURRENCY == TCURC.WAERS
Internal Order
  • Client
  • Internal Order
  • I_RU_PROPERTYTAXITEMCUBE.MANDT == AUFK.MANDT
  • I_RU_PROPERTYTAXITEMCUBE.INTERNALORDER == AUFK.AUFNR
Maintenance Order
  • Client
  • Maintenance Order
  • I_RU_PROPERTYTAXITEMCUBE.MANDT == AUFK.MANDT
  • I_RU_PROPERTYTAXITEMCUBE.MAINTENANCEORDER == AUFK.AUFNR
Plant
  • Client
  • Plant
  • I_RU_PROPERTYTAXITEMCUBE.MANDT == T001W.MANDT
  • I_RU_PROPERTYTAXITEMCUBE.PLANT == T001W.WERKS
Segment
  • Client
  • Segment for Segmental Reporting
  • I_RU_PROPERTYTAXITEMCUBE.MANDT == FAGL_SEGM.MANDT
  • I_RU_PROPERTYTAXITEMCUBE.SEGMENT == FAGL_SEGM.SEGMENT
Tax Jurisdiction
  • Client
  • Tax Jurisdiction
  • ?
  • I_RU_PROPERTYTAXITEMCUBE.MANDT == TTXJ.MANDT
  • I_RU_PROPERTYTAXITEMCUBE.TAXJURISDICTION == TTXJ.TXJCD
  • I_RU_PROPERTYTAXITEMCUBE.[column in domain "TAX_KALSM"] == TTXJ.KALSM