MDC_PRCTYPE

Transparent Table System Table (SAP only)
10 Fields 2 CDS Views

MDC Process Type (Process Template)

MDC_PRCTYPE is an SAP database table in S/4HANA. MDC Process Type (Process Template). It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MDChgProcTmplRAPBased view from BASIC Process Templates Federation Only
I_MDChgProcTypeTextFixedValues view union COMPOSITE MD Change Process Type Text

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY id MDC_PROCESS_TYPE_ID Process Template
source_otc MDG_OBJECT_TYPE_CODE_BS Bus. Obj. Type
workflow MDC_WORKFLOW Workflow Template
delete_source MDC_DELETE_SOURCE Delete Source
goal MDC_PROCESS_GOAL Process Goal
mass_process_default MDC_MASS_PROCESS_DEFAULT Default Template
duplicate_strategy MDC_DUPLICATE_STRATEGY Strategy
maintenance_action MDC_MAINTENANCE_ACTION Maintenance Action
last_change TIMESTAMP Time Stamp
visualization_option MDC_PROC_VISUAL_OPTION Visualization Option

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.

-- MDC Process Type (Process Template)
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDC_PRCTYPE (
    ID,                    -- Process Template [MDC_PROCESS_TYPE_ID]
    SOURCE_OTC,            -- Bus. Obj. Type [MDG_OBJECT_TYPE_CODE_BS]
    WORKFLOW,              -- Workflow Template [MDC_WORKFLOW]
    DELETE_SOURCE,         -- Delete Source [MDC_DELETE_SOURCE]
    GOAL,                  -- Process Goal [MDC_PROCESS_GOAL]
    MASS_PROCESS_DEFAULT,  -- Default Template [MDC_MASS_PROCESS_DEFAULT]
    DUPLICATE_STRATEGY,    -- Strategy [MDC_DUPLICATE_STRATEGY]
    MAINTENANCE_ACTION,    -- Maintenance Action [MDC_MAINTENANCE_ACTION]
    LAST_CHANGE,           -- Time Stamp [TIMESTAMP]
    VISUALIZATION_OPTION,  -- Visualization Option [MDC_PROC_VISUAL_OPTION]
    PRIMARY KEY (ID)
);

Learn More