C_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 C_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.
-- SQL view name: CBDGTDOCITRECVTP

CREATE VIEW C_BudgetDocumentItemReceiverTP AS
SELECT
  ControllingArea,
  BudgetDocument,
  BudgetDocumentYear,
  BudgetDocumentItem,
  BudgetDocumentItemForEdit,
  BudgetingType,
  BudgetProcess,
  BudgetCategory,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  ControllingAreaForEdit,
  SponsoredProgram,
  SponsoredClass,
  GteeMBudgetValidityNumber,
  Fund,
  BudgetPeriod,
  CostCenter,
  GLAccount,
  FunctionalArea,
  GrantID,
  WBSElement,
  WBSElementInternalID,
  Project,
  ProjectInternalID,
  FiscalPeriod,
  ProfitCenter,
  FiscalYear,
  FinancialManagementArea,
  cast( '' as bdgt_p_rkcur ) AS BudgetAmountCurrency,
  cast( cast( 0 as abap.curr( 23, 2 ) ) as bdgt_p_ksl ) AS BudgetAmountInBdgtAmtCrcy,
  cast( '' as bdgt_rkcur ) AS AvailableAmountCurrency,
  cast( cast( 0 as abap.curr( 23, 2 ) ) as bdgt_ksl ) AS AvailableAmountInAvailAmtCrcy,
  cast( '' as bdgt_control_obj_addr ) AS ControlObject,
  GlobalCurrency,
  AmountInGlobalCurrency,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  BudgetDocumentLineItemDesc
FROM I_BudgetDocumentItemReceiverTP AS BudgetDocumentItem
LEFT OUTER JOIN C_BudgetDocumentTP AS _BudgetDocument ON ControllingArea = _BudgetDocument.ControllingArea AND BudgetDocumentYear = _BudgetDocument.BudgetDocumentYear AND BudgetDocument = _BudgetDocument.BudgetDocument  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaForEdit ON ControllingAreaForEdit = _ControllingAreaForEdit.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_FundText AS _FundText ON _FundText.FinancialManagementArea = BudgetDocumentItem.FinancialManagementArea AND Fund = _FundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount AND ChartOfAccounts = _GLAccountText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID  -- association [0..*]
LEFT OUTER JOIN I_SponsoredClassText AS _SponsoredClassText ON SponsoredClass = _SponsoredClassText.SponsoredClass  -- association [0..*]
LEFT OUTER JOIN I_SponsoredProgramText AS _SponsoredProgramText ON SponsoredProgram = _SponsoredProgramText.SponsoredProgram  -- association [0..*]
LEFT OUTER JOIN I_BudgetingTypeText AS _BudgetingTypeText ON BudgetingType = _BudgetingTypeText.BudgetingType  -- association [0..*]
LEFT OUTER JOIN I_BudgetProcessText AS _BudgetProcessText ON BudgetProcess = _BudgetProcessText.BudgetProcess AND _BudgetProcessText.Language = $session.system_language  -- association [0..1]
;