C_FundedProgramTP

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_FundedProgramTP.
-- 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: CFUNDEDPROGTP

CREATE VIEW C_FundedProgramTP AS
SELECT
  iFundedProgram.FinancialManagementArea AS FinancialManagementArea,
  iFundedProgram.FundedProgram AS FundedProgram,
  iFundedProgram.FinancialManagementAreaForEdit AS FinancialManagementAreaForEdit,
  iFundedProgram.FundedProgramForEdit AS FundedProgramForEdit,
  iFundedProgram.FundedProgramName AS FundedProgramName,
  iFundedProgram.FundedProgramDescription AS FundedProgramDescription,
  iFundedProgram.ValidityStartDate AS ValidityStartDate,
  iFundedProgram.ValidityEndDate AS ValidityEndDate,
  iFundedProgram.FundedProgramExpirationDate AS FundedProgramExpirationDate,
  iFundedProgram.FundedProgramType AS FundedProgramType,
  iFundedProgram.FundedProgramAuthznGrp AS FundedProgramAuthznGrp,
  iFundedProgram.CreatedByUser AS CreatedByUser,
  iFundedProgram.CreationDate AS CreationDate,
  iFundedProgram.LastChangedByUser AS LastChangedByUser,
  iFundedProgram.LastChangeDate AS LastChangeDate,
  iFundedProgram.FundedPgmFinMgmtAreaForAuthzn AS FundedPgmFinMgmtAreaForAuthzn,
  iFundedProgram._FinMgmtArea AS _FinMgmtArea,
  iFundedProgram._FundedProgramType AS _FundedProgramType
FROM I_FundedProgramTP AS iFundedProgram
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..*]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea1VH ON FinancialManagementAreaForEdit = _FinMgmtArea1VH.FinancialManagementArea  -- association [1]
;