TBTC_TASK_DET

Transparent Table Temporary Data
14 Fields 6 CDS Views

Aufgabedetails

TBTC_TASK_DET is an SAP database table in S/4HANA. Aufgabedetails. It contains 14 fields. 6 CDS views read from this table.

CDS Views using this table (6)

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
APJ_V_JOB_TASK_DATA view inner CDS View to retrieve the Template name
I_APJ_JOB_USR_OVERVIEW view_entity inner Application Job Users Overview

Fields (14)

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.string
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

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.

-- Aufgabedetails
-- 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.string
    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]
    PRIMARY KEY (TASKID)
);

Learn More