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
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
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 IHC_STR_PN_PAYRQ ABSBU T001 BUKRS REF 1 CN
2 IHC_STR_PN_PAYRQ AWSYS TBDLS LOGSYS REF 1 CN
3 IHC_STR_PN_PAYRQ AWTYP TTYP AWTYP REF 1 CN
4 IHC_STR_PN_PAYRQ BKHBK SKA1 SAKNR REF 1 CN
5 IHC_STR_PN_PAYRQ BUKRS T001 BUKRS REF 1 CN
6 IHC_STR_PN_PAYRQ BUSAB T001S BUSAB REF 1 CN
7 IHC_STR_PN_PAYRQ DTAWS T015W DTAWS REF 1 CN
8 IHC_STR_PN_PAYRQ DTWS1 T015W1 DTWSX REF 1 CN
9 IHC_STR_PN_PAYRQ DTWS2 T015W1 DTWSX REF 1 CN
10 IHC_STR_PN_PAYRQ DTWS3 T015W1 DTWSX REF 1 CN
11 IHC_STR_PN_PAYRQ DTWS4 T015W1 DTWSX REF 1 CN
12 IHC_STR_PN_PAYRQ GGRUP SKA1 SAKNR REF 1 CN
13 IHC_STR_PN_PAYRQ GSBER TGSB GSBER REF 1 CN
14 IHC_STR_PN_PAYRQ HBKGR TFIBLHBG HBKGR REF 1 CN
15 IHC_STR_PN_PAYRQ HBKID T012 HBKID REF 1 CN
16 IHC_STR_PN_PAYRQ HKONT SKA1 SAKNR REF 1 CN
17 IHC_STR_PN_PAYRQ HKTID T012K HKTID REF 1 CN
18 IHC_STR_PN_PAYRQ HWAE2 TCURC WAERS REF 1 CN
19 IHC_STR_PN_PAYRQ HWAE3 TCURC WAERS REF 1 CN
20 IHC_STR_PN_PAYRQ HWAER TCURC WAERS REF 1 CN
21 IHC_STR_PN_PAYRQ LAND1 T005 LAND1 REF 1 CN
22 IHC_STR_PN_PAYRQ LANDL T005 LAND1 REF 1 CN
23 IHC_STR_PN_PAYRQ LZBKZ T015L LZBKZ REF 1 CN
24 IHC_STR_PN_PAYRQ MANDT T000 MANDT KEY 1 CN
25 IHC_STR_PN_PAYRQ ORIGIN TFIBLORIGIN ORIGIN REF 1 CN
26 IHC_STR_PN_PAYRQ PACUR TCURC WAERS    
27 IHC_STR_PN_PAYRQ POST_NAME USR02 BNAME REF 1 CN
28 IHC_STR_PN_PAYRQ REGIO T005S BLAND REF 1 CN
29 IHC_STR_PN_PAYRQ REL_NAME USR02 BNAME REF 1 CN
30 IHC_STR_PN_PAYRQ STGRD T041C STGRD REF 1 CN
31 IHC_STR_PN_PAYRQ UBHKT SKA1 SAKNR REF 1 CN
32 IHC_STR_PN_PAYRQ UBNKR T005S BLAND    
33 IHC_STR_PN_PAYRQ UBNKS T005 LAND1 REF 1 CN
34 IHC_STR_PN_PAYRQ UBNKY BNKA BANKL REF 1 CN
35 IHC_STR_PN_PAYRQ USNAM USR02 BNAME REF 1 CN
36 IHC_STR_PN_PAYRQ UZAWE T042F UZAWE REF 1 CN
37 IHC_STR_PN_PAYRQ VBUND T880 RCOMP REF 1 CN
38 IHC_STR_PN_PAYRQ WAERS TCURC WAERS REF 1 CN
39 IHC_STR_PN_PAYRQ ZBNKR T005S BLAND REF 1 CN
40 IHC_STR_PN_PAYRQ ZBNKS T005 LAND1 REF 1 CN
41 IHC_STR_PN_PAYRQ ZBNKY BNKA BANKL REF 1 CN
42 IHC_STR_PN_PAYRQ ZBUKR T001 BUKRS REF 1 CN
43 IHC_STR_PN_PAYRQ ZGSBR TGSB GSBER REF 1 CN
44 IHC_STR_PN_PAYRQ ZLAND T005 LAND1 REF 1 CN
45 IHC_STR_PN_PAYRQ ZLSPR T008 ZAHLS REF 1 CN
46 IHC_STR_PN_PAYRQ ZREGI T005S BLAND REF 1 CN
47 IHC_STR_PN_PAYRQ ZSPRA T002 SPRAS REF 1 CN
History
Last changed by/on SAP  20140121 
SAP Release Created in 500