P_AmtPredictionFiltered2

DDL: P_AMTPREDICTIONFILTERED2 SQL: PFSAMTPREDINF Type: view COMPOSITE

P_AmtPredictionFiltered2 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_AmtPredictionFiltered) and exposes 38 fields with key fields mandt, rldnr, rbukrs, racct, prctr.

Data Sources (1)

SourceAliasJoin Type
P_AmtPredictionFiltered P_AmtPredictionFiltered from

Parameters (2)

NameTypeDefault
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PFSAMTPREDINF view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY mandt rclnt Client
KEY rldnr rldnr Ledger (Compat.)
KEY rbukrs rbukrs Company Code
KEY racct racct GL Account From
KEY prctr prctr Profit Centers
KEY kokrs kokrs Org. Value
KEY segment segment Segment number
KEY ktopl ktopl G/L Chart of Accounts
KEY matnr matnr Vehicle Model
KEY kunnr kunnr Stock customer
KEY werks werks Receiving Plant
KEY fiscyearper fiscyearper Period/Year
KEY budat budat Posting Date
KEY gjahr gjahr Settlement Year
KEY rhcur rhcur Local Currency
KEY rkcur rkcur Ledger curr.
KEY currency currency Valuation Crcy
amount amount Value Amount
posting_week posting_week
n_postings n_postings
pre_budat pre_budat
first_budat first_budat
amount_sign amount_sign
days2first days2first
amount_n1 amount_n1
amount_n2 amount_n2
past_amount past_amount
diff_n0_n1 diff_n0_n1
diff_n1_n2 diff_n1_n2
diff_n2_n3 diff_n2_n3
diff_n3_n4 diff_n3_n4
diff_n4_n5 diff_n4_n5
diff_n5_n6 diff_n5_n6
diff_n6_n7 diff_n6_n7
diff_n7_n8 diff_n7_n8
diff_n8_n9 diff_n8_n9
diff_n9_n10 diff_n9_n10
diff_n10_n11 diff_n10_n11

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 P_AmtPredictionFiltered2.
-- 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: PFSAMTPREDINF
-- Parameters: P_FromFiscalYearPeriod : fins_fyearperiod, P_ToFiscalYearPeriod : fins_fyearperiod

CREATE VIEW P_AmtPredictionFiltered2 AS
SELECT
  rclnt AS mandt,
  rldnr,
  rbukrs,
  racct,
  prctr,
  kokrs,
  segment,
  ktopl,
  matnr,
  kunnr,
  werks,
  fiscyearper,
  budat,
  gjahr,
  rhcur,
  rkcur,
  currency,
  amount,
  posting_week,
  n_postings,
  pre_budat,
  first_budat,
  amount_sign,
  days2first,
  amount_n1,
  amount_n2,
  past_amount,
  diff_n0_n1,
  diff_n1_n2,
  diff_n2_n3,
  diff_n3_n4,
  diff_n4_n5,
  diff_n5_n6,
  diff_n6_n7,
  diff_n7_n8,
  diff_n8_n9,
  diff_n9_n10,
  diff_n10_n11
FROM P_AmtPredictionFiltered
;