I_ApplicationOfFund

DDL: I_APPLICATIONOFFUND SQL: IAPPLOFFUND Type: view COMPOSITE

Application of Fund

I_ApplicationOfFund (Composite)

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

Application Of Fund · Cross Applications

I_ApplicationOfFund is a Composite CDS View (Dimension) that provides data about "Application of Fund" in SAP S/4HANA. It reads from 1 data source (I_ApplicationOfFundBasic) and exposes 19 fields with key fields FinancialManagementArea, ApplicationOfFunds. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentPSM-FM-MD
CapabilitiesAnalytical Dimension, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Data Extraction
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ApplicationOfFundBasic I_ApplicationOfFundBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_ApplicationOfFund _Extension $projection.FinancialManagementArea = _Extension.FinancialManagementArea and $projection.ApplicationOfFunds = _Extension.ApplicationOfFunds

Annotations (18)

NameValueLevelField
EndUserText.label Application of Fund view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE 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.sapObjectNodeType.name ApplicationOfFund view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IAPPLOFFUND view
Search.searchable true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea FinancialManagementArea Financial Management Area
KEY ApplicationOfFunds ApplicationOfFunds Application of Funds
ValidityStartDate ValidityStartDate Application of Funds Validity Start Date
ValidityEndDate ValidityEndDate Application of Funds Validity End Date
CreatedByUser CreatedByUser Application of Funds Created by User
CreationDate CreationDate Application of Funds Created on Date
LastChangeUser LastChangeUser Application of Funds Last Changed by User
LastChangeDate LastChangeDate Application of Funds Last Changed on Date
US_FedGvmntDepartmentRegular US_FedGvmntDepartmentRegular Department Regular
US_FedGvmntDepartmentTransfer US_FedGvmntDepartmentTransfer Department Transfer
US_FedGvmntMainAccount US_FedGvmntMainAccount Main Account
US_FedGvmntSubAccount US_FedGvmntSubAccount Sub account
US_FedGvmntSplitSequenceNumber US_FedGvmntSplitSequenceNumber Split Sequence Number
US_IsFedGvmntFACTS2Relevant US_IsFedGvmntFACTS2Relevant FACTS II Relevant
US_FedGvmntPreparer US_FedGvmntPreparer Preparer ID
US_FedGvmntCertifier US_FedGvmntCertifier Certifier ID
_US_IsFedGvmntFACTS2Relevant _US_IsFedGvmntFACTS2Relevant
_FinMgmtArea _FinMgmtArea
_Text _Text

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_ApplicationOfFund.
-- 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: IAPPLOFFUND

CREATE VIEW I_ApplicationOfFund AS
SELECT
  FinancialManagementArea,
  ApplicationOfFunds,
  ValidityStartDate,
  ValidityEndDate,
  CreatedByUser,
  CreationDate,
  LastChangeUser,
  LastChangeDate,
  US_FedGvmntDepartmentRegular,
  US_FedGvmntDepartmentTransfer,
  US_FedGvmntMainAccount,
  US_FedGvmntSubAccount,
  US_FedGvmntSplitSequenceNumber,
  US_IsFedGvmntFACTS2Relevant,
  US_FedGvmntPreparer,
  US_FedGvmntCertifier
FROM I_ApplicationOfFundBasic
LEFT OUTER JOIN E_ApplicationOfFund AS _Extension ON FinancialManagementArea = _Extension.FinancialManagementArea AND ApplicationOfFunds = _Extension.ApplicationOfFunds  -- association [1..1]
;