fiscds_trk_fld_text

DDL: FISVD_TRK_FLD_TEXT SQL: FISV_TRK_FLD_TXT Type: view

Changed Field Name of Dcoument

fiscds_trk_fld_text is a CDS View that provides data about "Changed Field Name of Dcoument" in SAP S/4HANA. It reads from 3 data sources (dd03l, dd04l, dd04t) and exposes 4 fields with key fields fieldname, tabname, language.

Data Sources (3)

SourceAliasJoin Type
dd03l a from
dd04l b inner
dd04t c inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FISV_TRK_FLD_TXT view
EndUserText.label Changed Field Name of Dcoument view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY fieldname dd03l fieldname UI Group FieldName
KEY tabname dd03l tabname Table/Constant Value
KEY language dd04t ddlanguage Lang.
ddtext dd04t ddtext Short text

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_trk_fld_text.
-- 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_TRK_FLD_TXT

CREATE VIEW fiscds_trk_fld_text AS
SELECT
  a.fieldname AS fieldname,
  a.tabname AS tabname,
  c.ddlanguage AS language,
  c.ddtext AS ddtext
FROM dd03l AS a
INNER JOIN dd04l AS b ON /* join condition not captured in parsed metadata */
INNER JOIN dd04t AS c ON /* join condition not captured in parsed metadata */
;