I_InvestmentReasonVH

DDL: I_INVESTMENTREASONVH Type: view_entity COMPOSITE

Investment Reason

I_InvestmentReasonVH is a Composite CDS View that provides data about "Investment Reason" in SAP S/4HANA. It reads from 1 data source (I_InvestmentReason) and exposes 2 fields with key field InvestmentReason.

Data Sources (1)

SourceAliasJoin Type
I_InvestmentReason I_InvestmentReason from

Annotations (11)

NameValueLevelField
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Investment Reason view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #COMPOSITE view
Search.searchable true view
Consumption.ranked true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY InvestmentReason InvestmentReason Invest. Reason
InvestmentReasonName

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_InvestmentReasonVH.
-- 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_InvestmentReasonVH AS
SELECT
  InvestmentReason,
  _Text[1: Language = $session.system_language].InvestmentReasonName AS InvestmentReasonName
FROM I_InvestmentReason
;