P_RU_TransportTaxAssetData

DDL: P_RU_TRANSPORTTAXASSETDATA SQL: PRUTRTASSETDT Type: view CONSUMPTION
11 Fields 1 Data Sources

Ru Transport Tax Master data

P_RU_TransportTaxAssetData is a Consumption CDS View that provides data about "Ru Transport Tax Master data" in SAP S/4HANA. It reads from 1 data source (I_FixedAsset) and exposes 11 fields with key fields company_code, asset_num, asset_subnum, period_start.

Data Sources (1)

SourceAliasJoin Type
I_FixedAsset I_FixedAsset from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PRUTRTASSETDT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Ru Transport Tax Master data view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY company_code I_FixedAsset CompanyCode Receiver Company Code
KEY asset_num I_FixedAsset MasterFixedAsset Fixed Asset
KEY asset_subnum I_FixedAsset FixedAsset Sub-number
KEY period_start _GlobAssetAssignment ValidityStartDate Validity Start Date
period_end _GlobAssetAssignment ValidityEndDate ValidTo
AssetClass AssetClass Asset Class
Currency I_FixedAsset Currency Valuation Crcy
description I_FixedAsset FixedAssetDescription Description
oktmo _GlobAssetAssignment RU_TransportTaxOKTMO
tax_base _GlobAssetAssignment RU_TranspTaxBaseQtyInBaseUnit
date_stolen _GlobAssetAssignment RU_VehicleStolenDate

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 P_RU_TransportTaxAssetData.
-- 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: PRUTRTASSETDT

CREATE VIEW P_RU_TransportTaxAssetData AS
SELECT
  I_FixedAsset.CompanyCode AS company_code,
  I_FixedAsset.MasterFixedAsset AS asset_num,
  I_FixedAsset.FixedAsset AS asset_subnum,
  _GlobAssetAssignment.ValidityStartDate AS period_start,
  _GlobAssetAssignment.ValidityEndDate AS period_end,
  AssetClass,
  I_FixedAsset.Currency AS Currency,
  I_FixedAsset.FixedAssetDescription AS description,
  _GlobAssetAssignment.RU_TransportTaxOKTMO AS oktmo,
  _GlobAssetAssignment.RU_TranspTaxBaseQtyInBaseUnit AS tax_base,
  _GlobAssetAssignment.RU_VehicleStolenDate AS date_stolen
FROM I_FixedAsset
;

Learn More