FAA_M_AANLP

DDL: FAA_M_AANLP Type: view Package: FINS_FAA_MD_COMMON
8 Fields 1 Data Sources

Selection view for matchcode ID AANL-P

FAA_M_AANLP is a CDS View that provides data about "Selection view for matchcode ID AANL-P" in SAP S/4HANA. It reads from 1 data source (I_WBSElement) and exposes 8 fields with key fields bukrs, anln1, anln2. Part of development package FINS_FAA_MD_COMMON.

Data Sources (1)

SourceAliasJoin Type
I_WBSElement v2 inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_M_AANLP view
AbapCatalog.preserveKey true view
EndUserText.label Selection view for matchcode ID AANL-P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY bukrs v1 bukrs Value
KEY anln1 v1 anln1 Asset
KEY anln2 v1 anln2 Sub-number
anlkl v1 anlkl Asset Class
posnr v1 posnr WBS Element
mcoa1 v1 mcoa1 Description
posid I_WBSElement WBSElement WBS Internal ID
AssetAuthorizationContext v1 AssetAuthorizationContext

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

CREATE VIEW FAA_M_AANLP AS
SELECT
  v1.bukrs AS bukrs,
  v1.anln1 AS anln1,
  v1.anln2 AS anln2,
  v1.anlkl AS anlkl,
  v1.posnr AS posnr,
  v1.mcoa1 AS mcoa1,
  v2.WBSElement AS posid,
  v1.AssetAuthorizationContext AS AssetAuthorizationContext
INNER JOIN I_WBSElement AS v2 ON /* join condition not captured in parsed metadata */
;

Learn More