What is I_GrantorProgramNote in SAP S/4HANA?

I_GrantorProgramNote is a basic CDS view in SAP S/4HANA. Grantor Program Note It contains 13 fields.

Which tables does I_GrantorProgramNote read from?

I_GrantorProgramNote reads data from: crms4d_gpm_note.

What VDM layer is I_GrantorProgramNote?

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

I_GrantorProgramNote

DDL: I_GRANTORPROGRAMNOTE Type: view_entity BASIC

13 Fields 1 Data Sources

Grantor Program Note

I_GrantorProgramNote (Basic)

Package: Explore, extend and adapt the SAP S/4HANA with built-in and side-by-side extension capabilities.

Public Sector

I_GrantorProgramNote is a Basic CDS View that provides data about "Grantor Program Note" in SAP S/4HANA. It reads from 1 data source (crms4d_gpm_note) and exposes 13 fields with key fields TextObjectKey, TextObjectType, Language.

SAP Help Documentation

Category	Grantor Program

Purpose
This CDS view serves as a basic view for grantor program notes and only retrieves data from the associated database table. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: CRM_GMP (Authorization Object CRM Grantor Program object) CRM_TXT_ID (CRM: Text ID)

Structure
Important Fields Important fields in this view include the following: Field Name Description TextObjectKey Text name TextObjectType ID of the text Language Language GrantorProgramUUID UUID of the grantor program GrantorProgramNoteText Text of note

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Public Sector
Application Component	PSM-GM-GTR-GEN
Capabilities	Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source in SQL Select
Package	Public Sector for SAP S/4HANA
Description	<p>This CDS view serves as a basic view for grantor program notes and only retrieves data from the associated database table.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA 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 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
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
crms4d_gpm_note	crms4d_gpm_note	from

Annotations (9)

Name	Value	Level
EndUserText.label	Grantor Program Note	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.modelingPattern	#NONE	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#M	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (13)

Key	Field	Source Field	Description
KEY	TextObjectKey	tdname	Text Name
KEY	TextObjectType	text_id	Text Identification
KEY	Language	language	Report Text Language
	GrantorProgramUUID	program_guid	Grantor program GUID
	GrntoProgramLogTextIdentifier	log_timestamp	Identifier (truncated timestamp) of a log text
	GrantorProgramNoteText	text	User Group
	GrantorProgramNoteMimeType	mime_type	MIME type
	CreationDateTime	created_at	Creation timestamp of a text
	CreatedByUser	created_by	User who created a text
	LastChangeDateTime	changed_at	Last change timestamp of a text
	LastChangedByUser	changed_by	User who last changed a text
	_Language	_Language
	_GrantorProgramAttributes	_GrantorProgramAttributes

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_GrantorProgramNote.
-- 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.

CREATE VIEW I_GrantorProgramNote AS
SELECT
  tdname AS TextObjectKey,
  text_id AS TextObjectType,
  Language,
  program_guid AS GrantorProgramUUID,
  log_timestamp AS GrntoProgramLogTextIdentifier,
  text AS GrantorProgramNoteText,
  mime_type AS GrantorProgramNoteMimeType,
  created_at AS CreationDateTime,
  created_by AS CreatedByUser,
  changed_at AS LastChangeDateTime,
  changed_by AS LastChangedByUser
FROM crms4d_gpm_note
;

Depth:

I_GrantorProgramNote view_entity

crms4d_gpm_note