I_FundedProgramText

DDL: I_FUNDEDPROGRAMTEXT SQL: IFMFUNDEDPROGT Type: view BASIC
8 Fields 1 Data Sources 3 Associations

Funded Program - Text

I_FundedProgramText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

FundedProgramText · Accounting and Financial Close

I_FundedProgramText is a Basic CDS View that provides data about "Funded Program - Text" in SAP S/4HANA. It reads from 1 data source (fmmeasuret) and exposes 8 fields with key fields FinancialManagementArea, FundedProgram, Language. It has 3 associations to related views.

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-FM
CapabilitiesLanguage-Dependent Text, Data Source for Data Extraction
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
fmmeasuret fmmeasuret from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_FinancialManagementArea _FinMgmtArea $projection.FinancialManagementArea = _FinMgmtArea.FinancialManagementArea
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_FundedProgram _FundedProgram $projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea and $projection.FundedProgram = _FundedProgram.FundedProgram

Annotations (15)

NameValueLevelField
EndUserText.label Funded Program - Text view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey FundedProgram view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.dataCategory #TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.sqlViewName IFMFUNDEDPROGT view
ObjectModel.sapObjectNodeType.name FundedProgramText view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea fmarea Financial Management Area
KEY FundedProgram measure Funded Program
KEY Language language Report Text Language
FundedProgramName Funded Program Name
FundedProgramDescription Funded Program Description
_FinMgmtArea _FinMgmtArea
_Language _Language
_FundedProgram _FundedProgram

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_FundedProgramText.
-- 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: IFMFUNDEDPROGT

CREATE VIEW I_FundedProgramText AS
SELECT
  fmarea AS FinancialManagementArea,
  measure AS FundedProgram,
  Language,
  cast (short_desc as fmis_fp_name) AS FundedProgramName,
  cast (description as fmis_fp_description) AS FundedProgramDescription
FROM fmmeasuret
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND FundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
;

Learn More