Faa_Anlp2

DDL: FAA_ANLP2 SQL: FAAV_ANLP2 Type: view
9 Fields 2 Data Sources

Intern: Parallele Waehrungen auf AfA-Bereiche mappen

Faa_Anlp2 is a CDS View that provides data about "Intern: Parallele Waehrungen auf AfA-Bereiche mappen" in SAP S/4HANA. It reads from 2 data sources (Faa_Anlp1, Faa_Curtyp) and exposes 9 fields with key fields mandt, bukrs, anln1, anln2, gjahr.

Data Sources (2)

SourceAliasJoin Type
Faa_Anlp1 v1 from
Faa_Curtyp v2 inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_ANLP2 view
EndUserText.label Intern: Parallele Waehrungen auf AfA-Bereiche mappen 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 Faa_Anlp1 mandt Editing Client
KEY bukrs Faa_Anlp1 bukrs Value
KEY anln1 Faa_Anlp1 anln1 Asset
KEY anln2 Faa_Anlp1 anln2 Sub-number
KEY gjahr Faa_Anlp1 gjahr Settlement Year
KEY afabe Faa_Curtyp afabe Deprec. Area
KEY peraf Faa_Anlp1 peraf Dev. Bill. Date
KEY afbnr Faa_Anlp1 afbnr Seq. No. in Period
rctyp rctyp

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_Anlp2.
-- 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_ANLP2

CREATE VIEW Faa_Anlp2 AS
SELECT
  v1.mandt AS mandt,
  v1.bukrs AS bukrs,
  v1.anln1 AS anln1,
  v1.anln2 AS anln2,
  v1.gjahr AS gjahr,
  v2.afabe AS afabe,
  v1.peraf AS peraf,
  v1.afbnr AS afbnr,
  rctyp
FROM Faa_Anlp1 AS v1
INNER JOIN Faa_Curtyp AS v2 ON /* join condition not captured in parsed metadata */
;

Learn More