I_GranteeMgmtActlDocCube

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_GranteeMgmtActlDocCube.
-- 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: IGMACDOCIANC

CREATE VIEW I_GranteeMgmtActlDocCube AS
SELECT
  Act.GranteeMgmtLongSequenceNumber AS GranteeMgmtLongSequenceNumber,
  Act.Ledger AS Ledger,
  Act.CompanyCode AS CompanyCode,
  Act.FinancialManagementArea AS FinancialManagementArea,
  Act.ControllingArea AS ControllingArea,
  Act.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  Act.GrantID AS GrantID,
  Act.SponsoredProgram AS SponsoredProgram,
  Act.SponsoredClass AS SponsoredClass,
  Act.Fund AS Fund,
  Act.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  Act.GLAccount AS GLAccount,
  Act.BusinessArea AS BusinessArea,
  Act.FundsCenter AS FundsCenter,
  Act.CommitmentItem AS CommitmentItem,
  Act.FunctionalArea AS FunctionalArea,
  Act.FundedProgram AS FundedProgram,
  Act.CostCenter AS CostCenter,
  Act.MasterFixedAsset AS MasterFixedAsset,
  Act.FixedAsset AS FixedAsset,
  Act.OrderID AS OrderID,
  Act.ProfitCenter AS ProfitCenter,
  Act.WBSElementInternalID AS WBSElementInternalID,
  Act.WBSElementExternalID AS WBSElementExternalID,
  Act.Material AS Material,
  Act.GrantFiscalYear AS GrantFiscalYear,
  Act.GrantFiscalYearPeriod AS GrantFiscalYearPeriod,
  Act.GrantFiscalYearVariant AS GrantFiscalYearVariant,
  Act.GranteeFiscalYear AS GranteeFiscalYear,
  Act.GranteeFiscalYearVariant AS GranteeFiscalYearVariant,
  Act.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  Act.FinMgmtAreaFiscalYearVariant AS FinMgmtAreaFiscalYearVariant,
  Act.GrantCurrency AS GrantCurrency,
  Act.AmountInGrantCurrency AS AmountInGrantCurrency,
  Act.CompanyCodeCurrency AS CompanyCodeCurrency,
  Act.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Act.OriginalCurrency AS OriginalCurrency,
  Act.AmountInOriginalCurrency AS AmountInOriginalCurrency,
  Act.GranteeMgmtValueType AS GranteeMgmtValueType,
  Act._ValueType.GranteeMgmtValueTypeCategory AS GranteeMgmtValueTypeCategory,
  Act.BusinessTransactionType AS BusinessTransactionType,
  Act.IsStatisticalItem AS IsStatisticalItem,
  Act.GranteeMgmtBdgtWorkFlowSts AS GranteeMgmtBdgtWorkFlowSts,
  Act.LogicalSystem AS LogicalSystem,
  Act.PostingDate AS PostingDate,
  Act.RefDocAccountAssignment AS RefDocAccountAssignment,
  Act.ReferenceDocumentScheduleLine AS ReferenceDocumentScheduleLine,
  Act.CreationDate AS CreationDate,
  Act.CreationTime AS CreationTime,
  Act.CreatedByUser AS CreatedByUser,
  Act.GranteeMgmtItemIsCompleted AS GranteeMgmtItemIsCompleted,
  Act.GranteeMgmtItemIsDeleted AS GranteeMgmtItemIsDeleted,
  Act._SponsoredClass.SponsoredClassType AS SponsoredClassType,
  Act._Grant.GrantLifecycleStatus AS GrantLifecycleStatus,
  Act.ReferenceDocument AS ReferenceDocument,
  Act.ReferenceDocumentFiscalYear AS ReferenceDocumentFiscalYear,
  Act.ReferenceDocumentItem AS ReferenceDocumentItem,
  Act.ReferenceDocumentType AS ReferenceDocumentType,
  Act.ReferenceDocumentContext AS ReferenceDocumentContext,
  Act.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  Act.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  Act.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  Act.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  Act.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  Act._Sponsor AS _Sponsor,
  Act._Grant._GrantLifecycleStatus AS _GrantLifecycleStatus,
  Act._BusinessArea AS _BusinessArea,
  Act._BusinessTransactionType AS _BusinessTransactionType,
  Act._CompanyCode AS _CompanyCode,
  Act._FinMgmtArea AS _FinMgmtArea,
  Act._FiscalYearForCompanyCode AS _FiscalYearForCompanyCode,
  Act._FunctionalArea AS _FunctionalArea,
  Act._Fund AS _Fund,
  Act._FundedProgram AS _FundedProgram,
  Act._GLAccount AS _GLAccount,
  Act._Grant AS _Grant,
  Act._Ledger AS _Ledger,
  Act._ControllingArea AS _ControllingArea,
  Act._CostCenter AS _CostCenter,
  Act._MasterFixedAsset AS _MasterFixedAsset,
  Act._FixedAsset AS _FixedAsset,
  Act._InternalOrder AS _InternalOrder,
  Act._ProfitCenter AS _ProfitCenter,
  Act._WBSElementBasicData AS _WBSElementBasicData,
  Act._Material AS _Material,
  Act._LogicalSystem AS _LogicalSystem,
  Act._ReferenceDocLogicalSystem AS _ReferenceDocLogicalSystem,
  Act._ReferenceDocumentType AS _ReferenceDocumentType,
  Act._SponsoredClass AS _SponsoredClass,
  Act._SponsoredClass._Type AS _SponsoredClassType,
  Act._SponsoredProgram AS _SponsoredProgram,
  Act._ValueType AS _ValueType
FROM I_GteeMCmtmtActlDocItem AS Act
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON FinancialManagementArea = _CommitmentItem.FinancialManagementArea AND CommitmentItem = _CommitmentItem.CommitmentItem AND ( FinMgmtAreaFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear OR _CommitmentItem.FinMgmtAreaFiscalYear = '0000')  -- association [0..*]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_GteeMBdgtValidityNumber AS _BudgetValidityNumber ON GrantID = _BudgetValidityNumber.GrantID AND GteeMBudgetValidityNumber = _BudgetValidityNumber.GteeMBudgetValidityNumber AND _BudgetValidityNumber.GranteeMgmtBdgtPhase = '3' AND _BudgetValidityNumber.GranteeMgmtBudgetStatus = 'R'  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_GteeMBdgtWorkFlowSts AS _GteeMBdgtWorkFlowSts ON GranteeMgmtBdgtWorkFlowSts = _GteeMBdgtWorkFlowSts.GranteeMgmtBdgtWorkFlowSts  -- association [0..1]
;