What is C_PubSecGrantCmtmtAging in SAP S/4HANA?

C_PubSecGrantCmtmtAging is a consumption CDS view in SAP S/4HANA. Grant Open Commitments It contains 67 fields.

Which tables does C_PubSecGrantCmtmtAging read from?

C_PubSecGrantCmtmtAging reads data from: I_PubSecCmtmtAgingLabel.

What VDM layer is C_PubSecGrantCmtmtAging?

C_PubSecGrantCmtmtAging is classified as a Consumption view optimized for specific business scenarios and reporting.

C_PubSecGrantCmtmtAging

DDL: C_PUBSECGRANTCMTMTAGING SQL: CPSMGRNTCMTAGING Type: view CONSUMPTION

67 Fields 1 Data Sources

Grant Open Commitments

C_PubSecGrantCmtmtAging (Consumption)

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

Cross Applications

C_PubSecGrantCmtmtAging is a Consumption CDS View (Cube) that provides data about "Grant Open Commitments" in SAP S/4HANA. It reads from 1 data source (I_PubSecCmtmtAgingLabel) and exposes 67 fields with key fields Ledger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	PSM-GM-GTE-IS
Capabilities	Data Provider for Analytical Queries
Package	Cross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition 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 Cloud Private Edition 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 Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_PubSecCmtmtAgingLabel	I_PubSecCmtmtAgingLabel	from

Parameters (3)

Name	Type	Default
P_CurrentDate	psm_open_cmtmt_param_sydats
P_PubSecOpnCmtmtTme1	psm_open_cmtmt_param_days
P_PubSecOpnCmtmtTme2	psm_open_cmtmt_param_slice

Annotations (19)

Name	Value	Level
AbapCatalog.sqlViewName	CPSMGRNTCMTAGING	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.type	#CLIENT_DEPENDENT	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.preserveKey	true	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
EndUserText.label	Grant Open Commitments	view
Analytics.internalName	#LOCAL	view
Analytics.dataCategory	#CUBE	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
OData.publish	true	view

Fields (67)

Key	Field	Source Table	Source Field	Description
KEY	Ledger	Item	Ledger	Ledger in General Ledger Accounting
KEY	CompanyCode	Item	CompanyCode	Receiver Company Code
KEY	FiscalYear	Item	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	Item	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	Item	LedgerGLLineItem	General Ledger Journal Entry Line Item
	FinancialManagementArea	Item	FinancialManagementArea	Financial Management Area
	Fund	Item	Fund	Sender Fund
	FundType	Item	FundType	FM Fund Type
	GLAccount	Item	GLAccount	General Ledger
	CostCenter	Item	CostCenter	Cost Center
	ProfitCenter	Item	ProfitCenter	Profit Center
	FunctionalArea	Item	FunctionalArea	Sendr Fctl Area
	BudgetPeriod	Item	BudgetPeriod	Budget Period
	GrantID	Item	GrantID	Sender Grant
	SponsoredClass	Item	SponsoredClass	Sponsored Class
	SponsoredProgram	Item	SponsoredProgram	Sponsored Program
	Segment	Item	Segment	Segment for Segmental Reporting
	WBSElementExternalID			WBS Element External ID
	PurchaseOrder	Item	PurchaseOrder	Purchase Order Number
	PurchaseRequisition	Item	PurchaseRequisition	Purchase Requisition Number
	EarmarkedFundsDocument	Item	EarmarkedFundsDocument	Document Number for Earmarked Funds
	AccountAssignmentNumber	Item	AccountAssignmentNumber	Account Assignment Number
	PubSecBudgetAccount	Item	PubSecBudgetAccount	Budget Account
	PubSecBdgtAcctRevnExpnCode	Item	PubSecBdgtAcctRevnExpnCode	Expense or Revenue on Budget Account
	PubSecBudgetCnsmpnType	Item	PubSecBudgetCnsmpnType	Budget Consumption Type
	PubSecOpnCmtmtTmeIntvl	Item	PubSecOpnCmtmtTmeIntvl	Shows Time Interval to Which Grouped Open Commitments Belong
	GlobalCurrency	Item	GlobalCurrency	GM Billing Element: Global Currency
	PubSecOpenCmtmtAgingDate	Item	PubSecOpenCmtmtAgingDate	Open Commitment Date
	SourceReferenceDocumentType	Item	SourceReferenceDocumentType	Source Reference Document Type
	SourceReferenceDocument	Item	SourceReferenceDocument	Source Reference Document
	SourceReferenceDocumentItem	Item	SourceReferenceDocumentItem	Source Reference Document Item
	SourceLogicalSystem	Item	SourceLogicalSystem	Source Logical System
	SourceReferenceDocumentCntxt	Item	SourceReferenceDocumentCntxt	Source Reference Document Context
	SourceReferenceDocSubitem	Item	SourceReferenceDocSubitem	Source Reference Document Subitem
	PubSecOpnCmtmtAmtInGlobCrcy1	Item	PubSecOpnCmtmtAmtInGlobCrcy1	Open Commitment Amount in Global Currency for Time Slice A
	PubSecOpnCmtmtAmtInGlobCrcy2	Item	PubSecOpnCmtmtAmtInGlobCrcy2	Open Commitment Amount in Global Currency for Time Slice B
	PubSecOpnCmtmtAmtInGlobCrcy3	Item	PubSecOpnCmtmtAmtInGlobCrcy3	Open Commitment Amount in Global Currency for Time Slice C
	PubSecOpnCmtmtAmtInGlobCrcy4	Item	PubSecOpnCmtmtAmtInGlobCrcy4	Open Commitment Amount in Global Currency for Time Slice D
	PubSecOpnCmtmtAmtInGlobCrcy5	Item	PubSecOpnCmtmtAmtInGlobCrcy5	Open Commitment Amount in Global Currency for Time Slice E
	TransactionCurrency	Item	TransactionCurrency	Transaction Currency
	PubSecOpnCmtmtAmtInTransCrcy	Item	PubSecOpnCmtmtAmtInTransCrcy	Total Open Commitment Amount in Transaction Currency
	CompanyCodeCurrency	Item	CompanyCodeCurrency	Company Code Currency
	PubSecOpnCmtmtAmtInCoCodeCrcy	Item	PubSecOpnCmtmtAmtInCoCodeCrcy	Total Open Commitment Amount in Company Code Currency
	PubSecOpnCmtmtAmtInGlobCrcy	Item	PubSecOpnCmtmtAmtInGlobCrcy	Total Open Commitment Amount in Global Currency
	FundDescription			Fund Description
	FunctionalAreaName			Name of the Functional Area
	BudgetPeriodName			Budget Period Desc.
	GrantName			Short Description of the Grant
	CostCenterName			Cost Center Desc.
	WBSDescription			Work Breakdown Structure Element Name
	GLAccountName			GL Account Desc.
	ProfitCenterName			Description of Profit Center
	SegmentName			Segment Desc.
	GLAccountText			Budget Account Desc.
	PubSecBdgtCnsmpnAmtTypeText			Description of Budget Consumption Type
	PubSecBdgtAcctRevnExpnCodeText			Description of Expense or Revenue on Budget Account
	ReferenceDocumentTypeName			Name of Object Type
	FundTypeDescription			Description of Fund Type
	CompanyCodeName			Name of Company Code or Company
	TransactionCurrencyName			Description
	ChartOfAccounts	Item	ChartOfAccounts	Chart of Accounts
	ControllingArea	Item	ControllingArea	Controlling Area
	_CurrentCostCenter	Item	_CurrentCostCenter
	_CurrentProfitCenter	Item	_CurrentProfitCenter
	_GLAccountInCompanyCode	Item	_GLAccountInCompanyCode
	_Grant	Item	_Grant
	_Fund	Item	_Fund

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_PubSecGrantCmtmtAging.
-- 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.
-- SQL view name: CPSMGRNTCMTAGING
-- Parameters: P_CurrentDate : psm_open_cmtmt_param_sydats, P_PubSecOpnCmtmtTme1 : psm_open_cmtmt_param_days, P_PubSecOpnCmtmtTme2 : psm_open_cmtmt_param_slice

CREATE VIEW C_PubSecGrantCmtmtAging AS
SELECT
  Item.Ledger AS Ledger,
  Item.CompanyCode AS CompanyCode,
  Item.FiscalYear AS FiscalYear,
  Item.AccountingDocument AS AccountingDocument,
  Item.LedgerGLLineItem AS LedgerGLLineItem,
  Item.FinancialManagementArea AS FinancialManagementArea,
  Item.Fund AS Fund,
  Item.FundType AS FundType,
  Item.GLAccount AS GLAccount,
  Item.CostCenter AS CostCenter,
  Item.ProfitCenter AS ProfitCenter,
  Item.FunctionalArea AS FunctionalArea,
  Item.BudgetPeriod AS BudgetPeriod,
  Item.GrantID AS GrantID,
  Item.SponsoredClass AS SponsoredClass,
  Item.SponsoredProgram AS SponsoredProgram,
  Item.Segment AS Segment,
  cast( coalesce( Item.WBSElementExternalID, '' ) as fis_wbsext_no_conv preserving type ) AS WBSElementExternalID,
  Item.PurchaseOrder AS PurchaseOrder,
  Item.PurchaseRequisition AS PurchaseRequisition,
  Item.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  Item.AccountAssignmentNumber AS AccountAssignmentNumber,
  Item.PubSecBudgetAccount AS PubSecBudgetAccount,
  Item.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  Item.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  Item.PubSecOpnCmtmtTmeIntvl AS PubSecOpnCmtmtTmeIntvl,
  Item.GlobalCurrency AS GlobalCurrency,
  Item.PubSecOpenCmtmtAgingDate AS PubSecOpenCmtmtAgingDate,
  Item.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  Item.SourceReferenceDocument AS SourceReferenceDocument,
  Item.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  Item.SourceLogicalSystem AS SourceLogicalSystem,
  Item.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  Item.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  Item.PubSecOpnCmtmtAmtInGlobCrcy1 AS PubSecOpnCmtmtAmtInGlobCrcy1,
  Item.PubSecOpnCmtmtAmtInGlobCrcy2 AS PubSecOpnCmtmtAmtInGlobCrcy2,
  Item.PubSecOpnCmtmtAmtInGlobCrcy3 AS PubSecOpnCmtmtAmtInGlobCrcy3,
  Item.PubSecOpnCmtmtAmtInGlobCrcy4 AS PubSecOpnCmtmtAmtInGlobCrcy4,
  Item.PubSecOpnCmtmtAmtInGlobCrcy5 AS PubSecOpnCmtmtAmtInGlobCrcy5,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.PubSecOpnCmtmtAmtInTransCrcy AS PubSecOpnCmtmtAmtInTransCrcy,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.PubSecOpnCmtmtAmtInCoCodeCrcy AS PubSecOpnCmtmtAmtInCoCodeCrcy,
  Item.PubSecOpnCmtmtAmtInGlobCrcy AS PubSecOpnCmtmtAmtInGlobCrcy,
  Item._Fund._Text[1:Language = $session.system_language].FundDescription AS FundDescription,
  Item._FunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  Item._BudgetPeriod._Text[1:Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName,
  Item._Grant._Text[1:Language = $session.system_language].GrantName AS GrantName,
  Item._CurrentCostCenter._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  Item._WBSElementExternalID.WBSDescription AS WBSDescription,
  Item._GLAccountInChartOfAccounts._Text[1:Language = $session.system_language].GLAccountName AS GLAccountName,
  Item._CurrentProfitCenter._Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  Item._Segment._Text[1:Language = $session.system_language].SegmentName AS SegmentName,
  Item._PubSecBudgetAccount._BudgetAccountText[1:Language = $session.system_language].BudgetAccountName AS GLAccountText,
  Item._PubSecBdgtCnsmpnType._Text[1:Language = $session.system_language].PubSecBudgetCnsmpnTypeText AS PubSecBdgtCnsmpnAmtTypeText,
  Item._PubSecBdgtAcctRevnExpnCode._Text[1:Language = $session.system_language].PubSecBdgtAcctRevnExpnCodeText AS PubSecBdgtAcctRevnExpnCodeText,
  Item._SourceReferenceDocumentType._Text[1:Language = $session.system_language].ReferenceDocumentTypeName AS ReferenceDocumentTypeName,
  Item._FundType._Text[1:Language = $session.system_language].FundTypeDescription AS FundTypeDescription,
  Item._CompanyCode.CompanyCodeName AS CompanyCodeName,
  Item._TransactionCurrency._Text[1:Language = $session.system_language].CurrencyName AS TransactionCurrencyName,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.ControllingArea AS ControllingArea,
  Item._CurrentCostCenter AS _CurrentCostCenter,
  Item._CurrentProfitCenter AS _CurrentProfitCenter,
  Item._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  Item._Grant AS _Grant,
  Item._Fund AS _Fund
FROM I_PubSecCmtmtAgingLabel
;

Depth:

C_PubSecGrantCmtmtAging view

I_PubSecCmtmtAgingLabel view