R_SponsoredProgramTP

DDL: R_SPONSOREDPROGRAMTP SQL: RGMSPPROGTP Type: view_entity TRANSACTIONAL
8 Fields 1 Data Sources 1 Associations

Sponsored Program

R_SponsoredProgramTP is a Transactional CDS View that provides data about "Sponsored Program" in SAP S/4HANA. It reads from 1 data source (I_SponsoredProgramCore) and exposes 8 fields with key field SponsoredProgram. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SponsoredProgramCore SProg from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_SponsoredProgramCore _Extension $projection.SponsoredProgram = _Extension.SponsoredProgram

Annotations (10)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.representativeKey SponsoredProgram view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Sponsored Program view
ObjectModel.sapObjectNodeType.name SponsoredProgram view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SponsoredProgram SponsoredProgram Sponsored Program
SponsoredProgramForEdit SponsoredProgram Sponsored Program
SponsoredProgramName
SponsoredProgramDescription
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp

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 R_SponsoredProgramTP.
-- 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: RGMSPPROGTP

CREATE VIEW R_SponsoredProgramTP AS
SELECT
  SponsoredProgram,
  SponsoredProgram AS SponsoredProgramForEdit,
  _Text[1:Language = $session.system_language].SponsoredProgramName AS SponsoredProgramName,
  _Text[1:Language = $session.system_language].SponsoredProgramDescription AS SponsoredProgramDescription,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate
FROM I_SponsoredProgramCore AS SProg
LEFT OUTER JOIN E_SponsoredProgramCore AS _Extension ON SponsoredProgram = _Extension.SponsoredProgram  -- association [1..1]
;

Learn More