I_BudgetDocumentItemReceiverTP

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_BudgetDocumentItemReceiverTP.
-- 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.

CREATE VIEW I_BudgetDocumentItemReceiverTP AS
SELECT
  BudgetDocument,
  BudgetDocumentYear,
  ControllingArea,
  BudgetDocumentItem,
  BudgetDocumentItem AS BudgetDocumentItemForEdit,
  ControllingArea AS ControllingAreaForEdit,
  BudgetCategory,
  CompanyCode,
  GLAccount,
  CostCenter,
  FunctionalArea,
  FiscalYear,
  FinancialManagementArea,
  Fund,
  GrantID,
  SponsoredProgram,
  SponsoredClass,
  GteeMBudgetValidityNumber,
  BudgetPeriod,
  WBSElement,
  WBSElementInternalID,
  _WBSElement.ProfitCenter AS ProfitCenter,
  Project,
  ProjectInternalID,
  FiscalPeriod,
  BudgetProcess,
  BudgetingType,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  ControllingObjectCurrency,
  BudgetDocumentLineItemDesc
FROM I_BudgetDocumentItemBasic
LEFT OUTER JOIN I_BudgetDocumentTP AS _BudgetDocument ON ControllingArea = _BudgetDocument.ControllingArea AND BudgetDocument = _BudgetDocument.BudgetDocument AND BudgetDocumentYear = _BudgetDocument.BudgetDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [1..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_BudgetPlanningCategory AS _PlanningCategory ON BudgetCategory = _PlanningCategory.PlanningCategory  -- association [1..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _LedgerFiscalYear ON FiscalYear = _LedgerFiscalYear.FiscalYear AND CompanyCode = _LedgerFiscalYear.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
;