P_SpnsrPgmDerivationRule

DDL: P_SPNSRPGMDERIVATIONRULE SQL: PSPNSRPDERIVRUL Type: view COMPOSITE
19 Fields 1 Data Sources

Derivation Rule for Sponsor Program

P_SpnsrPgmDerivationRule is a Composite CDS View that provides data about "Derivation Rule for Sponsor Program" in SAP S/4HANA. It reads from 1 data source (I_SpnsrPgmDerivationRule) and exposes 19 fields with key fields SpnsrdPgmWhereUsedObjType, SponsoredProgram, FinSubstitutionValidationRule, FinSubstnValdtnRuleStatus.

Data Sources (1)

SourceAliasJoin Type
I_SpnsrPgmDerivationRule I_SpnsrPgmDerivationRule from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSPNSRPDERIVRUL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Derivation Rule for Sponsor Program view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SpnsrdPgmWhereUsedObjType SpnsrdPgmWhereUsedObjType
KEY SponsoredProgram SponsoredProgram Sponsored Program
KEY FinSubstitutionValidationRule FinSubstitutionValidationRule Rule ID
KEY FinSubstnValdtnRuleStatus FinSubstnValdtnRuleStatus Rule Status
FinSubstitutionValdtnRuleName FinSubstitutionValdtnRuleName Rule Name
PubSecSubstnValdtnRule PubSecSubstnValdtnRule Rule ID
FinSubstnValdtnRuleDescription FinSubstnValdtnRuleDescription Rule Description
FinSubstnValdtnRuleContext FinSubstnValdtnRuleContext Context ID
FinSubstnValdtnRuleContextDesc FinSubstnValdtnRuleContextDesc Context Description
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_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: PSPNSRPDERIVRUL

CREATE VIEW P_SpnsrPgmDerivationRule AS
SELECT
  SpnsrdPgmWhereUsedObjType,
  SponsoredProgram,
  FinSubstitutionValidationRule,
  FinSubstnValdtnRuleStatus,
  FinSubstitutionValdtnRuleName,
  PubSecSubstnValdtnRule,
  FinSubstnValdtnRuleDescription,
  FinSubstnValdtnRuleContext,
  FinSubstnValdtnRuleContextDesc,
  FinSubstitutionValdtnRuleType,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  _RuleTypeText[ Language = $session.system_language ].FinSubstnValdtnRuleTypeName AS FinSubstnValdtnRuleTypeName,
  _RuleStatusText[ Language = $session.system_language ].FinSubstnValdtnRuleStatusName AS FinSubstnValdtnRuleStatusName
FROM I_SpnsrPgmDerivationRule
;

Learn More