P_GteeMIndrctCostRelevantItem

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_GteeMIndrctCostRelevantItem.
-- 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: PGMIDCRLVTITEM

CREATE VIEW P_GteeMIndrctCostRelevantItem AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  AccountingDocumentItem,
  SplitInformationSequenceNumber,
  GrantID,
  _Grant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  _Grant.GrantType AS GrantType,
  _Grant.GteeMIndrctCostShrngRule AS GteeMIndrctCostShrngRule,
  _Grant.GrantLifecycleStatus AS GrantLifecycleStatus,
  _Grant.ValidityStartDate AS ValidityStartDate,
  _Grant.ValidityEndDate AS ValidityEndDate,
  _GrantSponsoredClassesLink.SpnsrdClIsIndrctCostShrngRlvt AS SpnsrdClIsIndrctCostShrngRlvt,
  _SponsoredClass.SponsoredClassType AS SponsoredClassType,
  _GrantOverheadCostLink.GteeMIndirectCostRateInPercent AS GteeMIndirectCostRateInPercent,
  SponsoredProgram,
  SponsoredClass,
  Fund,
  _Fund._FundType.GranteeMgmtFundType AS GranteeMgmtFundType,
  LedgerFiscalYear,
  FiscalYearPeriod,
  FiscalYearVariant,
  LogicalSystem,
  AccountingDocumentCategory,
  AccountingDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  IsReversal,
  IsReversed,
  AccountingDocCreatedByUser,
  LastChangeDateTime,
  CreationDateTime,
  CreationDate,
  PostingDate,
  PubSecBudgetCnsmpnDate,
  ChartOfAccounts,
  GLAccountType,
  BusinessTransactionType,
  FinancialTransactionType,
  ControllingArea,
  PubSecBudgetCnsmpnType,
  FinancialManagementArea,
  GLAccount,
  BudgetPeriod,
  FunctionalArea,
  CostCenter,
  WBSElementInternalID,
  ProfitCenter,
  MasterFixedAsset,
  FixedAsset,
  Product,
  BusinessArea,
  OrderID,
  Segment,
  PubSecBudgetAccountCoCode,
  PubSecBudgetAccount,
  CashLedgerCompanyCode,
  CashLedgerAccount,
  TaxCode,
  DebitCreditCode,
  PostingKey,
  AmountInTransactionCurrency,
  TransactionCurrency,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  _Grant._Sponsor AS _Sponsor,
  _Grant._GrantType AS _GrantType,
  _Grant._IndirectCostSharingRule AS _IndirectCostSharingRule,
  _Grant._GrantLifecycleStatus AS _GrantLifecycleStatus,
  _SponsoredClass._Type AS _Type,
  _Fund._FundType._GranteeMgmtFundType AS _GranteeMgmtFundType
FROM P_GteeMIndrctCostLbltyActLItem
LEFT OUTER JOIN I_GrantSponsoredClassesLink AS _GrantSponsoredClassesLink ON GrantID = _GrantSponsoredClassesLink.GrantID AND SponsoredClass = _GrantSponsoredClassesLink.SponsoredClass  -- association [1..1]
LEFT OUTER JOIN I_GrantOverHeadCostLink AS _GrantOverheadCostLink ON GrantID = _GrantOverheadCostLink.GrantID AND SponsoredClass = _GrantOverheadCostLink.SponsoredClass AND SponsoredProgram = _GrantOverheadCostLink.SponsoredProgram AND PostingDate >= _GrantOverheadCostLink.ValidityStartDate AND PostingDate <= _GrantOverheadCostLink.ValidityEndDate  -- association [1..1]
;