SAP table T028B (Transaction Type of Sender Bank)
SAP table T028B has 3 primary key fields being MANDT,BANKL,KTONR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| BANKL | Bank Key (Usually Bank Number) | CHAR | 15 | 0 | BANKK_EB | ||
| KTONR | Bank account number | CHAR | 18 | 0 | BANKN | ||
| VGTYP | Transaction Type | CHAR | 8 | 0 | T028V | VGTYP_EB | |
| CURRKEY | Class of the Currency Key Used | CHAR | 8 | 0 | T028O | CURRKEY | |
| DSART | Planning type | CHAR | 2 | 0 | T037 | DSART | |
| XVERD | Summarize Bank Statement Items | CHAR | 1 | 0 | FFDISXVERD | ||
| BNKKO | Cash Management Account Name | CHAR | 10 | 0 | T035D | DISKB | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| WORKLIST | Worklist | CHAR | 10 | 0 | TFAV | WORKLIST_EB | |
| NOCLEAR | No Automatic Clearing | CHAR | 1 | 0 | NOAUTOCLEAR_EB | ||
| MANSP | Set Dunning Block | CHAR | 1 | 0 | T040S | MANSP_EB | |
| ANZTG | Days After Which Dunning Block Is Deleted | NUMC | 2 | 0 | ANZTG_EB |
T028B foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T028B | BNKKO | T035D | Cash Management Account Names | BUKRS |
| 0 T028B | BNKKO | T035D | Cash Management Account Names | DISKB |
| 1 T028B | BUKRS | T001 | Company Codes | BUKRS |
| 0 T028B | DSART | T037 | Planning Types | DSART |
| 1 T028B | MANDT | T000 | Clients | MANDT |
| 0 T028B | WORKLIST | TFAV | FI: Worklists | MANDT |
| 0 T028B | WORKLIST | TFAV | FI: Worklists | OBJCT |