SAP table T012K (House Bank Accounts)
SAP table T012K has 4 primary key fields being MANDT,BUKRS,HBKID,HKTID.
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 | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| HBKID | Short Key for a House Bank | CHAR | 5 | 0 | T012 | HBKID | |
| HKTID | ID for Account Details | CHAR | 5 | 0 | HKTID | ||
| BANKN | Bank account number | CHAR | 18 | 0 | BANKN | ||
| BKONT | Bank Control Key | CHAR | 2 | 0 | BKONT | ||
| WAERS | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |
| REFZL | Reference Information | CHAR | 27 | 0 | REFZL | ||
| DTAAI | DME Sold-To Party Identification (Switzerland) | CHAR | 5 | 0 | DTAAI | ||
| BNKN2 | Alternative Bank Account Number (for Ambiguous Acct Number) | CHAR | 24 | 0 | BNKN2 | ||
| FDGRP | Planning Group | CHAR | 10 | 0 | T035 | FDGRP | |
| ABWAE | Settlement currency for bank transfers | CUKY | 5 | 0 | TCURC | ABWAE | |
| HKONT | General Ledger Account | CHAR | 10 | 0 | SKB1 | HKONT | |
| WEKON | Subaccount for Bill of Exchange Presentation for Discounting | CHAR | 10 | 0 | SKB1 | WEKON | |
| MINDT | Minimum days until due date when presenting for collection | NUMC | 3 | 0 | MINDT | ||
| HBID1 | Alternative house bnk for bill/exch. presentation debit memo | CHAR | 5 | 0 | T012 | HBID1_012K | |
| HKID1 | Account details for debit memo from bill/exch. presentation | CHAR | 5 | 0 | T012K | HKID1_012K | |
| HBID2 | Alternative house bank for failed bill/exch. receivable | CHAR | 5 | 0 | T012 | HBID2_012K | |
| HKID2 | Account details for debit memo from bill/exch. presentation | CHAR | 5 | 0 | T012K | HKID2_012K | |
| WKKON | Bk Act to Be Debited with Amount from Returned Bill Payable | CHAR | 10 | 0 | SKB1 | WKKON_012K | |
| WIKON | Subaccount for Bill of Exchange Collection | CHAR | 10 | 0 | SKB1 | WIKON_012K | |
| BROLL | Attribute for use by house banks in PRQ payment program | CHAR | 2 | 0 | PRQ_BROLL | ||
| XTPRB | Flag for determining whether transit or principal bank | CHAR | 1 | 0 | PRQ_XTPRB |
T012K foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T012K | ABWAE | TCURC | Currency Codes | MANDT |
| 0 T012K | ABWAE | TCURC | Currency Codes | WAERS |
| 1 T012K | BUKRS | T001 | Company Codes | BUKRS |
| 0 T012K | FDGRP | T035 | Planning groups | GRUPP |
| 1 T012K | HBID1 | T012 | House Banks | BUKRS |
| 0 T012K | HBID2 | T012 | House Banks | BUKRS |
| 1 T012K | HBKID | T012 | House Banks | BUKRS |
| 0 T012K | HKID1 | T012K | House Bank Accounts | MANDT |
| 0 T012K | HKID1 | T012K | House Bank Accounts | BUKRS |
| 0 T012K | HKID1 | T012K | House Bank Accounts | HBKID |
| 0 T012K | HKID1 | T012K | House Bank Accounts | HKTID |
| 1 T012K | HKID2 | T012K | House Bank Accounts | MANDT |
| 1 T012K | HKID2 | T012K | House Bank Accounts | BUKRS |
| 1 T012K | HKID2 | T012K | House Bank Accounts | HBKID |
| 1 T012K | HKID2 | T012K | House Bank Accounts | HKTID |
| 0 T012K | HKONT | SKB1 | G/L account master (company code) | MANDT |
| 0 T012K | HKONT | SKB1 | G/L account master (company code) | BUKRS |
| 1 T012K | MANDT | T000 | Clients | MANDT |
| 0 T012K | WAERS | TCURC | Currency Codes | MANDT |
| 0 T012K | WAERS | TCURC | Currency Codes | WAERS |
| 1 T012K | WEKON | SKB1 | G/L account master (company code) | MANDT |
| 1 T012K | WEKON | SKB1 | G/L account master (company code) | BUKRS |
| 0 T012K | WIKON | SKB1 | G/L account master (company code) | MANDT |
| 0 T012K | WIKON | SKB1 | G/L account master (company code) | BUKRS |
| 1 T012K | WKKON | SKB1 | G/L account master (company code) | MANDT |
| 1 T012K | WKKON | SKB1 | G/L account master (company code) | BUKRS |