C_FundedProgram_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_FundedProgram_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: CFPROGOBJP

CREATE VIEW C_FundedProgram_ObjP AS
SELECT
  I_FundedProgram.FinancialManagementArea AS FinancialManagementArea,
  I_FundedProgram.FundedProgram AS FundedProgram,
  I_FundedProgram.ValidityStartDate AS ValidityStartDate,
  I_FundedProgram.FundedProgramExpirationDate AS FundedProgramExpirationDate,
  I_FundedProgram.ValidityEndDate AS ValidityEndDate,
  I_FundedProgram.FundedProgramAuthznGrp AS FundedProgramAuthznGrp,
  I_FundedProgram.CreatedByUser AS CreatedByUser,
  I_FundedProgram.CreationDate AS CreationDate,
  I_FundedProgram.CreationTime AS CreationTime,
  I_FundedProgram.LastChangedByUser AS LastChangedByUser,
  I_FundedProgram.LastChangeDate AS LastChangeDate,
  I_FundedProgram.LastChangeTime AS LastChangeTime,
  I_FundedProgram.FundedProgramType AS FundedProgramType,
  I_FundedProgram._FundedProgramType._Text[1:Language=$session.system_language].FundedProgramTypeName AS FundedProgramTypeName,
  _Text[1:Language=$session.system_language].FundedProgramName AS FundedProgramName,
  I_FundedProgram._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,
  cast( concat_with_space(FundedProgramType, _FundedProgramType._Text[1:Language=$session.system_language].FundedProgramTypeName, 1)as fmis_measureexttypename ) AS FundedProgramExtendedTypeName,
  _Text[1:Language=$session.system_language].FundedProgramDescription AS FundedProgramDescription,
  I_FundedProgram.FundedPgmFinMgmtAreaForAuthzn AS FundedPgmFinMgmtAreaForAuthzn
FROM I_FundedProgram
LEFT OUTER JOIN C_BudDocItemForObjP AS _BudgetEntryDocument ON FinancialManagementArea = _BudgetEntryDocument.FinancialManagementArea AND FundedProgram = _BudgetEntryDocument.BudgetedFundedProgram  -- association [0..*]
LEFT OUTER JOIN C_EarmarkedFundsItemForObjP AS _EarmarkedFundsItem ON FinancialManagementArea = _EarmarkedFundsItem.FinancialManagementArea AND FundedProgram = _EarmarkedFundsItem.FundedProgram  -- association [0..*]
LEFT OUTER JOIN C_PurchaseOrderByFMAA AS _PurchaseOrder ON FinancialManagementArea = _PurchaseOrder.FinancialManagementArea AND FundedProgram = _PurchaseOrder.PostedFundedProgram  -- association [0..*]
LEFT OUTER JOIN C_PurchaseRequisitionByFMAA AS _PurchaseRequisition ON FinancialManagementArea = _PurchaseRequisition.FinancialManagementArea AND FundedProgram = _PurchaseRequisition.PostedFundedProgram  -- association [0..*]
LEFT OUTER JOIN C_JrnlEntrItmByLeadingLdgr_FM AS _AccountingLine ON FinancialManagementArea = _AccountingLine.FinancialManagementArea AND FundedProgram = _AccountingLine.FundedProgram  -- association [0..*]
LEFT OUTER JOIN C_Setleafforfundedprgmobjp AS _Sets ON _Sets.SetClass = '0315' AND FinancialManagementArea = _Sets.SetSubClass AND FundedProgram = _Sets.FundedProgram  -- association [0..*]
;