I_InvestmentSupportMeasureText

DDL: I_INVESTMENTSUPPORTMEASURETEXT SQL: IFIINVMTSUPPMSRT Type: view BASIC

Investment Support Measure - Text

I_InvestmentSupportMeasureText (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_InvestmentSupportMeasureText is a Basic CDS View that provides data about "Investment Support Measure - Text" in SAP S/4HANA. It reads from 1 data source (t085s) and exposes 6 fields with key fields ChartOfDepreciation, InvestmentSupportMeasure, Language. It has 2 associations to related views.

SAP API Hub

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

Documentation

Data Sources (1)

SourceAliasJoin Type
t085s t085s from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ChartOfDepreciation _ChartOfDepreciation $projection.ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IFIINVMTSUPPMSRT view
EndUserText.label Investment Support Measure - Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey InvestmentSupportMeasure view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ChartOfDepreciation t085s afapl Chart of Depreciaton for Asset Valuation
KEY InvestmentSupportMeasure t085s invsl Investment Support Key
KEY Language t085s spras Off. Language
InvestmentSupportMeasureName t085s invetx Investment Support Measure
_Language _Language
_ChartOfDepreciation _ChartOfDepreciation

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_InvestmentSupportMeasureText.
-- 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: IFIINVMTSUPPMSRT

CREATE VIEW I_InvestmentSupportMeasureText AS
SELECT
  t085s.afapl AS ChartOfDepreciation,
  t085s.invsl AS InvestmentSupportMeasure,
  t085s.spras AS Language,
  t085s.invetx AS InvestmentSupportMeasureName
FROM t085s
LEFT OUTER JOIN I_ChartOfDepreciation AS _ChartOfDepreciation ON ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;