IPUTS_A_TESTPLAN

Transparent Table Application Table

IPUTS Test Plan Details

IPUTS_A_TESTPLAN is an SAP database table in S/4HANA. IPUTS Test Plan Details. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_IPUTSBuildCoverage view_entity from BASIC Build Coverage
I_IPUTSTestPlanDetail view_entity from BASIC Test Plan Details IPUTS

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tpname_id IPUTS_DTE_TESTPLAN_UUID Test Plan
testplan_no IPUTS_DTE_TESTPLAN_NO Test Plan Number
tpgroup_id IPUTS_DTE_TESTPLAN_GROUP_UUID Test Plan Group
process_id IPUTS_DTE_PROCESS_ID Process ID
testplan_id IPUTS_DTE_TESTPLAN_ID Test Plan ID
variant_id IPUTS_DTE_VARIANT_ID Variant ID
cloud_release IPUTS_DTE_CLOUD_RELEASE Cloud Release
log_id IPUTS_DTE_LOG_ID Log ID
status IPUTS_DTE_STATUS Status
status_desc IPUTS_DTE_STATUS_DESC Status Description
executed_on IPUTS_DTE_EXECUTED_ON Execution Date
system_id IPUTS_DTE_SYSTEM_ID System ID
created_by IPUTS_DTE_CREATED_BY Created By
created_at IPUTS_DTE_CREATED_AT Created At
changed_by IPUTS_DTE_CHANGED_BY Changed By
changed_at IPUTS_DTE_CHANGED_AT Changed At

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.

-- IPUTS Test Plan Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IPUTS_A_TESTPLAN (
    MANDT,          -- Client [MANDT]
    TPNAME_ID,      -- Test Plan [IPUTS_DTE_TESTPLAN_UUID]
    TESTPLAN_NO,    -- Test Plan Number [IPUTS_DTE_TESTPLAN_NO]
    TPGROUP_ID,     -- Test Plan Group [IPUTS_DTE_TESTPLAN_GROUP_UUID]
    PROCESS_ID,     -- Process ID [IPUTS_DTE_PROCESS_ID]
    TESTPLAN_ID,    -- Test Plan ID [IPUTS_DTE_TESTPLAN_ID]
    VARIANT_ID,     -- Variant ID [IPUTS_DTE_VARIANT_ID]
    CLOUD_RELEASE,  -- Cloud Release [IPUTS_DTE_CLOUD_RELEASE]
    LOG_ID,         -- Log ID [IPUTS_DTE_LOG_ID]
    STATUS,         -- Status [IPUTS_DTE_STATUS]
    STATUS_DESC,    -- Status Description [IPUTS_DTE_STATUS_DESC]
    EXECUTED_ON,    -- Execution Date [IPUTS_DTE_EXECUTED_ON]
    SYSTEM_ID,      -- System ID [IPUTS_DTE_SYSTEM_ID]
    CREATED_BY,     -- Created By [IPUTS_DTE_CREATED_BY]
    CREATED_AT,     -- Created At [IPUTS_DTE_CREATED_AT]
    CHANGED_BY,     -- Changed By [IPUTS_DTE_CHANGED_BY]
    CHANGED_AT,     -- Changed At [IPUTS_DTE_CHANGED_AT]
    PRIMARY KEY (MANDT, TPNAME_ID)
);