C_CommitmentItem_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_CommitmentItem_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: CCOMMITIOBJP

CREATE VIEW C_CommitmentItem_ObjP AS
SELECT
  I_CommitmentItem.FinancialManagementArea AS FinancialManagementArea,
  I_CommitmentItem.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  I_CommitmentItem.CommitmentItem AS CommitmentItem,
  I_CommitmentItem.CommitmentItemShortID AS CommitmentItemShortID,
  I_CommitmentItem.CommitmentItemIsPostingEnabled AS CommitmentItemIsPostingEnabled,
  I_CommitmentItem.CmtmtItmFinancialTransaction AS CmtmtItmFinancialTransaction,
  I_CommitmentItem._FinancialTransaction._Text[1:Language = $session.system_language].CmtmtItmFinTransactionText AS CmtmtItmFinTransactionText,
  I_CommitmentItem.CommitmentItemCategory AS CommitmentItemCategory,
  I_CommitmentItem._CommitmentItemCategory._Text[1:Language = $session.system_language].CommitmentItemCategoryName AS CommitmentItemCategoryName,
  I_CommitmentItem.CommitmentItemType AS CommitmentItemType,
  I_CommitmentItem.ParentCommitmentItem AS ParentCommitmentItem,
  I_CommitmentItem.CommitmentItemInternalId AS CommitmentItemInternalId,
  I_CommitmentItem.CmtmtItmDefaultFundsCenter AS CmtmtItmDefaultFundsCenter,
  _FundsCenter.FundsCenterName AS FundsCenterName,
  _FundsCenter.FundsCenterDescription AS FundsCenterDescription,
  I_CommitmentItem.CmtmtItmCarryFwdItmCategory AS CmtmtItmCarryFwdItmCategory,
  I_CommitmentItem.CommitmentItemAuthznGrp AS CommitmentItemAuthznGrp,
  I_CommitmentItem.CommitmentItemIsStatistical AS CommitmentItemIsStatistical,
  I_CommitmentItem.CommitmentItemRequestType AS CommitmentItemRequestType,
  I_CommitmentItem._CommitmentItemHierarchy[1:CommitmentItemHierarchyVariant = '000'].CreatedByUser AS CreatedByUser,
  I_CommitmentItem._CommitmentItemHierarchy[1:CommitmentItemHierarchyVariant = '000'].CreationDate AS CreationDate,
  I_CommitmentItem._FinMgmtArea.FinMgmtAreaFiscalYearVariant AS FinMgmtAreaFiscalYearVariant,
  I_CommitmentItem.CmtmtItemFinMgmtAreaForAuthzn AS CmtmtItemFinMgmtAreaForAuthzn,
  I_CommitmentItem._FinMgmtArea._Text[1:Language = $session.system_language].FinancialManagementAreaName AS FinancialManagementAreaName,
  cast( concat_with_space(FinancialManagementArea, _FinMgmtArea._Text[1:Language = $session.system_language].FinancialManagementAreaName, 1) as fmis_fmaextendedname ) AS FinMgmtAreaExtendedName,
  _Text[1:Language=$session.system_language].CommitmentItemName AS CommitmentItemName,
  I_CommitmentItem.ValidityEndDate AS ValidityEndDate,
  I_CommitmentItem.ValidityStartDate AS ValidityStartDate,
  I_CommitmentItem.CommitmentItemExpirationDate AS CommitmentItemExpirationDate
FROM I_CommitmentItem
LEFT OUTER JOIN C_GlAccountByFinMgmtArea AS _GLAccount ON FinancialManagementArea = _GLAccount.FinancialManagementArea AND CommitmentItemShortID = _GLAccount.CommitmentItemShortID  -- association [0..*]
LEFT OUTER JOIN C_OplAcctgDocItemForObjp AS _AccountingLine ON FinancialManagementArea = _AccountingLine.CompanyCode AND CommitmentItemShortID = _AccountingLine.CommitmentItemShortID  -- association [0..*]
LEFT OUTER JOIN C_BudDocItemForObjP AS _BudgetEntryDocument ON FinancialManagementArea = _BudgetEntryDocument.FinancialManagementArea AND CommitmentItem = _BudgetEntryDocument.BudgetedCommitmentItem  -- association [0..*]
LEFT OUTER JOIN C_PurchaseOrderByFMAA AS _PurchaseOrder ON FinancialManagementArea = _PurchaseOrder.FinancialManagementArea AND CommitmentItem = _PurchaseOrder.PostedCommitmentItem  -- association [0..*]
LEFT OUTER JOIN C_PurchaseRequisitionByFMAA AS _PurchaseRequisition ON FinancialManagementArea = _PurchaseRequisition.FinancialManagementArea AND CommitmentItem = _PurchaseRequisition.PostedCommitmentItem  -- association [0..*]
LEFT OUTER JOIN C_EarmarkedFundsItemForObjP AS _EarmarkedFundsItem ON FinancialManagementArea = _EarmarkedFundsItem.FinancialManagementArea AND CommitmentItem = _EarmarkedFundsItem.CommitmentItem  -- association [0..*]
LEFT OUTER JOIN C_LastValidFundsCenterWST AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND CmtmtItmDefaultFundsCenter = _FundsCenter.FundsCenter  -- association [0..1]
LEFT OUTER JOIN C_SetLeafForCIObjP AS _Sets ON _Sets.SetClass = '0311' AND CommitmentItem = _Sets.CommitmentItem AND FinancialManagementArea = _Sets.SetSubClass  -- association [0..*]
;