P_GrantDrvtnRule

DDL: P_GRANTDRVTNRULE Type: view COMPOSITE
19 Fields 1 Data Sources

WUGRANT Derivation Rule

P_GrantDrvtnRule is a Composite CDS View that provides data about "WUGRANT Derivation Rule" in SAP S/4HANA. It reads from 1 data source (I_GrantDrvtnRule) and exposes 19 fields with key fields GrantWhereUsedObjType, GrantID, FinSubstitutionValidationRule.

Data Sources (1)

SourceAliasJoin Type
I_GrantDrvtnRule I_GrantDrvtnRule from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWUGRANTDRVNRL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label WUGRANT Derivation Rule view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY GrantWhereUsedObjType GrantWhereUsedObjType
KEY GrantID GrantID Sender Grant
KEY FinSubstitutionValidationRule FinSubstitutionValidationRule Rule ID
FinSubstitutionValdtnRuleName FinSubstitutionValdtnRuleName Rule Name
PubSecSubstnValdtnRule PubSecSubstnValdtnRule Rule ID
FinSubstnValdtnRuleDescription FinSubstnValdtnRuleDescription Rule Description
FinSubstnValdtnRuleContext FinSubstnValdtnRuleContext Context ID
FinSubstnValdtnRuleContextDesc FinSubstnValdtnRuleContextDesc Context Description
FinSubstnValdtnRuleStatus FinSubstnValdtnRuleStatus Rule Status
FinSubstitutionValdtnRuleType FinSubstitutionValdtnRuleType Rule Type
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
FinSubstnValdtnRuleTypeName
FinSubstnValdtnRuleStatusName
_EventRule _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 P_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.

CREATE VIEW P_GrantDrvtnRule AS
SELECT
  GrantWhereUsedObjType,
  GrantID,
  FinSubstitutionValidationRule,
  FinSubstitutionValdtnRuleName,
  PubSecSubstnValdtnRule,
  FinSubstnValdtnRuleDescription,
  FinSubstnValdtnRuleContext,
  FinSubstnValdtnRuleContextDesc,
  FinSubstnValdtnRuleStatus,
  FinSubstitutionValdtnRuleType,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  _RuleTypeText[ Language = $session.system_language ].FinSubstnValdtnRuleTypeName AS FinSubstnValdtnRuleTypeName,
  _RuleStatusText[ Language = $session.system_language ].FinSubstnValdtnRuleStatusName AS FinSubstnValdtnRuleStatusName
FROM I_GrantDrvtnRule
;

Learn More