SAP Table PSBT
Bank Transfer
PSBT (Bank Transfer) 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 PSBT to other SAP tables.
PSBT table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
EMFSL1 | Payee Key | P_EMFSL | CHAR | 8 | 0 | |||
EMFSL2 | Payee Key | P_EMFSL | CHAR | 8 | 0 | |||
EMFSL3 | Payee Key | P_EMFSL | CHAR | 8 | 0 | |||
EMFTX1 | Payee Text | EMFTX | CHAR | 40 | 0 | |||
EMFTX2 | Payee Text | EMFTX | CHAR | 40 | 0 | |||
EMFTX3 | Payee Text | EMFTX | CHAR | 40 | 0 | |||
STRAS | Payee Street | P_STRAS | CHAR | 8 | 0 | |||
BKPLZ1 | Postal Code | BKPLZ | CHAR | 10 | 0 | |||
BKPLZ2 | Postal Code | BKPLZ | CHAR | 10 | 0 | |||
BKPLZ3 | Postal Code | BKPLZ | CHAR | 10 | 0 | |||
BKORT1 | City | ORT01 | CHAR | 25 | 0 | |||
BKORT2 | City | ORT01 | CHAR | 25 | 0 | |||
BKORT3 | City | ORT01 | CHAR | 25 | 0 | |||
BANKS1 | Bank country key | BANKS | T005 | CHAR | 3 | 0 | ||
BANKS2 | Bank country key | BANKS | T005 | CHAR | 3 | 0 | ||
BANKS3 | Bank country key | BANKS | T005 | CHAR | 3 | 0 | ||
BANKL1 | Bank Keys | BANKK | CHAR | 15 | 0 | |||
BANKL2 | Bank Keys | BANKK | CHAR | 15 | 0 | |||
BANKL3 | Bank Keys | BANKK | CHAR | 15 | 0 | |||
BANKN1 | Bank account number | BANKN | CHAR | 18 | 0 | |||
BANKN2 | Bank account number | BANKN | CHAR | 18 | 0 | |||
BANKN3 | Bank account number | BANKN | CHAR | 18 | 0 | |||
ZLSCH1 | Payment Method | PCODE | T042Z | CHAR | 1 | 0 | ||
ZLSCH2 | Payment Method | PCODE | T042Z | CHAR | 1 | 0 | ||
ZLSCH3 | Payment Method | PCODE | T042Z | CHAR | 1 | 0 | ||
ZWECK1 | Purpose of Bank Transfers | DZWECK | CHAR | 40 | 0 | |||
ZWECK2 | Purpose of Bank Transfers | DZWECK | CHAR | 40 | 0 | |||
ZWECK3 | Purpose of Bank Transfers | DZWECK | CHAR | 40 | 0 |
PSBT foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
PSBT | BANKS1 | * | T005 | Countries | MANDT | |
PSBT | BANKS1 | PSBT | BANKS1 | T005 | Countries | LAND1 |
PSBT | BANKS2 | * | T005 | Countries | MANDT | |
PSBT | BANKS2 | PSBT | BANKS2 | T005 | Countries | LAND1 |
PSBT | BANKS3 | * | T005 | Countries | MANDT | |
PSBT | BANKS3 | PSBT | BANKS3 | T005 | Countries | LAND1 |
PSBT | ZLSCH1 | SYST | MANDT | T042Z | Payment Methods for Automatic Payment | MANDT |
PSBT | ZLSCH1 | PSYST | LAND | T042Z | Payment Methods for Automatic Payment | LAND1 |
PSBT | ZLSCH1 | PSBT | ZLSCH1 | T042Z | Payment Methods for Automatic Payment | ZLSCH |
PSBT | ZLSCH2 | SYST | MANDT | T042Z | Payment Methods for Automatic Payment | MANDT |
PSBT | ZLSCH2 | PSYST | LAND | T042Z | Payment Methods for Automatic Payment | LAND1 |
PSBT | ZLSCH2 | PSBT | ZLSCH2 | T042Z | Payment Methods for Automatic Payment | ZLSCH |
PSBT | ZLSCH3 | PSBT | ZLSCH3 | T042Z | Payment Methods for Automatic Payment | ZLSCH |
PSBT | ZLSCH3 | SYST | MANDT | T042Z | Payment Methods for Automatic Payment | MANDT |
PSBT | ZLSCH3 | PSYST | LAND | T042Z | Payment Methods for Automatic Payment | LAND1 |