I_PubSecCmtmtAgingGroup

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_PubSecCmtmtAgingGroup.
-- 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: IPUBSECCMTAGING
-- Parameters: P_CurrentDate : sydats, P_PubSecOpnCmtmtTme1 : psm_open_cmtmt_param_days, P_PubSecOpnCmtmtTme2 : psm_open_cmtmt_param_slice

CREATE VIEW I_PubSecCmtmtAgingGroup 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.ControllingArea AS ControllingArea,
  Item.Fund AS Fund,
  Item.FundType AS FundType,
  Item.GLAccount AS GLAccount,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.CostCenter AS CostCenter,
  Item.ProfitCenter AS ProfitCenter,
  Item.FunctionalArea AS FunctionalArea,
  Item.BudgetPeriod AS BudgetPeriod,
  Item.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  Item.GrantID AS GrantID,
  Item.SponsoredProgram AS SponsoredProgram,
  Item.SponsoredClass AS SponsoredClass,
  Item.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  Item.PubSecBudgetAccount AS PubSecBudgetAccount,
  Item.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  Item.WBSElementInternalID AS WBSElementInternalID,
  Item.WBSElementExternalID AS WBSElementExternalID,
  Item.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  Item.Segment AS Segment,
  Item.SourceReferenceDocument AS SourceReferenceDocument,
  Item.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  Item.SourceLogicalSystem AS SourceLogicalSystem,
  Item.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  Item.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  Item.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  Ext.PubSecOpenCmtmtAgingDate AS PubSecOpenCmtmtAgingDate,
  Item.PurchasingDocument AS PurchasingDocument,
  Item.PurchasingDocumentItem AS PurchasingDocumentItem,
  Item.AccountAssignmentNumber AS AccountAssignmentNumber,
  Item.TransactionCurrency AS TransactionCurrency,
  cast(sum(Item.AmountInTransactionCurrency) as psm_open_cmtmt_amt_trans) AS PubSecOpnCmtmtAmtInTransCrcy,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast(sum(Item.AmountInCompanyCodeCurrency) as psm_open_cmtmt_amt_cc) AS PubSecOpnCmtmtAmtInCoCodeCrcy,
  Item.GlobalCurrency AS GlobalCurrency,
  cast(sum(Item.AmountInGlobalCurrency) as psm_open_cmtmt_amt_gc) AS PubSecOpnCmtmtAmtInGlobCrcy,
  Item._CompanyCode AS _CompanyCode,
  Item._Fund AS _Fund,
  Item._FundType AS _FundType,
  Item._TransactionCurrency AS _TransactionCurrency,
  Item._CompanyCodeCurrency AS _CompanyCodeCurrency,
  Item._FiscalYear AS _FiscalYear,
  Item._FinancialManagementArea AS _FinancialManagementArea,
  Item._CostCenter AS _CostCenter,
  Item._CurrentCostCenter AS _CurrentCostCenter,
  Item._GlobalCurrency AS _GlobalCurrency,
  Item._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  Item._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  Item._BudgetPeriod AS _BudgetPeriod,
  Item._FunctionalArea AS _FunctionalArea,
  Item._Grant AS _Grant,
  Item._ProfitCenter AS _ProfitCenter,
  Item._CurrentProfitCenter AS _CurrentProfitCenter,
  Item._Segment AS _Segment,
  Item._SourceReferenceDocumentType AS _SourceReferenceDocumentType,
  Item._PubSecBdgtCnsmpnType AS _PubSecBdgtCnsmpnType,
  Item._PubSecBudgetAccount AS _PubSecBudgetAccount,
  Item._PubSecBdgtAcctRevnExpnCode AS _PubSecBdgtAcctRevnExpnCode,
  Item._WBSElementBasicData AS _WBSElementBasicData,
  Item._WBSElementExternalID AS _WBSElementExternalID,
  cast(DATS_DAYS_BETWEEN( Ext.PubSecOpenCmtmtAgingDate, :P_CurrentDate) as psm_open_cmtmt_total_days) AS PubSecOpnCmtmtDays,
  cast(:P_PubSecOpnCmtmtTme1 + :P_PubSecOpnCmtmtTme2 as psm_open_cmtmt_time1) AS PubSecOpnCmtmtTme1,
  cast(:P_PubSecOpnCmtmtTme1 + :P_PubSecOpnCmtmtTme2 + :P_PubSecOpnCmtmtTme2 as psm_open_cmtmt_time2) AS PubSecOpnCmtmtTme2,
  cast(:P_PubSecOpnCmtmtTme1 + :P_PubSecOpnCmtmtTme2 + :P_PubSecOpnCmtmtTme2 +:P_PubSecOpnCmtmtTme2 as psm_open_cmtmt_time3) AS PubSecOpnCmtmtTme3,
  cast(:P_PubSecOpnCmtmtTme1 + :P_PubSecOpnCmtmtTme2 + :P_PubSecOpnCmtmtTme2 +:P_PubSecOpnCmtmtTme2 +:P_PubSecOpnCmtmtTme2 as psm_open_cmtmt_time4 ) AS PubSecOpnCmtmtTme4,
  cast(:P_PubSecOpnCmtmtTme1 + :P_PubSecOpnCmtmtTme2 + :P_PubSecOpnCmtmtTme2 +:P_PubSecOpnCmtmtTme2 +:P_PubSecOpnCmtmtTme2 + :P_PubSecOpnCmtmtTme2 as psm_open_cmtmt_time5) AS PubSecOpnCmtmtTme5
FROM I_PubSecCmtmtActlItemCube AS Item
INNER JOIN I_PubSecCmtmtAgingBasic AS Ext ON /* join condition not captured in parsed metadata */
;