T405

Transparent Table Customizing Table
12 Fields 2 CDS Views

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_entity 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)
);

Learn More