I_GrantSubstitutionValidation

DDL: I_GRANTSUBSTITUTIONVALIDATION SQL: IWUGRANTSUBVAL Type: view COMPOSITE
5 Fields 2 Data Sources 2 Associations

Substitution Validation Rules Grant

I_GrantSubstitutionValidation is a Composite CDS View that provides data about "Substitution Validation Rules Grant" in SAP S/4HANA. It reads from 2 data sources (I_Grant, I_Grant) and exposes 5 fields with key fields GrantID, FinSubstitutionValidationRule, FinSubstitutionValidationRule. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_Grant _Grant from
I_Grant _Grant union

Associations (2)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWUGRANTSUBVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Substitution Validation Rules Grant 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 GrantID I_Grant GrantID Sender Grant
KEY FinSubstitutionValidationRule _substitution FinSubstitutionValidationRule Rule ID
GrantID Sender Grant
KEY FinSubstitutionValidationRule _condvalidation FinSubstitutionValidationRule Rule ID
GrantName

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_GrantSubstitutionValidation.
-- 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: IWUGRANTSUBVAL

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

Learn More