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