P_GteeMCommitmentOpenItem

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 P_GteeMCommitmentOpenItem.
-- 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: PIGMIACP

CREATE VIEW P_GteeMCommitmentOpenItem AS
SELECT
  Item.GranteeMgmtLongSequenceNumber AS GranteeMgmtLongSequenceNumber,
  Item.Ledger AS Ledger,
  Item.CompanyCode AS CompanyCode,
  Item.FinancialManagementArea AS FinancialManagementArea,
  Item.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  Item.GrantID AS GrantID,
  Item.SponsoredProgram AS SponsoredProgram,
  Item.SponsoredClass AS SponsoredClass,
  Item.Fund AS Fund,
  Item.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  Item.GLAccount AS GLAccount,
  Item.BusinessArea AS BusinessArea,
  Item.FundsCenter AS FundsCenter,
  Item.CommitmentItem AS CommitmentItem,
  Item.FunctionalArea AS FunctionalArea,
  Item.FundedProgram AS FundedProgram,
  Item.GrantFiscalYear AS GrantFiscalYear,
  Item.GrantFiscalYearPeriod AS GrantFiscalYearPeriod,
  Item.GrantFiscalYearVariant AS GrantFiscalYearVariant,
  Item.GranteeFiscalYear AS GranteeFiscalYear,
  Item.GranteeFiscalYearVariant AS GranteeFiscalYearVariant,
  Item.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  Item.FinMgmtAreaFiscalYearVariant AS FinMgmtAreaFiscalYearVariant,
  Item.GrantCurrency AS GrantCurrency,
  Item.AmountInGrantCurrency AS AmountInGrantCurrency,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Item.OriginalCurrency AS OriginalCurrency,
  Item.AmountInOriginalCurrency AS AmountInOriginalCurrency,
  Item.GranteeMgmtValueType AS GranteeMgmtValueType,
  Item.BusinessTransactionType AS BusinessTransactionType,
  Item.IsStatisticalItem AS IsStatisticalItem,
  Item.LogicalSystem AS LogicalSystem,
  Item.PostingDate AS PostingDate,
  Item.RefDocAccountAssignment AS RefDocAccountAssignment,
  Item.ReferenceDocumentScheduleLine AS ReferenceDocumentScheduleLine,
  Item.CreationDate AS CreationDate,
  Item.CreationTime AS CreationTime,
  Item.CreatedByUser AS CreatedByUser,
  Item.GranteeMgmtItemIsCompleted AS GranteeMgmtItemIsCompleted,
  Item.GranteeMgmtItemIsDeleted AS GranteeMgmtItemIsDeleted,
  Item.ReferenceDocument AS ReferenceDocument,
  Item.ReferenceDocumentFiscalYear AS ReferenceDocumentFiscalYear,
  Item.ReferenceDocumentItem AS ReferenceDocumentItem,
  Item.ReferenceDocumentType AS ReferenceDocumentType,
  Item.ReferenceDocumentContext AS ReferenceDocumentContext,
  Item.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  Item.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  Item.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  Item.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  Item.PredecessorReferenceDocItem AS PredecessorReferenceDocItem
FROM I_GteeMCmtmtActlDocItem AS Item
;