I_RU_AssetDepreciationGroup

DDL: I_RU_ASSETDEPRECIATIONGROUP SQL: IRUASSETDEPRGR Type: view BASIC Package: GLO_FIN_FAA_RU

Russia Asset Depreciation Group

I_RU_AssetDepreciationGroup (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Country or Region-Specific Functions for Finance

I_RU_AssetDepreciationGroup is a Basic CDS View that provides data about "Russia Asset Depreciation Group" in SAP S/4HANA. It reads from 1 data source (j_3rokof16_dgr) and exposes 8 fields with key fields Country, RU_AssetOKOF, RU_AssetDepreciationGroup. It has 5 associations to related views. Part of development package GLO_FIN_FAA_RU.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessCountry or Region-Specific Functions for Finance
Application ComponentFI-LOC-AA-RU
CapabilitiesData Source for Defining CDS Entities,Enabled for UI Consumption
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageCountry/Region-Specific Functions for Finance for SAP S/4HANA Cloud Public Edition
Description <p>This view should be used for value help purposes only. The purpose of this CDS view is to provide a structured way to access and display information related to asset depreciation groups specific to Russia, including associations with country and OKOF asset classification codes.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>Which asset depreciation groups are defined in the Russian localization, based on country and OKOF asset classification code?</p></li> <li><p>How can you retrieve representative descriptive text for these asset depreciation groups, including country and OKOF asset classification code context?</p></li> <li><p>What country or OKOF asset classification code exists for a specific asset depreciation group in Russia?</p></li> <li><p>How do you access related country and OKOF asset classification code information when selecting an asset depreciation group for configuration or reporting?</p></li> <li><p>Which depreciation groups specific to Russia can be selected in asset management applications?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
j_3rokof16_dgr j_3rokof16_dgr from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_Country _Country $projection.Country = _Country.Country
[0..*] I_CountryText _CountryText $projection.Country = _CountryText.Country
[1..1] I_RU_AssetOKOF _RU_AssetOKOF $projection.RU_AssetOKOF = _RU_AssetOKOF.RU_AssetOKOF and $projection.Country = _RU_AssetOKOF.Country
[0..*] I_RU_AssetOKOFText _RU_AssetOKOFText $projection.RU_AssetOKOF = _RU_AssetOKOFText.RU_AssetOKOF and $projection.Country = _RU_AssetOKOFText.Country
[0..*] I_RU_AssetDepreciationGroupT _Text $projection.RU_AssetDepreciationGroup = _Text.RU_AssetDepreciationGroup and $projection.Country = _Text.Country and $projection.RU_AssetOKOF = _Text.RU_AssetOKOF

Annotations (14)

NameValueLevelField
EndUserText.label Russia Asset Depreciation Group view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IRUASSETDEPRGR view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataExtraction.enabled false view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey RU_AssetDepreciationGroup view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Country land1 Country/Region Key
KEY RU_AssetOKOF okof New OKOF Code
KEY RU_AssetDepreciationGroup depr_group Depreciation Group
_Country _Country
_CountryText _CountryText
_RU_AssetOKOF _RU_AssetOKOF
_RU_AssetOKOFText _RU_AssetOKOFText
_Text _Text

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_AssetDepreciationGroup.
-- 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: IRUASSETDEPRGR

CREATE VIEW I_RU_AssetDepreciationGroup AS
SELECT
  land1 AS Country,
  okof AS RU_AssetOKOF,
  depr_group AS RU_AssetDepreciationGroup
FROM j_3rokof16_dgr
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON Country = _CountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_RU_AssetOKOF AS _RU_AssetOKOF ON RU_AssetOKOF = _RU_AssetOKOF.RU_AssetOKOF AND Country = _RU_AssetOKOF.Country  -- association [1..1]
LEFT OUTER JOIN I_RU_AssetOKOFText AS _RU_AssetOKOFText ON RU_AssetOKOF = _RU_AssetOKOFText.RU_AssetOKOF AND Country = _RU_AssetOKOFText.Country  -- association [0..*]
LEFT OUTER JOIN I_RU_AssetDepreciationGroupT AS _Text ON RU_AssetDepreciationGroup = _Text.RU_AssetDepreciationGroup AND Country = _Text.Country AND RU_AssetOKOF = _Text.RU_AssetOKOF  -- association [0..*]
;