I_SpnsrdClDerivationRule

DDL: I_SPNSRDCLDERIVATIONRULE SQL: IWUSPNSRCDRVNRL Type: view COMPOSITE Package: ODATA_PSM_S4C_GM_WHRUSED_SPOBJ
19 Fields 1 Data Sources 4 Associations

Substitution Validation Rules Spnsrcls

I_SpnsrdClDerivationRule is a Composite CDS View that provides data about "Substitution Validation Rules Spnsrcls" in SAP S/4HANA. It reads from 1 data source (I_SpnsrdClSubstnValdtn) and exposes 19 fields with key fields SpnsrdClsWhereUsedObjType, SponsoredClass, FinSubstitutionValidationRule. It has 4 associations to related views. Part of development package ODATA_PSM_S4C_GM_WHRUSED_SPOBJ.

Data Sources (1)

SourceAliasJoin Type
I_SpnsrdClSubstnValdtn I_SpnsrdClSubstnValdtn from

Associations (4)

CardinalityTargetAliasCondition
[1..*] I_PubSecSubValBusContext _Context $projection.FinSubstitutionValidationRule = _Context.FinSubstitutionValidationRule
[1..*] I_FinSubstnValdtnRule _Rule $projection.FinSubstitutionValidationRule = _Rule.FinSubstitutionValidationRule
[0..*] I_FinSubstnRuleTypeText _RuleTypeText $projection.finsubstitutionvaldtnruletype = _RuleTypeText.FinSubstitutionValdtnRuleType
[0..*] I_FinSubstnRuleStatusText _RuleStatusText $projection.finsubstnvaldtnrulestatus = _RuleStatusText.FinSubstnValdtnRuleStatus

Annotations (10)

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

KeyFieldSource TableSource FieldDescription
KEY SpnsrdClsWhereUsedObjType
KEY SponsoredClass I_SpnsrdClSubstnValdtn SponsoredClass Sponsored Class
KEY FinSubstitutionValidationRule I_SpnsrdClSubstnValdtn 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
_RuleTypeText _RuleTypeText
_RuleStatusText _RuleStatusText
_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_SpnsrdClDerivationRule.
-- 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: IWUSPNSRCDRVNRL

CREATE VIEW I_SpnsrdClDerivationRule AS
SELECT
  cast ('3DRT' as psm_s4c_gm_spdcls_wu_objtypevh ) AS SpnsrdClsWhereUsedObjType,
  I_SpnsrdClSubstnValdtn.SponsoredClass AS SponsoredClass,
  I_SpnsrdClSubstnValdtn.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_SpnsrdClSubstnValdtn
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..*]
LEFT OUTER JOIN I_FinSubstnRuleTypeText AS _RuleTypeText ON finsubstitutionvaldtnruletype = _RuleTypeText.FinSubstitutionValdtnRuleType  -- association [0..*]
LEFT OUTER JOIN I_FinSubstnRuleStatusText AS _RuleStatusText ON finsubstnvaldtnrulestatus = _RuleStatusText.FinSubstnValdtnRuleStatus  -- association [0..*]
;

Learn More