I_FundedProgramTP

DDL: I_FUNDEDPROGRAMTP SQL: IFUNDEDPROGTP Type: view TRANSACTIONAL
20 Fields 1 Data Sources 2 Associations

Manage Funded Programs

I_FundedProgramTP is a Transactional CDS View that provides data about "Manage Funded Programs" in SAP S/4HANA. It reads from 1 data source (I_FundedProgram) and exposes 20 fields with key fields FinancialManagementArea, FundedProgram. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FundedProgram iFundedProgram from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_FundedProgramType _FundedProgramType $projection.FundedProgramType = _FundedProgramType.FundedProgramType
[1..1] E_FundedProgram _Extension $projection.FinancialManagementArea = _Extension.FinancialManagementArea and $projection.FundedProgram = _Extension.FundedProgram

Annotations (23)

NameValueLevelField
AbapCatalog.sqlViewName IFUNDEDPROGTP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manage Funded Programs view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.createEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.representativeKey FundedProgram view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.writeDraftPersistence FMFUNDEDPR_DRAFT view
ObjectModel.entityChangeStateId EXTERNAL_CALCULATION view
ObjectModel.lifecycle.draft.expiryBehavior #RELATIVE_TO_PROCESSING_START view
ObjectModel.lifecycle.draft.expiryInterval P5D view
ObjectModel.sapObjectNodeType.name FundedProgram view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea I_FundedProgram FinancialManagementArea FM Area
KEY FundedProgram I_FundedProgram FundedProgram Funded Program
FinancialManagementAreaForEdit I_FundedProgram FinancialManagementArea FM Area
FundedProgramForEdit I_FundedProgram FundedProgram Funded Program
FundedProgramType I_FundedProgram FundedProgramType
FundedProgramAuthznGrp I_FundedProgram FundedProgramAuthznGrp
CreatedByUser I_FundedProgram CreatedByUser User Name
CreationDate I_FundedProgram CreationDate Time Stamp
CreationTime I_FundedProgram CreationTime Time of Change
LastChangedByUser I_FundedProgram LastChangedByUser User Name
LastChangeDate I_FundedProgram LastChangeDate Time Stamp
LastChangeTime I_FundedProgram LastChangeTime Time changed
ValidityStartDate I_FundedProgram ValidityStartDate Validity Start Date
ValidityEndDate I_FundedProgram ValidityEndDate ValidTo
FundedProgramExpirationDate I_FundedProgram FundedProgramExpirationDate
FundedProgramName
FundedProgramDescription
FundedPgmFinMgmtAreaForAuthzn I_FundedProgram FundedPgmFinMgmtAreaForAuthzn
_FinMgmtArea I_FundedProgram _FinMgmtArea
_FundedProgramType _FundedProgramType

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_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: IFUNDEDPROGTP

CREATE VIEW I_FundedProgramTP AS
SELECT
  iFundedProgram.FinancialManagementArea AS FinancialManagementArea,
  iFundedProgram.FundedProgram AS FundedProgram,
  iFundedProgram.FinancialManagementArea AS FinancialManagementAreaForEdit,
  iFundedProgram.FundedProgram AS FundedProgramForEdit,
  iFundedProgram.FundedProgramType AS FundedProgramType,
  iFundedProgram.FundedProgramAuthznGrp AS FundedProgramAuthznGrp,
  iFundedProgram.CreatedByUser AS CreatedByUser,
  iFundedProgram.CreationDate AS CreationDate,
  iFundedProgram.CreationTime AS CreationTime,
  iFundedProgram.LastChangedByUser AS LastChangedByUser,
  iFundedProgram.LastChangeDate AS LastChangeDate,
  iFundedProgram.LastChangeTime AS LastChangeTime,
  iFundedProgram.ValidityStartDate AS ValidityStartDate,
  iFundedProgram.ValidityEndDate AS ValidityEndDate,
  iFundedProgram.FundedProgramExpirationDate AS FundedProgramExpirationDate,
  iFundedProgram._Text[1:Language = $session.system_language].FundedProgramName AS FundedProgramName,
  iFundedProgram._Text[1:Language = $session.system_language].FundedProgramDescription AS FundedProgramDescription,
  iFundedProgram.FundedPgmFinMgmtAreaForAuthzn AS FundedPgmFinMgmtAreaForAuthzn,
  iFundedProgram._FinMgmtArea AS _FinMgmtArea
FROM I_FundedProgram AS iFundedProgram
LEFT OUTER JOIN I_FundedProgramType AS _FundedProgramType ON FundedProgramType = _FundedProgramType.FundedProgramType  -- association [0..1]
LEFT OUTER JOIN E_FundedProgram AS _Extension ON FinancialManagementArea = _Extension.FinancialManagementArea AND FundedProgram = _Extension.FundedProgram  -- association [1..1]
;

Learn More