I_BudgetDocumentItemBasic

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_BudgetDocumentItemBasic.
-- 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: IBDGTDOCITBASIC

CREATE VIEW I_BudgetDocumentItemBasic AS
SELECT
  kokrs AS ControllingArea,
  BudgetDocument,
  cast( BudgetDocumentYear as gjahr ) AS BudgetDocumentYear,
  BudgetDocumentItem,
  category AS BudgetCategory,
  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,
  rsponsored_prog AS SponsoredProgram,
  rsponsored_class AS SponsoredClass,
  rbdgt_vldty_nbr AS GteeMBudgetValidityNumber,
  ps_posid AS WBSElement,
  cast( ps_psp_pnr as ps_posnr ) AS WBSElementInternalID,
  ps_pspid AS Project,
  cast( ps_prj_pnr as ps_s4_proj_pspnr ) AS ProjectInternalID,
  poper AS FiscalPeriod,
  BudgetProcess,
  BudgetSubCategory AS BudgetingType,
  rwcur AS TransactionCurrency,
  wsl AS AmountInTransactionCurrency,
  rhcur AS CompanyCodeCurrency,
  hsl AS AmountInCompanyCodeCurrency,
  rkcur AS GlobalCurrency,
  ksl AS AmountInGlobalCurrency,
  rco_ocur AS ControllingObjectCurrency,
  co_osl AS AmountInObjectCurrency,
  BudgetDocumentLineItemDesc
FROM P_Acdocp_BdgtDoc_Item
LEFT OUTER JOIN I_BudgetDocument AS _BudgetDocument ON ControllingArea = _BudgetDocument.ControllingArea AND BudgetDocumentYear = _BudgetDocument.BudgetDocumentYear AND BudgetDocument = _BudgetDocument.BudgetDocument  -- association [1..1]
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_BudgetPlanningCategory AS _PlanningCategory ON BudgetCategory = _PlanningCategory.PlanningCategory  -- 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_BudgetProcess AS _BudgetProcess ON BudgetProcess = _BudgetProcess.BudgetProcess  -- association [0..1]
LEFT OUTER JOIN I_BudgetingType AS _BudgetingType ON BudgetingType = _BudgetingType.BudgetingType  -- association [0..1]
;