I_InvestmentSupportMeasure

DDL: I_INVESTMENTSUPPORTMEASURE SQL: IFIINVMTSUPPMSR Type: view BASIC

Investment Support Measure

I_InvestmentSupportMeasure (Basic)

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

Accounting and Financial Close

I_InvestmentSupportMeasure is a Basic CDS View (Dimension) that provides data about "Investment Support Measure" in SAP S/4HANA. It reads from 1 data source (t085) and exposes 4 fields with key fields ChartOfDepreciation, InvestmentSupportMeasure. It has 2 associations to related views.

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 investment support measures are defined?

Structure
Measures and attributes Important measure and attribute: Investment Support Measure

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-FIO-GL-IS
CapabilitiesAnalytical Dimension
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
t085 t085 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ChartOfDepreciation _ChartOfDepreciation $projection.ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation
[0..*] I_InvestmentSupportMeasureText _Text $projection.ChartOfDepreciation = _Text.ChartOfDepreciation and $projection.InvestmentSupportMeasure = _Text.InvestmentSupportMeasure

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IFIINVMTSUPPMSR view
Analytics.dataCategory #DIMENSION view
EndUserText.label Investment Support Measure view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey InvestmentSupportMeasure 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

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ChartOfDepreciation t085 afapl Chart of Depreciaton for Asset Valuation
KEY InvestmentSupportMeasure t085 invsl Investment Support 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_InvestmentSupportMeasure.
-- 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: IFIINVMTSUPPMSR

CREATE VIEW I_InvestmentSupportMeasure AS
SELECT
  t085.afapl AS ChartOfDepreciation,
  t085.invsl AS InvestmentSupportMeasure
FROM t085
LEFT OUTER JOIN I_ChartOfDepreciation AS _ChartOfDepreciation ON ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation  -- association [0..1]
LEFT OUTER JOIN I_InvestmentSupportMeasureText AS _Text ON ChartOfDepreciation = _Text.ChartOfDepreciation AND InvestmentSupportMeasure = _Text.InvestmentSupportMeasure  -- association [0..*]
;