FPRLS_PAYMENT_DATA SAP (Payment Data) Structure details
Description: Payment Data
Related tables to FPRLS_PAYMENT_DATA
Access table FPRLS_PAYMENT_DATA
Structure field list including key, data, relationships and ABAP select examples
FPRLS_PAYMENT_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Payment Data" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_FPRLS_PAYMENT_DATA TYPE FPRLS_PAYMENT_DATA.
The FPRLS_PAYMENT_DATA table consists of various fields, each holding specific information or linking keys about Payment Data data available in SAP. These include LAUFI_PAY (Additional Identification), VBLNR_PAY (Document Number of the Payment Document), PYORD_PAY (Payment Order), XF110_EXEC (General Flag).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FPRLS_PAYMENT_DATA structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
LAUFD_PAY | Date on Which the Program Is to Be Run | LAUFD | DATS | 8 | DATUM | ||||
LAUFI_PAY | Additional Identification | LAUFI | CHAR | 6 | LAUFI | ||||
VBLNR_PAY | Document Number of the Payment Document | VBLNR | CHAR | 10 | ALPHA | BELNR | |||
PYORD_PAY | Payment Order | PYORD | CHAR | 10 | ALPHA | PYORD | |||
XF110_EXEC | General Flag | FLAG | CHAR | 1 | FLAG | ||||
LAUFD | Date of Proposal Run | FPRL_LAUFD | DATS | 8 | DATUM | ||||
LAUFI | Payment Proposal | FPRL_LAUFI | CHAR | 6 | LAUFI | ||||
JOBCOUNT | Job ID | BTCJOBCNT | CHAR | 8 | CHAR8 | ||||
ZBUKR | Paying company code | DZBUKR | CHAR | 4 | T001 | BUKRS | |||
ABSBU | Sending company code | ABSBU | CHAR | 4 | Assigned to domain | BUKRS | |||
ZNME1 | Name of the payee | DZNME1 | CHAR | 35 | TEXT35 | ||||
ZPSTL | Postal code of the payee | DZPSTL | CHAR | 10 | PSTLZ | ||||
ZORT1 | City of the payee | DZORT1 | CHAR | 35 | TEXT35 | ||||
ZLAND | Country Key | DZLAND | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
ZREGI | Regional code of the payee | DZREGI | CHAR | 3 | Assigned to domain | REGIO | |||
ZSPRA | Language key of the payee | DZSPRA | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
ZBVTY | Bank Data Indicator for the Payee | DZBVTY | CHAR | 4 | BVTYP | ||||
ZBNKS | Country Key | DZBNKS | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
ZBNKY | Bank key of the payee's bank | DZBNKY | CHAR | 15 | BANKK | ||||
ZBNKL | Bank number of the payee's bank | DZBNKL | CHAR | 15 | BANKL | ||||
ZBNKN | Bank account number of the payee | DZBNKN | CHAR | 18 | BANKN | ||||
ZBKON | Bank Control Key of the Payee's Bank | DZBKON | CHAR | 2 | BKONT | ||||
BKREF | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
ZSWIF | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
ZIBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
KOINH | Account Holder Name | KOINH_FI | CHAR | 60 | KOINH | ||||
HKTID | ID for account details | HKTID | CHAR | 5 | Assigned to domain | HKTID | |||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
UBNKS | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
UBNKY | Bank key of our bank | UBNKY | CHAR | 15 | BANKK | ||||
UBNKL | Bank number of our bank | UBNKL | CHAR | 15 | BANKL | ||||
UBKNT | Our account number at the bank | UBKNT | CHAR | 18 | BANKN | ||||
UBKON | Bank control key at our bank | UBKON | CHAR | 2 | BKONT | ||||
UBHKT | G/L Account Number for Our Bank Account / Bank Sub-Account | UBHKT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
RZAWE | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | T042F | UZAWE | |||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | Assigned to domain | DTAWS | |||
ZALDT | Posting date of the payment document | DZALDT_ZHL | DATS | 8 | DATUM | ||||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
AUSFD | Due date of the paid items | AUSFD | DATS | 8 | DATUM | ||||
ANFAE | Bill of Exchange Payment Request Due Date | ANFAE | DATS | 8 | DATUM | ||||
WEFAE | Bill of Exchange Due Date | WEFAE | DATS | 8 | DATUM | ||||
WDATE | Bill of Exchange Issue Date | WDATE | DATS | 8 | DATUM | ||||
BUSAB | Accounting clerk | BUSAB | CHAR | 2 | Assigned to domain | BUSAB | |||
EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | EIKTO | CHAR | 12 | CHAR12 | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
RFTTRN | Payment code | RFTTRN_BF | CHAR | 20 | RFTTRN_BF | ||||
BTYP1 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | CHAR | 1 | BNTYP | ||||
BNKS1 | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
BNKL1 | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
BNKN1 | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BTYP2 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | CHAR | 1 | BNTYP | ||||
BNKS2 | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
BNKL2 | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
BNKN2 | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BTYP3 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | CHAR | 1 | BNTYP | ||||
BNKS3 | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
BNKL3 | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
BNKN3 | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
MGUID | SEPA Mandate: GUID of Mandate | SEPA_MGUID | RAW | 16 | |||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 |
Key field | Non-key field |
How do I retrieve data from SAP structure FPRLS_PAYMENT_DATA using ABAP code?
As FPRLS_PAYMENT_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FPRLS_PAYMENT_DATA as there is no data to select.How to access SAP table FPRLS_PAYMENT_DATA
Within an ECC or HANA version of SAP you can also view further information about FPRLS_PAYMENT_DATA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects