I_FunctionAreaSubValidation

DDL: I_FUNCTIONAREASUBVALIDATION SQL: IWUFNAREASUBVAL Type: view COMPOSITE Package: ODATA_PSM_S4C_FM_WHRUSED_FAREA
5 Fields 2 Data Sources 2 Associations

Substitution Validation Rules Func Area

I_FunctionAreaSubValidation is a Composite CDS View that provides data about "Substitution Validation Rules Func Area" in SAP S/4HANA. It reads from 2 data sources (I_FundsMgmtFunctionalArea, I_FundsMgmtFunctionalArea) and exposes 5 fields with key fields FunctionalArea, FinSubstitutionValidationRule, FinSubstitutionValidationRule. It has 2 associations to related views. Part of development package ODATA_PSM_S4C_FM_WHRUSED_FAREA.

Data Sources (2)

SourceAliasJoin Type
I_FundsMgmtFunctionalArea _FuncArea from
I_FundsMgmtFunctionalArea _FuncArea union

Associations (2)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWUFNAREASUBVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Substitution Validation Rules Func Area 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 (5)

KeyFieldSource TableSource FieldDescription
KEY FunctionalArea I_FundsMgmtFunctionalArea FunctionalArea Sendr Fctl Area
KEY FinSubstitutionValidationRule _substitution FinSubstitutionValidationRule Rule ID
FunctionalArea Sendr Fctl Area
KEY FinSubstitutionValidationRule _condvalidation FinSubstitutionValidationRule Rule ID
FunctionalAreaName

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_FunctionAreaSubValidation.
-- 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: IWUFNAREASUBVAL

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

Learn More