PAYR SAP (Payment Medium File) Table details
Dictionary Type: Table
Description: Payment Medium File
Description: Payment Medium File
Table field list including key, data, relationships and ABAP select examples
PAYR is a standard SAP Table which is used to store Payment Medium File data and is available within R/3 SAP systems depending on the version and release level.
The PAYR table consists of various fields, each holding specific information or linking keys about Payment Medium File data available in SAP. These include ZBUKR (Paying company code), HBKID (Short Key for a House Bank), HKTID (ID for account details), RZAWE (Payment Method).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP PAYR table 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
ZBUKR | Paying company code | DZBUKR | CHAR | 4 | T001 | BUKRS | |||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
HKTID | ID for account details | HKTID | CHAR | 5 | T012K | HKTID | |||
RZAWE | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
CHECT | Check number | CHECT | CHAR | 13 | CHCKN | CHK | |||
CHECF | Check Number From | CHECF | CHAR | 13 | CHCKN | CHK | |||
LAUFD | Date on Which the Program Is to Be Run | LAUFD | DATS | 8 | DATUM | ||||
LAUFI | Additional Identification | LAUFI | CHAR | 6 | LAUFI | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
EMPFG | Payee code | EMPFG | CHAR | 16 | EMPFG | ||||
UBHKT | G/L Account Number for Our Bank Account / Bank Sub-Account | UBHKT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
VBLNR | Document Number of the Payment Document | VBLNR | CHAR | 10 | ALPHA | BELNR | |||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
ZALDT | Probable Payment Date (Cash Discount 1 Due) | DZALDT | DATS | 8 | DATUM | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
RWBTR | Amount Paid in the Payment Currency | RWBTR | CURR | 13(2) | WRTV7 | ||||
STRGB | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
PRIDT | Print Date | PRIDT | DATS | 8 | DATUM | ||||
PRITI | Print Time | PRITI | TIMS | 6 | UZEIT | ||||
PRIUS | Print User | PRIUS | CHAR | 12 | UNAME | ||||
XMANU | X - Manual check | XMANU | CHAR | 1 | XFELD | ||||
XBANC | X - Paid Check | XBANC | CHAR | 1 | XFELD | ||||
BANCD | Check encashment date | BANCD | DATS | 8 | DATUM | ||||
EXTRD | Date of Extract Creation | EXTRD | DATS | 8 | DATUM | ||||
EXTRT | Time of Extract Creation | EXTRT | TIMS | 6 | UZEIT | ||||
XBUKR | X - Intercompany Payment | XBUKR | CHAR | 1 | XFELD | ||||
ZANRE | Title of the payee | DZANRE | CHAR | 15 | TEXT15 | ||||
ZNME1 | Name of the payee | DZNME1 | CHAR | 35 | TEXT35 | ||||
ZNME2 | Name of the payee | DZNME1 | CHAR | 35 | TEXT35 | ||||
ZNME3 | Name of the payee | DZNME1 | CHAR | 35 | TEXT35 | ||||
ZNME4 | 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 | ||||
ZSTRA | Street and house number of the payee | DZSTRA | CHAR | 35 | TEXT35 | ||||
ZPFAC | P.O. box of the payee | DZPFAC | CHAR | 10 | PFACH | ||||
ZLAND | Country Key | DZLAND | CHAR | 3 | T005 | LAND1 | LND | ||
ZREGI | Regional code of the payee | DZREGI | CHAR | 3 | T005S | REGIO | |||
ZBNKS | Country Key | DZBNKS | CHAR | 3 | T005 | LAND1 | LND | ||
ZBNKN | Bank account number of the payee | DZBNKN | CHAR | 18 | BANKN | ||||
ZBNKL | Bank number of the payee's bank | DZBNKL | CHAR | 15 | BANKL | ||||
ZBKON | Bank Control Key of the Payee's Bank | DZBKON | CHAR | 2 | BKONT | ||||
ZSWIF | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
ZIBAN | IBAN of the Payee | DZIBAN | CHAR | 34 | IBAN | ||||
VOIDR | Check void reason code | VOIDR | NUMC | 2 | TVOID | VOIDR | |||
VOIDD | Voided Check Date | VOIDD | DATS | 8 | DATUM | ||||
VOIDU | Voided check user | VOIDU | CHAR | 12 | UNAME | ||||
CHECV | Replacement check number | CHECV | CHAR | 13 | CHCKN | ||||
HBKIV | Replacement check bank | HBKIV | CHAR | 5 | T012 | HBKID | |||
HKTIV | Replacement check account | HKTIV | CHAR | 5 | T012K | HKTID | |||
ZPST2 | P.O. box postal code of the payee | DZPST2 | CHAR | 10 | PSTLZ | ||||
XRAGL | Indicator: Clearing was Reversed | XRAGL | CHAR | 1 | XFELD | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
SEQNR | Sequence Number | SEQC5 | CHAR | 5 | CHAR5 | ||||
BTZNR | Assignment of Transfers | BTZNR | RAW | 1 | RAW1 | ||||
REC_BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
REC_GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
ZPFOR | City of payee's PO box | PFORT_Z | CHAR | 35 | TEXT35 | ||||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | T042F | UZAWE | |||
ICHEC | Type of Payment Medium (Stored in Payment Register) | ICHEC | CHAR | 1 | ICHEC | ||||
IREFE | Information as to Whether a Reference to this Payment Exists | ICREF | CHAR | 1 | ICREF | ||||
RWSKT | Total Cash Discount for the Pmnt Transactn in Pmnt Currency | RWSKT | CURR | 13(2) | WRTV7 |
Key field | Non-key field |
How do I retrieve data from SAP table PAYR using ABAP code
The following ABAP code Example will allow you to do a basic selection on PAYR to SELECT all data from the tableDATA: WA_PAYR TYPE PAYR.
SELECT SINGLE *
FROM PAYR
INTO CORRESPONDING FIELDS OF WA_PAYR
WHERE...
How to access SAP table PAYR
Within an ECC or HANA version of SAP you can also view further information about PAYR 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