ESH_FL_FTASK_DDL

DDL: ESH_FL_FTASK_DDL SQL: V_ESH_FL_FTASK Type: view
16 Fields 1 Data Sources

ESH_FL_FTASK_DDL is a CDS View in SAP S/4HANA. It reads from 1 data source (esh_fl_ftask) and exposes 16 fields with key fields ph_class, phio_id, file_num, job_id.

Data Sources (1)

SourceAliasJoin Type
esh_fl_ftask esh_fl_ftask from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName V_ESH_FL_FTASK view
AbapCatalog.compiler.compareFilter true view
UI.headerInfo.typeName File Processing Finished Task view
UI.headerInfo.typeNamePlural File Processing Finished Tasks view
Search.searchable true view
Metadata.allowExtensions true view
UI.headerInfo.title.value TITLE view
UI.headerInfo.title.url URL_BIN_CONTENT view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ph_class ph_class PHIO Class
KEY phio_id phio_id Phys. Document
KEY file_num file_num File Number
KEY job_id job_id Package ID
title title View Title
plain_text plain_text Plain text
filename filename File Name
mime_type mime_type Type
language language Language
url_suv url_suv URL SUV file
creator creator User ID
author author User Name
size_file size_file Size
ph_class_suv ph_class_suv PHIO Class SUV
phio_id_suv phio_id_suv Phys. Document SUV
file_num_suv file_num_suv File Number SUV

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 ESH_FL_FTASK_DDL.
-- 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: V_ESH_FL_FTASK

CREATE VIEW ESH_FL_FTASK_DDL AS
SELECT
  ph_class,
  phio_id,
  file_num,
  job_id,
  title,
  plain_text,
  filename,
  mime_type,
  language,
  url_suv,
  creator,
  author,
  size_file,
  ph_class_suv,
  phio_id_suv,
  file_num_suv
FROM esh_fl_ftask
;

Learn More