fgl_lib_txt_skat

DDL: FGL_LIB_TXT_SKAT SQL: FILIBTXTSKAT Type: view
4 Fields 1 Data Sources

FI LIB: Account texts

fgl_lib_txt_skat is a CDS View that provides data about "FI LIB: Account texts" in SAP S/4HANA. It reads from 1 data source (skat) and exposes 4 fields with key fields ktopl, saknr.

Data Sources (1)

SourceAliasJoin Type
skat skat from

Parameters (1)

NameTypeDefault
p_langu spras

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FILIBTXTSKAT view
EndUserText.label FI LIB: Account 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 (4)

KeyFieldSource TableSource FieldDescription
KEY ktopl skat ktopl G/L Chart of Accounts
KEY saknr skat saknr G/L Account
txt20 skat txt20 Text 20
txt50 skat txt50 Status Name

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_skat.
-- 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: FILIBTXTSKAT
-- Parameters: p_langu : spras

CREATE VIEW fgl_lib_txt_skat AS
SELECT
  skat.ktopl AS ktopl,
  skat.saknr AS saknr,
  skat.txt20 AS txt20,
  skat.txt50 AS txt50
FROM skat
;

Learn More