Faa_Sil_Anla_Relevant

DDL: FAA_SIL_ANLA_RELEVANT SQL: FAAV_SIL_ANLA Type: view

Relevante Anlagen für Rücksetzen selektieren

Faa_Sil_Anla_Relevant is a CDS View that provides data about "Relevante Anlagen für Rücksetzen selektieren" in SAP S/4HANA. It reads from 4 data sources (anla, faac_sil_map, fins_sif_proj, t093c) and exposes 9 fields with key fields mandt, project_id, afapl, bukrs, anln1.

Data Sources (4)

SourceAliasJoin Type
anla anla inner
faac_sil_map sil_map inner
fins_sif_proj sil_proj inner
t093c t093c inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_SIL_ANLA view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Relevante Anlagen für Rücksetzen selektieren view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY mandt ydda mandt Editing Client
KEY project_id faac_sil_map project_id Project UUID
KEY afapl faac_sil_map afapl Chart of Depr.
KEY bukrs ydda bukrs Value
KEY anln1 ydda anln1 Asset
KEY anln2 ydda anln2 Sub-number
abgdt anla abgdt Last Retirement
deakt anla deakt Deact.Date
xinvm anla xinvm Inv. Measure

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_Sil_Anla_Relevant.
-- 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_SIL_ANLA

CREATE VIEW Faa_Sil_Anla_Relevant AS
SELECT
  ydda.mandt AS mandt,
  sil_map.project_id AS project_id,
  sil_map.afapl AS afapl,
  ydda.bukrs AS bukrs,
  ydda.anln1 AS anln1,
  ydda.anln2 AS anln2,
  anla.abgdt AS abgdt,
  anla.deakt AS deakt,
  anla.xinvm AS xinvm
INNER JOIN t093c ON /* join condition not captured in parsed metadata */
INNER JOIN faac_sil_map AS sil_map ON /* join condition not captured in parsed metadata */
INNER JOIN fins_sif_proj AS sil_proj ON /* join condition not captured in parsed metadata */
INNER JOIN anla ON /* join condition not captured in parsed metadata */
;