FAA_DERP_AREA

DDL: FAA_DERP_AREA SQL: FAAV_DEPR_AREA Type: view Package: FINS_FAA_CFG_DB

FIAA depreciation areas

FAA_DERP_AREA is a CDS View that provides data about "FIAA depreciation areas" in SAP S/4HANA. It reads from 4 data sources (faa_bf_active, faa_bf_active, t093t, faac_cmp_da0_t) and exposes 7 fields with key fields comp_code, depr_area, depr_area. Part of development package FINS_FAA_CFG_DB.

Data Sources (4)

SourceAliasJoin Type
faa_bf_active bf_status inner
faa_bf_active bf_status inner
t093t t left_outer
faac_cmp_da0_t t left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_DEPR_AREA view
EndUserText.label FIAA depreciation areas view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY comp_code v1 bukrs Value
KEY depr_area v1 afaber Deprec. Area
afaber v1 afaber Deprec. Area
afaplasafapl
KEY depr_area v1 depr_area Deprec. Area
afaber v1 depr_area Deprec. Area
description_shortasDESCRIPTION_SHORT

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_DERP_AREA.
-- 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_DEPR_AREA

CREATE VIEW FAA_DERP_AREA AS
SELECT
  v1.bukrs AS comp_code,
  v1.afaber AS depr_area,
  v1.afaber AS afaber
INNER JOIN faa_bf_active AS bf_status ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t093t AS t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN faac_cmp_da0_t AS t ON /* join condition not captured in parsed metadata */
;