I_ActiveCostElementWithDraft

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_ActiveCostElementWithDraft.
-- 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: IFIACOSTELMNT

CREATE VIEW I_ActiveCostElementWithDraft AS
SELECT
  ActiveDocument.ChartOfAccounts AS ChartOfAccounts,
  ActiveDocument.ControllingArea AS ControllingArea,
  ActiveDocument.GLAccount AS GLAccount,
  ActiveDocument.ValidityStartDate AS ValidityStartDate,
  ActiveDocument.ValidityEndDate AS ValidityEndDate,
  ActiveDocument.CostElementCategory AS CostElementCategory,
  ActiveDocument.ConsumptionQtyIsRecorded AS ConsumptionQtyIsRecorded,
  ActiveDocument.UnitOfMeasure AS UnitOfMeasure,
  ActiveDocument.CreationDate AS CreationDate,
  ActiveDocument.CreatedByUser AS CreatedByUser,
  ActiveDocument.FunctionalArea AS FunctionalArea,
  ActiveDocument.AcctAssignmentIsStatistical AS AcctAssignmentIsStatistical,
  _GLAccountInChartOfAccounts._GLAcctInChartOfAcctsStatus.GLAcctCOAImplementStatus AS GLAcctCOAImplementStatus,
  _GLAccountInChartOfAccounts._GLAcctInChartOfAcctsStatus.GLAccountCOAIsDeliveredBySAP AS GLAccountCOAIsDeliveredBySAP,
  DraftAdmin.DraftIsProcessedByMe AS DraftIsProcessedByMe,
  DraftAdmin.InProcessByUser AS InProcessByUser,
  DraftAdmin.InProcessByUserDescription AS InProcessByUserDescription,
  ActiveDocument.LastChangeDateTime AS LastChangeDateTime,
  _GLAccountInChartOfAccounts.GLAccountType AS GLAccountType
FROM I_CostElement AS ActiveDocument
LEFT OUTER JOIN I_DraftAdministrativeData AS DraftAdmin ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_CostElementCategory AS _CostElementCategory ON CostElementCategory = _CostElementCategory.CostElementCategory  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _Text ON ChartOfAccounts = _Text.ChartOfAccounts AND GLAccount = _Text.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAcctTxtInMaintLang AS _GLAcctTxtInMaintLang ON ChartOfAccounts = _GLAcctTxtInMaintLang.ChartOfAccounts AND GLAccount = _GLAcctTxtInMaintLang.GLAccount  -- association [0..1]
;