P_FinSubstnValdtnEventAllRule

DDL: P_FINSUBSTNVALDTNEVENTALLRULE Type: view_entity BASIC
19 Fields 3 Data Sources

P_FinSubstnValdtnEventAllRule is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (fin_re_rule, P_FinSubstnValdtnEventRule, P_FinSubstnValdtnEventStdRule) and exposes 19 fields with key fields FinSubstitutionValidationEvent, FinSubstitutionValidationRule, FinSubstitutionValidationRule.

Data Sources (3)

SourceAliasJoin Type
fin_re_rule CustRule inner
P_FinSubstnValdtnEventRule EventRule from
P_FinSubstnValdtnEventStdRule EventRule union_all

Annotations (8)

NameValueLevelField
Search.searchable true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
Metadata.ignorePropagatedAnnotations true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY FinSubstitutionValidationEvent P_FinSubstnValdtnEventStdRule FinSubstitutionValidationEvent Event ID
KEY FinSubstitutionValidationRule P_FinSubstnValdtnEventStdRule FinSubstitutionValidationRule Rule ID
FinSubstnValdtnScenario P_FinSubstnValdtnEventStdRule FinSubstnValdtnScenario Scenario ID
FinSubstnValdtnRuleIsDisabled P_FinSubstnValdtnEventStdRule FinSubstnValdtnRuleIsDisabled Rule Disabled
FinSubstnRulePriorityValue P_FinSubstnValdtnEventStdRule FinSubstnRulePriorityValue Rule Priority
CreationDateTime P_FinSubstnValdtnEventStdRule CreationDateTime Timestamp
CreatedByUser P_FinSubstnValdtnEventStdRule CreatedByUser User Name
LastChangeDateTime P_FinSubstnValdtnEventStdRule LastChangeDateTime Timestamp
LastChangedByUser P_FinSubstnValdtnEventStdRule LastChangedByUser User Name
FinSubstitutionValidationEvent Event ID
KEY FinSubstitutionValidationRule P_FinSubstnValdtnEventStdRule FinSubstitutionValidationRule Rule ID
FinSubstnValdtnScenario P_FinSubstnValdtnEventStdRule FinSubstnValdtnScenario Scenario ID
FinSubstnValdtnRuleIsDisabled Rule Disabled
FinSubstnRulePriorityValue P_FinSubstnValdtnEventStdRule FinSubstnRulePriorityValue Rule Priority
CreationDateTime Timestamp
CreatedByUser User Name
LastChangeDateTime Timestamp
LastChangedByUser User Name
_EventsOfScenario P_FinSubstnValdtnEventStdRule _EventsOfScenario

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_FinSubstnValdtnEventAllRule.
-- 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_FinSubstnValdtnEventAllRule AS
SELECT
  EventRule.FinSubstitutionValidationEvent AS FinSubstitutionValidationEvent,
  EventRule.FinSubstitutionValidationRule AS FinSubstitutionValidationRule,
  EventRule.FinSubstnValdtnScenario AS FinSubstnValdtnScenario,
  EventRule.FinSubstnValdtnRuleIsDisabled AS FinSubstnValdtnRuleIsDisabled,
  EventRule.FinSubstnRulePriorityValue AS FinSubstnRulePriorityValue,
  EventRule.CreationDateTime AS CreationDateTime,
  EventRule.CreatedByUser AS CreatedByUser,
  EventRule.LastChangeDateTime AS LastChangeDateTime,
  EventRule.LastChangedByUser AS LastChangedByUser,
  EventRule._EventsOfScenario AS _EventsOfScenario
FROM P_FinSubstnValdtnEventRule AS EventRule
INNER JOIN fin_re_rule AS CustRule ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_FinSubstnValdtnEventStdRule
;

Learn More