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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||
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 | BUPLA | J_1BBRANCH | Business Place | BRANCH |
| T012 | BUPLA | T012 | MANDT | J_1BBRANCH | Business Place | MANDT |
| T012 | BUPLA | T012 | BUKRS | J_1BBRANCH | Business Place | BUKRS |
| T012 | MANDT | T012 | MANDT | T000 | Clients | MANDT |
| T012 | SPRAS | T012 | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |
