I_CommitmentItemBasic

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_CommitmentItemBasic.
-- 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: ICOMMITEMB

CREATE VIEW I_CommitmentItemBasic AS
SELECT
  fikrs AS FinancialManagementArea,
  cast( gjahr as fmis_fma_fiscal_year preserving type ) AS FinMgmtAreaFiscalYear,
  fipex AS CommitmentItem,
  cast( fipos as fmis_ci_internalname preserving type ) AS CommitmentItemShortID,
  kateg AS CommitmentItemIsPostingEnabled,
  fivor AS CmtmtItmFinancialTransaction,
  potyp AS CommitmentItemCategory,
  fpart AS CommitmentItemType,
  cast( fipup as fmis_ci_superior preserving type ) AS ParentCommitmentItem,
  cast( posit as fmis_ci_internalid preserving type ) AS CommitmentItemInternalId,
  fictr AS FundsCenter,
  cast( fictr as fmis_ci_defaultfc preserving type ) AS CmtmtItmDefaultFundsCenter,
  vptyp AS CmtmtItmCarryFwdItmCategory,
  stats AS CommitmentItemIsStatistical,
  augrp AS CommitmentItemAuthznGrp,
  cast( datbis as fmis_ci_validityenddate preserving type ) AS ValidityEndDate,
  cast( datab as fmis_ci_validitystartdate preserving type ) AS ValidityStartDate,
  cast( date_exp as fmis_ci_expirationdate preserving type ) AS CommitmentItemExpirationDate,
  _CommitmentItemHierarchy[1:CommitmentItemHierarchyVariant = '000'].CreationDate AS CreationDate,
  _CommitmentItemHierarchy[1:CommitmentItemHierarchyVariant = '000'].CreatedByUser AS CreatedByUser
FROM fmci
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_CommitmentItemText AS _Text ON FinancialManagementArea = _Text.FinancialManagementArea AND FinMgmtAreaFiscalYear = _Text.FinMgmtAreaFiscalYear AND CommitmentItem = _Text.CommitmentItem  -- association [0..*]
LEFT OUTER JOIN I_CmtmtItmFinancialTransaction AS _FinancialTransaction ON CmtmtItmFinancialTransaction = _FinancialTransaction.CmtmtItmFinancialTransaction  -- association [1..1]
LEFT OUTER JOIN I_CommitmentItemCategory AS _CommitmentItemCategory ON CommitmentItemCategory = _CommitmentItemCategory.CommitmentItemCategory  -- association [1..1]
LEFT OUTER JOIN I_CmtmtItmIsPostingEnabled AS _CmtmtItmIsPostingEnabled ON CommitmentItemIsPostingEnabled = _CmtmtItmIsPostingEnabled.CommitmentItemIsPostingEnabled  -- association [1..1]
LEFT OUTER JOIN I_CommitmentItemHierarchy AS _CommitmentItemHierarchy ON FinancialManagementArea = _CommitmentItemHierarchy.FinancialManagementArea AND FinMgmtAreaFiscalYear = _CommitmentItemHierarchy.FinMgmtAreaFiscalYear AND CommitmentItem = _CommitmentItemHierarchy.CommitmentItem  -- association [1..*]
LEFT OUTER JOIN I_CommitmentItemHierarchyNode AS _CommitmentItemHierarchyNode ON FinancialManagementArea = _CommitmentItemHierarchyNode.FinancialManagementArea AND CommitmentItem = _CommitmentItemHierarchyNode.CommitmentItem AND FinMgmtAreaFiscalYear = _CommitmentItemHierarchyNode.CommitmentItemFiscalYear  -- association [0..*]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItemParent ON FinancialManagementArea = _CommitmentItemParent.FinancialManagementArea AND ParentCommitmentItem = _CommitmentItemParent.CommitmentItem AND FinMgmtAreaFiscalYear = _CommitmentItemParent.FinMgmtAreaFiscalYear  -- association [0..1]
;