What is I_GrantorApplicationCube in SAP S/4HANA?

I_GrantorApplicationCube is a composite CDS view in SAP S/4HANA. Grantor Application - Cube It contains 86 fields.

Which tables does I_GrantorApplicationCube read from?

I_GrantorApplicationCube reads data from: I_GrantorApplicationEnhanced.

What VDM layer is I_GrantorApplicationCube?

I_GrantorApplicationCube is classified as a Composite view that combines data from multiple basic views.

I_GrantorApplicationCube

DDL: I_GRANTORAPPLICATIONCUBE Type: view_entity COMPOSITE

86 Fields 1 Data Sources

Grantor Application - Cube

I_GrantorApplicationCube (Composite)

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

Public Sector

I_GrantorApplicationCube is a Composite CDS View (Cube) that provides data about "Grantor Application - Cube" in SAP S/4HANA. It reads from 1 data source (I_GrantorApplicationEnhanced) and exposes 86 fields with key fields BusinessObjectType, GrantorApplication.

SAP Help Documentation

Category	Grantor Management
Data Category	Cube

Purpose
This CDS view retrieves grantor application data. It also retrieves the total of all its item amounts for requested, eligible, and authorized. Depending on the clearing strategy of the related grantor program, the requested amount, eligible amount, as well as the authorized amount observe clearings between advance payment items and related payment items. 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_GAP (Authorization Object CRM Order - Bus. Obj: Grantor application) CRM_ORD_OE (Authorization Object CRM Order - Allowed Organ. Units) CRM_ORD_PR (Authorization Object CRM Order - Business Transaction Type) Alternatively, users who want to use this CDS view must have the authorization object CRM_ORD_OP (Authorization Object CRM Order - Own Documents) assigned to them, must have the authorization for partner function category 0008 ( Person Responsible ) and partner function 00000014 ( Employee Responsible ) assigned, and must be the Employee Responsible of the grantor application.

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute GrantorApplication ID of the grantor application Attribute GrantorApplicationType Transaction type for the grantor application Attribute GrantorRequestedAmount Requested amount Measure GrantorEligibleAmount Eligible amount Measure GrantorAuthorizedAmount Authorized amount Measure

Constraints
If your system already contains data created on release S/4HANA 2023 FPS01 or an earlier release, this CDS view doesn't display accurate data until you've run the silent data migration classes cl_sdm_grm_application , cl_sdm_grm_agreement , and cl_sdm_grm_claim . Therefore, if you're upgrading from a release older than S/4HANA 2023 FPS02 and have already created data in an older release of the system, you have to run these three silent data migration classes to ensure that you can start using this CDS view and its corresponding Fiori apps with accurate data.

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Public Sector
Application Component	PSM-GM-GTR-GEN
Capabilities	Data Source in SQL Select, Data Provider for Analytical Queries, Data Source for Defining CDS Entities
Package	Public Sector for SAP S/4HANA
Description	<p>This CDS view retrieves grantor application data. It also retrieves the total of all its item amounts for requested, eligible, and authorized.</p> <p>Depending on the clearing strategy of the related grantor program, the requested amount, eligible amount, as well as the authorized amount observe clearings between advance payment items and related payment items.</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
I_GrantorApplicationEnhanced	I_GrantorApplicationEnhanced	from

Annotations (12)

Name	Value	Level
EndUserText.label	Grantor Application - Cube	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
Analytics.dataCategory	#CUBE	view
Analytics.internalName	#LOCAL	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (86)

Key	Field	Source Table	Source Field	Description
KEY	BusinessObjectType		BusinessObjectType	Business Trans. Cat.
KEY	GrantorApplication		GrantorApplication	Grantor Application
	GrantorApplicationUUID		GrantorApplicationUUID	GUID of a CRM Order Object
	GrantorApplicationCharUUID		GrantorApplicationCharUUID	32 Character CRM Object GUID
	GrantorApplicationType		GrantorApplicationType	Business Transaction Type
	DocumentDescription		DocumentDescription	Transaction Description
	Language		Language	Language Key of Description
	PostingDate		PostingDate	Posting Date for a Business Transaction
	CreationDateTime		CreationDateTime	Created At
	CreatedByUser		CreatedByUser	User that Created the Transaction
	LastChangeDateTime		LastChangeDateTime	Changed At
	LastChangedByUser		LastChangedByUser	Transaction Last Changed By
	PricingDocument		PricingDocument	Number of the Document Condition
	PricingProcedure		PricingProcedure	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
	GrantorDocumentGrantee		GrantorDocumentGrantee	Grantee
	GrntoDocGranteeAddressNumber		GrntoDocGranteeAddressNumber	Address Number
	GranteeCountry	_GranteeAddress	Country	Country/Region Key
	GrntoDocResponsibleEmployee		GrntoDocResponsibleEmployee	Employee Responsible
	GrantorDocumentContactPerson		GrantorDocumentContactPerson	Customer Contact Person
	GrantorDocumentBillToParty		GrantorDocumentBillToParty	Bill-To Party
	GrantorDocumentPayer		GrantorDocumentPayer	Payer
	GrntoDocumentPaymentRecipient		GrntoDocumentPaymentRecipient	Payment Recipient
	DocumentStartDateTime		DocumentStartDateTime	Time Dependency: Validity Start Date
	DocumentStartDate		DocumentStartDate	Grantor Valid From Date
	DocumentEndDateTime		DocumentEndDateTime	Time Dependency: Validity End Date
	DocumentEndDate		DocumentEndDate	Grantor Valid To Date
	GrantorApplicationStatus		GrantorApplicationStatus	Life Cycle Status
	IsReleased		IsReleased	Release Status
	IsOpen		IsOpen	Status "Open"
	HasError		HasError	Error Status
	IsRejected		IsRejected	Indicator for document is rejected
	GrantorDocIsSuccessfullyTrnsfd		GrantorDocIsSuccessfullyTrnsfd	Grantor Management: Status Transferred
	GrantorDocHasTransferError		GrantorDocHasTransferError	Grantor Management: Status Transfer failed
	GrantorDocumentIsCancelled		GrantorDocumentIsCancelled	Grantor Management: Status Cancelled
	SalesOrganizationOrgUnitID		SalesOrganizationOrgUnitID	Sales Organization ID
	SalesOfficeOrgUnitID		SalesOfficeOrgUnitID	Sales Office
	SalesGroupOrgUnitID		SalesGroupOrgUnitID	Sales Group
	DistributionChannel		DistributionChannel	Distribution Channel
	Division		Division	Internal Division ID
	ServiceOrganization		ServiceOrganization	Service Organization
	ResponsibleServiceOrganization		ResponsibleServiceOrganization	Organizational Unit (Service)
	ResponsibleSalesOrganization		ResponsibleSalesOrganization	Organizational Unit (Sales)
	SalesOrganization		SalesOrganization	Sales Organization
	SalesOffice		SalesOffice	Sales Office
	SalesGroup		SalesGroup	Sales Group
	GrantorProgram		GrantorProgram	External Identifier of a Grantor Program
	GrantorProgramType	_GrantorProgram	GrantorProgramType	Grantor Program Type
	GrantorAgreement		GrantorAgreement	Grantor Agreement
	TransactionCurrency		TransactionCurrency	Transaction Currency
	ContractAccount		ContractAccount	Contract Account Number
	GrantorRequestedAmount	_GrantorApplicationAmounts	GrantorRequestedAmount	Grantor Requested Amount
	GrantorEligibleAmount	_GrantorApplicationAmounts	GrantorEligibleAmount	Grantor Eligible Amount
	GrantorAuthorizedAmount	_GrantorApplicationAmounts	GrantorAuthorizedAmount	Grantor Authorized Amount
	_BusinessObjectType		_BusinessObjectType
	_GrantorProgram		_GrantorProgram
	_GrantorProgramType	_GrantorProgram	_GrantorProgramType
	_GrantorApplicationItem		_GrantorApplicationItem
	_ContractAccount		_ContractAccount
	_GrantorApplicationType		_GrantorApplicationType
	_TransactionCurrency		_TransactionCurrency
	_GrantorApplLifecycleStatus		_GrantorApplLifecycleStatus
	_GrantorApplicationHasError		_GrantorApplicationHasError
	_GrantorApplicationIsOpen		_GrantorApplicationIsOpen
	_GrantorApplicationIsReleased		_GrantorApplicationIsReleased
	_GrantorApplicationIsRejected		_GrantorApplicationIsRejected
	_GrantorDocumentIsCancelled		_GrantorDocumentIsCancelled
	_GrantorDocHasTransferError		_GrantorDocHasTransferError
	_GrntoDocIsSuccessfullyTrnsfd		_GrntoDocIsSuccessfullyTrnsfd
	_GrantorDocumentBillToParty		_GrantorDocumentBillToParty
	_GrantorDocumentContactPerson		_GrantorDocumentContactPerson
	_GrantorDocumentGrantee		_GrantorDocumentGrantee
	_GranteeAddress		_GranteeAddress
	_GranteeCountry		_GranteeCountry
	_GrantorDocumentPayer		_GrantorDocumentPayer
	_GrntoDocResponsibleEmployee		_GrntoDocResponsibleEmployee
	_GrntoDocumentPaymentRecipient		_GrntoDocumentPaymentRecipient
	_RespSrvcOrganizationOrgUnit		_RespSrvcOrganizationOrgUnit
	_SalesGroup		_SalesGroup
	_SalesGroupOrgUnit		_SalesGroupOrgUnit
	_SalesOffice		_SalesOffice
	_SalesOfficeOrgUnit		_SalesOfficeOrgUnit
	_SalesOrganization		_SalesOrganization
	_SalesOrganizationOrgUnit		_SalesOrganizationOrgUnit
	_ServiceOrganizationOrgUnit		_ServiceOrganizationOrgUnit
	_DistributionChannel		_DistributionChannel
	_Division		_Division

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_GrantorApplicationCube.
-- 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_GrantorApplicationCube AS
SELECT
  BusinessObjectType,
  GrantorApplication,
  GrantorApplicationUUID,
  GrantorApplicationCharUUID,
  GrantorApplicationType,
  DocumentDescription,
  Language,
  PostingDate,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  PricingDocument,
  PricingProcedure,
  GrantorDocumentGrantee,
  GrntoDocGranteeAddressNumber,
  _GranteeAddress.Country AS GranteeCountry,
  GrntoDocResponsibleEmployee,
  GrantorDocumentContactPerson,
  GrantorDocumentBillToParty,
  GrantorDocumentPayer,
  GrntoDocumentPaymentRecipient,
  DocumentStartDateTime,
  DocumentStartDate,
  DocumentEndDateTime,
  DocumentEndDate,
  GrantorApplicationStatus,
  IsReleased,
  IsOpen,
  HasError,
  IsRejected,
  GrantorDocIsSuccessfullyTrnsfd,
  GrantorDocHasTransferError,
  GrantorDocumentIsCancelled,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  DistributionChannel,
  Division,
  ServiceOrganization,
  ResponsibleServiceOrganization,
  ResponsibleSalesOrganization,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  GrantorProgram,
  _GrantorProgram.GrantorProgramType AS GrantorProgramType,
  GrantorAgreement,
  TransactionCurrency,
  ContractAccount,
  _GrantorApplicationAmounts.GrantorRequestedAmount AS GrantorRequestedAmount,
  _GrantorApplicationAmounts.GrantorEligibleAmount AS GrantorEligibleAmount,
  _GrantorApplicationAmounts.GrantorAuthorizedAmount AS GrantorAuthorizedAmount,
  _GrantorProgram._GrantorProgramType AS _GrantorProgramType
FROM I_GrantorApplicationEnhanced
;

Depth:

I_GrantorApplicationCube view_entity

I_GrantorApplicationEnhanced view_entity