I_GrantDrvtnRule

DDL: I_GRANTDRVTNRULE SQL: IWUGRANTDRVNRL Type: view COMPOSITE
17 Fields 1 Data Sources 2 Associations

Substitution Validation Rules Grant

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

Data Sources (1)

SourceAliasJoin Type
I_GrantSubstitutionValidation I_GrantSubstitutionValidation from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_PubSecSubValBusContext _Context $projection.FinSubstitutionValidationRule = _Context.FinSubstitutionValidationRule
[1..*] I_FinSubstnValdtnRule _Rule $projection.FinSubstitutionValidationRule = _Rule.FinSubstitutionValidationRule

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWUGRANTDRVNRL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY 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 (17)

KeyFieldSource TableSource FieldDescription
KEY GrantWhereUsedObjType
KEY GrantID I_GrantSubstitutionValidation GrantID Sender Grant
KEY FinSubstitutionValidationRule I_GrantSubstitutionValidation FinSubstitutionValidationRule Rule ID
FinSubstitutionValdtnRuleName _Rule FinSubstitutionValdtnRuleName Rule Name
PubSecSubstnValdtnRule _Rule FinSubstitutionValidationRule Rule ID
FinSubstnValdtnRuleDescription
FinSubstnValdtnRuleContext _Context FinSubstnValdtnRuleContext Context ID
FinSubstnValdtnRuleContextDesc
FinSubstnValdtnRuleStatus _Rule FinSubstnValdtnRuleStatus Rule Status
FinSubstitutionValdtnRuleType _Rule FinSubstitutionValdtnRuleType Rule Type
clientNULLasCreationDate
CreatedByUser _Rule CreatedByUser User Name
clientNULLasLastChangeDate
LastChangedByUser _Rule LastChangedByUser User Name
_EventRule _Rule _EventRule
_Context _Context
_Rule _Rule

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_GrantDrvtnRule.
-- 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: IWUGRANTDRVNRL

CREATE VIEW I_GrantDrvtnRule AS
SELECT
  cast( '14DRVN' as psm_s4c_gm_grant_wu_obj_typ_vh ) AS GrantWhereUsedObjType,
  I_GrantSubstitutionValidation.GrantID AS GrantID,
  I_GrantSubstitutionValidation.FinSubstitutionValidationRule AS FinSubstitutionValidationRule,
  _Rule.FinSubstitutionValdtnRuleName AS FinSubstitutionValdtnRuleName,
  _Rule.FinSubstitutionValidationRule AS PubSecSubstnValdtnRule,
  _Rule._RuleText[Language = $session.system_language ].FinSubstnValdtnRuleDescription AS FinSubstnValdtnRuleDescription,
  _Context.FinSubstnValdtnRuleContext AS FinSubstnValdtnRuleContext,
  _Context._Text[Language = $session.system_language ].FinSubstnValdtnRuleContextDesc AS FinSubstnValdtnRuleContextDesc,
  _Rule.FinSubstnValdtnRuleStatus AS FinSubstnValdtnRuleStatus,
  _Rule.FinSubstitutionValdtnRuleType AS FinSubstitutionValdtnRuleType,
  tstmp_to_dats( _Rule.CreationDateTime , abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as CreationDate AS clientNULLasCreationDate,
  _Rule.CreatedByUser AS CreatedByUser,
  tstmp_to_dats( _Rule.LastChangeDateTime , abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as LastChangeDate AS clientNULLasLastChangeDate,
  _Rule.LastChangedByUser AS LastChangedByUser,
  _Rule._EventRule AS _EventRule
FROM I_GrantSubstitutionValidation
LEFT OUTER JOIN I_PubSecSubValBusContext AS _Context ON FinSubstitutionValidationRule = _Context.FinSubstitutionValidationRule  -- association [1..*]
LEFT OUTER JOIN I_FinSubstnValdtnRule AS _Rule ON FinSubstitutionValidationRule = _Rule.FinSubstitutionValidationRule  -- association [1..*]
;

Learn More