T405

Transparent Table Customizing Table

Purchasing Value Key

T405 is an SAP database table in S/4HANA. Purchasing Value Key. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PurgAcknowledgmentProfile view_entity from BASIC Puchasing Acknowledgment Profile
I_Purgvalkey view from BASIC Purchasing Value Key

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ekwsl EKWSL Purch.value key
mahn1 MAHN1 1st Rem./Exped.
mahn2 MAHN2 2nd Rem./Exped.
mahn3 MAHN3 3rd Rem./Exped.
untto UNTTO Underdel. Tol.
uebto UEBTO Overdeliv. Tol.
uebtk UEBTK Unlimited
evers EVERS Shipping Instr.
kzabs KZABS Acknowl. Reqd.
weprz WEPRZ Min.Del.Qty %
welfz WELFZ StValDelDtVar

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.

-- Purchasing Value Key
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T405 (
    MANDT,  -- Client [MANDT]
    EKWSL,  -- Purch.value key [EKWSL]
    MAHN1,  -- 1st Rem./Exped. [MAHN1]
    MAHN2,  -- 2nd Rem./Exped. [MAHN2]
    MAHN3,  -- 3rd Rem./Exped. [MAHN3]
    UNTTO,  -- Underdel. Tol. [UNTTO]
    UEBTO,  -- Overdeliv. Tol. [UEBTO]
    UEBTK,  -- Unlimited [UEBTK]
    EVERS,  -- Shipping Instr. [EVERS]
    KZABS,  -- Acknowl. Reqd. [KZABS]
    WEPRZ,  -- Min.Del.Qty % [WEPRZ]
    WELFZ,  -- StValDelDtVar [WELFZ]
    PRIMARY KEY (MANDT, EKWSL)
);