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 Workflow state for routings (no draft table)

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