C_BudgetPeriod_ObjP

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_BudgetPeriod_ObjP.
-- 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: CBUDGETPDOBJP

CREATE VIEW C_BudgetPeriod_ObjP AS
SELECT
  I_BudgetPeriod.BudgetPeriod AS BudgetPeriod,
  I_BudgetPeriod.ValidityStartDate AS ValidityStartDate,
  I_BudgetPeriod.ValidityEndDate AS ValidityEndDate,
  I_BudgetPeriod.BudgetPeriodAuthznGrp AS BudgetPeriodAuthznGrp,
  I_BudgetPeriod.BudgetPeriodExpirationDate AS BudgetPeriodExpirationDate,
  I_BudgetPeriod.BudgetPeriodReversalDate AS BudgetPeriodReversalDate,
  I_BudgetPeriod.CreatedByUser AS CreatedByUser,
  I_BudgetPeriod.CreationDate AS CreationDate,
  I_BudgetPeriod.LastChangeUser AS LastChangeUser,
  I_BudgetPeriod.LastChangeDate AS LastChangeDate,
  _Text[Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName
FROM I_BudgetPeriod
LEFT OUTER JOIN C_FundToBudgetPeriod AS _FundToBP ON BudgetPeriod = _FundToBP.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN C_FixedAssetsForFundsMgmt AS _FixedAsset ON BudgetPeriod = _FixedAsset.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN C_BudDocItemForObjP AS _BudgetEntryDocument ON BudgetPeriod = _BudgetEntryDocument.BudgetedBudgetPeriod  -- association [0..*]
LEFT OUTER JOIN C_EarmarkedFundsItemForObjP AS _EarmarkedFundsItem ON BudgetPeriod = _EarmarkedFundsItem.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN C_PurchaseOrderByFMAA AS _PurchaseOrder ON BudgetPeriod = _PurchaseOrder.PostedBudgetPeriod  -- association [0..*]
LEFT OUTER JOIN C_PurchaseRequisitionByFMAA AS _PurchaseRequisition ON BudgetPeriod = _PurchaseRequisition.PostedBudgetPeriod  -- association [0..*]
LEFT OUTER JOIN C_JrnlEntrItmByLeadingLdgr_FM AS _AccountingLine ON _AccountingLine.BudgetPeriod = BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN C_SetleafForBPObjp AS _Sets ON _Sets.SetClass = '0114' AND BudgetPeriod = _Sets.BudgetPeriod  -- association [0..*]
;