SAP Table T521B
Payee Keys
T521B (Payee Keys) 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 T521B to other SAP tables.
T521B table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| EMFSL | Payee key for bank transfers | EMFSL_521B | CHAR | 8 | 0 | |||||||
| ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||||||
| BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||
| EMFNA | Payee name | EMFNA | CHAR | 25 | 0 | |||||||
| PSTLZ | Postal Code | PSTLZ | CHAR | 10 | 0 | |||||||
| ORT01 | City | ORT01 | CHAR | 25 | 0 | |||||||
| BANKS | Bank country key | BANKS | T005 | CHAR | 3 | 0 | ||||||
| BANKL | Bank Keys | BANKK | CHAR | 15 | 0 | |||||||
| BKKTO | Bank account number | BANKN | CHAR | 18 | 0 | |||||||
| USBKZ | Overwrite indicator | USBKZ | CHAR | 1 | 0 |
Possible values
|
||||||
| ZLSCH | Payment Method | PCODE | T042Z | CHAR | 1 | 0 | ||||||
| STRAS | House number and street | STRAS | CHAR | 30 | 0 | |||||||
| TELNR | Telephone Number | TELNR | CHAR | 14 | 0 | |||||||
| ETEXT | Payee designation | EMTXT | CHAR | 25 | 0 | |||||||
| CTRAN | Collective transfer | CTRAN | CHAR | 1 | 0 |
Possible values
|
||||||
| PSKTO | Account Number of Bank Account At Post Office | PSKTO | CHAR | 16 | 0 | |||||||
| PBSNR | Transfer customer number | PBSNR | CHAR | 8 | 0 | |||||||
| TRANS | OSI transfer (Denmark) | OSIUB | CHAR | 1 | 0 |
Possible values
|
||||||
| BKONT | Bank Control Key | BKONT | CHAR | 2 | 0 | |||||||
| BTTYP | PBS Transfer Type | P09_BTTYP | T5M3T | NUMC | 2 | 0 | ||||||
| ESRNR | ISR Subscriber Number | ESRNR | CHAR | 11 | 0 | |||||||
| BKREF | Reference specifications for bank details | BKREF | CHAR | 20 | 0 | |||||||
| STATE | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||||||
| DEBIT | Automatic Debit Authorization Indicator | P00_XDEBIT_EMFSL | CHAR | 1 | 0 |
Possible values
|
||||||
| CTRNS | Coll. Bank Transfer Indicator | HRPAY00_COLDME_CTRNS | CHAR | 1 | 0 |
Possible values
|
||||||
| IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | 0 | |||||||
T521B foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T521B | BANKS | T521B | MANDT | T005 | Countries | MANDT |
| T521B | BANKS | T521B | BANKS | T005 | Countries | LAND1 |
| T521B | BTTYP | T521B | MANDT | T5M3T | Texts for Transfer Types (Denmark) | MANDT |
| T521B | BTTYP | T521B | BTTYP | T5M3T | Texts for Transfer Types (Denmark) | BTTYP |
| T521B | MANDT | T521B | MANDT | T000 | Clients | MANDT |
| T521B | STATE | T521B | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| T521B | STATE | T521B | BANKS | T005S | Taxes: Region (Province) Key | LAND1 |
| T521B | STATE | T521B | STATE | T005S | Taxes: Region (Province) Key | BLAND |
| T521B | ZLSCH | T521B | MANDT | T042Z | Payment Methods for Automatic Payment | MANDT |
| T521B | ZLSCH | T521B | BANKS | T042Z | Payment Methods for Automatic Payment | LAND1 |
| T521B | ZLSCH | T521B | ZLSCH | T042Z | Payment Methods for Automatic Payment | ZLSCH |
