SAP ABAP Table IHC_STR_PN_PAYRQ (PAYRQ of a Payment Order)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FIN-FSCM-IHC (Application Component) FSCM In-House Cash
⤷ FIN_IHC (Package) Payment Order In-House Cash
⤷ FIN-FSCM-IHC (Application Component) FSCM In-House Cash
⤷ FIN_IHC (Package) Payment Order In-House Cash
Basic Data
Table Category | INTTAB | Structure |
Structure | IHC_STR_PN_PAYRQ | Table Relationship Diagram |
Short Description | PAYRQ of a Payment Order |
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 | UNIT1 | IHC_DTE_UNIT | IHC_DOM_UNIT | CHAR | 4 | 0 | Bank Area | ||
2 | NUMBER1 | IHC_DTE_PN_NUMBER | IHC_DOM_PN_NUMBER | NUMC | 10 | 0 | Payment Order Number | ||
3 | YEAR1 | IHC_DTE_PN_JAHR | JAHR | NUMC | 4 | 0 | Fiscal Year of IHC Payment Order | ||
4 | .INCLUDE | 0 | 0 | Payment Requests | |||||
5 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
6 | KEYNO | PRQ_KEYNO | PRQ_KEYNO | CHAR | 10 | 0 | Key Number for Payment Request | * | |
7 | ZBUKR | PRQ_ZBUKR | BUKRS | CHAR | 4 | 0 | Paying Company Code for this Payment Request | T001 | |
8 | ABSBU | PRQ_ABSBU | BUKRS | CHAR | 4 | 0 | Sending Company Code for Payment Requests | T001 | |
9 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
10 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
11 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
12 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
13 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
14 | USNAM | USNAM | XUBNAME | CHAR | 12 | 0 | User name | USR02 | |
15 | MONAT | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
16 | CPUDT | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
17 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | TCURC | |
18 | WAERS | PRQ_DOCUR | WAERS | CUKY | 5 | 0 | Currency Key of the Invoice | TCURC | |
19 | HWAE2 | HWAE2 | WAERS | CUKY | 5 | 0 | Currency Key of Second Local Currency | TCURC | |
20 | HWAE3 | HWAE3 | WAERS | CUKY | 5 | 0 | Currency Key of Third Local Currency | TCURC | |
21 | PACUR | PRQ_PACUR | WAERS | CUKY | 5 | 0 | Payment Request Currency Key | TCURC | |
22 | DMBTR | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
23 | DMBE2 | DMBE2 | WERT7 | CURR | 13 | 2 | Amount in Second Local Currency | ||
24 | DMBE3 | DMBE3 | WERT7 | CURR | 13 | 2 | Amount in Third Local Currency | ||
25 | WRBTR | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
26 | PAMTL | PRQ_AMTLC | WERT7 | CURR | 13 | 2 | Payment Request Amount in Local Currency | ||
27 | PAMTF | PRQ_AMTFC | WERT7 | CURR | 13 | 2 | Payment Request Amount in Payment Currency | ||
28 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
29 | KOART | KOART | KOART | CHAR | 1 | 0 | Account type | ||
30 | PARNO | PRQ_PARNO | PRQ_PARNO | CHAR | 10 | 0 | Business Partner | ||
31 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | SKA1 | |
32 | PAYEE | PRQ_PAYEE | PRQ_PARNO | CHAR | 10 | 0 | Account Number of the Alternative Payee | ||
33 | FILKD | FILKD | MAXKK | CHAR | 10 | 0 | Account Number of the Branch | ||
34 | ANRED | ANRED | TEXT15 | CHAR | 15 | 0 | Title | ||
35 | NAME1 | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
36 | NAME2 | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
37 | NAME3 | NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
38 | NAME4 | NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
39 | PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
40 | ORT01 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
41 | PSTL2 | PSTL2 | PSTLZ | CHAR | 10 | 0 | P.O. Box Postal Code | ||
42 | STRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
43 | PFACH | PFACH | PFACH | CHAR | 10 | 0 | PO Box | ||
44 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
45 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
46 | BUSAB | BUSAB | BUSAB | CHAR | 2 | 0 | Accounting clerk | T001S | |
47 | STCD1 | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
48 | DTAMS | DTAMS | DTAMS | CHAR | 1 | 0 | Report key for data medium exchange | ||
49 | DTAWS | DTAWS | DTAWS | CHAR | 2 | 0 | Instruction key for data medium exchange | T015W | |
50 | DTWS1 | DTAT16 | DTWSX | NUMC | 2 | 0 | Instruction key 1 | T015W1 | |
51 | DTWS2 | DTAT17 | DTWSX | NUMC | 2 | 0 | Instruction key 2 | T015W1 | |
52 | DTWS3 | DTAT18 | DTWSX | NUMC | 2 | 0 | Instruction key 3 | T015W1 | |
53 | DTWS4 | DTAT19 | DTWSX | NUMC | 2 | 0 | Instruction key 4 | T015W1 | |
54 | LZBKZ | LZBKZ | LZBKZ | CHAR | 3 | 0 | State central bank indicator | T015L | |
55 | LANDL | LANDL | LAND1 | CHAR | 3 | 0 | Supplying Country | T005 | |
56 | ZANRE | DZANRE | TEXT15 | CHAR | 15 | 0 | Title of the payee | ||
57 | ZNME1 | DZNME1 | TEXT35 | CHAR | 35 | 0 | Name of the payee | ||
58 | ZNME2 | DZNME1 | TEXT35 | CHAR | 35 | 0 | Name of the payee | ||
59 | ZNME3 | DZNME1 | TEXT35 | CHAR | 35 | 0 | Name of the payee | ||
60 | ZNME4 | DZNME1 | TEXT35 | CHAR | 35 | 0 | Name of the payee | ||
61 | ZPSTL | DZPSTL | PSTLZ | CHAR | 10 | 0 | Postal code of the payee | ||
62 | ZORT1 | DZORT1 | TEXT35 | CHAR | 35 | 0 | City of the payee | ||
63 | ZPST2 | DZPST2 | PSTLZ | CHAR | 10 | 0 | P.O. box postal code of the payee | ||
64 | ZSTRA | DZSTRA | TEXT35 | CHAR | 35 | 0 | Street and house number of the payee | ||
65 | ZPFAC | DZPFAC | PFACH | CHAR | 10 | 0 | P.O. box of the payee | ||
66 | ZLAND | DZLAND | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
67 | ZREGI | DZREGI | REGIO | CHAR | 3 | 0 | Regional code of the payee | T005S | |
68 | ZSPRA | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
69 | EIKTO | EIKTO | CHAR12 | CHAR | 12 | 0 | Shipper's (Our) Account Number at the Customer or Vendor | ||
70 | ZTLFX | TELFX | TEXT31 | CHAR | 31 | 0 | Fax Number | ||
71 | ZTELF | TELF1 | TEXT16 | CHAR | 16 | 0 | First telephone number | ||
72 | ZTELX | TELX1 | TEXT30 | CHAR | 30 | 0 | Telex number | ||
73 | HKTID | HKTID | HKTID | CHAR | 5 | 0 | ID for account details | T012K | |
74 | HBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | T012 | |
75 | UBNKY | UBNKY | BANKK | CHAR | 15 | 0 | Bank key of our bank | BNKA | |
76 | UBNKS | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | T005 | |
77 | UBNKL | UBNKL | BANKL | CHAR | 15 | 0 | Bank number of our bank | ||
78 | UIBAN | UIBAN | IBAN | CHAR | 34 | 0 | IBAN at our House Bank | ||
79 | UBKNT | UBKNT | BANKN | CHAR | 18 | 0 | Our account number at the bank | ||
80 | UBKON | UBKON | BKONT | CHAR | 2 | 0 | Bank control key at our bank | ||
81 | UBNKR | PRQ_UBNKR | REGIO | CHAR | 3 | 0 | Regional Code of the House Bank | T005S | |
82 | UBHKT | UBHKT | SAKNR | CHAR | 10 | 0 | G/L Account Number for Our Bank Account / Bank Sub-Account | SKA1 | |
83 | BKHBK | PRQ_BKHBK | SAKNR | CHAR | 10 | 0 | G/L Account for Bank Clearing Account | SKA1 | |
84 | .INCLUDE | 0 | 0 | REGUH extension for the payment request | |||||
85 | BTYP1 | BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
86 | BNKS1 | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
87 | BNKL1 | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
88 | BNKN1 | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
89 | BKON1 | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
90 | BKRF1 | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
91 | IBAN1 | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
92 | BTYP2 | BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
93 | BNKS2 | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
94 | BNKL2 | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
95 | BNKN2 | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
96 | BKON2 | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
97 | BKRF2 | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
98 | IBAN2 | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
99 | BTYP3 | BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
100 | BNKS3 | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
101 | BNKL3 | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
102 | BNKN3 | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
103 | BKON3 | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
104 | BKRF3 | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
105 | IBAN3 | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
106 | BVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
107 | ZBNKS | DZBNKS | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
108 | ZBNKN | DZBNKN | BANKN | CHAR | 18 | 0 | Bank account number of the payee | ||
109 | ZBNKL | DZBNKL | BANKL | CHAR | 15 | 0 | Bank number of the payee's bank | ||
110 | ZBNKY | DZBNKY | BANKK | CHAR | 15 | 0 | Bank key of the payee's bank | BNKA | |
111 | ZBKON | DZBKON | BKONT | CHAR | 2 | 0 | Bank Control Key of the Payee's Bank | ||
112 | BKREF | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
113 | ZBNKR | PRQ_ZBNKR | REGIO | CHAR | 3 | 0 | Regional Code of the Payee's Bank | T005S | |
114 | SWIFT | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
115 | KOINH | KOINH_FI | KOINH | CHAR | 60 | 0 | Account Holder Name | ||
116 | ZGSBR | PRQ_ZGSBR | GSBER | CHAR | 4 | 0 | Business Area: Offsetting Posting | TGSB | |
117 | GGRUP | PRQ_ZHKONT | SAKNR | CHAR | 10 | 0 | Partner Bank's Account No. for Bank Account Transfers | SKA1 | |
118 | XRELD | PRQ_XRELD | X | CHAR | 1 | 0 | Indicator: Released for Posting | ||
119 | XRELI | PRQ_XRELI | X | CHAR | 1 | 0 | Indicator: Complete | ||
120 | XRELP | PRQ_XRELP | X | CHAR | 1 | 0 | Indicator: Released for Payment | ||
121 | XREVE | PRQ_XREVE | XFELD | CHAR | 1 | 0 | Indicator: Payment Request is Reversed | ||
122 | STGRD | STGRD | STGRD | CHAR | 2 | 0 | Reason for Reversal | T041C | |
123 | XURGE | PRQ_XURGE | X | CHAR | 1 | 0 | Indicator: Extremely Urgent Payment | ||
124 | TAGE1 | TAGE1 | NUM04 | NUMC | 4 | 0 | Residence time 1 | ||
125 | DUEDT | PRQ_DUEDT | DATUM | DATS | 8 | 0 | Payment Request Due Date | ||
126 | VALUT | PRQ_VALDT | DATUM | DATS | 8 | 0 | Value Date for the Sending Bank | ||
127 | CRVAL | PRQ_CRVAL | DATUM | DATS | 8 | 0 | Value Date at Payee's Bank | ||
128 | IMPER | PRQ_IMPER | PRQ_IMPER | CHAR | 1 | 0 | Value Date may no Longer be Changed | ||
129 | ZUONR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
130 | XPORE | PRQ_XPORE | XFELD | CHAR | 1 | 0 | Indicator: Individual Payment? | ||
131 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | T042F | |
132 | ZWELS | DZWELS | ZWELS | CHAR | 10 | 0 | List of the Payment Methods to be Considered | ||
133 | XEZER | XEZER | XFELD | CHAR | 1 | 0 | Indicator: Is there collection authorization ? | ||
134 | SWTXT | PRQ_SWTXT | PRQ_SWTXT | CHAR | 140 | 0 | Swift Text | ||
135 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
136 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
137 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
138 | PAYGR | PAYGR | CHAR20 | CHAR | 20 | 0 | Grouping Field for Automatic Payments | ||
139 | XKDFB | XKDFB_042E | XFELD | CHAR | 1 | 0 | Do not Post any Exchange Rate Differences | ||
140 | ZLSPR | DZLSPR | ZAHLS | CHAR | 1 | 0 | Payment Block Key | T008 | |
141 | VBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | T880 | |
142 | AUGDT | AUGDT | DATUM | DATS | 8 | 0 | Clearing Date | ||
143 | AUGCP | AUGCP | DATUM | DATS | 8 | 0 | Clearing Entry Date | ||
144 | AUGBL | AUGBL | BELNR | CHAR | 10 | 0 | Document Number of the Clearing Document | ||
145 | AWSYS | LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | TBDLS | |
146 | AWTYP | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | TTYP | |
147 | AWKEY | AWKEY | AWKEY | CHAR | 20 | 0 | Object key | ||
148 | ORIGIN | FIBL_ORIGIN | FIBL_ORIGIN | CHAR | 8 | 0 | Origin Indicator | TFIBLORIGIN | |
149 | HBKGR | FIBL_HBG | FIBL_HBG | CHAR | 2 | 0 | Group of House Bank Accounts | TFIBLHBG | |
150 | RFTTRN | RFTTRN_BF | RFTTRN_BF | CHAR | 20 | 0 | Payment code | ||
151 | POST_NAME | PRQ_POSTNAME | XUBNAME | CHAR | 12 | 0 | User who Carried Out the Posting | USR02 | |
152 | POST_DATE | PRQ_POSTDATE | DATUM | DATS | 8 | 0 | Day on Which Payment Request was Posted | ||
153 | REL_NAME | PRQ_RELNAME | XUBNAME | CHAR | 12 | 0 | User who Carried Out the Release | USR02 | |
154 | REL_DATE | PRQ_RELDATE | DATUM | DATS | 8 | 0 | Release Date for Payment | ||
155 | DEDUAMNTP | PRQ_DEDUAMNTP | WERT7 | CURR | 13 | 2 | Deductions in Payment Currency | ||
156 | DEDUAMNTL | PRQ_DEDUAMNTL | WERT7 | CURR | 13 | 2 | Deductions in Local Currency | ||
157 | WTAMNTP | PRQ_WTAMNTP | WERT7 | CURR | 13 | 2 | Withholding Tax Amount in Payment Currency | ||
158 | WTAMNTL | PRQ_WTAMNTL | WERT7 | CURR | 13 | 2 | Withholding Tax Amount in Local Currency | ||
159 | KIDNO | KIDNO | CHAR30 | CHAR | 30 | 0 | Payment Reference | ||
160 | ZIBAN | DZIBAN | IBAN | CHAR | 34 | 0 | IBAN of the Payee | ||
161 | SNAME1 | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
162 | SORT01 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
163 | SLAND1 | LAND1_GP | LAND1 | CHAR | 3 | 0 | Country Key | * | |
164 | .INCLUDE | 0 | 0 | Incl. for Payment Requests (for example Fields from REGUP) | |||||
165 | VERTN | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
166 | ZPFOR | PFORT_Z | TEXT35 | CHAR | 35 | 0 | City of payee's PO box | ||
167 | MGUID | SEPA_MGUID | RAW | 16 | 0 | SEPA Mandate: GUID of Mandate | |||
168 | SNAME2 | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
169 | SNAME3 | NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
170 | SNAME4 | NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
171 | SSTRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
172 | SSTRS2 | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
173 | SPSTLZ | PSTLZ_BAS | PSTLZ | CHAR | 10 | 0 | Postal code | ||
174 | SID | SENDER_ID | CHAR35 | CHAR | 35 | 0 | Original Payer of a Payment (ID) | ||
175 | PURP_CODE | FPM_PURP_CODE | CHAR4 | CHAR | 4 | 0 | SEPA Purpose Code: Classification of a Payment/Debit Memo | ||
176 | STATUS | PRQ_STATUS | PRQ_STATUS | CHAR | 2 | 0 | Status of a Payment Request |
Foreign Keys
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 500 |