IHC_STR_PN_PAYRQ SAP (PAYRQ of a Payment Order) Structure details
Description: PAYRQ of a Payment Order
Related tables to IHC_STR_PN_PAYRQ
Access table IHC_STR_PN_PAYRQ
Structure field list including key, data, relationships and ABAP select examples
IHC_STR_PN_PAYRQ 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 "PAYRQ of a Payment Order" 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_IHC_STR_PN_PAYRQ TYPE IHC_STR_PN_PAYRQ.
The IHC_STR_PN_PAYRQ table consists of various fields, each holding specific information or linking keys about PAYRQ of a Payment Order data available in SAP. These include NUMBER1 (Payment Order Number), YEAR1 (Fiscal Year of IHC Payment Order), MANDT (Client), KEYNO (Key Number for Payment Request).. 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 IHC_STR_PN_PAYRQ 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 |
UNIT1 | Bank Area | IHC_DTE_UNIT | CHAR | 4 | _UNIT | IHC_DOM_UNIT | PN_UNIT | IHC_SHLP_PN_UNIT | |
NUMBER1 | Payment Order Number | IHC_DTE_PN_NUMBER | NUMC | 10 | IHC_DOM_PN_NUMBER | ||||
YEAR1 | Fiscal Year of IHC Payment Order | IHC_DTE_PN_JAHR | NUMC | 4 | JAHR | ||||
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
KEYNO | Key Number for Payment Request | PRQ_KEYNO | CHAR | 10 | Assigned to domain | ALPHA | PRQ_KEYNO | ||
ZBUKR | Paying Company Code for this Payment Request | PRQ_ZBUKR | CHAR | 4 | T001 | BUKRS | |||
ABSBU | Sending Company Code for Payment Requests | PRQ_ABSBU | CHAR | 4 | T001 | BUKRS | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
USNAM | User name | USNAM | CHAR | 12 | USR02 | XUBNAME | USR | ||
MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
HWAER | Local Currency | HWAER | CUKY | 5 | TCURC | WAERS | |||
WAERS | Currency Key of the Invoice | PRQ_DOCUR | CUKY | 5 | TCURC | WAERS | |||
HWAE2 | Currency Key of Second Local Currency | HWAE2 | CUKY | 5 | TCURC | WAERS | |||
HWAE3 | Currency Key of Third Local Currency | HWAE3 | CUKY | 5 | TCURC | WAERS | |||
PACUR | Payment Request Currency Key | PRQ_PACUR | CUKY | 5 | TCURC | WAERS | |||
DMBTR | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
DMBE2 | Amount in Second Local Currency | DMBE2 | CURR | 13(2) | WERT7 | ||||
DMBE3 | Amount in Third Local Currency | DMBE3 | CURR | 13(2) | WERT7 | ||||
WRBTR | Amount in document currency | WRBTR | CURR | 13(2) | WERT7 | ||||
PAMTL | Payment Request Amount in Local Currency | PRQ_AMTLC | CURR | 13(2) | WERT7 | ||||
PAMTF | Payment Request Amount in Payment Currency | PRQ_AMTFC | CURR | 13(2) | WERT7 | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
PARNO | Business Partner | PRQ_PARNO | CHAR | 10 | ALPHA | PRQ_PARNO | |||
HKONT | General Ledger Account | HKONT | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
PAYEE | Account Number of the Alternative Payee | PRQ_PAYEE | CHAR | 10 | ALPHA | PRQ_PARNO | |||
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
BUSAB | Accounting clerk | BUSAB | CHAR | 2 | T001S | BUSAB | |||
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
DTAMS | Indicator for Data Medium Exchange | DTAMS | CHAR | 1 | DTAMS | ||||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | T015W | DTAWS | |||
DTWS1 | Instruction key 1 | DTAT16 | NUMC | 2 | T015W1 | DTWSX | |||
DTWS2 | Instruction key 2 | DTAT17 | NUMC | 2 | T015W1 | DTWSX | |||
DTWS3 | Instruction key 3 | DTAT18 | NUMC | 2 | T015W1 | DTWSX | |||
DTWS4 | Instruction key 4 | DTAT19 | NUMC | 2 | T015W1 | DTWSX | |||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | T015L | LZBKZ | |||
LANDL | Supplying Country | LANDL | CHAR | 3 | T005 | LAND1 | |||
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 | ||||
ZPST2 | P.O. box postal code of the payee | DZPST2 | CHAR | 10 | PSTLZ | ||||
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 | |||
ZSPRA | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | EIKTO | CHAR | 12 | CHAR12 | ||||
ZTLFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
ZTELF | First telephone number | TELF1 | CHAR | 16 | TEXT16 | ||||
ZTELX | Telex number | TELX1 | CHAR | 30 | TEXT30 | ||||
HKTID | ID for account details | HKTID | CHAR | 5 | T012K | HKTID | |||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
UBNKY | Bank key of our bank | UBNKY | CHAR | 15 | BNKA | BANKK | |||
UBNKS | Bank country key | BANKS | CHAR | 3 | T005 | LAND1 | BKL | ||
UBNKL | Bank number of our bank | UBNKL | CHAR | 15 | BANKL | ||||
UIBAN | IBAN at our House Bank | UIBAN | CHAR | 34 | IBAN | ||||
UBKNT | Our account number at the bank | UBKNT | CHAR | 18 | BANKN | ||||
UBKON | Bank control key at our bank | UBKON | CHAR | 2 | BKONT | ||||
UBNKR | Regional Code of the House Bank | PRQ_UBNKR | CHAR | 3 | T005S | REGIO | |||
UBHKT | G/L Account Number for Our Bank Account / Bank Sub-Account | UBHKT | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
BKHBK | G/L Account for Bank Clearing Account | PRQ_BKHBK | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
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 | ||||
BKON1 | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
BKRF1 | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
IBAN1 | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
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 | ||||
BKON2 | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
BKRF2 | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
IBAN2 | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
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 | ||||
BKON3 | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
BKRF3 | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
IBAN3 | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
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 | ||||
ZBNKY | Bank key of the payee's bank | DZBNKY | CHAR | 15 | BNKA | BANKK | |||
ZBKON | Bank Control Key of the Payee's Bank | DZBKON | CHAR | 2 | BKONT | ||||
BKREF | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
ZBNKR | Regional Code of the Payee's Bank | PRQ_ZBNKR | CHAR | 3 | T005S | REGIO | |||
SWIFT | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
KOINH | Account Holder Name | KOINH_FI | CHAR | 60 | KOINH | ||||
ZGSBR | Business Area: Offsetting Posting | PRQ_ZGSBR | CHAR | 4 | TGSB | GSBER | GSB | ||
GGRUP | Partner Bank's Account No. for Bank Account Transfers | PRQ_ZHKONT | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
XRELD | Indicator: Released for Posting | PRQ_XRELD | CHAR | 1 | X | ||||
XRELI | Indicator: Complete | PRQ_XRELI | CHAR | 1 | X | ||||
XRELP | Indicator: Released for Payment | PRQ_XRELP | CHAR | 1 | X | ||||
XREVE | Indicator: Payment Request is Reversed | PRQ_XREVE | CHAR | 1 | XFELD | ||||
STGRD | Reason for Reversal | STGRD | CHAR | 2 | T041C | STGRD | FSG | ||
XURGE | Indicator: Extremely Urgent Payment | PRQ_XURGE | CHAR | 1 | X | ||||
TAGE1 | Residence time 1 | TAGE1 | NUMC | 4 | NUM04 | ||||
DUEDT | Payment Request Due Date | PRQ_DUEDT | DATS | 8 | DATUM | ||||
VALUT | Value Date for the Sending Bank | PRQ_VALDT | DATS | 8 | DATUM | ||||
CRVAL | Value Date at Payee's Bank | PRQ_CRVAL | DATS | 8 | DATUM | ||||
IMPER | Value Date may no Longer be Changed | PRQ_IMPER | CHAR | 1 | PRQ_IMPER | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
XPORE | Indicator: Individual Payment? | PRQ_XPORE | CHAR | 1 | XFELD | ||||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | T042F | UZAWE | |||
ZWELS | List of the Payment Methods to be Considered | DZWELS | CHAR | 10 | ZWELS | ||||
XEZER | Indicator: Is there collection authorization ? | XEZER | CHAR | 1 | XFELD | ||||
SWTXT | Swift Text | PRQ_SWTXT | CHAR | 140 | PRQ_SWTXT | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
PAYGR | Grouping Field for Automatic Payments | PAYGR | CHAR | 20 | CHAR20 | ||||
XKDFB | Do not Post any Exchange Rate Differences | XKDFB_042E | CHAR | 1 | XFELD | ||||
ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | T008 | ZAHLS | SPE | ||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | PGS | |
AUGDT | Clearing Date | AUGDT | DATS | 8 | DATUM | ||||
AUGCP | Clearing Entry Date | AUGCP | DATS | 8 | DATUM | ||||
AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 10 | ALPHA | BELNR | |||
AWSYS | Logical System | LOGSYSTEM | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
AWTYP | Reference Transaction | AWTYP | CHAR | 5 | TTYP | AWTYP | |||
AWKEY | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
ORIGIN | Origin Indicator | FIBL_ORIGIN | CHAR | 8 | TFIBLORIGIN | FIBL_ORIGIN | |||
HBKGR | Group of House Bank Accounts | FIBL_HBG | CHAR | 2 | TFIBLHBG | FIBL_HBG | |||
RFTTRN | Payment code | RFTTRN_BF | CHAR | 20 | RFTTRN_BF | ||||
POST_NAME | User who Carried Out the Posting | PRQ_POSTNAME | CHAR | 12 | USR02 | XUBNAME | USR | ||
POST_DATE | Day on Which Payment Request was Posted | PRQ_POSTDATE | DATS | 8 | DATUM | ||||
REL_NAME | User who Carried Out the Release | PRQ_RELNAME | CHAR | 12 | USR02 | XUBNAME | USR | ||
REL_DATE | Release Date for Payment | PRQ_RELDATE | DATS | 8 | DATUM | ||||
DEDUAMNTP | Deductions in Payment Currency | PRQ_DEDUAMNTP | CURR | 13(2) | WERT7 | ||||
DEDUAMNTL | Deductions in Local Currency | PRQ_DEDUAMNTL | CURR | 13(2) | WERT7 | ||||
WTAMNTP | Withholding Tax Amount in Payment Currency | PRQ_WTAMNTP | CURR | 13(2) | WERT7 | ||||
WTAMNTL | Withholding Tax Amount in Local Currency | PRQ_WTAMNTL | CURR | 13(2) | WERT7 | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
ZIBAN | IBAN of the Payee | DZIBAN | CHAR | 34 | IBAN | ||||
SNAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
SORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
SLAND1 | Country Key | LAND1_GP | CHAR | 3 | Assigned to domain | LAND1 | C_LAND1 | ||
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
EXTACCOUNT | External Account | TPM_EXT_ACCOUNT | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | ||
ZPFOR | City of payee's PO box | PFORT_Z | CHAR | 35 | TEXT35 | ||||
MGUID | SEPA Mandate: GUID of Mandate | SEPA_MGUID | RAW | 16 | |||||
SNAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
SNAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
SNAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
SSTRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
SSTRS2 | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
SPSTLZ | Postal code | PSTLZ_BAS | CHAR | 10 | PSTLZ | ||||
SID | Original Payer of a Payment (ID) | SENDER_ID | CHAR | 35 | CHAR35 | ||||
STATUS | Status of a Payment Request | PRQ_STATUS | CHAR | 2 | PRQ_STATUS |
Key field | Non-key field |
How do I retrieve data from SAP structure IHC_STR_PN_PAYRQ using ABAP code?
As IHC_STR_PN_PAYRQ 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 IHC_STR_PN_PAYRQ as there is no data to select.How to access SAP table IHC_STR_PN_PAYRQ
Within an ECC or HANA version of SAP you can also view further information about IHC_STR_PN_PAYRQ 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