I_CostElementTP

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_CostElementTP.
-- 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: ICOELTP

CREATE VIEW I_CostElementTP AS
SELECT
  I_CostElement.ChartOfAccounts AS ChartOfAccounts,
  I_CostElement.GLAccount AS GLAccount,
  I_CostElement.ControllingArea AS ControllingArea,
  I_CostElement.ControllingArea AS ControllingAreaForEdit,
  _GLAcctInChtAcctsTP.ChartOfAccounts AS ChartOfAccountsForEdit,
  _GLAcctInChtAcctsTP.GLAccountForEdit AS GLAccountForEdit,
  ValidityStartDate,
  ValidityEndDate,
  CostElementCategory,
  ConsumptionQtyIsRecorded,
  UnitOfMeasure,
  CreationDate,
  CreatedByUser,
  FunctionalArea,
  AcctAssignmentIsStatistical
FROM I_CostElement
LEFT OUTER JOIN P_GLAcctNotMarkForDeletion AS _PostableGLAccount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAcctInChtAcctsTP AS _GLAcctInChtAcctsTP ON ChartOfAccounts = _GLAcctInChtAcctsTP.ChartOfAccounts AND GLAccount = _GLAcctInChtAcctsTP.GLAccount  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingAreaForEdit = _ControllingArea.ControllingArea AND ChartOfAccountsForEdit = _ControllingArea.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CostElementCategory AS _CostElementCategory ON CostElementCategory = _CostElementCategory.CostElementCategory  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
;