SAP table T521B (Payee Keys)
SAP table T521B has 3 primary key fields being MANDT,EMFSL,ENDDA.
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 | |
| EMFSL | Payee key for bank transfers | CHAR | 8 | 0 | EMFSL_521B | ||
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| EMFNA | Payee name | CHAR | 25 | 0 | EMFNA | ||
| PSTLZ | Postal Code | CHAR | 10 | 0 | PSTLZ | ||
| ORT01 | City | CHAR | 25 | 0 | ORT01 | ||
| BANKS | Country/Region Key of Bank | CHAR | 3 | 0 | T005 | BANKS | |
| BANKL | Bank Keys | CHAR | 15 | 0 | BANKK | ||
| BKKTO | Bank account number | CHAR | 18 | 0 | BANKN | ||
| USBKZ | Overwrite indicator | CHAR | 1 | 0 | USBKZ | ||
| ZLSCH | Payment Method | CHAR | 1 | 0 | T042Z | PCODE | |
| STRAS | Street and House Number | CHAR | 30 | 0 | STRAS | ||
| TELNR | Telephone Number | CHAR | 14 | 0 | TELNR | ||
| ETEXT | Payee designation | CHAR | 25 | 0 | EMTXT | ||
| CTRAN | Collective transfer | CHAR | 1 | 0 | CTRAN | ||
| PSKTO | PO Bank Current Acct No. or Building Society Ref. No. | CHAR | 16 | 0 | PSKTO | ||
| PBSNR | Transfer customer number | CHAR | 8 | 0 | PBSNR | ||
| TRANS | OSI transfer (Denmark) | CHAR | 1 | 0 | OSIUB | ||
| BKONT | Bank Control Key | CHAR | 2 | 0 | BKONT | ||
| BTTYP | PBS Transfer Type | NUMC | 2 | 0 | T5M3T | P09_BTTYP | |
| ESRNR | ISR subscriber number | CHAR | 11 | 0 | ESRNR | ||
| BKREF | Reference Details for Bank Details | CHAR | 20 | 0 | BKREF | ||
| STATE | Region (State, Province, County) | CHAR | 3 | 0 | T005S | REGIO | |
| DEBIT | Automatic Debit Authorization Indicator | CHAR | 1 | 0 | P00_XDEBIT_EMFSL | ||
| CTRNS | Coll. Bank Transfer Indicator | CHAR | 1 | 0 | HRPAY00_COLDME_CTRNS | ||
| IBAN | IBAN (International Bank Account Number) | CHAR | 34 | 0 | IBAN |
T521B foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T521B | BANKS | T005 | Countries | MANDT |
| 0 T521B | BANKS | T005 | Countries | LAND1 |
| 1 T521B | BTTYP | T5M3T | Texts for Transfer Types (Denmark) | MANDT |
| 1 T521B | BTTYP | T5M3T | Texts for Transfer Types (Denmark) | BTTYP |
| 0 T521B | STATE | T005S | Taxes: Region (Province) Key | LAND1 |
| 1 T521B | ZLSCH | T042Z | Payment Methods for Automatic Payment | MANDT |
| 1 T521B | ZLSCH | T042Z | Payment Methods for Automatic Payment | LAND1 |
| 1 T521B | ZLSCH | T042Z | Payment Methods for Automatic Payment | ZLSCH |