DPR_TSK_TYPE

Transparent Table Customizing (protected)
13 Fields 4 CDS Views

Task Type

DPR_TSK_TYPE is an SAP database table in S/4HANA. Task Type. It contains 13 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_DevelopmentProjectTaskType view_entity from BASIC Development Project Task Type
I_DevProjectElementType view_entity from BASIC Development Project Element
I_DevProjectElementType view_entity union_all BASIC Development Project Element
I_PPM_Tasktype view from BASIC Task Type

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY tsk_type dpr_tv_tsk_type Task Type
rate dpr_tv_rate Cost/Rev. Rate
active dpr_tv_tsk_type_active Activate Task Type
complete dpr_tv_tsk_type_complete Completion
editsub dpr_tv_tsk_type_editsub Editable
complete_sub dpr_tv_tsk_type_complete_all Complt Subtasks
complete_100 dpr_tv_tsk_type_complete_100 Set Compl 100%
oper_object_type dpr_tv_ool_type Oper. Object Link
relevant_milestone dpr_tv_milestone_is_relevant Relevant Milestone
essential_milestone dpr_tv_milestone_is_essential Main Milestone
milestone_only dpr_tv_milestone_only MilestoneOnly
no_fi_int dpr_tv_no_fi_int No WBS

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 Type
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DPR_TSK_TYPE (
    CLIENT,               -- Client [mandt]
    TSK_TYPE,             -- Task Type [dpr_tv_tsk_type]
    RATE,                 -- Cost/Rev. Rate [dpr_tv_rate]
    ACTIVE,               -- Activate Task Type [dpr_tv_tsk_type_active]
    COMPLETE,             -- Completion [dpr_tv_tsk_type_complete]
    EDITSUB,              -- Editable [dpr_tv_tsk_type_editsub]
    COMPLETE_SUB,         -- Complt Subtasks [dpr_tv_tsk_type_complete_all]
    COMPLETE_100,         -- Set Compl 100% [dpr_tv_tsk_type_complete_100]
    OPER_OBJECT_TYPE,     -- Oper. Object Link [dpr_tv_ool_type]
    RELEVANT_MILESTONE,   -- Relevant Milestone [dpr_tv_milestone_is_relevant]
    ESSENTIAL_MILESTONE,  -- Main Milestone [dpr_tv_milestone_is_essential]
    MILESTONE_ONLY,       -- MilestoneOnly [dpr_tv_milestone_only]
    NO_FI_INT,            -- No WBS [dpr_tv_no_fi_int]
    PRIMARY KEY (CLIENT, TSK_TYPE)
);

Learn More