I_RU_PropertyTaxItemLog

DDL: I_RU_PROPERTYTAXITEMLOG SQL: IRUPRTITMLOG Type: view BASIC
44 Fields 1 Data Sources

Russia Property Tax Item Log

I_RU_PropertyTaxItemLog is a Basic CDS View that provides data about "Russia Property Tax Item Log" in SAP S/4HANA. It reads from 1 data source (firud_prt_rpitm) and exposes 44 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, PositionID.

Data Sources (1)

SourceAliasJoin Type
firud_prt_rpitm firud_prt_rpitm from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRUPRTITMLOG view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Russia Property Tax Item Log view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity statryrptgentity Reporting Entity
KEY StatryRptCategory statryrptcategory Report ID
KEY StatryRptRunID statryrptrunid Report Run ID
KEY PositionID itemid Russia Statutory Reporting Report Land Tax, Run Item ID
CompanyCode companycode Receiver Company Code
MasterFixedAsset masterfixedasset Fixed Asset
FixedAsset fixedasset Sub-number
ValidityStartDate intervalstart Valid From
ValidityEndDate intervalend Valid To
RU_PropertyTaxOKTMO OKTMO
RU_AssetPropertyType propertytype Property Type
NetBookValueAmt01InLoclCrcy nbv01 NBV as of 01.01
NetBookValueAmt02InLoclCrcy nbv02 NBV as of 01.02
NetBookValueAmt03InLoclCrcy nbv03 NBV as of 01.03
NetBookValueAmt04InLoclCrcy nbv04 NBV as of 01.04
NetBookValueAmt05InLoclCrcy nbv05 NBV as of 01.05
NetBookValueAmt06InLoclCrcy nbv06 NBV as of 01.06
NetBookValueAmt07InLoclCrcy nbv07 NBV as of 01.07
NetBookValueAmt08InLoclCrcy nbv08 NBV as of 01.08
NetBookValueAmt09InLoclCrcy nbv09 NBV as of 01.09
NetBookValueAmt10InLoclCrcy nbv10 NBV as of 01.10
NetBookValueAmt11InLoclCrcy nbv11 NBV as of 01.11
NetBookValueAmt12InLoclCrcy nbv12 NBV as of 01.12
NetBookValueAmt13InLoclCrcy nbv13 NBV as of 31.12
RU_PrptyCadastrAmtInLoclCrcy cadastralvalue LandPlotCadastralVal
RU_PropertyTaxExemption taxexemptionid Tax Exemption Code
RU_PropertyTaxExemptionDesc taxexemptioncode TaxExemptionOutCode
RU_PropertyTaxExmpQuantity taxexemptionvalue Value to Exemption
RU_PropertyTaxExmpQuantityUnit taxexemptionunitvalue UnitOfValueToExemp
RU_PropertyTaxRateReduction taxratereducnid TaxRateReductionCode
RU_PropertyTaxRateReducnDesc taxratereducncode TaxRateReducnOutCode
TaxRate taxrate Tax Rate
TaxBaseAmountInCountryCrcy taxbaseamt Tax Base Amount
TaxAmount taxamtperiod TaxAmountPeriod
DownPaymentAmount taxamtdownpayment Amount of Down Paym
RU_PropertyTaxAmtReduction taxamtreducnid Tax Amount Red.Code
RU_PropertyTaxAmtReductionDesc taxamtreducncode TaxAmtReducnOutCode
RU_PrptyTaxReducnAmtInLoclCrcy taxamtreducn TaxAmountReduction
MonthInFirstInterval ownershipmonths Months of Ownership
MonthInSecondInterval cadastralvaluemonths Months of Cad. Value
PaidAbroadTaxAmountInLoclCrcy taxamtpaidabroad Tax Paid Abroad
Region region Venue Region
RU_AssetIsMovableProperty ismovableproperty Is Movable Property
RU_PropertyTaxSZPKAttribute szpk SZPK Attribute

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_RU_PropertyTaxItemLog.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IRUPRTITMLOG

CREATE VIEW I_RU_PropertyTaxItemLog AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  itemid AS PositionID,
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  intervalstart AS ValidityStartDate,
  intervalend AS ValidityEndDate,
  cast(oktmo as firu_oktmo_int ) AS RU_PropertyTaxOKTMO,
  propertytype AS RU_AssetPropertyType,
  nbv01 AS NetBookValueAmt01InLoclCrcy,
  nbv02 AS NetBookValueAmt02InLoclCrcy,
  nbv03 AS NetBookValueAmt03InLoclCrcy,
  nbv04 AS NetBookValueAmt04InLoclCrcy,
  nbv05 AS NetBookValueAmt05InLoclCrcy,
  nbv06 AS NetBookValueAmt06InLoclCrcy,
  nbv07 AS NetBookValueAmt07InLoclCrcy,
  nbv08 AS NetBookValueAmt08InLoclCrcy,
  nbv09 AS NetBookValueAmt09InLoclCrcy,
  nbv10 AS NetBookValueAmt10InLoclCrcy,
  nbv11 AS NetBookValueAmt11InLoclCrcy,
  nbv12 AS NetBookValueAmt12InLoclCrcy,
  nbv13 AS NetBookValueAmt13InLoclCrcy,
  cadastralvalue AS RU_PrptyCadastrAmtInLoclCrcy,
  taxexemptionid AS RU_PropertyTaxExemption,
  taxexemptioncode AS RU_PropertyTaxExemptionDesc,
  taxexemptionvalue AS RU_PropertyTaxExmpQuantity,
  taxexemptionunitvalue AS RU_PropertyTaxExmpQuantityUnit,
  taxratereducnid AS RU_PropertyTaxRateReduction,
  taxratereducncode AS RU_PropertyTaxRateReducnDesc,
  TaxRate,
  taxbaseamt AS TaxBaseAmountInCountryCrcy,
  taxamtperiod AS TaxAmount,
  taxamtdownpayment AS DownPaymentAmount,
  taxamtreducnid AS RU_PropertyTaxAmtReduction,
  taxamtreducncode AS RU_PropertyTaxAmtReductionDesc,
  taxamtreducn AS RU_PrptyTaxReducnAmtInLoclCrcy,
  ownershipmonths AS MonthInFirstInterval,
  cadastralvaluemonths AS MonthInSecondInterval,
  taxamtpaidabroad AS PaidAbroadTaxAmountInLoclCrcy,
  Region,
  ismovableproperty AS RU_AssetIsMovableProperty,
  szpk AS RU_PropertyTaxSZPKAttribute
FROM firud_prt_rpitm
;

Learn More