I_PubSecGrantOverview

DDL: I_PUBSECGRANTOVERVIEW Type: view_entity COMPOSITE Package: ODATA_PSM_S4C_GM_REPORTING
22 Fields 1 Data Sources

Grant Master data for Monitor Grants

I_PubSecGrantOverview is a Composite CDS View that provides data about "Grant Master data for Monitor Grants" in SAP S/4HANA. It reads from 1 data source (I_Grant) and exposes 22 fields with key field GrantID. Part of development package ODATA_PSM_S4C_GM_REPORTING.

Data Sources (1)

SourceAliasJoin Type
I_Grant I_Grant from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED 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
VDM.viewType #COMPOSITE view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY GrantID GrantID Sender Grant
GrantName
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
GranteeMgmtSponsor GranteeMgmtSponsor With Partner
BusinessPartnerName _Sponsor BusinessPartnerName Extracted Customer Name
GrantType GrantType Grant Type
GrantTypeDescription
CompanyCode CompanyCode Receiver Company Code
GrantLifecycleStatus GrantLifecycleStatus Status
GrantStatus GrantStatus Workflow Status
GrantStatusName _GrantStatus GrantStatusName
GrantIsNotRelevantGrant GrantIsNotRelevantGrant
GrantAuthznGrp GrantAuthznGrp Authorization Group
GrantLfcycStatusForAuthzn GrantLfcycStatusForAuthzn
GrantFiscalYearVariant GrantFiscalYearVariant Grant FY variant
GrantBlockedByWorkflow
NumberOfGteeMMasterDataRecords
int4endasNumberOfRecords
_Sponsor _Sponsor
_GrantType _GrantType
_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 I_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 I_PubSecGrantOverview AS
SELECT
  GrantID,
  _Text[1:Language = $session.system_language].GrantName AS GrantName,
  ValidityStartDate,
  ValidityEndDate,
  GranteeMgmtSponsor,
  _Sponsor.BusinessPartnerName AS BusinessPartnerName,
  GrantType,
  _GrantType._GrantTypeText[1:Language = $session.system_language].GrantTypeDescription AS GrantTypeDescription,
  CompanyCode,
  GrantLifecycleStatus,
  GrantStatus,
  _GrantStatus.GrantStatusName AS GrantStatusName,
  GrantIsNotRelevantGrant,
  GrantAuthznGrp,
  GrantLfcycStatusForAuthzn,
  GrantFiscalYearVariant,
  cast( 'X' as boole_d ) AS GrantBlockedByWorkflow,
  cast( 1 as abap.int4 ) AS NumberOfGteeMMasterDataRecords,
  case when GrantBlockedByWorkflow = '1' then cast( 1 as abap.int4 ) else cast( 0 as abap.int4 ) end as NumberOfRecords AS int4endasNumberOfRecords
FROM I_Grant
;

Learn More