Faa_Anlp_Poper

DDL: FAA_ANLP_POPER SQL: FAAV_ANLP_POPER Type: view Package: AB

Intern: Ermittelt Perioden fuer ANLP-Saetze

Faa_Anlp_Poper is a CDS View that provides data about "Intern: Ermittelt Perioden fuer ANLP-Saetze" in SAP S/4HANA. It reads from 4 data sources (acdoca, acdoca, Faa_Curtyp, Faa_Curtyp) and exposes 25 fields. Part of development package AB.

Data Sources (4)

SourceAliasJoin Type
acdoca adoc inner
acdoca adoc inner
Faa_Curtyp crtp inner
Faa_Curtyp crtp inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_ANLP_POPER view
EndUserText.label Intern: Ermittelt Perioden fuer ANLP-Saetze view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (25)

KeyFieldSource TableSource FieldDescription
mandt acdoca rclnt Client
bukrs acdoca rbukrs Value
gjahr acdoca ryear Settlement Year
anln1 acdoca anln1 Group Asset
anln2 acdoca anln2 Subnumber
afaber Faa_Curtyp afabe Deprec. Area
rclntasmandt
bukrs acdoca rbukrs Value
gjahr acdoca ryear Settlement Year
anln1 acdoca anlgr Group Asset
anln2 acdoca anlgr2 Subnumber
afaber Faa_Curtyp afabe Deprec. Area
bukrs bukrs Value
gjahr gjahr Settlement Year
anln1 anln1 Group Asset
anln2 anln2 Subnumber
afaber afabe Deprec. Area
afbnr
bukrs bukrs Value
gjahr gjahr Settlement Year
anln1 anlgr Group Asset
anln2 anlgr2 Subnumber
afaber afabe Deprec. Area
afbnr
poper

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_Anlp_Poper.
-- 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_ANLP_POPER

CREATE VIEW Faa_Anlp_Poper AS
SELECT
  adoc.rclnt AS mandt,
  adoc.rbukrs AS bukrs,
  adoc.ryear AS gjahr,
  adoc.anln1 AS anln1,
  adoc.anln2 AS anln2,
  crtp.afabe AS afaber,
  adoc.poper as poper AS rclntasmandt,
  '00' AS afbnr,
  '000' AS poper
INNER JOIN acdoca AS adoc ON /* join condition not captured in parsed metadata */
INNER JOIN Faa_Curtyp AS crtp ON /* join condition not captured in parsed metadata */
;