I_FinStmntPredictedAmt

DDL: I_FINSTMNTPREDICTEDAMT SQL: IFSIAMNTPREDOUT Type: view COMPOSITE
20 Fields 1 Data Sources 3 Associations

Financial Statement Predicted Amount

I_FinStmntPredictedAmt is a Composite CDS View that provides data about "Financial Statement Predicted Amount" in SAP S/4HANA. It reads from 1 data source (P_AmountPrediction) and exposes 20 fields with key fields SAPClient, Ledger, CompanyCode, GLAccount, ProfitCenter. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_AmountPrediction P_AmountPrediction from

Parameters (2)

NameTypeDefault
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Currency _CompanyCodeCurrency $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
[0..1] I_Currency _GlobalCurrency $projection.GlobalCurrency = _GlobalCurrency.Currency
[0..1] I_Currency _ReportingCurrency $projection.ReportingCurrency = _ReportingCurrency.Currency

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IFSIAMNTPREDOUT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Financial Statement Predicted Amount view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality X view
ObjectModel.usageType.sizeCategory #XL view
OData.publish true view
VDM.viewType #COMPOSITE view
VDM.private false view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SAPClient rclnt Client
KEY Ledger rldnr Ledger (Compat.)
KEY CompanyCode rbukrs Company Code
KEY GLAccount racct GL Account From
KEY ProfitCenter prctr Profit Centers
KEY ControllingArea kokrs Org. Value
KEY Segment segment Segment number
KEY ActiveChartOfAccounts ktopl G/L Chart of Accounts
KEY Material matnr Vehicle Model
KEY Customer kunnr Stock customer
KEY Plant werks Receiving Plant
KEY FiscalYear gjahr Settlement Year
KEY FiscalYearPeriod fiscyearper Period/Year
KEY PostingDate budat Posting Date
KEY CompanyCodeCurrency rhcur Local Currency
KEY GlobalCurrency rkcur Ledger curr.
KEY ReportingCurrency currency Valuation Crcy
_CompanyCodeCurrency _CompanyCodeCurrency
_GlobalCurrency _GlobalCurrency
_ReportingCurrency _ReportingCurrency

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_FinStmntPredictedAmt.
-- 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: IFSIAMNTPREDOUT
-- Parameters: P_FromFiscalYearPeriod : fins_fyearperiod, P_ToFiscalYearPeriod : fins_fyearperiod

CREATE VIEW I_FinStmntPredictedAmt AS
SELECT
  rclnt AS SAPClient,
  rldnr AS Ledger,
  rbukrs AS CompanyCode,
  racct AS GLAccount,
  prctr AS ProfitCenter,
  kokrs AS ControllingArea,
  Segment,
  ktopl AS ActiveChartOfAccounts,
  matnr AS Material,
  kunnr AS Customer,
  werks AS Plant,
  gjahr AS FiscalYear,
  fiscyearper AS FiscalYearPeriod,
  budat AS PostingDate,
  rhcur AS CompanyCodeCurrency,
  rkcur AS GlobalCurrency,
  currency AS ReportingCurrency
FROM P_AmountPrediction
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON ReportingCurrency = _ReportingCurrency.Currency  -- association [0..1]
;

Learn More