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
⤷ FI-AP-AP-PT (Application Component) Payment Transactions
⤷ FIN_PRL (Package) Payment Release List
Basic Data
Table Category | INTTAB | Structure |
Structure | FPRLS_PAYMENT_DATA | Table Relationship Diagram |
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_PAY | LAUFD | DATUM | DATS | 8 | 0 | Date on Which the Program Is to Be Run | ||
2 | LAUFI_PAY | LAUFI | LAUFI | CHAR | 6 | 0 | Additional Identification | ||
3 | VBLNR_PAY | VBLNR | BELNR | CHAR | 10 | 0 | Document Number of the Payment Document | ||
4 | PYORD_PAY | PYORD | PYORD | CHAR | 10 | 0 | Payment Order | ||
5 | XF110_EXEC | FLAG | FLAG | CHAR | 1 | 0 | General Flag | ||
6 | LAUFD | FPRL_LAUFD | DATUM | DATS | 8 | 0 | Date of Proposal Run | ||
7 | LAUFI | FPRL_LAUFI | LAUFI | CHAR | 6 | 0 | Payment Proposal | ||
8 | JOBCOUNT | BTCJOBCNT | CHAR8 | CHAR | 8 | 0 | Job ID | ||
9 | ZBUKR | DZBUKR | BUKRS | CHAR | 4 | 0 | Paying company code | T001 | |
10 | ABSBU | ABSBU | BUKRS | CHAR | 4 | 0 | Sending company code | * | |
11 | ZNME1 | DZNME1 | TEXT35 | CHAR | 35 | 0 | Name of the payee | ||
12 | ZPSTL | DZPSTL | PSTLZ | CHAR | 10 | 0 | Postal code of the payee | ||
13 | ZORT1 | DZORT1 | TEXT35 | CHAR | 35 | 0 | City of the payee | ||
14 | ZLAND | DZLAND | LAND1 | CHAR | 3 | 0 | Country Key | * | |
15 | ZREGI | DZREGI | REGIO | CHAR | 3 | 0 | Regional code of the payee | * | |
16 | ZSPRA | DZSPRA | SPRAS | LANG | 1 | 0 | Language key of the payee | * | |
17 | NAME1 | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
18 | ZBVTY | DZBVTY | BVTYP | CHAR | 4 | 0 | Bank Data Indicator for the Payee | ||
19 | ZBNKS | DZBNKS | LAND1 | CHAR | 3 | 0 | Country Key | * | |
20 | ZBNKY | DZBNKY | BANKK | CHAR | 15 | 0 | Bank key of the payee's bank | ||
21 | ZBNKL | DZBNKL | BANKL | CHAR | 15 | 0 | Bank number of the payee's bank | ||
22 | ZBNKN | DZBNKN | BANKN | CHAR | 18 | 0 | Bank account number of the payee | ||
23 | ZBKON | DZBKON | BKONT | CHAR | 2 | 0 | Bank Control Key of the Payee's Bank | ||
24 | BKREF | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
25 | ZSWIF | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
26 | ZIBAN | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
27 | KOINH | KOINH_FI | KOINH | CHAR | 60 | 0 | Account Holder Name | ||
28 | HKTID | HKTID | HKTID | CHAR | 5 | 0 | ID for account details | * | |
29 | HBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | T012 | |
30 | UBNKS | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
31 | UBNKY | UBNKY | BANKK | CHAR | 15 | 0 | Bank key of our bank | ||
32 | UBNKL | UBNKL | BANKL | CHAR | 15 | 0 | Bank number of our bank | ||
33 | UBKNT | UBKNT | BANKN | CHAR | 18 | 0 | Our account number at the bank | ||
34 | UBKON | UBKON | BKONT | CHAR | 2 | 0 | Bank control key at our bank | ||
35 | UBHKT | UBHKT | SAKNR | CHAR | 10 | 0 | G/L Account Number for Our Bank Account / Bank Sub-Account | * | |
36 | RZAWE | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | T042Z | |
37 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | T042F | |
38 | DTAWS | DTAWS | DTAWS | CHAR | 2 | 0 | Instruction key for data medium exchange | * | |
39 | ZALDT | DZALDT_ZHL | DATUM | DATS | 8 | 0 | Posting date of the payment document | ||
40 | VALUT | VALUT | DATUM | DATS | 8 | 0 | Fixed Value Date | ||
41 | AUSFD | AUSFD | DATUM | DATS | 8 | 0 | Due date of the paid items | ||
42 | ANFAE | ANFAE | DATUM | DATS | 8 | 0 | Bill of Exchange Payment Request Due Date | ||
43 | WEFAE | WEFAE | DATUM | DATS | 8 | 0 | Bill of Exchange Due Date | ||
44 | WDATE | WDATE | DATUM | DATS | 8 | 0 | Bill of Exchange Issue Date | ||
45 | BUSAB | BUSAB | BUSAB | CHAR | 2 | 0 | Accounting clerk | * | |
46 | EIKTO | EIKTO | CHAR12 | CHAR | 12 | 0 | Shipper's (Our) Account Number at the Customer or Vendor | ||
47 | KIDNO | KIDNO | CHAR30 | CHAR | 30 | 0 | Payment Reference | ||
48 | RFTTRN | RFTTRN_BF | RFTTRN_BF | CHAR | 20 | 0 | Payment code | ||
49 | BTYP1 | BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
50 | BNKS1 | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
51 | BNKL1 | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
52 | BNKN1 | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
53 | BTYP2 | BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
54 | BNKS2 | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
55 | BNKL2 | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
56 | BNKN2 | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
57 | BTYP3 | BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
58 | BNKS3 | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
59 | BNKL3 | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
60 | BNKN3 | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
61 | MGUID | SEPA_MGUID | RAW | 16 | 0 | SEPA Mandate: GUID of Mandate | |||
62 | MNDID | 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 | T012 | HBKID | REF | 1 | CN |
2 | FPRLS_PAYMENT_DATA | RZAWE | T042Z | ZLSCH | REF | 1 | CN |
3 | FPRLS_PAYMENT_DATA | UZAWE | T042F | UZAWE | REF | C | CN |
4 | FPRLS_PAYMENT_DATA | ZBUKR | T001 | BUKRS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 700 |