START_TP_VARS

Transparent Table Application Table
30 Fields 1 CDS Views

Global Data Variants for Test Plan

START_TP_VARS is an SAP database table in S/4HANA. Global Data Variants for Test Plan. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_IPUTSVariant view_entity from BASIC IPUTS Variant

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY variant_id START_DTE_PROCESS_ID Process Id
testplan_id START_DTE_STEP_ID stepid
variant_name START_DTE_VARIANT_NAME Variant Name
country LAND1 Country/Reg.
version START_DTE_VERSION version
variant_desc START_DTE_VARIANT_DESC Variant Description
language LAISO Language Code
created_on START_DTE_CREATED_ON CreatedOn
created_by XUBNAME User
variant_xml START_DTE_STEP_XML StepXML
defaultvar FLAG Indicator
bukrs BUKRS Company Code
vkorg VKORG Sales Org.
ekorg EKORG Purchasing Org.
werks WERKS_D Plant
kkber KKBER Cred.Contr.Area
waers WAERS Currency
vtweg VTWEG Distr. Channel
spart SPART Division
vkgrp VKGRP Sales Group
vkbur VKBUR Sales Office
step_sq START_DTE_SEQNO sequecne number
process_sq START_DTE_SEQNO sequecne number
created_at UZEIT Time
changed_at UZEIT Time
step_id START_DTE_TESTPLAN_ID Testplan Id
obsolete FLAG Indicator
changed_on START_DTE_CREATED_ON CreatedOn
changed_by XUBNAME User

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.

-- Global Data Variants for Test Plan
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE START_TP_VARS (
    MANDT,         -- Client [MANDT]
    VARIANT_ID,    -- Process Id [START_DTE_PROCESS_ID]
    TESTPLAN_ID,   -- stepid [START_DTE_STEP_ID]
    VARIANT_NAME,  -- Variant Name [START_DTE_VARIANT_NAME]
    COUNTRY,       -- Country/Reg. [LAND1]
    VERSION,       -- version [START_DTE_VERSION]
    VARIANT_DESC,  -- Variant Description [START_DTE_VARIANT_DESC]
    LANGUAGE,      -- Language Code [LAISO]
    CREATED_ON,    -- CreatedOn [START_DTE_CREATED_ON]
    CREATED_BY,    -- User [XUBNAME]
    VARIANT_XML,   -- StepXML [START_DTE_STEP_XML]
    DEFAULTVAR,    -- Indicator [FLAG]
    BUKRS,         -- Company Code [BUKRS]
    VKORG,         -- Sales Org. [VKORG]
    EKORG,         -- Purchasing Org. [EKORG]
    WERKS,         -- Plant [WERKS_D]
    KKBER,         -- Cred.Contr.Area [KKBER]
    WAERS,         -- Currency [WAERS]
    VTWEG,         -- Distr. Channel [VTWEG]
    SPART,         -- Division [SPART]
    VKGRP,         -- Sales Group [VKGRP]
    VKBUR,         -- Sales Office [VKBUR]
    STEP_SQ,       -- sequecne number [START_DTE_SEQNO]
    PROCESS_SQ,    -- sequecne number [START_DTE_SEQNO]
    CREATED_AT,    -- Time [UZEIT]
    CHANGED_AT,    -- Time [UZEIT]
    STEP_ID,       -- Testplan Id [START_DTE_TESTPLAN_ID]
    OBSOLETE,      -- Indicator [FLAG]
    CHANGED_ON,    -- CreatedOn [START_DTE_CREATED_ON]
    CHANGED_BY,    -- User [XUBNAME]
    PRIMARY KEY (MANDT, VARIANT_ID)
);

Learn More