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