I_DepreciationKey

DDL: I_DEPRECIATIONKEY SQL: IFIDEPRKEY Type: view BASIC Package: FINS_FIS_AA_MD
4 Fields 1 Data Sources 2 Associations

Depreciation Key

I_DepreciationKey (Basic)

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

Accounting and Financial Close

I_DepreciationKey is a Basic CDS View (Dimension) that provides data about "Depreciation Key" in SAP S/4HANA. It reads from 1 data source (t090na) and exposes 4 fields with key fields ChartOfDepreciation, DepreciationKey. It has 2 associations to related views. Part of development package FINS_FIS_AA_MD.

SAP Help Documentation

CategoryCDS Views for Configuration Data
Data CategoryDimension
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business question: How many depreciation keys are defined?

Structure
Measures and attributes Important measure and attribute: Depreciation Key

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-FIO-AA-ANA-2CL
CapabilitiesAnalytical Dimension,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Data Source in SQL Select,Data Source for Search
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering the following business question:</p> <ul> <li><p>How many depreciation keys are defined?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
t090na t090na from

Associations (2)

CardinalityTargetAliasCondition
[1] I_ChartOfDepreciation _ChartOfDepreciation $projection.ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation
[0..*] I_DepreciationKeyText _Text $projection.ChartOfDepreciation = _Text.ChartOfDepreciation and $projection.DepreciationKey = _Text.DepreciationKey

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IFIDEPRKEY view
Analytics.dataCategory #DIMENSION view
EndUserText.label Depreciation Key view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey DepreciationKey view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ChartOfDepreciation t090na afapl Chart of Depreciaton for Asset Valuation
KEY DepreciationKey t090na afasl Depreciation Key
_ChartOfDepreciation _ChartOfDepreciation
_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_DepreciationKey.
-- 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: IFIDEPRKEY

CREATE VIEW I_DepreciationKey AS
SELECT
  t090na.afapl AS ChartOfDepreciation,
  t090na.afasl AS DepreciationKey
FROM t090na
LEFT OUTER JOIN I_ChartOfDepreciation AS _ChartOfDepreciation ON ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation  -- association [1]
LEFT OUTER JOIN I_DepreciationKeyText AS _Text ON ChartOfDepreciation = _Text.ChartOfDepreciation AND DepreciationKey = _Text.DepreciationKey  -- association [0..*]
;

Learn More