T042Z
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA