R_FundedProgramTP

DDL: R_FUNDEDPROGRAMTP Type: view_entity TRANSACTIONAL Package: PSM_FM_API
24 Fields 1 Data Sources 3 Associations

Manage Funded Program - TP

R_FundedProgramTP is a Transactional CDS View that provides data about "Manage Funded Program - TP" in SAP S/4HANA. It reads from 1 data source (I_FundedProgram) and exposes 24 fields with key fields FinancialManagementArea, FundedProgram. It has 3 associations to related views. Part of development package PSM_FM_API.

Data Sources (1)

SourceAliasJoin Type
I_FundedProgram iFundedProgram from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_User _user_created $projection.CreatedByUser = _user_created.UserID
[0..1] I_User _user_changed $projection.LastChangedByUser = _user_changed.UserID
[0..1] E_FundedProgram _Extension $projection.FundedProgram = _Extension.FundedProgram and $projection.FinancialManagementArea = _Extension.FinancialManagementArea

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Manage Funded Program - TP view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea I_FundedProgram FinancialManagementArea FM Area
KEY FundedProgram I_FundedProgram FundedProgram Funded Program
FundedProgramType I_FundedProgram FundedProgramType
ValidityStartDate I_FundedProgram ValidityStartDate Validity Start Date
ValidityEndDate I_FundedProgram ValidityEndDate ValidTo
FundedProgramExpirationDate I_FundedProgram FundedProgramExpirationDate
FundedProgramAuthznGrp I_FundedProgram FundedProgramAuthznGrp
FundedPgmFinMgmtAreaForAuthzn I_FundedProgram FundedPgmFinMgmtAreaForAuthzn
CreatedByUserDescription
LastChangedByUserDescription
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
FundedProgramName
FundedProgramDescription
_FinMgmtArea I_FundedProgram _FinMgmtArea
_Text I_FundedProgram _Text
_FundedProgramType I_FundedProgram _FundedProgramType
_CreatedByUser I_FundedProgram _CreatedByUser
_LastChangedByUser I_FundedProgram _LastChangedByUser
_FundedProgramHierarchyNode I_FundedProgram _FundedProgramHierarchyNode

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 R_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.

CREATE VIEW R_FundedProgramTP AS
SELECT
  iFundedProgram.FinancialManagementArea AS FinancialManagementArea,
  iFundedProgram.FundedProgram AS FundedProgram,
  iFundedProgram.FundedProgramType AS FundedProgramType,
  iFundedProgram.ValidityStartDate AS ValidityStartDate,
  iFundedProgram.ValidityEndDate AS ValidityEndDate,
  iFundedProgram.FundedProgramExpirationDate AS FundedProgramExpirationDate,
  iFundedProgram.FundedProgramAuthznGrp AS FundedProgramAuthznGrp,
  iFundedProgram.FundedPgmFinMgmtAreaForAuthzn AS FundedPgmFinMgmtAreaForAuthzn,
  cast( _user_created.UserDescription as vdm_createdbyuserdescription preserving type ) AS CreatedByUserDescription,
  cast( _user_changed.UserDescription as vdm_lastchangedbyuserdescripti preserving type ) AS LastChangedByUserDescription,
  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._Text[1:Language = $session.system_language].FundedProgramName AS FundedProgramName,
  iFundedProgram._Text[1:Language = $session.system_language].FundedProgramDescription AS FundedProgramDescription,
  iFundedProgram._FinMgmtArea AS _FinMgmtArea,
  iFundedProgram._Text AS _Text,
  iFundedProgram._FundedProgramType AS _FundedProgramType,
  iFundedProgram._CreatedByUser AS _CreatedByUser,
  iFundedProgram._LastChangedByUser AS _LastChangedByUser,
  iFundedProgram._FundedProgramHierarchyNode AS _FundedProgramHierarchyNode
FROM I_FundedProgram AS iFundedProgram
LEFT OUTER JOIN I_User AS _user_created ON CreatedByUser = _user_created.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _user_changed ON LastChangedByUser = _user_changed.UserID  -- association [0..1]
LEFT OUTER JOIN E_FundedProgram AS _Extension ON FundedProgram = _Extension.FundedProgram AND FinancialManagementArea = _Extension.FinancialManagementArea  -- association [0..1]
;

Learn More