fgl_lib_txt_matnr

DDL: FGL_LIB_TXT_MATNR SQL: FILIBTXTMATNR Type: view
2 Fields 1 Data Sources

FI LIB: Material texts

fgl_lib_txt_matnr is a CDS View that provides data about "FI LIB: Material texts" in SAP S/4HANA. It reads from 1 data source (makt) and exposes 2 fields with key field matnr.

Data Sources (1)

SourceAliasJoin Type
makt makt from

Parameters (1)

NameTypeDefault
p_langu spras

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FILIBTXTMATNR view
EndUserText.label FI LIB: Material texts view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY matnr makt matnr Vehicle Model
maktx makt maktx Product Description

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 fgl_lib_txt_matnr.
-- 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: FILIBTXTMATNR
-- Parameters: p_langu : spras

CREATE VIEW fgl_lib_txt_matnr AS
SELECT
  makt.matnr AS matnr,
  makt.maktx AS maktx
FROM makt
;

Learn More