T042

Transparent Table Customizing Table
16 Fields 2 CDS Views

Parameters for payment transactions

T042 is an SAP database table in S/4HANA. Parameters for payment transactions. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FOP_AUTH_CANCEL view inner
I_PayableToleranceDay view from BASIC Payable Tolerance Day

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
zbukr DZBUKR Paying co. code
ulsk1 ULSK1 Sp. G/L Transactions to Be Paid
ulsk2 ULSK2 Sp. G/L Trans. for Exception List
ulsd1 ULSD1 Sp. G/L Transactions to Be Paid
ulsd2 ULSD2 Sp. G/L Trans. for Exception List
xkdfb XKDFB Post Exchange Rate Differences
xgbtr XGBTR Separate Payment per Business Area
toltg TOLTG_042 Tolerance Days for Payable
sktug SKTUG_042 Outgoing Pmnt with Cash Disc.From
xskr1 XSKR1 Max.Cash Discount
absbu ABSBU Sending co.code
xuzaw XUZAW Pyt Meth Suppl.
xbptr XBPTR Separate Payment per Business Place
xrguh XBSEC_042Z Transfer Bank Details

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.

-- Parameters for payment transactions
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T042 (
    MANDT,  -- Client [MANDT]
    BUKRS,  -- Company Code [BUKRS]
    ZBUKR,  -- Paying co. code [DZBUKR]
    ULSK1,  -- Sp. G/L Transactions to Be Paid [ULSK1]
    ULSK2,  -- Sp. G/L Trans. for Exception List [ULSK2]
    ULSD1,  -- Sp. G/L Transactions to Be Paid [ULSD1]
    ULSD2,  -- Sp. G/L Trans. for Exception List [ULSD2]
    XKDFB,  -- Post Exchange Rate Differences [XKDFB]
    XGBTR,  -- Separate Payment per Business Area [XGBTR]
    TOLTG,  -- Tolerance Days for Payable [TOLTG_042]
    SKTUG,  -- Outgoing Pmnt with Cash Disc.From [SKTUG_042]
    XSKR1,  -- Max.Cash Discount [XSKR1]
    ABSBU,  -- Sending co.code [ABSBU]
    XUZAW,  -- Pyt Meth Suppl. [XUZAW]
    XBPTR,  -- Separate Payment per Business Place [XBPTR]
    XRGUH,  -- Transfer Bank Details [XBSEC_042Z]
    PRIMARY KEY (MANDT, BUKRS)
);

Learn More