I_FundSubstitutionValidation

DDL: I_FUNDSUBSTITUTIONVALIDATION SQL: IWUFUNDSUBVAL Type: view COMPOSITE Package: ODATA_PSM_S4C_FM_WHRUSED_FUND
7 Fields 2 Data Sources 2 Associations

Substitution Validation Rules Fund

I_FundSubstitutionValidation is a Composite CDS View that provides data about "Substitution Validation Rules Fund" in SAP S/4HANA. It reads from 2 data sources (I_Fund, I_Fund) and exposes 7 fields with key fields FinancialManagementArea, Fund, FinSubstitutionValidationRule, Fund, FinSubstitutionValidationRule. It has 2 associations to related views. Part of development package ODATA_PSM_S4C_FM_WHRUSED_FUND.

Data Sources (2)

SourceAliasJoin Type
I_Fund _Fund from
I_Fund _Fund union

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_FinSubstitutionRuleSubstn _substitution $projection.Fund = _substitution.FinSubstnRuleSubstitutionValue and _substitution.FinSubstnRuleTargetField like '%Fund%'
[1..*] I_PubSecValidationCndnRule _condvalidation _Fund.Fund = _condvalidation.RangeFromValue or ( _Fund.Fund between _condvalidation.RangeFromValue and _condvalidation.RangeToValue ) and _condvalidation.FinSubstnValdtnRuleFieldPath like '%Fund%'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWUFUNDSUBVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Substitution Validation Rules Fund view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea I_Fund FinancialManagementArea FM Area
KEY Fund I_Fund Fund Sender Fund
KEY FinSubstitutionValidationRule _substitution FinSubstitutionValidationRule Rule ID
FinancialManagementArea FM Area
KEY Fund I_Fund Fund Sender Fund
KEY FinSubstitutionValidationRule _condvalidation FinSubstitutionValidationRule Rule ID
FundName

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_FundSubstitutionValidation.
-- 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: IWUFUNDSUBVAL

CREATE VIEW I_FundSubstitutionValidation AS
SELECT
  _Fund.FinancialManagementArea AS FinancialManagementArea,
  _Fund.Fund AS Fund,
  _substitution.FinSubstitutionValidationRule AS FinSubstitutionValidationRule,
  _Fund._Text[ Language = $session.system_language ].FundName AS FundName
FROM I_Fund AS _Fund
LEFT OUTER JOIN I_FinSubstitutionRuleSubstn AS _substitution ON Fund = _substitution.FinSubstnRuleSubstitutionValue AND _substitution.FinSubstnRuleTargetField like '%Fund%'  -- association [1..*]
LEFT OUTER JOIN I_PubSecValidationCndnRule AS _condvalidation ON _Fund.Fund = _condvalidation.RangeFromValue OR ( _Fund.Fund between _condvalidation.RangeFromValue AND _condvalidation.RangeToValue ) AND _condvalidation.FinSubstnValdtnRuleFieldPath like '%Fund%'  -- association [1..*]
-- UNION with additional select branch(es): I_Fund
;

Learn More