DPR_TSK_TYPE

Transparent Table Customizing (protected)

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)
);