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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
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 |