FAA_ASSET_CLASS

DDL: FAA_ASSET_CLASS SQL: FAAV_ASSET_CLASS Type: view Package: FINS_FAA_CFG_DB
6 Fields 4 Data Sources

FIAA asset classes

FAA_ASSET_CLASS is a CDS View that provides data about "FIAA asset classes" in SAP S/4HANA. It reads from 4 data sources (faa_bf_active, faa_bf_active, ankt, faac_acls0_t) and exposes 6 fields with key field ASSET_CLASS. Part of development package FINS_FAA_CFG_DB.

Data Sources (4)

SourceAliasJoin Type
faa_bf_active bf_status inner
faa_bf_active bf_status inner
ankt t left_outer
faac_acls0_t t left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_ASSET_CLASS view
EndUserText.label FIAA asset classes view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ASSET_CLASS v1 anlkl Asset Class
anlkl v1 anlkl Asset Class
txk20astxk20
txk20astxk50
asset_classasASSET_CLASS
anlkl v1 asset_class Asset Class

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

CREATE VIEW FAA_ASSET_CLASS AS
SELECT
  v1.anlkl AS ASSET_CLASS,
  v1.anlkl AS anlkl
INNER JOIN faa_bf_active AS bf_status ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ankt AS t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN faac_acls0_t AS t ON /* join condition not captured in parsed metadata */
;

Learn More