I_GteeMCmtmtActlDocItem

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_GteeMCmtmtActlDocItem.
-- 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: IGMACDOCI

CREATE VIEW I_GteeMCmtmtActlDocItem AS
SELECT
  Item.GranteeMgmtLongSequenceNumber AS GranteeMgmtLongSequenceNumber,
  Item.Ledger AS Ledger,
  Item.CompanyCode AS CompanyCode,
  Item.FinancialManagementArea AS FinancialManagementArea,
  Item.ControllingArea AS ControllingArea,
  Item._Grant.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.CostCenter AS CostCenter,
  Item.MasterFixedAsset AS MasterFixedAsset,
  Item.FixedAsset AS FixedAsset,
  Item.OrderID AS OrderID,
  Item.ProfitCenter AS ProfitCenter,
  Item.WBSElementInternalID AS WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  Item.Material AS Material,
  Item.GranteeMgmtBillingStatus AS GranteeMgmtBillingStatus,
  Item.GrantFiscalYear AS GrantFiscalYear,
  Item.GrantFiscalYearPeriod AS GrantFiscalYearPeriod,
  Item.GrantFiscalYearVariant AS GrantFiscalYearVariant,
  Item.GranteeFiscalYear AS GranteeFiscalYear,
  Item.GranteeFiscalYearVariant AS GranteeFiscalYearVariant,
  _FiscalCalendarDate.FiscalYear 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.GranteeMgmtBdgtWorkFlowSts AS GranteeMgmtBdgtWorkFlowSts,
  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,
  Item._Grant._Sponsor AS _Sponsor,
  Item._Ledger AS _Ledger,
  Item._FiscalYearForCompanyCode AS _FiscalYearForCompanyCode,
  Item._CompanyCode AS _CompanyCode,
  Item._CompanyCodeFiscalYearVariant AS _CompanyCodeFiscalYearVariant,
  Item._Grant AS _Grant,
  Item._GrantFiscalYearVariant AS _GrantFiscalYearVariant,
  Item._SponsoredProgram AS _SponsoredProgram,
  Item._SponsoredClass AS _SponsoredClass,
  Item._Fund AS _Fund,
  Item._ValueType AS _ValueType,
  Item._BusinessTransactionType AS _BusinessTransactionType,
  Item._FinMgmtArea AS _FinMgmtArea,
  Item._FinMgmtAreaFiscalYearVariant AS _FinMgmtAreaFiscalYearVariant,
  Item._FunctionalArea AS _FunctionalArea,
  Item._FundedProgram AS _FundedProgram,
  Item._GLAccount AS _GLAccount,
  Item._BusinessArea AS _BusinessArea,
  Item._ControllingArea AS _ControllingArea,
  Item._LogicalSystem AS _LogicalSystem,
  Item._ReferenceDocLogicalSystem AS _ReferenceDocLogicalSystem,
  Item._ReferenceDocumentType AS _ReferenceDocumentType,
  Item._FiscalCalendarDate AS _FiscalCalendarDate,
  Item._BillingStatus AS _BillingStatus
FROM I_GteeMCmtmtActlDocItemBasic AS Item
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_FundsCenterByYear AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FundsCenter.FinMgmtAreaFiscalYear AND FundsCenter = _FundsCenter.FundsCenter  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON FinancialManagementArea = _CommitmentItem.FinancialManagementArea AND CommitmentItem = _CommitmentItem.CommitmentItem AND ( FinMgmtAreaFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear OR _CommitmentItem.FinMgmtAreaFiscalYear = '0000' )  -- association [1..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
;