T042Y

Transparent Table Customizing Table
10 Fields 4 CDS Views

Account Determination for Bank to Bank Payments

T042Y is an SAP database table in S/4HANA. Account Determination for Bank to Bank Payments. It contains 10 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FCLMGLAccountBankClearing view from G/L Accounts Assigned to Bank Clearing
I_BkToBkPaymentClearingAccount view from BASIC Clearing Account for Bank to Bank Payment
I_HouseBkAcctInPaymentConfign view union BASIC House Bank Acct in payment configuration
I_PaymentMethodVH view from BASIC Obsolete: Payment Method Value Help

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY zbukr DZBUKR Paying co. code
KEY hbkid HBKID House Bank
KEY zlsch DZLSCH Pymt Meth.
KEY waers WAERS Currency
KEY hktid HKTID Account ID
ukont UKONT_042I Bank Subacct
vkont VKONT_042I Clearing Account
gebkz GEBKZ Charge Ind.
gsber GSBER_BANK Bus. Area

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.

-- Account Determination for Bank to Bank Payments
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T042Y (
    MANDT,  -- Client [MANDT]
    ZBUKR,  -- Paying co. code [DZBUKR]
    HBKID,  -- House Bank [HBKID]
    ZLSCH,  -- Pymt Meth. [DZLSCH]
    WAERS,  -- Currency [WAERS]
    HKTID,  -- Account ID [HKTID]
    UKONT,  -- Bank Subacct [UKONT_042I]
    VKONT,  -- Clearing Account [VKONT_042I]
    GEBKZ,  -- Charge Ind. [GEBKZ]
    GSBER,  -- Bus. Area [GSBER_BANK]
    PRIMARY KEY (MANDT, ZBUKR, HBKID, ZLSCH, WAERS, HKTID)
);

Learn More