I_RU_LandTaxItemLog

DDL: I_RU_LANDTAXITEMLOG SQL: IRULNDTITMLOG Type: view BASIC Package: GLO_FIN_IS_RU_LAND_TAX
31 Fields 1 Data Sources

Russia Land Tax Item Log

I_RU_LandTaxItemLog is a Basic CDS View that provides data about "Russia Land Tax Item Log" in SAP S/4HANA. It reads from 1 data source (firud_lndt_rpitm) and exposes 31 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, RU_LandTaxItemNumber. Part of development package GLO_FIN_IS_RU_LAND_TAX.

Data Sources (1)

SourceAliasJoin Type
firud_lndt_rpitm firud_lndt_rpitm from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRULNDTITMLOG 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 Land Tax Item Log view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity statryrptgentity Reporting Entity
KEY StatryRptCategory statryrptcategory Report ID
KEY StatryRptRunID statryrptrunid Report Run ID
KEY RU_LandTaxItemNumber 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_LandTaxOKTMO OKTMO
RU_CadastrAmtInLoclCrcy cadastralvalue LandPlotCadastralVal
RU_AssetCommonPropertyShare ownershiprightshare ShareRightOwnership
RU_LandTaxBaseReduction taxbasereducnid TaxBaseReductionCode
RU_LandTxBaseReducnUsgeInMnths taxbasereducnmonths MonthsTaxBaseReducn
RU_LandTaxBaseReducnAmount taxbasereducnamt TaxBaseReduction
TaxBaseAmountInCountryCrcy taxbaseamt Tax Base Amount
TaxRate taxrate Tax Rate
TaxAmountInCountryCrcy taxamtperiod TaxAmountPeriod
RU_LandTaxRateReduction taxratereducnid TaxRateReductionCode
RU_LandTxRateReducnUsgeInMnths taxratereducnmonths MonthsTaxRateReducn
RU_LandTaxReducedRate taxratereduced Reduced Tax Rate
RU_LandTaxAmtReduction taxamtreducnid Tax Amount Red.Code
RU_LandTxAmtReducnUsgeInMnths taxamtreducnmonths MonthsTaxAmoutReducn
RU_LandTaxReducnAmtInLoclCrcy taxamtreducn TaxAmountReduction
DownPaymentQtr1AmtInLoclCrcy taxamtdwnpaytq1 DownPaymentAmountQ1
DownPaymentQtr2AmtInLoclCrcy taxamtdwnpaytq2 DownPaymentAmountQ1
DownPaymentQtr3AmtInLoclCrcy taxamtdwnpaytq3 DownPaymentAmountQ1
TaxOverpaymentAmountInLoclCrcy taxamtoverpayment Overpayment Amount
RU_LandPlotOwnershipInMonths ownershipmonths Months of Ownership
RU_CadastrAmtValidityInMonths cadastralvaluemonths Months of Cad. Value
RU_LandTxConstructionCoeffVal coeffconstructionperiod CoeffConstrPeriod

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_LandTaxItemLog.
-- 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: IRULNDTITMLOG

CREATE VIEW I_RU_LandTaxItemLog AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  itemid AS RU_LandTaxItemNumber,
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  intervalstart AS ValidityStartDate,
  intervalend AS ValidityEndDate,
  cast(oktmo as firu_oktmo_int ) AS RU_LandTaxOKTMO,
  cadastralvalue AS RU_CadastrAmtInLoclCrcy,
  ownershiprightshare AS RU_AssetCommonPropertyShare,
  taxbasereducnid AS RU_LandTaxBaseReduction,
  taxbasereducnmonths AS RU_LandTxBaseReducnUsgeInMnths,
  taxbasereducnamt AS RU_LandTaxBaseReducnAmount,
  taxbaseamt AS TaxBaseAmountInCountryCrcy,
  TaxRate,
  taxamtperiod AS TaxAmountInCountryCrcy,
  taxratereducnid AS RU_LandTaxRateReduction,
  taxratereducnmonths AS RU_LandTxRateReducnUsgeInMnths,
  taxratereduced AS RU_LandTaxReducedRate,
  taxamtreducnid AS RU_LandTaxAmtReduction,
  taxamtreducnmonths AS RU_LandTxAmtReducnUsgeInMnths,
  taxamtreducn AS RU_LandTaxReducnAmtInLoclCrcy,
  taxamtdwnpaytq1 AS DownPaymentQtr1AmtInLoclCrcy,
  taxamtdwnpaytq2 AS DownPaymentQtr2AmtInLoclCrcy,
  taxamtdwnpaytq3 AS DownPaymentQtr3AmtInLoclCrcy,
  taxamtoverpayment AS TaxOverpaymentAmountInLoclCrcy,
  ownershipmonths AS RU_LandPlotOwnershipInMonths,
  cadastralvaluemonths AS RU_CadastrAmtValidityInMonths,
  coeffconstructionperiod AS RU_LandTxConstructionCoeffVal
FROM firud_lndt_rpitm
;

Learn More