I_BudgetDocumentItmSearchBasic

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_BudgetDocumentItmSearchBasic.
-- 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: IBDGTDOCITMESH

CREATE VIEW I_BudgetDocumentItmSearchBasic AS
SELECT
  kokrs AS ControllingArea,
  ryear AS BudgetDocumentYear,
  awref AS BudgetDocument,
  record AS BudgetDocumentItem,
  category AS PlanningCategory,
  rbukrs AS CompanyCode,
  racct AS GLAccount,
  rcntr AS CostCenter,
  rfarea AS FunctionalArea,
  ryear AS FiscalYear,
  fikrs AS FinancialManagementArea,
  rfund AS Fund,
  rbudget_pd AS BudgetPeriod,
  rgrant_nbr AS GrantID,
  cast( ps_posid as ps_posid_edit ) AS WBSElement,
  cast( ps_psp_pnr as ps_s4_pspnr ) AS WBSElementInternalID,
  cast( ps_pspid as ps_pspid_edit ) AS Project,
  cast( ps_prj_pnr as ps_s4_proj_pspnr ) AS ProjectInternalID,
  poper AS FiscalPeriod,
  budget_process AS BudgetProcess,
  budget_subcategory AS BudgetingType,
  cast( rwcur as fis_rwcur preserving type ) AS TransactionCurrency,
  cast( wsl as fis_wsl preserving type ) AS AmountInTransactionCurrency,
  cast( rhcur as fis_hwaer preserving type ) AS CompanyCodeCurrency,
  cast( hsl as fis_hsl preserving type ) AS AmountInCompanyCodeCurrency,
  cast( rkcur as fis_rkcur preserving type ) AS GlobalCurrency,
  cast( ksl as fis_ksl preserving type ) AS AmountInGlobalCurrency,
  cast( rco_ocur as fins_co_ocur preserving type ) AS ControllingObjectCurrency,
  cast( co_osl as fins_vco_ocur12 preserving type ) AS AmountInObjectCurrency
FROM acdocp
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ControllingAreaCurrency ON ControllingObjectCurrency = _ControllingAreaCurrency.Currency  -- 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_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_BudgetPlanningCategory AS _PlanningCategory ON PlanningCategory = _PlanningCategory.PlanningCategory  -- association [1..1]
LEFT OUTER JOIN I_BudgetProcess AS _BudgetProcess ON BudgetProcess = _BudgetProcess.BudgetProcess  -- association [0..1]
LEFT OUTER JOIN I_BudgetingType AS _BudgetingType ON BudgetingType = _BudgetingType.BudgetingType  -- association [0..1]
;