FAA_MD_LAYOUT

DDL: FAA_MD_LAYOUT SQL: FAAV_MD_LAYOUT Type: view Package: FINS_FAA_CFG_DB

FIAA MasterData Layout

FAA_MD_LAYOUT is a CDS View that provides data about "FIAA MasterData Layout" in SAP S/4HANA. It reads from 4 data sources (faa_bf_active, faa_bf_active, faac_layout0_t, t082h) and exposes 5 fields with key field layout. 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
faac_layout0_t t left_outer
t082h t left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_MD_LAYOUT view
EndUserText.label FIAA MasterData Layout view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true 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 (5)

KeyFieldSource TableSource FieldDescription
KEY layout v1 layout Tab layout
felei v1 layout Screen Layout
feleiasLayout
felei v1 felei Screen Layout
description t082h txt30 Text

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_MD_LAYOUT.
-- 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_MD_LAYOUT

CREATE VIEW FAA_MD_LAYOUT AS
SELECT
  v1.layout AS layout,
  v1.layout AS felei,
  t.description as description AS feleiasLayout,
  t.txt30 AS description
INNER JOIN faa_bf_active AS bf_status ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN faac_layout0_t AS t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t082h AS t ON /* join condition not captured in parsed metadata */
;