fiscds_versn

DDL: FISVD_VERSN SQL: FISV_VERSN Type: view Package: FINS_FIS_GL
7 Fields 5 Data Sources

F4 Help: Financial Statement Variant

fiscds_versn is a CDS View that provides data about "F4 Help: Financial Statement Variant" in SAP S/4HANA. It reads from 5 data sources (t002, t002, t011, t011t, t011t) and exposes 7 fields. Part of development package FINS_FIS_GL.

Data Sources (5)

SourceAliasJoin Type
t002 t002 inner
t002 t002 inner
t011 t011 inner
t011t t011t left_outer
t011t t011t left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FISV_VERSN view
EndUserText.label F4 Help: Financial Statement Variant view
ClientDependent true view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view

Fields (7)

KeyFieldSource TableSource FieldDescription
versn t011 versn Version
ktopl t011 ktopl G/L Chart of Accounts
spras t002 spras Off. Language
versn Version
ktopl fagl_011zc ktopl G/L Chart of Accounts
spras t002 spras Off. Language
vstxt t011t vstxt 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 fiscds_versn.
-- 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: FISV_VERSN

CREATE VIEW fiscds_versn AS
SELECT
  t011.versn AS versn,
  t011.ktopl AS ktopl,
  t002.spras AS spras,
  t011t.vstxt AS vstxt
INNER JOIN t002 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t011t ON /* join condition not captured in parsed metadata */
INNER JOIN t011 ON /* join condition not captured in parsed metadata */
;

Learn More