I_RU_TransportTaxItemLog

DDL: I_RU_TRANSPORTTAXITEMLOG SQL: IRUTRTITMLOG Type: view BASIC
26 Fields 1 Data Sources

Russia Transport Tax item Log

I_RU_TransportTaxItemLog is a Basic CDS View that provides data about "Russia Transport Tax item Log" in SAP S/4HANA. It reads from 1 data source (firud_trt_rpitm) and exposes 26 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID.

Data Sources (1)

SourceAliasJoin Type
firud_trt_rpitm firud_trt_rpitm from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRUTRTITMLOG 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 Transport Tax item Log view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity statryrptgentity Reporting Entity
KEY StatryRptCategory statryrptcategory Report ID
KEY StatryRptRunID statryrptrunid Report Run ID
CompanyCode companycode Receiver Company Code
MasterFixedAsset masterfixedasset Fixed Asset
FixedAsset fixedasset Sub-number
ValidityStartDate intervalstart Valid From
ValidityEndDate intervalend Valid To
RU_TransportTaxOKTMO OKTMO
RU_VehicleLicensePlateNumber licensenum License Plate
RU_TransportTxOwnershipInMnths ownershipmonths Months of Ownership
TaxRate taxrate Tax Rate
RU_TranspTaxBaseQtyInBaseUnit taxbase Tax Base Unit
RU_TransportTaxPowerUnit taxbase_unit Tax base unit
RU_TransptCommonOwnershipShare ownershipshare Share in Ownership
RU_TransptTxExpensiveRatio coeff_kp CoefficientExpVeh
RU_TransportTaxExemption taxexemptionid Tax Exemption Code
RU_TransptTxExemptionAmount taxexmpreducamt Exemption Amount
RU_TransportTaxReduction taxratereducid Tax Concession ID
RU_TransptTxRateReducnAmount taxratereducamt Tax Rate Reduction
RU_TranspTxAmtReduction taxamtreducid Tax Concession ID
RU_TransptTxAmtReducnAmount taxamtreducamt Tax Amount Reduction
DownPaymentQtr1AmtInLoclCrcy taxamtdownpmnt_q1 Downpayment Amnt
DownPaymentQtr2AmtInLoclCrcy taxamtdownpmnt_q2 Downpayment Amnt
DownPaymentQtr3AmtInLoclCrcy taxamtdownpmnt_q3 Downpayment Amnt
TaxAmountInCountryCrcy taxamount Tax Amt in Rptg Crcy

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_TransportTaxItemLog.
-- 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: IRUTRTITMLOG

CREATE VIEW I_RU_TransportTaxItemLog AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  intervalstart AS ValidityStartDate,
  intervalend AS ValidityEndDate,
  cast(oktmo as firu_oktmo_int ) AS RU_TransportTaxOKTMO,
  licensenum AS RU_VehicleLicensePlateNumber,
  ownershipmonths AS RU_TransportTxOwnershipInMnths,
  TaxRate,
  taxbase AS RU_TranspTaxBaseQtyInBaseUnit,
  taxbase_unit AS RU_TransportTaxPowerUnit,
  ownershipshare AS RU_TransptCommonOwnershipShare,
  coeff_kp AS RU_TransptTxExpensiveRatio,
  taxexemptionid AS RU_TransportTaxExemption,
  taxexmpreducamt AS RU_TransptTxExemptionAmount,
  taxratereducid AS RU_TransportTaxReduction,
  taxratereducamt AS RU_TransptTxRateReducnAmount,
  taxamtreducid AS RU_TranspTxAmtReduction,
  taxamtreducamt AS RU_TransptTxAmtReducnAmount,
  taxamtdownpmnt_q1 AS DownPaymentQtr1AmtInLoclCrcy,
  taxamtdownpmnt_q2 AS DownPaymentQtr2AmtInLoclCrcy,
  taxamtdownpmnt_q3 AS DownPaymentQtr3AmtInLoclCrcy,
  taxamount AS TaxAmountInCountryCrcy
FROM firud_trt_rpitm
;

Learn More