I_GrntoAgreementEnhancedCube

DDL: I_GRNTOAGREEMENTENHANCEDCUBE Type: view_entity COMPOSITE
90 Fields 1 Data Sources

Grantor Agreement Enhanced - Cube

I_GrntoAgreementEnhancedCube (Composite)

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

Public Sector

I_GrntoAgreementEnhancedCube is a Composite CDS View (Cube) that provides data about "Grantor Agreement Enhanced - Cube" in SAP S/4HANA. It reads from 1 data source (I_GrantorAgreementEnhanced) and exposes 90 fields with key fields BusinessObjectType, GrantorAgreement.

SAP Help Documentation

CategoryGrantor Management
Data CategoryCube
Purpose
This CDS view retrieves grantor agreement data. It also retrieves the total of all its item amounts for authorized, holdback, cleared, released holdback, and billing request. The authorized amount observes clearings between advance payment items and related payment items according to the clearing strategy for the related program. For claim-based payments, the billing request amount from the related claim items is included. 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_GAG (Authorization Object CRM Order - Bus. Obj: Grantor agreement) 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 agreement.

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute GrantorAgreement ID of the grantor agreement Attribute GrantorAgreementType Transaction type for the grantor agreement Attribute GrantorAuthorizedAmount Authorized amount Measure GrantorHoldbackAmount Holdback amount Measure GrantorClearedAmount Cleared amount Measure GrantorReleasedHoldbackAmount Released holdback amount Measure GrantorBillingRequestAmount Sum of the billing request amounts of all items Measure If you have activated the business function PSCD_GRANTOR in the system, the open and cleared amount of the related claim items is added for claim-based items and this CDS view is enhanced with the following fields: Field Name Description Measure or Attribute CAOpenAmountInLocalCrcy Open amount in local currency Measure CAClearedAmountInLocalCrcy Cleared amount in local currency 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

StateC1
Line of BusinessPublic Sector
Application ComponentPSM-GM-GTR-GEN
CapabilitiesData Source in SQL Select, Data Provider for Analytical Queries, Data Source for Defining CDS Entities
PackagePublic Sector for SAP S/4HANA
Description <p>This CDS view retrieves grantor agreement data. It also retrieves the total of all its item amounts for authorized, holdback, cleared, released holdback, and billing request.</p> <p>The authorized amount observes clearings between advance payment items and related payment items according to the clearing strategy for the related program. For claim-based payments, the billing request amount from the related claim items is included.</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_GrantorAgreementEnhanced I_GrantorAgreementEnhanced from

Annotations (12)

NameValueLevelField
EndUserText.label Grantor Agreement Enhanced - 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 (90)

KeyFieldSource TableSource FieldDescription
KEY BusinessObjectType BusinessObjectType Business Trans. Cat.
KEY GrantorAgreement GrantorAgreement Grantor Agreement
GrantorAgreementUUID GrantorAgreementUUID GUID of a CRM Order Object
GrantorAgreementCharUUID GrantorAgreementCharUUID 32 Character CRM Object GUID
GrantorAgreementType GrantorAgreementType 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
GrantorAgreementStatus GrantorAgreementStatus 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
CompanyCodeCurrency Currency Key
GrantorProgram GrantorProgram External Identifier of a Grantor Program
GrantorProgramType _GrantorProgram GrantorProgramType Grantor Program Type
GrantorApplication GrantorApplication Grantor Application
TransactionCurrency TransactionCurrency Transaction Currency
ContractAccount ContractAccount Contract Account Number
GrantorAuthorizedAmount _GrantorAgreementAmounts GrantorAuthorizedAmount Grantor Authorized Amount
GrantorHoldbackAmount _GrantorAgreementAmounts GrantorHoldbackAmount Grantor Holdback Amount
GrantorClearedAmount _GrantorAgreementAmounts GrantorClearedAmount Grantor Cleared Amount
GrantorReleasedHoldbackAmount _GrantorAgreementAmounts GrantorReleasedHoldbackAmount Grantor Released Holdback Amount
GrantorBillingRequestAmount _GrantorAgreementAmounts GrantorBillingRequestAmount Grantor Billing Request Amount
_BusinessObjectType _BusinessObjectType
_GrantorProgram _GrantorProgram
_GrantorProgramType _GrantorProgram _GrantorProgramType
_GrantorAgreementItem _GrantorAgreementItem
_ContractAccount _ContractAccount
_GrantorAgreementType _GrantorAgreementType
_TransactionCurrency _TransactionCurrency
_GrantorAgrmtLifecycleStatus _GrantorAgrmtLifecycleStatus
_GrantorAgreementHasError _GrantorAgreementHasError
_GrantorAgreementIsOpen _GrantorAgreementIsOpen
_GrantorAgreementIsReleased _GrantorAgreementIsReleased
_GrantorAgreementIsRejected _GrantorAgreementIsRejected
_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
_CompanyCodeCurrency _CompanyCodeCurrency

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_GrntoAgreementEnhancedCube.
-- 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_GrntoAgreementEnhancedCube AS
SELECT
  BusinessObjectType,
  GrantorAgreement,
  GrantorAgreementUUID,
  GrantorAgreementCharUUID,
  GrantorAgreementType,
  DocumentDescription,
  Language,
  PostingDate,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  PricingDocument,
  PricingProcedure,
  GrantorDocumentGrantee,
  GrntoDocGranteeAddressNumber,
  _GranteeAddress.Country AS GranteeCountry,
  GrntoDocResponsibleEmployee,
  GrantorDocumentContactPerson,
  GrantorDocumentBillToParty,
  GrantorDocumentPayer,
  GrntoDocumentPaymentRecipient,
  DocumentStartDateTime,
  DocumentStartDate,
  DocumentEndDateTime,
  DocumentEndDate,
  GrantorAgreementStatus,
  IsReleased,
  IsOpen,
  HasError,
  IsRejected,
  GrantorDocIsSuccessfullyTrnsfd,
  GrantorDocHasTransferError,
  GrantorDocumentIsCancelled,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  DistributionChannel,
  Division,
  ServiceOrganization,
  ResponsibleServiceOrganization,
  ResponsibleSalesOrganization,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  _SalesOrganization._CompanyCode.Currency AS CompanyCodeCurrency,
  GrantorProgram,
  _GrantorProgram.GrantorProgramType AS GrantorProgramType,
  GrantorApplication,
  TransactionCurrency,
  ContractAccount,
  _GrantorAgreementAmounts.GrantorAuthorizedAmount AS GrantorAuthorizedAmount,
  _GrantorAgreementAmounts.GrantorHoldbackAmount AS GrantorHoldbackAmount,
  _GrantorAgreementAmounts.GrantorClearedAmount AS GrantorClearedAmount,
  _GrantorAgreementAmounts.GrantorReleasedHoldbackAmount AS GrantorReleasedHoldbackAmount,
  _GrantorAgreementAmounts.GrantorBillingRequestAmount AS GrantorBillingRequestAmount,
  _GrantorProgram._GrantorProgramType AS _GrantorProgramType
FROM I_GrantorAgreementEnhanced
;

Learn More