SAP Table T012
House Banks
T012 (House Banks) 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 T012 to other SAP tables.
T012 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 |
CHAR
|
5 | 0 | ||||||||
|
BANKS
Bank country key
|
BANKS | T005 |
CHAR
|
3 | 0 | |||||||
|
BANKL
Bank Keys
|
BANKK |
CHAR
|
15 | 0 | ||||||||
|
TELF1
First telephone number
|
TELF1 |
CHAR
|
16 | 0 | ||||||||
|
STCD1
Tax Number 1
|
STCD1 |
CHAR
|
16 | 0 | ||||||||
|
NAME1
Name of contact person
|
NAME1_A |
CHAR
|
30 | 0 | ||||||||
|
SPRAS
Language Key
|
SPRAS | T002 |
LANG
|
1 | 0 | |||||||
|
BUPLA
Business Place
|
BUPLA_T012 | J_1BBRANCH |
CHAR
|
4 | 0 | |||||||
|
VPAST
Value date in the past allowed
|
VPAST |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
T012 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T012 | BANKS | T012 | MANDT |
T005
Countries
|
MANDT |
| T012 | BANKS | T012 | BANKS |
T005
Countries
|
LAND1 |
| T012 | BUKRS | T012 | MANDT |
T001
Company Codes
|
MANDT |
| T012 | BUKRS | T012 | BUKRS |
T001
Company Codes
|
BUKRS |
| T012 | BUPLA | T012 | MANDT |
J_1BBRANCH
Business Place
|
MANDT |
| T012 | BUPLA | T012 | BUKRS |
J_1BBRANCH
Business Place
|
BUKRS |
| T012 | BUPLA | T012 | BUPLA |
J_1BBRANCH
Business Place
|
BRANCH |
| T012 | MANDT | T012 | MANDT |
T000
Clients
|
MANDT |
| T012 | SPRAS | T012 | SPRAS |
T002
Language Keys (Component BC-I18)
|
SPRAS |