Faa_Plan_Values

DDL: FAA_PLAN_VALUES SQL: FAAV_PLAN_VALUES Type: view Package: FINS_FAA_DB
73 Fields 3 Data Sources

Geplante und Gebuchte Werte pro Anlage und Werttyp

Faa_Plan_Values is a CDS View that provides data about "Geplante und Gebuchte Werte pro Anlage und Werttyp" in SAP S/4HANA. It reads from 3 data sources (acdoca, faat_plan_values, Faa_Rep_Ledger) and exposes 73 fields with key fields mandt, bukrs, anln1, anln2, gjahr. Part of development package FINS_FAA_DB.

Data Sources (3)

SourceAliasJoin Type
acdoca acdoca union_all
faat_plan_values faat_plan_values from
Faa_Rep_Ledger rldnr inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_PLAN_VALUES view
EndUserText.label Geplante und Gebuchte Werte pro Anlage und Werttyp view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt Editing Client
KEY bukrs bukrs Company Code
KEY anln1 anln1 Asset
KEY anln2 anln2 Sub-number
KEY gjahr gjahr Ref. Year1
KEY afaber afabe Deprec. Area
KEY poper poper Posting periods
KEY SLALITTYPE slalittype SLALineItemType
KEY movcat movcat Trans.Type Cat.
KEY depr_period poper Posting Period
SILnewLedgerkeyasposted
ldgrp ldgrp Target Ledger Group
anlgr anlgr Group Asset
anlgr2 anlgr2 Subnumber
HSL hsl Local Crcy Amt
ksl ksl GrpCurr
osl osl Other Crcy Amnt
vsl vsl Amount in Currency 2
bsl bsl Exchange Key
csl csl Amount in Currency 4
dsl dsl Amount in Currency 5
esl esl Amount in Currency 6
fsl fsl Amount in Currency 7
gsl gsl Amount in Currency 8
RHCUR rhcur Local Currency
rkcur rkcur Ledger curr.
rocur rocur Free Defined Crcy 1
rvcur rvcur Free Defined Crcy 4
rbcur rbcur Free Defined Crcy 3
rccur rccur Third Currency
rdcur rdcur Free Defined Crcy 5
recur recur Free Defined Crcy 6
rfcur rfcur Free Defined Crcy 7
rgcur rgcur Free Defined Crcy 8
RECID recid Statistical Key Figure Item
xpost xpost To Be Posted
rclntasmandt
KEY bukrs acdoca rbukrs Company Code
KEY anln1 acdoca anln1 Asset
KEY anln2 acdoca anln2 Sub-number
KEY gjahr acdoca ryear Ref. Year1
KEY afaber acdoca afabe Deprec. Area
KEY poper acdoca poper Posting periods
KEY SLALITTYPE acdoca slalittype SLALineItemType
KEY movcat acdoca movcat Trans.Type Cat.
KEY depr_period acdoca depr_period Posting Period
awtypAS91thenAelseXendasposted
ldgrp Faa_Rep_Ledger ldgrp Target Ledger Group
anlgr acdoca anlgr Group Asset
anlgr2 acdoca anlgr2 Subnumber
HSL Local Crcy Amt
ksl GrpCurr
osl Other Crcy Amnt
vsl Amount in Currency 2
bsl Exchange Key
csl Amount in Currency 4
dsl Amount in Currency 5
esl Amount in Currency 6
fsl Amount in Currency 7
gsl Amount in Currency 8
RHCUR acdoca rhcur Local Currency
rkcur acdoca rkcur Ledger curr.
rocur acdoca rocur Free Defined Crcy 1
rvcur acdoca rvcur Free Defined Crcy 4
rbcur acdoca rbcur Free Defined Crcy 3
rccur acdoca rccur Third Currency
rdcur acdoca rdcur Free Defined Crcy 5
recur acdoca recur Free Defined Crcy 6
rfcur acdoca rfcur Free Defined Crcy 7
rgcur acdoca rgcur Free Defined Crcy 8
RECID acdoca recid Statistical Key Figure Item
xpost To Be Posted
MIG_SOURCE acdoca mig_source Migr. Source

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 Faa_Plan_Values.
-- 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: FAAV_PLAN_VALUES

CREATE VIEW Faa_Plan_Values AS
SELECT
  mandt,
  bukrs,
  anln1,
  anln2,
  gjahr,
  afabe AS afaber,
  poper,
  SLALITTYPE,
  movcat,
  poper AS depr_period,
  ldgrp,
  anlgr,
  anlgr2,
  HSL,
  ksl,
  osl,
  vsl,
  bsl,
  csl,
  dsl,
  esl,
  fsl,
  gsl,
  RHCUR,
  rkcur,
  rocur,
  rvcur,
  rbcur,
  rccur,
  rdcur,
  recur,
  rfcur,
  rgcur,
  RECID,
  xpost,
  mig_source as MIG_SOURCE AS rclntasmandt,
  acdoca.mig_source AS MIG_SOURCE
FROM faat_plan_values
INNER JOIN Faa_Rep_Ledger AS rldnr ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): acdoca
;

Learn More