/PF1/DB_TEST

Transparent Table Application Table
22 Fields 1 CDS Views

Database Table for Tests

/PF1/DB_TEST is an SAP database table in S/4HANA. Database Table for Tests. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
/PF1/P_DB_TEST view from Rule Conditions - P View

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY clearing_area /PF1/DTE_BPE_CLEARING_AREA Clearing Area
KEY release_status /PF1/DTE_BPE_RELEASE_STATUS Release Status
KEY component_id /PF1/DTE_RP_COMPONENT_ID Component
KEY ruleset_id /PF1/DTE_RP_RULESET_ID ID for Rule Set
KEY rule_id /PF1/DTE_RP_RULE_ID Rule ID
KEY test_id /PF1/DTE_RP_TEST_ID Test ID
KEY so_index /PF1/DTE_RP_SO_INDEX Index Number
characteristic /PF1/DTE_RP_CHARACTERISTIC_ID Characteristic
so_sign /PF1/DTE_RP_SO_SIGN Inclusive/exclusive
so_option /PF1/DTE_RP_SO_OPTION Option
so_low /PF1/DTE_RP_SELOPT_VALUE Value
so_high /PF1/DTE_RP_SELOPT_VALUE Value
crusr /PF1/DTE_BPE_CRUSR Created By
crdat /PF1/DTE_BPE_CRDAT Created On
crtim /PF1/DTE_BPE_CRTIM Created At
chusr /PF1/DTE_BPE_CHUSR Changed By
chdat /PF1/DTE_BPE_CHDAT Changed On
chtim /PF1/DTE_BPE_CHTIM Changed At
rlusr /PF1/DTE_BPE_RLUSR Released By
rldat /PF1/DTE_BPE_RLDAT Released
rltim /PF1/DTE_BPE_RLTIM Released 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.

-- Database Table for Tests
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /PF1/DB_TEST (
    CLIENT,          -- Client [MANDT]
    CLEARING_AREA,   -- Clearing Area [/PF1/DTE_BPE_CLEARING_AREA]
    RELEASE_STATUS,  -- Release Status [/PF1/DTE_BPE_RELEASE_STATUS]
    COMPONENT_ID,    -- Component [/PF1/DTE_RP_COMPONENT_ID]
    RULESET_ID,      -- ID for Rule Set [/PF1/DTE_RP_RULESET_ID]
    RULE_ID,         -- Rule ID [/PF1/DTE_RP_RULE_ID]
    TEST_ID,         -- Test ID [/PF1/DTE_RP_TEST_ID]
    SO_INDEX,        -- Index Number [/PF1/DTE_RP_SO_INDEX]
    CHARACTERISTIC,  -- Characteristic [/PF1/DTE_RP_CHARACTERISTIC_ID]
    SO_SIGN,         -- Inclusive/exclusive [/PF1/DTE_RP_SO_SIGN]
    SO_OPTION,       -- Option [/PF1/DTE_RP_SO_OPTION]
    SO_LOW,          -- Value [/PF1/DTE_RP_SELOPT_VALUE]
    SO_HIGH,         -- Value [/PF1/DTE_RP_SELOPT_VALUE]
    CRUSR,           -- Created By [/PF1/DTE_BPE_CRUSR]
    CRDAT,           -- Created On [/PF1/DTE_BPE_CRDAT]
    CRTIM,           -- Created At [/PF1/DTE_BPE_CRTIM]
    CHUSR,           -- Changed By [/PF1/DTE_BPE_CHUSR]
    CHDAT,           -- Changed On [/PF1/DTE_BPE_CHDAT]
    CHTIM,           -- Changed At [/PF1/DTE_BPE_CHTIM]
    RLUSR,           -- Released By [/PF1/DTE_BPE_RLUSR]
    RLDAT,           -- Released [/PF1/DTE_BPE_RLDAT]
    RLTIM,           -- Released At [/PF1/DTE_BPE_RLTIM]
    PRIMARY KEY (CLIENT, CLEARING_AREA, RELEASE_STATUS, COMPONENT_ID, RULESET_ID, RULE_ID, TEST_ID, SO_INDEX)
);

Learn More