TCA01_SUBTYPE

Transparent Table Customizing (protected)
18 Fields 3 CDS Views

Task list subtype (Routing Profile)

TCA01_SUBTYPE is an SAP database table in S/4HANA. Task list subtype (Routing Profile). It contains 18 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BillOfOperationsVersionType view from BASIC Bill of Operations Version Type
P_RTGVERSUIWFL view_entity from BASIC Workflow state for routings
P_RTGVERSUIWFL_S view_entity from BASIC

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY subtype PLNSUBTYPE Version Profile
default_subtype FLG_DEFAULT_SUBTYPE Default Profile
default_rework_subtype FLG_DEFAULT_REWORK_SUBTYPE Default Rework Prof.
successive_vers FLG_SUCCESSIVE_VERS Successive Version
numeric_version FLG_NUMERIC_VERSION Numeric Version
change_record_required FLG_CHANGE_RECORD_REQUIRED CR Required
upgrade_mbom FLG_UPGRADE_MBOM Upgrade MBOM
single_mbom FLG_PLNVERSN_SINGLE_MBOM Single MBOM
default_verwe PLN_DEFAULT_VERWE Default Usage
default_statu PLN_DEFAULT_STATU Default Status
workflow_scenario_id SWF_FLEX_SCENARIO_ID Scenario
default_flexible MPE_FLEXIBLE_PROCESSING Flexible
default_activity_sasname MPE_SASNAME_OA_CUST SAS for Op. Activity
default_sfi_sasname MPE_SASNAME_SFIOA_NOSIMGROUP SAS: Serialized Prod
default_sfi_sasname_noscrap MPE_SASNAME_SFIOA_SIMGROUP SAS: S. Prod Sim Grp
default_control_key MPE_RTG_DEFAULT_CONTROLKEY Control Key
default_vornr_lcl_chg_n_allwd MPE_VORNR_LOCAL_CHG_NOT_ALLWD Op. Nos Fixed

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 list subtype (Routing Profile)
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCA01_SUBTYPE (
    MANDT,                          -- Client [MANDT]
    SUBTYPE,                        -- Version Profile [PLNSUBTYPE]
    DEFAULT_SUBTYPE,                -- Default Profile [FLG_DEFAULT_SUBTYPE]
    DEFAULT_REWORK_SUBTYPE,         -- Default Rework Prof. [FLG_DEFAULT_REWORK_SUBTYPE]
    SUCCESSIVE_VERS,                -- Successive Version [FLG_SUCCESSIVE_VERS]
    NUMERIC_VERSION,                -- Numeric Version [FLG_NUMERIC_VERSION]
    CHANGE_RECORD_REQUIRED,         -- CR Required [FLG_CHANGE_RECORD_REQUIRED]
    UPGRADE_MBOM,                   -- Upgrade MBOM [FLG_UPGRADE_MBOM]
    SINGLE_MBOM,                    -- Single MBOM [FLG_PLNVERSN_SINGLE_MBOM]
    DEFAULT_VERWE,                  -- Default Usage [PLN_DEFAULT_VERWE]
    DEFAULT_STATU,                  -- Default Status [PLN_DEFAULT_STATU]
    WORKFLOW_SCENARIO_ID,           -- Scenario [SWF_FLEX_SCENARIO_ID]
    DEFAULT_FLEXIBLE,               -- Flexible [MPE_FLEXIBLE_PROCESSING]
    DEFAULT_ACTIVITY_SASNAME,       -- SAS for Op. Activity [MPE_SASNAME_OA_CUST]
    DEFAULT_SFI_SASNAME,            -- SAS: Serialized Prod [MPE_SASNAME_SFIOA_NOSIMGROUP]
    DEFAULT_SFI_SASNAME_NOSCRAP,    -- SAS: S. Prod Sim Grp [MPE_SASNAME_SFIOA_SIMGROUP]
    DEFAULT_CONTROL_KEY,            -- Control Key [MPE_RTG_DEFAULT_CONTROLKEY]
    DEFAULT_VORNR_LCL_CHG_N_ALLWD,  -- Op. Nos Fixed [MPE_VORNR_LOCAL_CHG_NOT_ALLWD]
    PRIMARY KEY (MANDT, SUBTYPE)
);

Learn More