SAP ABAP Table IPRQI (Items from a Payment Request (External Interface))
Hierarchy
☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM-PO (Application Component) Funds Management-Specific Postings
     ⤷ FMFI_EU (Package) IS-PS: Basics for Funds Management for EU
Basic Data
Table Category INTTAB    Structure 
Structure IPRQI   Table Relationship Diagram
Short Description Items from a Payment Request (External Interface)    
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 ACIND ACIND ACIND CHAR 3   0   Account Determination Characteristic *
2 OACIN PRQ_OACIN PRQ_OACIN CHAR 3   0   Payment sequence and special payment  
3 SAKN2 SAKNR_ZIEL SAKNR CHAR 10   0   Target account *
4 KBLNR_COM KBLNR_COM KBLNR CHAR 10   0   Funds commitment (commitment budget) *
5 KBLPOS_COM KBLPOS KBLPOS NUMC 3   0   Earmarked Funds: Document Item *
6 FIPOS_COM FIPOS FIPOS CHAR 14   0   Commitment Item *
7 FISTL_COM FISTL FISTL CHAR 16   0   Funds Center *
8 GEBER_COM BP_GEBER BP_GEBER CHAR 10   0   Fund *
9 ERLKZ_COM KBLERLKZ_C CHAR1_X CHAR 1   0   Completed indicator for funds commitment line item  
10 ERLKZ_PAY KBLERLKZ_P CHAR1_X CHAR 1   0   Completed indicator for payment commitment line item  
11 .INCLUDE       0   0   Document Segment for Document Parking - G/L Account Database  
12 MANDT MANDT MANDT CLNT 3   0   Client T000
13 AUSBK AUSBK BUKRS CHAR 4   0   Source Company Code T001
14 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
15 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year VBKPF
16 BZKEY BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
17 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
18 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
19 BSCHL BSCHL BSCHL CHAR 2   0   Posting Key *
20 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
21 GSBER GSBER GSBER CHAR 4   0   Business Area *
22 PARGB PARGB GSBER CHAR 4   0   Trading partner's business area *
23 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
24 DMBTR DMBTR WERT7 CURR 13   2   Amount in local currency  
25 DMBE2 DMBE2 WERT7 CURR 13   2   Amount in Second Local Currency  
26 DMBE3 DMBE3 WERT7 CURR 13   2   Amount in Third Local Currency  
27 WRBTR WRBTR WERT7 CURR 13   2   Amount in document currency  
28 HWMET HWMET HWMET CHAR 1   0   Method with Which the Local Currency Amount Was Determined  
29 HWBAS HWBAS WERT7 CURR 13   2   Tax Base Amount in Local Currency  
30 FWBAS FWBAS WERT7 CURR 13   2   Tax Base Amount in Document Currency  
31 MWART MWART MWART CHAR 1   0   Tax Type  
32 KURSR KURSR KURSP DEC 9   5   Hedged Exchange Rate  
33 GBETR GBETR WERT7 CURR 13   2   Hedged Amount in Foreign Currency  
34 ZFBDT DZFBDT DATUM DATS 8   0   Baseline date for due date calculation  
35 VALUT VALUT DATUM DATS 8   0   Fixed Value Date  
36 ZUONR DZUONR ZUONR CHAR 18   0   Assignment number  
37 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
38 ANBWA ANBWA BWASL CHAR 3   0   Asset Transaction Type *
39 ZINKZ DZINKZ ZINKZ CHAR 2   0   Exempted from Interest Calculation  
40 RMVCT RMVCT RMVCT CHAR 3   0   Transaction type *
41 FDLEV FDLEV FDLEV CHAR 2   0   Planning Level *
42 FDGRP FDGRP FDGRP CHAR 10   0   Planning Group *
43 FDWBT FDWBT WERTV7 CURR 13   2   Planned Amount in Document or G/L Account Currency  
44 FDTAG FDTAG DATUM DATS 8   0   Planning Date  
45 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area *
46 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
47 AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
48 KDAUF KDAUF VBELN CHAR 10   0   Sales Order Number *
49 KDPOS KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
50 PPRCTR PPRCTR PRCTR CHAR 10   0   Partner Profit Center *
51 IMKEY IMKEY IMKEY CHAR 8   0   Internal Key for Real Estate Object  
52 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
53 XUMSW XUMSW XFELD CHAR 1   0   Indicator: Sales-Related Item ?  
54 XSKRL XSKRL XFELD CHAR 1   0   Indicator: Line item not liable to cash discount?  
55 SAKNR SAKNR SAKNR CHAR 10   0   G/L Account Number *
56 HZUON HZUON ZUONR CHAR 18   0   Assignment Number for Special G/L Accounts  
57 LZBKZ LZBKZ LZBKZ CHAR 3   0   State central bank indicator *
58 LANDL LANDL LAND1 CHAR 3   0   Supplying Country *
59 MATNR MATNR MATNR CHAR 18   0   Material Number *
60 WERKS WERKS_D WERKS CHAR 4   0   Plant *
61 MENGE MENGE_D MENG13 QUAN 13   3   Quantity  
62 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure *
63 BPMNG BPMNG MENG13 QUAN 13   3   Quantity in order price quantity unit  
64 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number *
65 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document *
66 REWRT REEWR WRTV7 CURR 13   2   Invoice Value Entered (in Local Currency)  
67 REWWR REFWR WRTV7 CURR 13   2   Invoice Value in Foreign Currency  
68 ZEKKN DZEKKN NUM02 NUMC 2   0   Sequential Number of Account Assignment  
69 LFBNR WEBLN BELNR CHAR 10   0   Number of goods receipt document  
70 LFPOS MBLPO MBLPO NUMC 4   0   Item in material document  
71 LFGJA MJAHR GJAHR NUMC 4   0   Year of material document  
72 BWKEY BWKEY BWKEY CHAR 4   0   Valuation area *
73 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type *
74 TBTKZ TBTKZ TBTKZ CHAR 1   0   Indicator: Subsequent Debit/Credit  
75 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
76 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
77 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture *
78 RECID JV_RECIND JV_RECIND CHAR 2   0   Recovery Indicator *
79 EGRUP JV_EGROUP JV_EGROUP CHAR 3   0   Equity group *
80 VPTNR JV_PART KUNNR CHAR 10   0   Partner account number *
81 VERTT RANTYP RANTYP CHAR 1   0   Contract Type  
82 VERTN RANL RANL CHAR 13   0   Contract Number  
83 VBEWA SBEWART SBEWART CHAR 4   0   Flow Type *
84 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
85 DABRZ DABRBEZ DDAT DATS 8   0   Reference date for settlement  
86 KSTRG KSTRG KSTRG CHAR 12   0   Cost Object *
87 NPLNR NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment *
88 AUFPL CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
89 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
90 PAOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
91 PASUBNR RKESUBNR RKESUBNR NUMC 4   0   Profitability Segment Changes (CO-PA)  
92 BTYPE JV_BILIND JV_BILIND CHAR 2   0   Payroll Type *
93 ETYPE JV_ETYPE JV_ETYPE CHAR 3   0   Equity type *
94 XEGDR XEGDR XFELD CHAR 1   0   Indicator: Triangular deal within the EU ?  
95 HRKFT HRKFT HRKFT CHAR 4   0   Origin Group as Subdivision of Cost Element *
96 FIPOS FIPOS FIPOS CHAR 14   0   Commitment Item *
97 KOART KOART KOART CHAR 1   0   Account type  
98 VPRSV VPRSV VPRSV CHAR 1   0   Price control indicator  
99 PEINH PEINH PACK3 DEC 5   0   Price unit  
100 KDEIN ETENR ETENR NUMC 4   0   Schedule line *
101 ANLN1 ANLN1 ANLN1 CHAR 12   0   Main Asset Number *
102 ANLN2 ANLN2 ANLN2 CHAR 4   0   Asset Subnumber *
103 SMWSK SMWSK SMWSK CHAR 2   0   Tax Category in Account Master Record  
104 SWAER WAERS WAERS CUKY 5   0   Currency Key *
105 STUNR STUNR STUNR NUMC 3   0   Level Number *
106 ZAEHK DZAEHK ZAEHK NUMC 2   0   Condition counter  
107 XFDIS XFDIS XFELD CHAR 1   0   Indicator: Cash Management activated?  
108 KBLNR KBLNR_FI KBLNR CHAR 10   0   Document number for earmarked funds KBLK
109 KBLPOS KBLPOS KBLPOS NUMC 3   0   Earmarked Funds: Document Item KBLP
110 STTAX STTAX WERT7 CURR 13   2   Tax Amount as Statistical Information in Document Currency  
111 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund *
112 FISTL FISTL FISTL CHAR 16   0   Funds Center *
113 VORNR VORNR VORNR CHAR 4   0   Operation/Activity Number  
114 ABPER ABPER_RF BUPER ACCP 6   0   Settlement period  
115 EREKZ EREKZ XFELD CHAR 1   0   Final Invoice Indicator  
116 FKBER FKBER FKBER CHAR 16   0   Functional Area TFKB
117 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner *
118 XREF1 XREF1 CHAR12 CHAR 12   0   Business partner reference key  
119 XREF2 XREF2 CHAR12 CHAR 12   0   Business partner reference key  
120 XREF3 XREF3 CHAR20 CHAR 20   0   Reference key for line item  
121 CCBTC CCBTC CCBTC CHAR 10   0   Payment cards: Settlement run  
122 RSTGR RSTGR RSTGR CHAR 3   0   Reason Code for Payments T053R
123 GRICD J_1AGICD_D J_1AGICD2 CHAR 2   0   Activity Code for Gross Income Tax J_1AGICD
124 GRIRG REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
125 GITYP J_1ADTYP_D J_1ADTYP CHAR 2   0   Distribution Type for Employment Tax J_1ADTYP
126 IDXSP J_1AINDXSP J_1AINDXP CHAR 5   0   Inflation Index J_1AINFT20
127 BUZID BUZID CHAR1 CHAR 1   0   Identification of the Line Item  
128 ERLKZ KBLERLKZ CHAR1_X CHAR 1   0   Completion indicator for line item  
129 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place *
130 LSTAR LSTAR LSTAR CHAR 6   0   Activity Type *
131 PSTYP PSTYP PSTYP CHAR 1   0   Item category in purchasing document *
132 PRZNR CO_PRZNR CO_PRZNR CHAR 12   0   Business Process *
133 KONTT KONTT_FI KONTT_FI CHAR 2   0   Account Assignment Category for Industry Solution  
134 KONTL KONTL_FI CHAR50 CHAR 50   0   Acct assignment string for industry-specific acct assignmnts  
135 .INCLUDE       0   0    
136 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
137 BZDAT BZDAT DATUM DATS 8   0   Asset Value Date  
138 XNEGP XNEGP XFELD CHAR 1   0   Indicator: Negative posting  
139 SEGMENT FB_SEGMENT FB_SEGMENT CHAR 10   0   Segment for Segmental Reporting *
140 PSEGMENT FB_PSEGMENT FB_SEGMENT CHAR 10   0   Partner Segment for Segmental Reporting *
141 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement *
142 PGEBER FM_PFUND BP_GEBER CHAR 10   0   Partner Fund *
143 PGRANT_NBR GM_GRANT_PARTNER GM_GRANT_NBR CHAR 20   0   Partner Grant  
144 MEASURE FM_MEASURE FM_MEASURE CHAR 24   0   Funded Program *
145 BUDGET_PD FM_BUDGET_PERIOD FM_BUDGET_PERIOD CHAR 10   0   FM: Budget Period *
146 PBUDGET_PD FM_PBUDGET_PERIOD FM_BUDGET_PERIOD CHAR 10   0   FM: Partner Budget Period *
147 .INCLU--AP       0   0   IS-PS: Append Struture VBSEGS for Payment Requests  
148 FIPEX FM_FIPEX_DONT_USE FM_FIPEX CHAR 24   0   Commitment item - Do not use field - see note 447805 *
149 .INCLU--AP       0   0   FMFG: US Federal Specific Fields  
150 PEROP_BEG FM_PEROP_FI_LOW DATUM DATS 8   0   Billing Period of Performance Start Date  
151 PEROP_END FM_PEROP_FI_HIGH DATUM DATS 8   0   Billing Period of Performance End Date  
152 FASTPAY FMFG_FASTPAY_FLG XFELD CHAR 1   0   PPA Fast Pay Indicator  
153 PPA_EX_IND EXCLUDE_FLG XFELD CHAR 1   0   PPA Exclude Indicator  
154 FMFGUS_KEY FMFG_US_KEY SYSUUID_22 CHAR 22   0   United States Federal Government Fields  
155 .INCLU--AP       0   0   Joint Venture Accounting  
156 PRODPER JV_PRODPER JV_PRODPER DATS 8   0   Production Month (Date to find period and year)  
157 .INCLU--AP       0   0   Credit Card: Append for VBSEGS  
158 .INCLUDE       0   0   Include for Appends for VBSE*  
159 CHWRB CHWRB CHAR1 CHAR 1   0   Document Parking: Amount not Modifiable  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 IPRQI AUSBK T001 BUKRS KEY 1 CN
2 IPRQI BUKRS T001 BUKRS REF 1 CN
3 IPRQI FKBER TFKB FKBER 1 CN
4 IPRQI GITYP J_1ADTYP J_1ADTYP 1 CN
5 IPRQI GJAHR VBKPF GJAHR KEY 1 CN
6 IPRQI GRICD J_1AGICD J_1AGICD 1 CN
7 IPRQI GRIRG T005S BLAND 1 CN
8 IPRQI IDXSP J_1AINFT20 J_1AINDX KEY 1 CN
9 IPRQI KBLNR KBLK BELNR REF C CN
10 IPRQI KBLPOS KBLP BLPOS REF C C
11 IPRQI MANDT T000 MANDT KEY 1 CN
12 IPRQI RSTGR T053R RSTGR C CN
History
Last changed by/on SAP  20140121 
SAP Release Created in