SAP table T042E (Company Code-Specific Specifications for Payment Methods)

SAP table T042E has 3 primary key fields being MANDT,ZBUKR,ZLSCH.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
ZBUKR Paying company code CHAR 4 0 T001 DZBUKR
ZLSCH Payment Method CHAR 1 0 T042Z DZLSCH
XAVIS Indicator: Separate Payment Advice If Form Is Full? CHAR 1 0 XAVIS
ANZPO Maximum Number of Items on a Form NUMC 2 0 ANZPO_042Z
VONBT Minimum Amount for a Payment Using This Payment Method CURR 23 2 VONBT_042Z
BISBT Maximum Amount for a Payment with This Payment Method CURR 23 2 BISBT_042Z
WAERS Currency Key CUKY 5 0 TCURC WAERS
XEIPO Indicator: One Payment per Item? CHAR 1 0 XEIPO_042Z
XAUSL Indicator: Foreign Business Partner Allowed? CHAR 1 0 XAUSL_042Z
XFWAE Indicator: Payment Method for Foreign Currencies Allowed CHAR 1 0 XFWAE_042Z
XAUSB Indicator: Payment via Cust./Vend. Bank Abroad Allowed? CHAR 1 0 XAUSB_042Z
XOPTB Indicator: Carry Out Bank Selection by Bank Group CHAR 1 0 XOPTB_042Z
XOPTP Indicator: Carry Out Bank Selection by Postal Code CHAR 1 0 XOPTP_042Z
AUST1 Issuer on the Form CHAR 35 0 AUSTX_042E
AUST2 Issuer on the Form CHAR 35 0 AUSTX_042E
AUSTO Issuer on the Form CHAR 35 0 AUSTX_042E
ZFORN Name of the Form for the Payment Transfer Medium CHAR 16 0 DZFORN
PDFFO Name of the PDF-based Form for the Payment Medium CHAR 30 0 DZFORN_PDF
WFORN Name of Next Form CHAR 16 0 WFORN
PDFWF Name of the Next PDF-based Form CHAR 30 0 WFORN_PDF
XFOSP Indicator: Extra Forms If Form Is Full CHAR 1 0 XFOSP
AUST3 Issuer on the Form CHAR 35 0 AUSTX_042E
XZFAE Indicator: Payment per Due Day CHAR 1 0 XZFAE
XSAVI Indicator: Always Payment Advice Notes for This Payment Mthd CHAR 1 0 XSAVI
CORRTXT Smart Forms: Name of a text module CHAR 30 0 T042ECT TDTXTNAME
XWVBU Indicator: Line Item for Bill Liability at the Bank? CHAR 1 0 XWVBU_042Z
WANFF Number of Days Until Bill of Exchange Pmnt Request Due Date NUMC 2 0 WANFF
WGBKZ Indicator for the Bill of Exchange Protest CHAR 1 0 WGBKZ
Drawer does not take over charges for bill/exch.protest
1 Drawer takes over charges for bill/exch.protest
9 Drawer gives explicit instructions for bill/exch.protest
SVARH Sort Variant for Payment Transaction Correspondence CHAR 3 0 T021M SVARH
SVARP Sort Variant for the Line Items CHAR 3 0 T021M SVARP
SPLBT Distribution into Payments up to a Maximum of This Amount CURR 23 2 SPLBT
XZWAE Indicator: Amount Limits in EUR CHAR 1 0 XZWAE
XNOTX Indicator: Do Not Consider Item Text CHAR 1 0 XSGTXT_NO
XEIPO_EXT Indicator: Extended Individual Payment CHAR 1 0 XEIPO_EXT_042Z

T042E foreign key relationships

Table Field Check Table Check Field
0 T042E CORRTXT T042ECT Letter for Payment Correspondence (PDF) MANDT
1 T042E SVARH T021M Sort Variants MANDT
1 T042E SVARH T021M Sort Variants PROGN
1 T042E SVARH T021M Sort Variants SRVAR
0 T042E SVARP T021M Sort Variants MANDT
0 T042E SVARP T021M Sort Variants PROGN
0 T042E SVARP T021M Sort Variants SRVAR
1 T042E WAERS TCURC Currency Codes MANDT
1 T042E WAERS TCURC Currency Codes WAERS
0 T042E ZBUKR T001 Company Codes BUKRS
1 T042E ZLSCH T042Z Payment Methods for Automatic Payment MANDT
1 T042E ZLSCH T042Z Payment Methods for Automatic Payment LAND1
1 T042E ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH