TBTC_TASK_DET

Transparent Table Temporary Data
45 Fields 5 CDS Views

Task Details

TBTC_TASK_DET is an SAP database table in S/4HANA. Task Details. It contains 45 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
APJ_V_JOB_RUN_AB_FIN_ENDDATE view left_outer All aborted or finished application jobs
Apj_V_Job_Run_Aborted_Finished view left_outer All aborted or finished application jobs
APJ_V_JOB_RUN_OVERVIEW view inner Job overview
APJ_V_JOB_RUN_OVERVIEW_S view inner Job overview
I_APJ_JOB_USR_OVERVIEW view_entity inner Application Job Users Overview

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY taskid BTC_TASKID ID of a Task
version BTC_TASK_VERSION Task Version
parent_id BTC_TASKID ID of a Task
description abap.strg
extid BTC_EXTID External ID
extid_type BTC_EXTID_TYPE External ID Type
to_be_archived BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
only_one_active BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
sdltype BTC_START_TYPE Type of Start Condition
sdl_nextdate SYDATUM Current Date
sdl_nexttime SYUZEIT Time
periodic BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
error_code INT4 INT4
chainid BTC_CHAINID Chain ID
progname PROGRAMM Program Name
variant VARIANT Variant
authckman SYMANDT Client ID
authcknam SYUNAME User Name
language SYLANGU Language Key
def_type BTC_JOBDEF_TYPE Job Definition Type
job_catalog_entry APJ_JOB_CATALOG_ENTRY_NAME Job Catalog
job_template_name APJ_JOB_TEMPLATE_NAME Job Template Name
create_timestamp BTCTIMESTAMP Time Stamp
create_user BTCUSER User
start_timestamp TIMESTAMP Time Stamp
start_user BTCUSER User
notif_enabled BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
end_timestamp TIMESTAMP Time Stamp
end_date SYDATUM Current Date
end_time SYUZEIT Time
max_iterations BTC_COUNTER Number
recurrtype BTC_PERIOD_TYPE Period Type
prdmins BTCPMIN Periodic job
prdhours BTCPHOUR Periodic job
prddays BTCPDAY Periodic job
prdweeks BTCPWEEK Periodic job
prdmonths BTCPMNTH Periodic job
calendarid BTCCALID Calendar
prdbehav BTCPRDBHV Behavior
wdayno BTCWORKDAY Workday
wdaycdir BTCWDCDIR Count direction
notbefore BTCSDATE Start Date
weekday BTCWEEKDAYS Weekdays
usewdays BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
calctzone TIMEZONE Time Zone

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.

-- Task Details
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TBTC_TASK_DET (
    TASKID,             -- ID of a Task [BTC_TASKID]
    VERSION,            -- Task Version [BTC_TASK_VERSION]
    PARENT_ID,          -- ID of a Task [BTC_TASKID]
    DESCRIPTION,        -- abap.strg
    EXTID,              -- External ID [BTC_EXTID]
    EXTID_TYPE,         -- External ID Type [BTC_EXTID_TYPE]
    TO_BE_ARCHIVED,     -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    ONLY_ONE_ACTIVE,    -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    SDLTYPE,            -- Type of Start Condition [BTC_START_TYPE]
    SDL_NEXTDATE,       -- Current Date [SYDATUM]
    SDL_NEXTTIME,       -- Time [SYUZEIT]
    PERIODIC,           -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    ERROR_CODE,         -- INT4 [INT4]
    CHAINID,            -- Chain ID [BTC_CHAINID]
    PROGNAME,           -- Program Name [PROGRAMM]
    VARIANT,            -- Variant [VARIANT]
    AUTHCKMAN,          -- Client ID [SYMANDT]
    AUTHCKNAM,          -- User Name [SYUNAME]
    LANGUAGE,           -- Language Key [SYLANGU]
    DEF_TYPE,           -- Job Definition Type [BTC_JOBDEF_TYPE]
    JOB_CATALOG_ENTRY,  -- Job Catalog [APJ_JOB_CATALOG_ENTRY_NAME]
    JOB_TEMPLATE_NAME,  -- Job Template Name [APJ_JOB_TEMPLATE_NAME]
    CREATE_TIMESTAMP,   -- Time Stamp [BTCTIMESTAMP]
    CREATE_USER,        -- User [BTCUSER]
    START_TIMESTAMP,    -- Time Stamp [TIMESTAMP]
    START_USER,         -- User [BTCUSER]
    NOTIF_ENABLED,      -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    END_TIMESTAMP,      -- Time Stamp [TIMESTAMP]
    END_DATE,           -- Current Date [SYDATUM]
    END_TIME,           -- Time [SYUZEIT]
    MAX_ITERATIONS,     -- Number [BTC_COUNTER]
    RECURRTYPE,         -- Period Type [BTC_PERIOD_TYPE]
    PRDMINS,            -- Periodic job [BTCPMIN]
    PRDHOURS,           -- Periodic job [BTCPHOUR]
    PRDDAYS,            -- Periodic job [BTCPDAY]
    PRDWEEKS,           -- Periodic job [BTCPWEEK]
    PRDMONTHS,          -- Periodic job [BTCPMNTH]
    CALENDARID,         -- Calendar [BTCCALID]
    PRDBEHAV,           -- Behavior [BTCPRDBHV]
    WDAYNO,             -- Workday [BTCWORKDAY]
    WDAYCDIR,           -- Count direction [BTCWDCDIR]
    NOTBEFORE,          -- Start Date [BTCSDATE]
    WEEKDAY,            -- Weekdays [BTCWEEKDAYS]
    USEWDAYS,           -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    CALCTZONE,          -- Time Zone [TIMEZONE]
    PRIMARY KEY (TASKID)
);

Learn More