I_GrantorProgramEnhanced

DDL: I_GRANTORPROGRAMENHANCED Type: view_entity COMPOSITE
53 Fields 1 Data Sources

Grantor Program Enhanced

I_GrantorProgramEnhanced (Composite)

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

Grantor Program · Public Sector

I_GrantorProgramEnhanced is a Composite CDS View (Dimension) that provides data about "Grantor Program Enhanced" in SAP S/4HANA. It reads from 1 data source (I_GrantorProgram) and exposes 53 fields with key field GrantorProgram.

SAP Help Documentation

CategoryGrantor Program
Data CategoryDimension
Purpose
This CDS retrieves enhanced information about grantor programs. It adds data provided by its association targets to the data selected by its underlying basic view ( I_GrantorProgram ). Additionally, it can be used for a data extraction in full mode, for example, to a BW system. Delta extraction isn't supported. 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)

Structure
Important Fields Important fields in this view include the following: Field Name Description GrantorProgram ID of the grantor program GrantorProgramUUID UUID of the grantor program

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessPublic Sector
Application ComponentPSM-GM-GTR-GEN
CapabilitiesAssociation Target for Defining CDS Entities, Data Source for Defining CDS Entities, Analytical Dimension, Data Source in SQL Select, Data Source for Data Extraction
PackagePublic Sector for SAP S/4HANA
Description <p>This CDS retrieves enhanced information about grantor programs. It adds data provided by its association targets to the data selected by its underlying basic view (I_GrantorProgram). Additionally, it can be used for a data extraction in full mode, for example, to a BW system. Delta extraction isn't supported.</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

Data Sources (1)

SourceAliasJoin Type
I_GrantorProgram I_GrantorProgram from

Annotations (15)

NameValueLevelField
EndUserText.label Grantor Program Enhanced view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey GrantorProgram view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.sapObjectNodeType.name GrantorProgram view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY GrantorProgram GrantorProgram External Identifier of a Grantor Program
GrantorProgramUUID GrantorProgramUUID Grantor program GUID
CreatedByUser CreatedByUser Name of Person Who Created Object
CreationDate CreationDate Date When the Object Was Created
LastChangedByUser LastChangedByUser Name of Person Who Changed Object
LastChangedDate LastChangedDate Date on which object was last changed
GrantorProgramType _GrantorProgramAttributes GrantorProgramType Grantor Program Type
ContractAccountCategory _GrantorProgramAttributes ContractAccountCategory Contract Account Category
GrntoProgramAuthorizationGroup _GrantorProgramAttributes GrntoProgramAuthorizationGroup Grantor Program Authorization Group
ServiceOrganization _GrantorProgramAttributes ServiceOrganization Service Organization
SalesOrganizationOrgUnitID _GrantorProgramAttributes SalesOrganizationOrgUnitID Sales Organization ID
GrantorSalesArea _GrantorProgramAttributes GrantorSalesArea Sales Area
GrantorProgramCurrency _GrantorProgramAttributes GrantorProgramCurrency Grantor Program Currency
GrantorProgramProfile _GrantorProgramAttributes GrantorProgramProfile Grantor Program Profile ID
GrantorClearingStrategy _GrantorProgramAttributes GrantorClearingStrategy Cearing Strategy
GrntoPgmTransferIsRequired _GrantorProgramAttributes GrntoPgmTransferIsRequired Transfer to Funds Management
GrntoAvailyControlProfile _GrantorProgramAttributes GrntoAvailyControlProfile Availabilty Control Profile Name
SalesOrganization _GrantorProgramAttributes SalesOrganization Sales Organization
DistributionChannel _GrantorProgramAttributes DistributionChannel Distribution Channel
Division _GrantorProgramAttributes Division Internal Division ID
ParentGrantorProgramUUID _GrantorProgramHierarchy ParentGrantorProgramUUID Grantor program GUID
_GrantorProgramDescription _GrantorProgramDescription
_GrantorProgramAttributes _GrantorProgramAttributes
_GrantorProgramProfile _GrantorProgramAttributes _GrantorProgramProfile
_GrantorProgramType _GrantorProgramAttributes _GrantorProgramType
_GrntoPgmAuthznGroup _GrantorProgramAttributes _GrntoPgmAuthznGroup
_ContractAccountCategory _GrantorProgramAttributes _ContractAccountCategory
_ServiceOrganization _GrantorProgramAttributes _ServiceOrganization
_SalesOrganizationOrgUnit _GrantorProgramAttributes _SalesOrganizationOrgUnit
_GrantorProgramCurrency _GrantorProgramAttributes _GrantorProgramCurrency
_GrantorClearingStrategy _GrantorProgramAttributes _GrantorClearingStrategy
_GrntoPgmTransferIsRequired _GrantorProgramAttributes _GrntoPgmTransferIsRequired
_GrntoAvailyCtrlProfile _GrantorProgramAttributes _GrntoAvailyCtrlProfile
_SalesOrganization _GrantorProgramAttributes _SalesOrganization
_Division _GrantorProgramAttributes _Division
_DistributionChannel _GrantorProgramAttributes _DistributionChannel
_GrantorProgramHierarchy _GrantorProgramHierarchy
_GrantorProgramExpenseType _GrantorProgramExpenseType
_GrantorProgramPartner _GrantorProgramPartner
_GrantorProgramProcess _GrantorProgramProcess
_GrantorProgramNote _GrantorProgramNote
_GrantorProgramReleaseStatus _GrantorProgramReleaseStatus
_GrantorProgramIsReleased _GrantorProgramIsReleased
_GrantorProgramCreatedStatus _GrantorProgramCreatedStatus
_GrantorProgramIsCreated _GrantorProgramIsCreated
_GrantorProgramFinishStatus _GrantorProgramFinishStatus
_GrantorProgramIsFinished _GrantorProgramIsFinished
_GrntoProgramArchivableStatus _GrntoProgramArchivableStatus
_GrantorProgramIsArchivable _GrantorProgramIsArchivable
_GrantorProgramArchivedStatus _GrantorProgramArchivedStatus
_GrantorProgramIsArchived _GrantorProgramIsArchived
_GrantorProgramLockStatus _GrantorProgramLockStatus
_GrantorProgramIsLocked _GrantorProgramIsLocked

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_GrantorProgramEnhanced.
-- 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_GrantorProgramEnhanced AS
SELECT
  GrantorProgram,
  GrantorProgramUUID,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangedDate,
  _GrantorProgramAttributes.GrantorProgramType AS GrantorProgramType,
  _GrantorProgramAttributes.ContractAccountCategory AS ContractAccountCategory,
  _GrantorProgramAttributes.GrntoProgramAuthorizationGroup AS GrntoProgramAuthorizationGroup,
  _GrantorProgramAttributes.ServiceOrganization AS ServiceOrganization,
  _GrantorProgramAttributes.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  _GrantorProgramAttributes.GrantorSalesArea AS GrantorSalesArea,
  _GrantorProgramAttributes.GrantorProgramCurrency AS GrantorProgramCurrency,
  _GrantorProgramAttributes.GrantorProgramProfile AS GrantorProgramProfile,
  _GrantorProgramAttributes.GrantorClearingStrategy AS GrantorClearingStrategy,
  _GrantorProgramAttributes.GrntoPgmTransferIsRequired AS GrntoPgmTransferIsRequired,
  _GrantorProgramAttributes.GrntoAvailyControlProfile AS GrntoAvailyControlProfile,
  _GrantorProgramAttributes.SalesOrganization AS SalesOrganization,
  _GrantorProgramAttributes.DistributionChannel AS DistributionChannel,
  _GrantorProgramAttributes.Division AS Division,
  _GrantorProgramHierarchy.ParentGrantorProgramUUID AS ParentGrantorProgramUUID,
  _GrantorProgramAttributes._GrantorProgramProfile AS _GrantorProgramProfile,
  _GrantorProgramAttributes._GrantorProgramType AS _GrantorProgramType,
  _GrantorProgramAttributes._GrntoPgmAuthznGroup AS _GrntoPgmAuthznGroup,
  _GrantorProgramAttributes._ContractAccountCategory AS _ContractAccountCategory,
  _GrantorProgramAttributes._ServiceOrganization AS _ServiceOrganization,
  _GrantorProgramAttributes._SalesOrganizationOrgUnit AS _SalesOrganizationOrgUnit,
  _GrantorProgramAttributes._GrantorProgramCurrency AS _GrantorProgramCurrency,
  _GrantorProgramAttributes._GrantorClearingStrategy AS _GrantorClearingStrategy,
  _GrantorProgramAttributes._GrntoPgmTransferIsRequired AS _GrntoPgmTransferIsRequired,
  _GrantorProgramAttributes._GrntoAvailyCtrlProfile AS _GrntoAvailyCtrlProfile,
  _GrantorProgramAttributes._SalesOrganization AS _SalesOrganization,
  _GrantorProgramAttributes._Division AS _Division,
  _GrantorProgramAttributes._DistributionChannel AS _DistributionChannel
FROM I_GrantorProgram
;

Learn More