I_SpnsrPgmDerivationRule

DDL: I_SPNSRPGMDERIVATIONRULE SQL: ISPNSRPDERIVRUL Type: view COMPOSITE
17 Fields 1 Data Sources 2 Associations

Substitution validation Rules Spnsrpgm

I_SpnsrPgmDerivationRule is a Composite CDS View that provides data about "Substitution validation Rules Spnsrpgm" in SAP S/4HANA. It reads from 1 data source (I_SpnsrPgmSubValdtn) and exposes 17 fields with key fields SpnsrdPgmWhereUsedObjType, SponsoredProgram, FinSubstitutionValidationRule, FinSubstnValdtnRuleStatus. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SpnsrPgmSubValdtn I_SpnsrPgmSubValdtn 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 ISPNSRPDERIVRUL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Substitution validation Rules Spnsrpgm 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 SpnsrdPgmWhereUsedObjType
KEY SponsoredProgram I_SpnsrPgmSubValdtn SponsoredProgram Sponsored Program
KEY FinSubstitutionValidationRule I_SpnsrPgmSubValdtn FinSubstitutionValidationRule Rule ID
KEY FinSubstnValdtnRuleStatus _Rule FinSubstnValdtnRuleStatus Rule Status
FinSubstitutionValdtnRuleName _Rule FinSubstitutionValdtnRuleName Rule Name
PubSecSubstnValdtnRule _Rule FinSubstitutionValidationRule Rule ID
FinSubstnValdtnRuleDescription
FinSubstnValdtnRuleContext _Context FinSubstnValdtnRuleContext Context ID
FinSubstnValdtnRuleContextDesc
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_SpnsrPgmDerivationRule.
-- 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: ISPNSRPDERIVRUL

CREATE VIEW I_SpnsrPgmDerivationRule AS
SELECT
  cast ('3DRT' as psm_s4c_gm_spdpgm_wu_objtypevh ) AS SpnsrdPgmWhereUsedObjType,
  I_SpnsrPgmSubValdtn.SponsoredProgram AS SponsoredProgram,
  I_SpnsrPgmSubValdtn.FinSubstitutionValidationRule AS FinSubstitutionValidationRule,
  _Rule.FinSubstnValdtnRuleStatus AS FinSubstnValdtnRuleStatus,
  _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.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_SpnsrPgmSubValdtn
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