SAP Table
T012K House Bank Accounts
SAP table T012K has 4 primary key fields being MANDT,BUKRS,HBKID,HKTID.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
T012K columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyBUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| KeyHBKID | Short Key for a House Bank | CHAR | 5 | 0 | T012 | HBKID | |
| KeyHKTID | 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 |
/ Relationships
T012K foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| T012K | ABWAE | TCURC | Currency Codes | MANDT |
| T012K | ABWAE | TCURC | Currency Codes | WAERS |
| T012K | BUKRS | T001 | Company Codes | BUKRS |
| T012K | FDGRP | T035 | Planning groups | GRUPP |
| T012K | HBID1 | T012 | House Banks | BUKRS |
| T012K | HBID2 | T012 | House Banks | BUKRS |
| T012K | HBKID | T012 | House Banks | BUKRS |
| T012K | HKID1 | T012K | House Bank Accounts | MANDT |
| T012K | HKID1 | T012K | House Bank Accounts | BUKRS |
| T012K | HKID1 | T012K | House Bank Accounts | HBKID |
| T012K | HKID1 | T012K | House Bank Accounts | HKTID |
| T012K | HKID2 | T012K | House Bank Accounts | MANDT |
| T012K | HKID2 | T012K | House Bank Accounts | BUKRS |
| T012K | HKID2 | T012K | House Bank Accounts | HBKID |
| T012K | HKID2 | T012K | House Bank Accounts | HKTID |
| T012K | HKONT | SKB1 | G/L account master (company code) | MANDT |
| T012K | HKONT | SKB1 | G/L account master (company code) | BUKRS |
| T012K | MANDT | T000 | Clients | MANDT |
| T012K | WAERS | TCURC | Currency Codes | MANDT |
| T012K | WAERS | TCURC | Currency Codes | WAERS |
| T012K | WEKON | SKB1 | G/L account master (company code) | MANDT |
| T012K | WEKON | SKB1 | G/L account master (company code) | BUKRS |
| T012K | WIKON | SKB1 | G/L account master (company code) | MANDT |
| T012K | WIKON | SKB1 | G/L account master (company code) | BUKRS |
| T012K | WKKON | SKB1 | G/L account master (company code) | MANDT |
| T012K | WKKON | SKB1 | G/L account master (company code) | BUKRS |