SAP-tabelreferentie
T012
House BanksBekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel T012.
SAP-tabel T012 heeft 3 primaire sleutelvelden: MANDT,BUKRS,HBKID.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
/ Velden
T012 velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |
|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Sleutel BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| Sleutel 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 |
/ Relaties
T012 relaties.
| Tabel | Veld | Checktabel | Omschrijving | Checkveld |
|---|---|---|---|---|
| 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 |