T042Z

Transparent Table Customizing Table

Payment Methods for Automatic Payment

T042Z is an SAP database table in S/4HANA. Payment Methods for Automatic Payment. It contains 38 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
Arberp_V_Paym_Methods view from Ariba: Relevant Payment Methods
I_ACMPaymentMethod view from BASIC ACM Payment Method
I_PaymentMethod view from BASIC Payment Method for Country/Region
I_PaymentMethodInCountryVH view from BASIC Payment Method for Country/Region
I_PaytReceiptPaytMethVH view inner BASIC Payment Receipt Payment Method
I_SettlementPaymentMethod view from BASIC Private layer for Payment Method

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY land1 LAND1 Country/Reg.
KEY zlsch DZLSCH Pymt Meth.
text1 TEXT1_042Z Name
xbkkt XBKKT Bank details
xstra XSTRA Street,P.O.box or P.O.box pst code
xeinz XEINZ Incoming Payments
xesrd XESRD_042Z ISR/QR payment procedure
xpgir XPGIR Post office curr.acct method?
xezer XEZER_042Z Collection Auth.
xschk XSCHK_042Z Check is created
progn PROGN_042Z Name of the Print Program
xzwhr XZWHR Allowed for personnel payments
xeuro XEURO EU Intnl Transfer
formi FORMI_COMBINED Payt Mdm Format
formz FORMZ_COMBINED Format Supplmnt
xwech XWECH Bill of Exchange Will Be Created
xwanf XWANF Bill of Exchange Payment Request
xpskt XPSKT Payment by Postal Check Account
xwecs XWECS Create Bill/Exch. Before Due Date
blart BLART_042Z Document Type for Payment
blarv BLARV_042Z Clearing Document Type
umskz UMSKZ_042Z Sp.G/L Ind.B/Ex. / B/Ex.Pmnt Req.
xswec XSWEC Check/Bill of Exchange
txtsl TXTSL_042Z Key in code line
zlstn DZLSTN Name of the Print Dataset
wlstn WLSTN Print Dataset for B/Exch.
xzanf XZANF Payment Request
xaktz XAKTZ Accepted
weart WEART Bill of Exc.Typ
xnopo XNOPO Payment Order Only
xorb FPMCL Payment Meth. Class.
xiban XIBAN_042Z SWIFT Code and IBAN
xno_accno XNO_ACCNO_042Z Indicator: No Account Number Required
xsepa XSEPA SEPA Mandate
xalias XALIAS Indicator: Alias Required
xsfsf XSFSF Supplier Financing
umskz_sf UMSKZ_SF Sp.G/L Ind. for SF

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.

-- Payment Methods for Automatic Payment
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T042Z (
    MANDT,      -- Client [MANDT]
    LAND1,      -- Country/Reg. [LAND1]
    ZLSCH,      -- Pymt Meth. [DZLSCH]
    TEXT1,      -- Name [TEXT1_042Z]
    XBKKT,      -- Bank details [XBKKT]
    XSTRA,      -- Street,P.O.box or P.O.box pst code [XSTRA]
    XEINZ,      -- Incoming Payments [XEINZ]
    XESRD,      -- ISR/QR payment procedure [XESRD_042Z]
    XPGIR,      -- Post office curr.acct method? [XPGIR]
    XEZER,      -- Collection Auth. [XEZER_042Z]
    XSCHK,      -- Check is created [XSCHK_042Z]
    PROGN,      -- Name of the Print Program [PROGN_042Z]
    XZWHR,      -- Allowed for personnel payments [XZWHR]
    XEURO,      -- EU Intnl Transfer [XEURO]
    FORMI,      -- Payt Mdm Format [FORMI_COMBINED]
    FORMZ,      -- Format Supplmnt [FORMZ_COMBINED]
    XWECH,      -- Bill of Exchange Will Be Created [XWECH]
    XWANF,      -- Bill of Exchange Payment Request [XWANF]
    XPSKT,      -- Payment by Postal Check Account [XPSKT]
    XWECS,      -- Create Bill/Exch. Before Due Date [XWECS]
    BLART,      -- Document Type for Payment [BLART_042Z]
    BLARV,      -- Clearing Document Type [BLARV_042Z]
    UMSKZ,      -- Sp.G/L Ind.B/Ex. / B/Ex.Pmnt Req. [UMSKZ_042Z]
    XSWEC,      -- Check/Bill of Exchange [XSWEC]
    TXTSL,      -- Key in code line [TXTSL_042Z]
    ZLSTN,      -- Name of the Print Dataset [DZLSTN]
    WLSTN,      -- Print Dataset for B/Exch. [WLSTN]
    XZANF,      -- Payment Request [XZANF]
    XAKTZ,      -- Accepted [XAKTZ]
    WEART,      -- Bill of Exc.Typ [WEART]
    XNOPO,      -- Payment Order Only [XNOPO]
    XORB,       -- Payment Meth. Class. [FPMCL]
    XIBAN,      -- SWIFT Code and IBAN [XIBAN_042Z]
    XNO_ACCNO,  -- Indicator: No Account Number Required [XNO_ACCNO_042Z]
    XSEPA,      -- SEPA Mandate [XSEPA]
    XALIAS,     -- Indicator: Alias Required [XALIAS]
    XSFSF,      -- Supplier Financing [XSFSF]
    UMSKZ_SF,   -- Sp.G/L Ind. for SF [UMSKZ_SF]
    PRIMARY KEY (MANDT, LAND1, ZLSCH)
);