I_AssetRevaluationIndexItem

DDL: I_ASSETREVALUATIONINDEXITEM Type: view_entity BASIC Package: FINS_FAA_INDEX
5 Fields 1 Data Sources 1 Associations

Asset Revaluation Index Item

I_AssetRevaluationIndexItem (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_AssetRevaluationIndexItem is a Basic CDS View that provides data about "Asset Revaluation Index Item" in SAP S/4HANA. It reads from 1 data source (faat_rv_indx_itm) and exposes 5 fields with key fields AssetRevaluationIndex, ValidityEndDate. It has 1 association to related views. Part of development package FINS_FAA_INDEX.

SAP Help Documentation

CategoryAsset Revaluation Index
Purpose
This CDS view provides the index items (that is, the index values) for the automatic revaluation of assets. Based on these index values, the system can automatically calculate revaluations. The calculated revaluation amounts are posted automatically as part of the periodic depreciation posting run. This CDS view provides the data to answer the following business questions: Which index values does a specific index have? For which period are the index values valid and can be used to revaluate acquisition and production costs and to revaluate depreciation values? 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 .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: A_RV_INDEX ( Asset Revaluation Index ) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included. Configuration

Structure
Important Fields Important fields in this view include the following: Field Name Is Key Data Element Description Comment AssetRevaluationIndex X FAA_RV_INDEX_ID Revaluation Index ID Asset Revaluation: Index ID ValidityEndDate X BDATU Valid To Date Validity Ends ValidityStartDate ADATU Valid From Date for Beginning of Validity AssetRevaluationIndexValue FAA_RV_INDEX_POINT Index Points Asset Revaluation: Index Points

Additional Information
For general information about CDS views, see Virtual Data Model and CDS Views in SAP S/4HANA Cloud Public Edition . For information about the CDS view for revaluation indexes, see Asset Revaluation Index . For more information about the automatic revaluation and the revaluation index app, see the product assistance for Asset Accounting under Revaluation and Maintain Asset Revaluation Index .

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-AA-AA-H-2CL
CapabilitiesData Source for Defining CDS Entities,Data Source in SQL Select,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the index items (that is, the index values) for the automatic revaluation of assets. Based on these index values, the system can automatically calculate revaluations. The calculated revaluation amounts are posted automatically as part of the periodic depreciation posting run.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>Which index values does a specific index have? </p></li> <li><p>For which period are the index values valid and can be used to revaluate acquisition and production costs and to revaluate depreciation values?</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
faat_rv_indx_itm faat_rv_indx_itm from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_AssetRevaluationIndex _AssetRevaluationIndex $projection.AssetRevaluationIndex = _AssetRevaluationIndex.AssetRevaluationIndex

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Asset Revaluation Index Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #NONE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY AssetRevaluationIndex index_id Asset Revaluation: Index ID
KEY ValidityEndDate valid_to_date Date Validity Ends
ValidityStartDate valid_from_date Date for Beginning of Validity
AssetRevaluationIndexValue index_point Asset Revaluation: Index Value
_AssetRevaluationIndex _AssetRevaluationIndex

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_AssetRevaluationIndexItem.
-- 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.

CREATE VIEW I_AssetRevaluationIndexItem AS
SELECT
  index_id AS AssetRevaluationIndex,
  valid_to_date AS ValidityEndDate,
  valid_from_date AS ValidityStartDate,
  index_point AS AssetRevaluationIndexValue
FROM faat_rv_indx_itm
LEFT OUTER JOIN I_AssetRevaluationIndex AS _AssetRevaluationIndex ON AssetRevaluationIndex = _AssetRevaluationIndex.AssetRevaluationIndex  -- association [1..1]
;

Learn More