FAA_DeltaDrvdAreaPlanVal

DDL: FAA_DELTADRVDAREAPLANVAL SQL: FAAVDDAPV Type: view
13 Fields 1 Data Sources

Delta Derived Area PLAN_VALUES

FAA_DeltaDrvdAreaPlanVal is a CDS View that provides data about "Delta Derived Area PLAN_VALUES" in SAP S/4HANA. It reads from 1 data source (FAA_DeltaDrvdAreaPlanVal00) and exposes 13 fields with key fields bukrs, anln1, anln2, gjahr, afabe.

Data Sources (1)

SourceAliasJoin Type
FAA_DeltaDrvdAreaPlanVal00 Values from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FAAVDDAPV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Delta Derived Area PLAN_VALUES view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY bukrs FAA_DeltaDrvdAreaPlanVal00 bukrs Value
KEY anln1 FAA_DeltaDrvdAreaPlanVal00 anln1 Asset
KEY anln2 FAA_DeltaDrvdAreaPlanVal00 anln2 Sub-number
KEY gjahr FAA_DeltaDrvdAreaPlanVal00 gjahr Settlement Year
KEY afabe FAA_DeltaDrvdAreaPlanVal00 afabe Deprec. Area
KEY slalittype FAA_DeltaDrvdAreaPlanVal00 slalittype SLALineItemType
movcat FAA_DeltaDrvdAreaPlanVal00 movcat Trans.Type Cat.
ksl
osl
rkcur FAA_DeltaDrvdAreaPlanVal00 rkcur Ledger curr.
rocur FAA_DeltaDrvdAreaPlanVal00 rocur Free Defined Crcy 1
anlkl FAA_DeltaDrvdAreaPlanVal00 anlkl Asset Class
ktogr FAA_DeltaDrvdAreaPlanVal00 ktogr Account Determ.

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_DeltaDrvdAreaPlanVal.
-- 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: FAAVDDAPV

CREATE VIEW FAA_DeltaDrvdAreaPlanVal AS
SELECT
  Values.bukrs AS bukrs,
  Values.anln1 AS anln1,
  Values.anln2 AS anln2,
  Values.gjahr AS gjahr,
  Values.afabe AS afabe,
  Values.slalittype AS slalittype,
  Values.movcat AS movcat,
  sum( Values.ksl ) AS ksl,
  sum( Values.osl ) AS osl,
  Values.rkcur AS rkcur,
  Values.rocur AS rocur,
  Values.anlkl AS anlkl,
  Values.ktogr AS ktogr
FROM FAA_DeltaDrvdAreaPlanVal00 AS Values
;

Learn More