Faa_Anlc1_Stat

DDL: FAA_ANLC1_STAT SQL: FAAV_ANLC1_STAT Type: view
34 Fields 1 Data Sources

Intern: Verdichten auf SLALITTYPE-Ebene

Faa_Anlc1_Stat is a CDS View that provides data about "Intern: Verdichten auf SLALITTYPE-Ebene" in SAP S/4HANA. It reads from 1 data source (faat_doc_it) and exposes 34 fields.

Data Sources (1)

SourceAliasJoin Type
faat_doc_it faat_doc_it from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_ANLC1_STAT view
EndUserText.label Intern: Verdichten auf SLALITTYPE-Ebene view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (34)

KeyFieldSource TableSource FieldDescription
mandt mandt Editing Client
bukrs bukrs Value
anln1 anln1 Group Asset
anln2 anln2 Subnumber
gjahr gjahr Settlement Year
afabe afabe Deprec. Area
slalittype slalittype SLALineItemType
movcat movcat Trans.Type Cat.
hsl
ksl
osl
vsl
bsl
csl
dsl
esl
fsl
bukrs bukrs Value
anln1 anlgr Group Asset
anln2 anlgr2 Subnumber
gjahr gjahr Settlement Year
afabe afabe Deprec. Area
slalittype slalittype SLALineItemType
movcat movcat Trans.Type Cat.
hsl
ksl
osl
vsl
bsl
csl
dsl
esl
fsl
gsl

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_Anlc1_Stat.
-- 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_ANLC1_STAT

CREATE VIEW Faa_Anlc1_Stat AS
SELECT
  mandt,
  bukrs,
  anln1,
  anln2,
  gjahr,
  afabe,
  slalittype,
  movcat,
  sum ( hsl ) AS hsl,
  sum ( ksl ) AS ksl,
  sum ( osl ) AS osl,
  sum ( vsl ) AS vsl,
  sum ( bsl ) AS bsl,
  sum ( csl ) AS csl,
  sum ( dsl ) AS dsl,
  sum ( esl ) AS esl,
  sum ( fsl ) AS fsl,
  sum ( gsl ) AS gsl
FROM faat_doc_it
;

Learn More