T012
House BanksExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table T012.
SAP table T012 has 3 primary key fields: MANDT,BUKRS,HBKID.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
T012 fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Key BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| Key HBKID | Short Key for a House Bank | CHAR | 5 | 0 | HBKID | ||
| BANKS | Country/Region Key of Bank | CHAR | 3 | 0 | T005 | BANKS | |
| BANKL | Bank Keys | CHAR | 15 | 0 | BANKK | ||
| TELF1 | First telephone number | CHAR | 16 | 0 | TELF1 | ||
| STCD1 | Tax Number 1 | CHAR | 16 | 0 | STCD1 | ||
| NAME1 | Name of contact person | CHAR | 30 | 0 | NAME1_A | ||
| SPRAS | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
| BUPLA | Business Place | CHAR | 4 | 0 | PBUSINESSPLACE | BUPLA_T012 | |
| VPAST | Value date in the past allowed | CHAR | 1 | 0 | VPAST |
T012 relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| T012 | BANKS | T005 | Countries | MANDT |
| T012 | BANKS | T005 | Countries | LAND1 |
| T012 | BUKRS | T001 | Company Codes | BUKRS |
| T012 | BUPLA | PBUSINESSPLACE | Generated Table for View | BUKRS |
| T012 | BUPLA | PBUSINESSPLACE | Generated Table for View | BRANCH |
| T012 | MANDT | T000 | Clients | MANDT |
| T012 | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |