What is I_SponsoredProgramCore in SAP S/4HANA?

I_SponsoredProgramCore is a basic CDS view in SAP S/4HANA. Sponsored Program It contains 10 fields.

Which tables does I_SponsoredProgramCore read from?

I_SponsoredProgramCore reads data from: gmspprogram.

What VDM layer is I_SponsoredProgramCore?

I_SponsoredProgramCore is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_SponsoredProgramCore

DDL: I_SPONSOREDPROGRAMCORE SQL: IGMSPPROGCL Type: view BASIC

10 Fields 1 Data Sources 5 Associations

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	PSM-GM-GTE-MD
Capabilities	Analytical Dimension, Data Source for Data Extraction, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
Package	Cross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
gmspprogram	gmspprogram	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..*]	I_SponsoredProgHierarchyNode	_SponsoredProgHierarchyNode	`$projection.SponsoredProgram = _SponsoredProgHierarchyNode.SponsoredProgram`
[0..*]	I_SponsoredProgramTextCore	_Text	`$projection.SponsoredProgram = _Text.SponsoredProgram`
[0..1]	I_User	_CreatedByUser	`$projection.CreatedByUser = _CreatedByUser.UserID`
[0..1]	I_User	_LastChangedByUser	`$projection.LastChangedByUser = _LastChangedByUser.UserID`
[1..1]	E_SponsoredProgramCore	_Extension	`$projection.SponsoredProgram = _Extension.SponsoredProgram`

Annotations (19)

Name	Value	Level
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.representativeKey	SponsoredProgram	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
Metadata.allowExtensions	true	view
Search.searchable	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
AbapCatalog.compiler.compareFilter	true	view
Analytics.internalName	#LOCAL	view
AbapCatalog.sqlViewName	IGMSPPROGCL	view
EndUserText.label	Sponsored Program	view
ObjectModel.sapObjectNodeType.name	SponsoredProgram	view

Fields (10)

Key	Field	Source Field	Description
KEY	SponsoredProgram	sponsored_prog	Sponsored Program
	CreatedByUser	created_by	Version Created By
	CreationDate	created_on	Variant created on
	LastChangedByUser	modified_by	Last Modified by
	LastChangeDate	modified_on	Date last modified
	SponsoredProgramAuthznGrp	auth_group	Grants Management: Authorization Groups
	_Text	_Text
	_SponsoredProgHierarchyNode	_SponsoredProgHierarchyNode
	_CreatedByUser	_CreatedByUser
	_LastChangedByUser	_LastChangedByUser

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_SponsoredProgramCore.
-- 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: IGMSPPROGCL

CREATE VIEW I_SponsoredProgramCore AS
SELECT
  sponsored_prog AS SponsoredProgram,
  created_by AS CreatedByUser,
  created_on AS CreationDate,
  modified_by AS LastChangedByUser,
  modified_on AS LastChangeDate,
  auth_group AS SponsoredProgramAuthznGrp
FROM gmspprogram
LEFT OUTER JOIN I_SponsoredProgHierarchyNode AS _SponsoredProgHierarchyNode ON SponsoredProgram = _SponsoredProgHierarchyNode.SponsoredProgram  -- association [0..*]
LEFT OUTER JOIN I_SponsoredProgramTextCore AS _Text ON SponsoredProgram = _Text.SponsoredProgram  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN E_SponsoredProgramCore AS _Extension ON SponsoredProgram = _Extension.SponsoredProgram  -- association [1..1]
;

Depth:

I_SponsoredProgramCore view

gmspprogram