ESH_FL_FTASK

Transparent Table Application Table
32 Fields 2 CDS Views

Finished Tasks

ESH_FL_FTASK is an SAP database table in S/4HANA. Finished Tasks. It contains 32 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
ESH_FL_FTASK_DDL view from
I_EntSrchFileAttachmentCntnt view from BASIC Processed Content of Attachment files

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ph_class esh_e_fl_sdok_phcl PHIO Class
KEY phio_id esh_e_fl_sdok_phid Phys. Document
KEY file_num esh_e_fl_fnumb File Number
KEY job_id esh_e_fl_job Job ID
url esh_e_fl_document_url URL
rguid esh_e_fl_rguid GUID
filename esh_e_fl_filename Filename
file_extension esh_e_fl_file_extension Extension
mime_type esh_e_fl_mime_type Mime type
language laiso Language Code
title esh_e_fl_title Title
creator esh_e_fl_creator Creator
author esh_e_fl_author Author
plain_text esh_e_fl_plain_text Plain text
size_file esh_e_fl_size_file File size
size_file_uom esh_e_fl_size_file_uom File size UOM
size_plain_text esh_e_fl_size_plain_text Size of text
size_plain_text_uom esh_e_fl_size_plain_text_uom UOM size plain text
content_hash_md5 esh_e_fl_content_hash_md5 MD5 hash
ph_class_suv esh_e_fl_sdok_phcl_suv PHIO Class SUV
phio_id_suv esh_e_fl_sdok_phid_suv Phys. Document SUV
file_num_suv esh_e_fl_fnumb_suv File Number SUV
mime_type_suv esh_e_fl_mime_type_suv MIME type SUV file
url_suv esh_e_fl_url_suv URL SUV file
ph_class_thumbnail esh_e_fl_sdok_phcl_thumbnail PHIO Class Thumbnail
phio_id_thumbnail esh_e_fl_sdok_phid_thumbnail Phys. Doc. Thumbnail
file_num_thumbnail esh_e_fl_fnumb_thumbnail File No. Thumbnail
url_thumbnail esh_e_fl_url_thumbnail URL thumbnail
url_bin_content esh_e_fl_url_bin_content URL binary content
file_property esh_e_fl_file_property File property
ftask_timestamp timestampl Time Stamp

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Finished Tasks
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ESH_FL_FTASK (
    MANDT,                -- Client [mandt]
    PH_CLASS,             -- PHIO Class [esh_e_fl_sdok_phcl]
    PHIO_ID,              -- Phys. Document [esh_e_fl_sdok_phid]
    FILE_NUM,             -- File Number [esh_e_fl_fnumb]
    JOB_ID,               -- Job ID [esh_e_fl_job]
    URL,                  -- URL [esh_e_fl_document_url]
    RGUID,                -- GUID [esh_e_fl_rguid]
    FILENAME,             -- Filename [esh_e_fl_filename]
    FILE_EXTENSION,       -- Extension [esh_e_fl_file_extension]
    MIME_TYPE,            -- Mime type [esh_e_fl_mime_type]
    LANGUAGE,             -- Language Code [laiso]
    TITLE,                -- Title [esh_e_fl_title]
    CREATOR,              -- Creator [esh_e_fl_creator]
    AUTHOR,               -- Author [esh_e_fl_author]
    PLAIN_TEXT,           -- Plain text [esh_e_fl_plain_text]
    SIZE_FILE,            -- File size [esh_e_fl_size_file]
    SIZE_FILE_UOM,        -- File size UOM [esh_e_fl_size_file_uom]
    SIZE_PLAIN_TEXT,      -- Size of text [esh_e_fl_size_plain_text]
    SIZE_PLAIN_TEXT_UOM,  -- UOM size plain text [esh_e_fl_size_plain_text_uom]
    CONTENT_HASH_MD5,     -- MD5 hash [esh_e_fl_content_hash_md5]
    PH_CLASS_SUV,         -- PHIO Class SUV [esh_e_fl_sdok_phcl_suv]
    PHIO_ID_SUV,          -- Phys. Document SUV [esh_e_fl_sdok_phid_suv]
    FILE_NUM_SUV,         -- File Number SUV [esh_e_fl_fnumb_suv]
    MIME_TYPE_SUV,        -- MIME type SUV file [esh_e_fl_mime_type_suv]
    URL_SUV,              -- URL SUV file [esh_e_fl_url_suv]
    PH_CLASS_THUMBNAIL,   -- PHIO Class Thumbnail [esh_e_fl_sdok_phcl_thumbnail]
    PHIO_ID_THUMBNAIL,    -- Phys. Doc. Thumbnail [esh_e_fl_sdok_phid_thumbnail]
    FILE_NUM_THUMBNAIL,   -- File No. Thumbnail [esh_e_fl_fnumb_thumbnail]
    URL_THUMBNAIL,        -- URL thumbnail [esh_e_fl_url_thumbnail]
    URL_BIN_CONTENT,      -- URL binary content [esh_e_fl_url_bin_content]
    FILE_PROPERTY,        -- File property [esh_e_fl_file_property]
    FTASK_TIMESTAMP,      -- Time Stamp [timestampl]
    PRIMARY KEY (MANDT, PH_CLASS, PHIO_ID, FILE_NUM, JOB_ID)
);

Learn More