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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
||||||||||||
|
CTRNS
Coll. Bank Transfer Indicator
|
HRPAY00_COLDME_CTRNS |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
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 |