SAP ABAP Table FPRLS_PAYMENT_DATA (Payment Data)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷
FI-AP-AP-PT (Application Component) Payment Transactions
⤷
FIN_PRL (Package) Payment Release List
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | FPRLS_PAYMENT_DATA |
|
| Short Description | Payment Data |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
LAUFD | DATUM | DATS | 8 | 0 | Date on Which the Program Is to Be Run | ||
| 2 | |
LAUFI | LAUFI | CHAR | 6 | 0 | Additional Identification | ||
| 3 | |
VBLNR | BELNR | CHAR | 10 | 0 | Document Number of the Payment Document | ||
| 4 | |
PYORD | PYORD | CHAR | 10 | 0 | Payment Order | ||
| 5 | |
FLAG | FLAG | CHAR | 1 | 0 | General Flag | ||
| 6 | |
FPRL_LAUFD | DATUM | DATS | 8 | 0 | Date of Proposal Run | ||
| 7 | |
FPRL_LAUFI | LAUFI | CHAR | 6 | 0 | Payment Proposal | ||
| 8 | |
BTCJOBCNT | CHAR8 | CHAR | 8 | 0 | Job ID | ||
| 9 | |
DZBUKR | BUKRS | CHAR | 4 | 0 | Paying company code | T001 | |
| 10 | |
ABSBU | BUKRS | CHAR | 4 | 0 | Sending company code | * | |
| 11 | |
DZNME1 | TEXT35 | CHAR | 35 | 0 | Name of the payee | ||
| 12 | |
DZPSTL | PSTLZ | CHAR | 10 | 0 | Postal code of the payee | ||
| 13 | |
DZORT1 | TEXT35 | CHAR | 35 | 0 | City of the payee | ||
| 14 | |
DZLAND | LAND1 | CHAR | 3 | 0 | Country Key | * | |
| 15 | |
DZREGI | REGIO | CHAR | 3 | 0 | Regional code of the payee | * | |
| 16 | |
DZSPRA | SPRAS | LANG | 1 | 0 | Language key of the payee | * | |
| 17 | |
NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
| 18 | |
DZBVTY | BVTYP | CHAR | 4 | 0 | Bank Data Indicator for the Payee | ||
| 19 | |
DZBNKS | LAND1 | CHAR | 3 | 0 | Country Key | * | |
| 20 | |
DZBNKY | BANKK | CHAR | 15 | 0 | Bank key of the payee's bank | ||
| 21 | |
DZBNKL | BANKL | CHAR | 15 | 0 | Bank number of the payee's bank | ||
| 22 | |
DZBNKN | BANKN | CHAR | 18 | 0 | Bank account number of the payee | ||
| 23 | |
DZBKON | BKONT | CHAR | 2 | 0 | Bank Control Key of the Payee's Bank | ||
| 24 | |
BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
| 25 | |
SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
| 26 | |
IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
| 27 | |
KOINH_FI | KOINH | CHAR | 60 | 0 | Account Holder Name | ||
| 28 | |
HKTID | HKTID | CHAR | 5 | 0 | ID for account details | * | |
| 29 | |
HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | T012 | |
| 30 | |
BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
| 31 | |
UBNKY | BANKK | CHAR | 15 | 0 | Bank key of our bank | ||
| 32 | |
UBNKL | BANKL | CHAR | 15 | 0 | Bank number of our bank | ||
| 33 | |
UBKNT | BANKN | CHAR | 18 | 0 | Our account number at the bank | ||
| 34 | |
UBKON | BKONT | CHAR | 2 | 0 | Bank control key at our bank | ||
| 35 | |
UBHKT | SAKNR | CHAR | 10 | 0 | G/L Account Number for Our Bank Account / Bank Sub-Account | * | |
| 36 | |
DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | T042Z | |
| 37 | |
UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | T042F | |
| 38 | |
DTAWS | DTAWS | CHAR | 2 | 0 | Instruction key for data medium exchange | * | |
| 39 | |
DZALDT_ZHL | DATUM | DATS | 8 | 0 | Posting date of the payment document | ||
| 40 | |
VALUT | DATUM | DATS | 8 | 0 | Fixed Value Date | ||
| 41 | |
AUSFD | DATUM | DATS | 8 | 0 | Due date of the paid items | ||
| 42 | |
ANFAE | DATUM | DATS | 8 | 0 | Bill of Exchange Payment Request Due Date | ||
| 43 | |
WEFAE | DATUM | DATS | 8 | 0 | Bill of Exchange Due Date | ||
| 44 | |
WDATE | DATUM | DATS | 8 | 0 | Bill of Exchange Issue Date | ||
| 45 | |
BUSAB | BUSAB | CHAR | 2 | 0 | Accounting clerk | * | |
| 46 | |
EIKTO | CHAR12 | CHAR | 12 | 0 | Shipper's (Our) Account Number at the Customer or Vendor | ||
| 47 | |
KIDNO | CHAR30 | CHAR | 30 | 0 | Payment Reference | ||
| 48 | |
RFTTRN_BF | RFTTRN_BF | CHAR | 20 | 0 | Payment code | ||
| 49 | |
BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
| 50 | |
BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
| 51 | |
BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
| 52 | |
BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
| 53 | |
BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
| 54 | |
BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
| 55 | |
BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
| 56 | |
BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
| 57 | |
BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
| 58 | |
BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
| 59 | |
BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
| 60 | |
BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
| 61 | |
SEPA_MGUID | RAW | 16 | 0 | SEPA Mandate: GUID of Mandate | |||
| 62 | |
SEPA_MNDID | ID035 | CHAR | 35 | 0 | Unique Referene to Mandate per Payment Recipient |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | FPRLS_PAYMENT_DATA | HBKID | |
|
REF | 1 | CN |
| 2 | FPRLS_PAYMENT_DATA | RZAWE | |
|
REF | 1 | CN |
| 3 | FPRLS_PAYMENT_DATA | UZAWE | |
|
REF | C | CN |
| 4 | FPRLS_PAYMENT_DATA | ZBUKR | |
|
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in | 700 |