C_PubSecGrantOverview
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)
| Source | Alias | Join Type |
|---|---|---|
| I_PubSecGrantOverview | I_PubSecGrantOverview | from |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| ASQL_F7716 | ASQL_F7716 | C2 | NOT_RELEASED | |
| UI_MONITORGRANTS_ANA_02 | UI_MONITORGRANTS_ANA_02 | V2 | C1 | NOT_RELEASED |
Fiori Apps (1)
| App ID | App Name | Type | Description |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- OData Services in SAP S/4HANA Explained
- Service Bindings and Service Definitions in SAP S/4HANA
- SAP Fiori Apps Architecture — How Fiori Apps Connect to Data
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA