I_FiscalYearForCommitmentItem

DDL: I_FISCALYEARFORCOMMITMENTITEM SQL: IFY4CMT Type: view COMPOSITE
3 Fields 1 Data Sources 1 Associations

Fiscal years of Commitment Item

I_FiscalYearForCommitmentItem (Composite)

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

Cross Applications

I_FiscalYearForCommitmentItem is a Composite CDS View (Dimension) that provides data about "Fiscal years of Commitment Item" in SAP S/4HANA. It reads from 1 data source (I_FiscalYearForCmtmtItemBsc) and exposes 3 fields with key fields FinancialManagementArea, CommitmentItemFiscalYear. 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, Data Provider for Analytical Queries, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Data Extraction
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_FiscalYearForCmtmtItemBsc FM from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_FinancialManagementArea _FinMgmtArea $projection.FinancialManagementArea = _FinMgmtArea.FinancialManagementArea

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IFY4CMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Fiscal years of Commitment Item view
ObjectModel.representativeKey CommitmentItemFiscalYear view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE view
Analytics.dataExtraction.enabled true view
Metadata.allowExtensions true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Metadata.ignorePropagatedAnnotations true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea FinancialManagementArea Financial Management Area
KEY CommitmentItemFiscalYear CommitmentItemFiscalYear Fiscal Year of Commitment Item
_FinMgmtArea _FinMgmtArea

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_FiscalYearForCommitmentItem.
-- 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: IFY4CMT

CREATE VIEW I_FiscalYearForCommitmentItem AS
SELECT
  FinancialManagementArea,
  CommitmentItemFiscalYear
FROM I_FiscalYearForCmtmtItemBsc AS FM
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
;

Learn More