SAP table T042I (Account determination for payment program)

SAP table T042I has 5 primary key fields being MANDT,ZBUKR,HBKID,ZLSCH,WAERS.

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 T000 MANDT
ZBUKR Paying company code CHAR 4 0 T001 DZBUKR
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
ZLSCH Payment Method CHAR 1 0 T042E DZLSCH
WAERS Currency Key CUKY 5 0 TCURC WAERS
HKTID ID for Account Details CHAR 5 0 T012K HKTID
UKONT G/L Account to Be Posted to (Bank Subaccount) CHAR 10 0 SKB1 UKONT_042I
VKONT Clearing Account for Bill Liability at the Bank CHAR 10 0 SKB1 VKONT_042I
GEBKZ Charge Indicator CHAR 2 0 GEBKZ
GSBER Business Area for Bank Posting CHAR 4 0 TGSB GSBER_BANK

T042I foreign key relationships

Table Field Check Table Check Field
0 T042I GSBER TGSB Business Areas MANDT
0 T042I GSBER TGSB Business Areas GSBER
1 T042I HBKID T012 House Banks BUKRS
0 T042I HKTID T012K House Bank Accounts MANDT
0 T042I HKTID T012K House Bank Accounts BUKRS
0 T042I HKTID T012K House Bank Accounts HBKID
0 T042I HKTID T012K House Bank Accounts HKTID
1 T042I MANDT T000 Clients MANDT
0 T042I UKONT SKB1 G/L account master (company code) MANDT
0 T042I UKONT SKB1 G/L account master (company code) BUKRS
1 T042I VKONT SKB1 G/L account master (company code) MANDT
1 T042I VKONT SKB1 G/L account master (company code) BUKRS
0 T042I WAERS TCURC Currency Codes MANDT
0 T042I WAERS TCURC Currency Codes WAERS
1 T042I ZBUKR T001 Company Codes BUKRS
0 T042I ZLSCH T042E Company Code-Specific Specifications for Payment Methods MANDT
0 T042I ZLSCH T042E Company Code-Specific Specifications for Payment Methods ZBUKR
0 T042I ZLSCH T042E Company Code-Specific Specifications for Payment Methods ZLSCH