I_ApplicationOfFundText

DDL: I_APPLICATIONOFFUNDTEXT SQL: IAPPLOFFUNDT Type: view BASIC

Application of Fund - Text

I_ApplicationOfFundText (Basic)

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

Cross Applications

I_ApplicationOfFundText is a Basic CDS View that provides data about "Application of Fund - Text" in SAP S/4HANA. It reads from 1 data source (fmfuset) and exposes 7 fields with key fields FinancialManagementArea, ApplicationOfFunds, Language. It has 2 associations to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentPSM-FM-MD
CapabilitiesLanguage-Dependent Text
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
fmfuset fmfuset from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FinancialManagementArea _FinMgmtArea $projection.FinancialManagementArea = _FinMgmtArea.FinancialManagementArea
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
EndUserText.label Application of Fund - Text view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey ApplicationOfFunds view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IAPPLOFFUNDT view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea fikrs Financial Management Area
KEY ApplicationOfFunds finuse Application of Funds
KEY Language spras Off. Language
ApplicationOfFundsName Application of Funds Name
ApplicationOfFundsDescription Application of Funds Description
_FinMgmtArea _FinMgmtArea
_Language _Language

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_ApplicationOfFundText.
-- 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: IAPPLOFFUNDT

CREATE VIEW I_ApplicationOfFundText AS
SELECT
  fikrs AS FinancialManagementArea,
  finuse AS ApplicationOfFunds,
  spras AS Language,
  cast( bezeich as fmis_apploffunds_name ) AS ApplicationOfFundsName,
  cast( beschr as fmis_apploffunds_description ) AS ApplicationOfFundsDescription
FROM fmfuset
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]
;