C_PubSecGrantOverview

DDL: C_PUBSECGRANTOVERVIEW Type: view_entity CONSUMPTION Package: ODATA_PSM_S4C_GM_REPORTING

Grant Master data for Monitor Grants

C_PubSecGrantOverview is a Consumption CDS View that provides data about "Grant Master data for Monitor Grants" in SAP S/4HANA. It reads from 1 data source (I_PubSecGrantOverview) and exposes 22 fields with key field GrantID. It is exposed through 2 OData services (ASQL_F7716, UI_MONITORGRANTS_ANA_02). It is used in 1 Fiori application: Monitor Grants. Part of development package ODATA_PSM_S4C_GM_REPORTING.

Data Sources (1)

SourceAliasJoin Type
I_PubSecGrantOverview I_PubSecGrantOverview from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Grant Master data for Monitor Grants view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7716 ASQL_F7716 C2 NOT_RELEASED
UI_MONITORGRANTS_ANA_02 UI_MONITORGRANTS_ANA_02 V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F7716 Monitor Grants Analytical An Application to monitor grants

Monitor Grants

Business Role: Grant Specialist

You can use the Monitor Grants Fiori app to visualize key grant monitoring data that can enable the organization to perform efficient and reliable analysis of the grant patterns.

Key Features: Grant Billing Details The grant billing details such as the unbilled amount, billed amount, and unpaid amount of all the grants are displayed on this card. You can click on the individual grant to navigate to the Grant Billing Analysis application. Top Sponsors The top sponsors details are displayed on this card. You can view the sponsor details such as sponsor name, budget, and number of grants and can sort the top sponsors by budget or number of grants. You can click on the individual sponsor to navigate to the Manage Grants application. Grants in Approval by Status The number of grants that are stuck in the approval process, based on different statuses, are displayed on this card. You can click on the individual status to navigate to the Manage Grants application. Budget Consumption by Grants The budget consumption details of the grants are displayed on this card. The details such as grant name, budget amount, consumed amount, and available amount are displayed. The grants can be sorted based on highest budget, highest budget consumed, or highest budget available. You can click on the individual grant to navigate to the Grants Budget AVC Overview application. Grants by Status The number of grants by each grant status is visualized on this card. You can click on the individual status to navigate to the Manage Grants application. Grant Revenue The total grant revenue and the revenue amount in global currency across fiscal years are visualized in this chart. You can click on the header section of the card, or the data point plotted to navigate to the Grants Overview application. Grants by Grant Type The number of grants by grant types are displayed in this card. You can click on the individual grant type to navigate to the Manage Grants application. Additionally, this dashboard offers a Quick Links card that allows you to navigate to the following pages: Manage Grants Grants Billing Analysis Grants Budget AVC Overview Grants Overview Note You can also add the cards as insights to your personalised My Home page. To add the cards as insights, click … (More) on the intended card and then click Add Card to Insights. The Add Card to Insights dialog box is displayed where you can modify the card name to be displayed on the My Home page and also add a subtitle if needed.

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY GrantID GrantID Sender Grant
GrantName GrantName
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
GranteeMgmtSponsor GranteeMgmtSponsor
BusinessPartnerName BusinessPartnerName Extracted Customer Name
GrantType GrantType
GrantTypeDescription GrantTypeDescription
CompanyCode CompanyCode Receiver Company Code
GrantLifecycleStatus GrantLifecycleStatus
GrantStatus GrantStatus
GrantStatusName GrantStatusName
GrantBlockedByWorkflow GrantBlockedByWorkflow
GrantIsNotRelevantGrant GrantIsNotRelevantGrant
GrantAuthznGrp GrantAuthznGrp
GrantLfcycStatusForAuthzn GrantLfcycStatusForAuthzn
GrantFiscalYearVariant GrantFiscalYearVariant
NumberOfGteeMMasterDataRecords NumberOfGteeMMasterDataRecords
NumberOfRecords NumberOfRecords
_GrantType _GrantType
_Sponsor _Sponsor
_GrantStatus _GrantStatus

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 C_PubSecGrantOverview.
-- 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 C_PubSecGrantOverview AS
SELECT
  GrantID,
  GrantName,
  ValidityStartDate,
  ValidityEndDate,
  GranteeMgmtSponsor,
  BusinessPartnerName,
  GrantType,
  GrantTypeDescription,
  CompanyCode,
  GrantLifecycleStatus,
  GrantStatus,
  GrantStatusName,
  GrantBlockedByWorkflow,
  GrantIsNotRelevantGrant,
  GrantAuthznGrp,
  GrantLfcycStatusForAuthzn,
  GrantFiscalYearVariant,
  NumberOfGteeMMasterDataRecords,
  NumberOfRecords
FROM I_PubSecGrantOverview
;