SAP Table T012K
House Bank Accounts
T012K (House Bank Accounts) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T012K to other SAP tables.
T012K table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||
| HBKID | Short Key for a House Bank | HBKID | T012 | CHAR | 5 | 0 | ||||||
| HKTID | ID for account details | HKTID | CHAR | 5 | 0 | |||||||
| BANKN | Bank account number | BANKN | CHAR | 18 | 0 | |||||||
| BKONT | Bank Control Key | BKONT | CHAR | 2 | 0 | |||||||
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
| REFZL | Reference Information | REFZL | CHAR | 27 | 0 | |||||||
| DTAAI | DME Sold-To Party Identification (Switzerland) | DTAAI | CHAR | 5 | 0 | |||||||
| BNKN2 | Alternative Bank Acct Number (for Ambiguous Acct Number) | BNKN2 | CHAR | 24 | 0 | |||||||
| FDGRP | Planning Group | FDGRP | T035 | CHAR | 10 | 0 | ||||||
| ABWAE | Settlement currency for bank transfers | ABWAE | TCURC | CUKY | 5 | 0 | ||||||
| HKONT | General Ledger Account | HKONT | SKB1 | CHAR | 10 | 0 | ||||||
| WEKON | Subaccount for bill of exchange presentation for discounting | WEKON | SKB1 | CHAR | 10 | 0 | ||||||
| MINDT | Minimum days until due date when presenting for collection | MINDT | NUMC | 3 | 0 | |||||||
| HBID1 | Alternative house bnk for bill/exch. presentation debit memo | HBID1_012K | T012 | CHAR | 5 | 0 | ||||||
| HKID1 | Account details for debit memo from bill/exch. presentation | HKID1_012K | T012K | CHAR | 5 | 0 | ||||||
| HBID2 | Alternative house bank for failed bill/exch. receivable | HBID2_012K | T012 | CHAR | 5 | 0 | ||||||
| HKID2 | Account details for debit memo from bill/exch. presentation | HKID2_012K | T012K | CHAR | 5 | 0 | ||||||
| WKKON | Bk act to be debited with amount from returned bill payable | WKKON_012K | SKB1 | CHAR | 10 | 0 | ||||||
| WIKON | Subaccount for bill of exchange collection | WIKON_012K | SKB1 | CHAR | 10 | 0 | ||||||
| BROLL | Attribute for use by house banks in PRQ payment program | PRQ_BROLL | CHAR | 2 | 0 | |||||||
| XTPRB | Flag for determining whether transit or principal bank | PRQ_XTPRB | CHAR | 1 | 0 |
Possible values
|
||||||
T012K foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T012K | ABWAE | T012K | MANDT | TCURC | Currency Codes | MANDT |
| T012K | ABWAE | T012K | ABWAE | TCURC | Currency Codes | WAERS |
| T012K | BUKRS | T012K | MANDT | T001 | Company Codes | MANDT |
| T012K | BUKRS | T012K | BUKRS | T001 | Company Codes | BUKRS |
| T012K | FDGRP | T012K | MANDT | T035 | Planning groups | MANDT |
| T012K | FDGRP | T012K | FDGRP | T035 | Planning groups | GRUPP |
| T012K | HBID1 | T012K | BUKRS | T012 | House Banks | BUKRS |
| T012K | HBID1 | T012K | HBID1 | T012 | House Banks | HBKID |
| T012K | HBID1 | T012K | MANDT | T012 | House Banks | MANDT |
| T012K | HBID2 | T012K | MANDT | T012 | House Banks | MANDT |
| T012K | HBID2 | T012K | BUKRS | T012 | House Banks | BUKRS |
| T012K | HBID2 | T012K | HBID2 | T012 | House Banks | HBKID |
| T012K | HBKID | T012K | BUKRS | T012 | House Banks | BUKRS |
| T012K | HBKID | T012K | HBKID | T012 | House Banks | HBKID |
| T012K | HBKID | T012K | MANDT | T012 | House Banks | MANDT |
| T012K | HKID1 | T012K | HKID1 | T012K | House Bank Accounts | HKTID |
| T012K | HKID1 | T012K | MANDT | T012K | House Bank Accounts | MANDT |
| T012K | HKID1 | T012K | BUKRS | T012K | House Bank Accounts | BUKRS |
| T012K | HKID1 | T012K | HBID1 | T012K | House Bank Accounts | HBKID |
| T012K | HKID2 | T012K | MANDT | T012K | House Bank Accounts | MANDT |
| T012K | HKID2 | T012K | BUKRS | T012K | House Bank Accounts | BUKRS |
| T012K | HKID2 | T012K | HBID2 | T012K | House Bank Accounts | HBKID |
| T012K | HKID2 | T012K | HKID2 | T012K | House Bank Accounts | HKTID |
| T012K | HKONT | T012K | MANDT | SKB1 | G/L account master (company code) | MANDT |
| T012K | HKONT | T012K | BUKRS | SKB1 | G/L account master (company code) | BUKRS |
| T012K | HKONT | T012K | HKONT | SKB1 | G/L account master (company code) | SAKNR |
| T012K | MANDT | T012K | MANDT | T000 | Clients | MANDT |
| T012K | WAERS | T012K | MANDT | TCURC | Currency Codes | MANDT |
| T012K | WAERS | T012K | WAERS | TCURC | Currency Codes | WAERS |
| T012K | WEKON | T012K | MANDT | SKB1 | G/L account master (company code) | MANDT |
| T012K | WEKON | T012K | BUKRS | SKB1 | G/L account master (company code) | BUKRS |
| T012K | WEKON | T012K | WEKON | SKB1 | G/L account master (company code) | SAKNR |
| T012K | WIKON | T012K | MANDT | SKB1 | G/L account master (company code) | MANDT |
| T012K | WIKON | T012K | BUKRS | SKB1 | G/L account master (company code) | BUKRS |
| T012K | WIKON | T012K | WIKON | SKB1 | G/L account master (company code) | SAKNR |
| T012K | WKKON | T012K | WKKON | SKB1 | G/L account master (company code) | SAKNR |
| T012K | WKKON | T012K | MANDT | SKB1 | G/L account master (company code) | MANDT |
| T012K | WKKON | T012K | BUKRS | SKB1 | G/L account master (company code) | BUKRS |
