What is I_GrantorApplicationItemCube in SAP S/4HANA?

I_GrantorApplicationItemCube is a composite CDS view in SAP S/4HANA. Grantor Application Item - Cube It contains 146 fields.

Which tables does I_GrantorApplicationItemCube read from?

I_GrantorApplicationItemCube reads data from: I_GrantorApplicationItmEnhcd.

What VDM layer is I_GrantorApplicationItemCube?

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

I_GrantorApplicationItemCube

DDL: I_GRANTORAPPLICATIONITEMCUBE Type: view_entity COMPOSITE

146 Fields 1 Data Sources

Grantor Application Item - Cube

I_GrantorApplicationItemCube (Composite)

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

Public Sector

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

SAP Help Documentation

Category	Grantor Management
Data Category	Cube

Purpose
This CDS view retrieves grantor application item data. It contains all possible amount fields that are filled depending on the payment type of the item. 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 GrantorApplicationItem Number of the grantor application item Attribute GrantorPaymentType Payment type of the item 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 item data. It contains all possible amount fields that are filled depending on the payment type of the item.</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_GrantorApplicationItmEnhcd	I_GrantorApplicationItmEnhcd	from

Annotations (12)

Name	Value	Level
EndUserText.label	Grantor Application Item - 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 (146)

Key	Field	Source Table	Source Field	Description
KEY	BusinessObjectType		BusinessObjectType	Business Trans. Cat.
KEY	GrantorApplication		GrantorApplication	Grantor Application
KEY	GrantorApplicationItem		GrantorApplicationItem	Grantor Application Item
	GrantorApplicationType		GrantorApplicationType	Business Transaction Type
	DocumentDescription		DocumentDescription	Transaction Description
	DocumentPostingDate		DocumentPostingDate	Posting Date for a Business Transaction
	DocumentCreationDateTime	_GrantorApplication	CreationDateTime	Created At
	GrantorApplicationItemUUID		GrantorApplicationItemUUID	GUID of a CRM Order Object
	GrantorApplicationItemCharUUID		GrantorApplicationItemCharUUID	32 Character CRM Object GUID
	DocumentItemDescription		DocumentItemDescription	Grantor Item Description
	Language		Language	Short Text Language for an Item
	PostingDateTime		PostingDateTime	Posting Date
	CreationDateTime		CreationDateTime	Created At
	GrantorApplicationItemCategory		GrantorApplicationItemCategory	Item Category
	GrantorPaymentType		GrantorPaymentType	Grantor Payment Type
	GrantorFinancialExecutionType		GrantorFinancialExecutionType	Financial Execution Type for Grants Management for Grantor
	GrantorDocumentItemGrantee		GrantorDocumentItemGrantee	Grantee
	GrntoDocItemGranteeAddressNmbr		GrntoDocItemGranteeAddressNmbr	Address Number
	GrntoDocItmResponsibleEmployee		GrntoDocItmResponsibleEmployee	Employee Responsible
	GrntoDocumentItemContactPerson		GrntoDocumentItemContactPerson	Customer Contact Person
	GrantorDocumentItemBillToParty		GrantorDocumentItemBillToParty	Bill-To Party
	GrantorDocumentItemPayer		GrantorDocumentItemPayer	Payer
	GrntoDocItemPaymentRecipient		GrntoDocItemPaymentRecipient	Payment Recipient
	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
	DocumentItemStartDateTime		DocumentItemStartDateTime	Time Dependency: Validity Start Date
	DocumentItemStartDate		DocumentItemStartDate	Grantor Valid From Date
	DocumentItemEndDateTime		DocumentItemEndDateTime	Time Dependency: Validity End Date
	DocumentItemEndDate		DocumentItemEndDate	Grantor Valid To Date
	DocumentItemDueDateTime		DocumentItemDueDateTime	Due Date
	DocumentItemDueDate		DocumentItemDueDate	Grantor Management Item Due Date
	DocumentStartDateTime	_GrantorApplication	DocumentStartDateTime	Time Dependency: Validity Start Date
	DocumentStartDate	_GrantorApplication	DocumentStartDate	Grantor Valid From Date
	DocumentEndDateTime	_GrantorApplication	DocumentEndDateTime	Time Dependency: Validity End Date
	DocumentEndDate	_GrantorApplication	DocumentEndDate	Grantor Valid To Date
	GrantorApplicationItemStatus		GrantorApplicationItemStatus	Life Cycle Status
	IsReleased		IsReleased	Release Status
	IsOpen		IsOpen	Status "Open"
	HasError		HasError	Error Status
	IsRejected		IsRejected	Indicator for document is rejected
	GrantorDocumentItemIsCancelled		GrantorDocumentItemIsCancelled	Grantor Management: Status Cancelled
	GrantorAgreementItemIsCreated		GrantorAgreementItemIsCreated	Status "Agreement Created"
	GrantorApplicationStatus	_GrantorApplication	GrantorApplicationStatus	Life Cycle Status
	DocumentIsReleased	_GrantorApplication	IsReleased	Release Status
	DocumentIsOpen	_GrantorApplication	IsOpen	Status "Open"
	DocumentIsRejected	_GrantorApplication	IsRejected	Indicator for document is rejected
	DocumentHasError	_GrantorApplication	HasError	Error Status
	GrantorDocumentIsCancelled	_GrantorApplication	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
	GrantorProgramUUID	_GrantorProgram	GrantorProgramUUID	Grantor program GUID
	GrantorProgramType	_GrantorProgram	GrantorProgramType	Grantor Program Type
	GrantorAgreementItem		GrantorAgreementItem	Grantor Agreement Item Number
	GrantorAdvanceReferenceItem		GrantorAdvanceReferenceItem	Grantor Advance Reference Item
	TransactionCurrency		TransactionCurrency	Transaction Currency
	GrantorDocumentItemIsCredit		GrantorDocumentItemIsCredit	Credit Debit Indicator
	GrantorRequestedAmount		GrantorRequestedAmount	Grantor Requested Amount
	GrantorEligibleAmount		GrantorEligibleAmount	Grantor Eligible Amount
	GrantorAuthorizedAmount		GrantorAuthorizedAmount	Grantor Authorized Amount
	NetAmount		NetAmount	Stated Amount
	GrantorDocItemGranteeExtRef		GrantorDocItemGranteeExtRef	Sold-To Party's External Reference Number
	GrantorDocItemRejectionReason		GrantorDocItemRejectionReason	Rejection Reason
	BillingPlanType		BillingPlanType	Billing Plan Type
	BillingPlanIsFinalized		BillingPlanIsFinalized	Billing Plan Is Finalized
	BillingPlanStartDateTime		BillingPlanStartDateTime	Billing Plan Start Date and Time
	BillingPlanEndDateTime		BillingPlanEndDateTime	Billing Plan End Date and Time
	BillingPlanTimeZone		BillingPlanTimeZone	Time Zone of Billing Plan Set
	ContractAccount		ContractAccount	Contract Account Number
	BillingDateTime		BillingDateTime	Billing Date for Billing Index and Printout
	BillingTimeZone		BillingTimeZone	Time Zone of Billing Plan Set
	BillingBlockReason		BillingBlockReason	Business Partner: Billing Block Reason
	GrantorExpenseCatalog		GrantorExpenseCatalog	Grantor Expense Catalog
	GrantorExpenseGroup		GrantorExpenseGroup	Grantor Expense Group
	GrantorExpenseType		GrantorExpenseType	Grantor Expense Type
	_GrantorProgram		_GrantorProgram
	_GrantorProgramAttributes	_GrantorProgram	_GrantorProgramAttributes
	_GrantorProgramType	_GrantorProgram	_GrantorProgramType
	_GrantorApplication		_GrantorApplication
	_GrantorApplicationType		_GrantorApplicationType
	_GrantorApplItemCategory		_GrantorApplItemCategory
	_GrantorPaymentType		_GrantorPaymentType
	_GrantorAdvanceReferenceItem		_GrantorAdvanceReferenceItem
	_BusinessObjectType		_BusinessObjectType
	_GrntoApplItemLifecycleStatus		_GrntoApplItemLifecycleStatus
	_GrantorApplicationItemIsOpen		_GrantorApplicationItemIsOpen
	_GrantorApplItmIsReleased		_GrantorApplItmIsReleased
	_GrantorApplItemHasError		_GrantorApplItemHasError
	_GrantorApplItemIsRejected		_GrantorApplItemIsRejected
	_GrantorAgreementItemIsCreated		_GrantorAgreementItemIsCreated
	_GrntoDocumentItemIsCancelled		_GrntoDocumentItemIsCancelled
	_GrantorApplLifecycleStatus	_GrantorApplication	_GrantorApplLifecycleStatus
	_GrantorApplicationIsReleased	_GrantorApplication	_GrantorApplicationIsReleased
	_GrantorApplicationIsOpen	_GrantorApplication	_GrantorApplicationIsOpen
	_GrantorApplicationIsRejected	_GrantorApplication	_GrantorApplicationIsRejected
	_GrantorApplicationHasError	_GrantorApplication	_GrantorApplicationHasError
	_GrantorDocumentIsCancelled	_GrantorApplication	_GrantorDocumentIsCancelled
	_GrantorDocumentItemGrantee		_GrantorDocumentItemGrantee
	_GrntoDocumentItmContactPerson		_GrntoDocumentItmContactPerson
	_GrntoDocItmRespEmployee		_GrntoDocItmRespEmployee
	_GrntoDocumentItemBillToParty		_GrntoDocumentItemBillToParty
	_GrantorDocumentItemPayer		_GrantorDocumentItemPayer
	_GrntoDocItemPaymentRecipient		_GrntoDocItemPaymentRecipient
	_GrantorDocumentGrantee		_GrantorDocumentGrantee
	_GranteeAddress		_GranteeAddress
	_GranteeCountry		_GranteeCountry
	_GrntoDocResponsibleEmployee		_GrntoDocResponsibleEmployee
	_GrantorDocumentBillToParty		_GrantorDocumentBillToParty
	_GrantorDocumentContactPerson		_GrantorDocumentContactPerson
	_GrantorDocumentPayer		_GrantorDocumentPayer
	_GrntoDocumentPaymentRecipient		_GrntoDocumentPaymentRecipient
	_TransactionCurrency		_TransactionCurrency
	_GrantorDocumentItemIsCredit		_GrantorDocumentItemIsCredit
	_ContractAccount		_ContractAccount
	_ContractAccountPartner		_ContractAccountPartner
	_BillingBlockReason		_BillingBlockReason
	_SalesOrganization		_SalesOrganization
	_SalesOrganizationOrgUnit		_SalesOrganizationOrgUnit
	_ServiceOrganizationOrgUnit		_ServiceOrganizationOrgUnit
	_SalesGroup		_SalesGroup
	_SalesGroupOrgUnit		_SalesGroupOrgUnit
	_SalesOffice		_SalesOffice
	_SalesOfficeOrgUnit		_SalesOfficeOrgUnit
	_RespSrvcOrganizationOrgUnit		_RespSrvcOrganizationOrgUnit
	_DistributionChannel		_DistributionChannel
	_Division		_Division
	_GrantorApplItmRejectionReason		_GrantorApplItmRejectionReason
	_GrantorExpenseCatalog		_GrantorExpenseCatalog
	_GrantorExpenseGroup		_GrantorExpenseGroup
	_GrantorExpenseType		_GrantorExpenseType
	_GrantorFinancialExecutionType		_GrantorFinancialExecutionType

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_GrantorApplicationItemCube.
-- 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_GrantorApplicationItemCube AS
SELECT
  BusinessObjectType,
  GrantorApplication,
  GrantorApplicationItem,
  GrantorApplicationType,
  DocumentDescription,
  DocumentPostingDate,
  _GrantorApplication.CreationDateTime AS DocumentCreationDateTime,
  GrantorApplicationItemUUID,
  GrantorApplicationItemCharUUID,
  DocumentItemDescription,
  Language,
  PostingDateTime,
  CreationDateTime,
  GrantorApplicationItemCategory,
  GrantorPaymentType,
  GrantorFinancialExecutionType,
  GrantorDocumentItemGrantee,
  GrntoDocItemGranteeAddressNmbr,
  GrntoDocItmResponsibleEmployee,
  GrntoDocumentItemContactPerson,
  GrantorDocumentItemBillToParty,
  GrantorDocumentItemPayer,
  GrntoDocItemPaymentRecipient,
  GrantorDocumentGrantee,
  GrntoDocGranteeAddressNumber,
  _GranteeAddress.Country AS GranteeCountry,
  GrntoDocResponsibleEmployee,
  GrantorDocumentContactPerson,
  GrantorDocumentBillToParty,
  GrantorDocumentPayer,
  GrntoDocumentPaymentRecipient,
  DocumentItemStartDateTime,
  DocumentItemStartDate,
  DocumentItemEndDateTime,
  DocumentItemEndDate,
  DocumentItemDueDateTime,
  DocumentItemDueDate,
  _GrantorApplication.DocumentStartDateTime AS DocumentStartDateTime,
  _GrantorApplication.DocumentStartDate AS DocumentStartDate,
  _GrantorApplication.DocumentEndDateTime AS DocumentEndDateTime,
  _GrantorApplication.DocumentEndDate AS DocumentEndDate,
  GrantorApplicationItemStatus,
  IsReleased,
  IsOpen,
  HasError,
  IsRejected,
  GrantorDocumentItemIsCancelled,
  GrantorAgreementItemIsCreated,
  _GrantorApplication.GrantorApplicationStatus AS GrantorApplicationStatus,
  _GrantorApplication.IsReleased AS DocumentIsReleased,
  _GrantorApplication.IsOpen AS DocumentIsOpen,
  _GrantorApplication.IsRejected AS DocumentIsRejected,
  _GrantorApplication.HasError AS DocumentHasError,
  _GrantorApplication.GrantorDocumentIsCancelled AS GrantorDocumentIsCancelled,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  DistributionChannel,
  Division,
  ServiceOrganization,
  ResponsibleServiceOrganization,
  ResponsibleSalesOrganization,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  GrantorProgram,
  _GrantorProgram.GrantorProgramUUID AS GrantorProgramUUID,
  _GrantorProgram.GrantorProgramType AS GrantorProgramType,
  GrantorAgreementItem,
  GrantorAdvanceReferenceItem,
  TransactionCurrency,
  GrantorDocumentItemIsCredit,
  GrantorRequestedAmount,
  GrantorEligibleAmount,
  GrantorAuthorizedAmount,
  NetAmount,
  GrantorDocItemGranteeExtRef,
  GrantorDocItemRejectionReason,
  BillingPlanType,
  BillingPlanIsFinalized,
  BillingPlanStartDateTime,
  BillingPlanEndDateTime,
  BillingPlanTimeZone,
  ContractAccount,
  BillingDateTime,
  BillingTimeZone,
  BillingBlockReason,
  GrantorExpenseCatalog,
  GrantorExpenseGroup,
  GrantorExpenseType,
  _GrantorProgram._GrantorProgramAttributes AS _GrantorProgramAttributes,
  _GrantorProgram._GrantorProgramType AS _GrantorProgramType,
  _GrantorApplication._GrantorApplLifecycleStatus AS _GrantorApplLifecycleStatus,
  _GrantorApplication._GrantorApplicationIsReleased AS _GrantorApplicationIsReleased,
  _GrantorApplication._GrantorApplicationIsOpen AS _GrantorApplicationIsOpen,
  _GrantorApplication._GrantorApplicationIsRejected AS _GrantorApplicationIsRejected,
  _GrantorApplication._GrantorApplicationHasError AS _GrantorApplicationHasError,
  _GrantorApplication._GrantorDocumentIsCancelled AS _GrantorDocumentIsCancelled
FROM I_GrantorApplicationItmEnhcd
;

Depth:

I_GrantorApplicationItemCube view_entity

I_GrantorApplicationItmEnhcd view_entity

C_GrantorApplicationItmKPI view_entity
P_GrntoApplItmAmountsEnhcd view_entity