SAP IPRQI Items from a Payment Request (External Interface) Table data and field list

IPRQI 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 "Items from a Payment Request (External Interface)" 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_IPRQI TYPE IPRQI.

The IPRQI table consists of various fields, each holding specific information or linking keys about Items from a Payment Request (External Interface) data available in SAP. These include OACIN (Payment sequence and special payment), SAKN2 (Target account), KBLNR_COM (Funds commitment (commitment budget)), KBLPOS_COM (Earmarked Funds: Document Item)... 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. .

IPRQI structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP IPRQI structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the IPRQI table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
ACIND	Account Determination Characteristic	ACIND	CHAR	3	Assigned to domain		ACIND
OACIN	Payment sequence and special payment	PRQ_OACIN	CHAR	3			PRQ_OACIN
SAKN2	Target account	SAKNR_ZIEL	CHAR	10	Assigned to domain	ALPHA	SAKNR
KBLNR_COM	Funds commitment (commitment budget)	KBLNR_COM	CHAR	10	Assigned to domain	ALPHA	KBLNR
KBLPOS_COM	Earmarked Funds: Document Item	KBLPOS	NUMC	3	Assigned to domain		KBLPOS	KBP
FIPOS_COM	Commitment Item	FIPOS	CHAR	14	Assigned to domain		FIPOS	FIP
FISTL_COM	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
GEBER_COM	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
ERLKZ_COM	Completed indicator for funds commitment line item	KBLERLKZ_C	CHAR	1			CHAR1_X
ERLKZ_PAY	Completed indicator for payment commitment line item	KBLERLKZ_P	CHAR	1			CHAR1_X
MANDT	Client	MANDT	CLNT	3	T000		MANDT
AUSBK	Source Company Code	AUSBK	CHAR	4	T001		BUKRS
BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
GJAHR	Fiscal Year	GJAHR	NUMC	4	VBKPF	GJAHR	GJAHR	GJR
BZKEY	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
BSCHL	Posting Key	BSCHL	CHAR	2	Assigned to domain		BSCHL
SHKZG	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
GSBER	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
PARGB	Trading partner's business area	PARGB	CHAR	4	Assigned to domain		GSBER	GSB
MWSKZ	Tax on sales/purchases code	MWSKZ	CHAR	2	Assigned to domain		MWSKZ
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
HWMET	Method with Which the Local Currency Amount Was Determined	HWMET	CHAR	1			HWMET
HWBAS	Tax Base Amount in Local Currency	HWBAS	CURR	13(2)			WERT7
FWBAS	Tax Base Amount in Document Currency	FWBAS	CURR	13(2)			WERT7
MWART	Tax Type	MWART	CHAR	1			MWART
KURSR	Hedged Exchange Rate	KURSR	DEC	9(5)			KURSP
GBETR	Hedged Amount in Foreign Currency	GBETR	CURR	13(2)			WERT7
ZFBDT	Baseline Date for Due Date Calculation	DZFBDT	DATS	8			DATUM
VALUT	Value date	VALUT	DATS	8			DATUM
ZUONR	Assignment Number	DZUONR	CHAR	18			ZUONR
SGTXT	Item Text	SGTXT	CHAR	50			TEXT50
ANBWA	Asset Transaction Type	ANBWA	CHAR	3	Assigned to domain		BWASL
ZINKZ	Exempted from interest calculation	DZINKZ	CHAR	2			ZINKZ
RMVCT	Transaction Type	RMVCT	CHAR	3	Assigned to domain		RMVCT
FDLEV	Planning level	FDLEV	CHAR	2	Assigned to domain		FDLEV	FFE
FDGRP	Planning Group	FDGRP	CHAR	10	Assigned to domain	ALPHA	FDGRP	FFG
FDWBT	Planning amount in document currency	FDWBT	CURR	13(2)			WERTV7
FDTAG	Planning date	FDTAG	DATS	8			DATUM	FDT
KOKRS	Controlling Area	KOKRS	CHAR	4	Assigned to domain		CACCD	CAC
KOSTL	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
AUFNR	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
KDAUF	Sales Order Number	KDAUF	CHAR	10	Assigned to domain	ALPHA	VBELN	AUN
KDPOS	Item Number in Sales Order	KDPOS	NUMC	6			NUM06	KPO
PPRCTR	Partner Profit Center	PPRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PPC
IMKEY	Internal Key for Real Estate Object	IMKEY	CHAR	8			IMKEY
PERNR	Personnel Number	PERNR_D	NUMC	8			PERNR	PER
XUMSW	Indicator: Sales-related item ?	XUMSW	CHAR	1			XFELD
XSKRL	Indicator: Line item not liable to cash discount?	XSKRL	CHAR	1			XFELD
SAKNR	G/L Account Number	SAKNR	CHAR	10	Assigned to domain	ALPHA	SAKNR	SAK	C_SAKNR
HZUON	Assignment Number for Special G/L Accounts	HZUON	CHAR	18			ZUONR
LZBKZ	State Central Bank Indicator	LZBKZ	CHAR	3	Assigned to domain		LZBKZ
LANDL	Supplying Country	LANDL	CHAR	3	Assigned to domain		LAND1
MATNR	Material Number	MATNR	CHAR	18	Assigned to domain	MATN1	MATNR	MAT	S_MAT1
WERKS	Plant	WERKS_D	CHAR	4	Assigned to domain		WERKS	WRK	H_T001W_C
MENGE	Quantity	MENGE_D	QUAN	13(3)			MENG13
MEINS	Base Unit of Measure	MEINS	UNIT	3	Assigned to domain	CUNIT	MEINS
BPMNG	Quantity in Purchase Order Price Unit	BPMNG	QUAN	13(3)			MENG13
EBELN	Purchasing Document Number	EBELN	CHAR	10	Assigned to domain	ALPHA	EBELN	BES	MEKK_C
EBELP	Item Number of Purchasing Document	EBELP	NUMC	5	Assigned to domain		EBELP	BSP
REWRT	Invoice Value Entered (in Local Currency)	REEWR	CURR	13(2)			WRTV7
REWWR	Invoice value in foreign currency	REFWR	CURR	13(2)			WRTV7
ZEKKN	Sequential Number of Account Assignment	DZEKKN	NUMC	2			NUM02
LFBNR	Number of goods receipt document	WEBLN	CHAR	10		ALPHA	BELNR
LFPOS	Item in Material Document	MBLPO	NUMC	4			MBLPO	POS
LFGJA	Material Document Year	MJAHR	NUMC	4		GJAHR	GJAHR	MJA
BWKEY	Valuation Area	BWKEY	CHAR	4	Assigned to domain		BWKEY	BWK
BWTAR	Valuation Type	BWTAR_D	CHAR	10	Assigned to domain		BWTAR	BWT
TBTKZ	Indicator: subsequent debit/credit	TBTKZ	CHAR	1			TBTKZ
STCEG	VAT Registration Number	STCEG	CHAR	20			STCEG
PRCTR	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
VNAME	Joint Venture	JV_NAME	CHAR	6	Assigned to domain	ALPHA	JV_NAME	JVV
RECID	Recovery Indicator	JV_RECIND	CHAR	2	Assigned to domain	ALPHA	JV_RECIND
EGRUP	Equity group	JV_EGROUP	CHAR	3	Assigned to domain	ALPHA	JV_EGROUP	GJE
VPTNR	Partner account number	JV_PART	CHAR	10	Assigned to domain	ALPHA	KUNNR
VERTT	Contract Type	RANTYP	CHAR	1			RANTYP
VERTN	Contract Number	RANL	CHAR	13		ALPHA	RANL	RAN
VBEWA	Flow Type	SBEWART	CHAR	4	Assigned to domain		SBEWART
TXJCD	Tax Jurisdiction	TXJCD	CHAR	15	Assigned to domain		TXJCD	TXJ
DABRZ	Reference Date for Settlement	DABRBEZ	DATS	8			DDAT
KSTRG	Cost Object	KSTRG	CHAR	12	Assigned to domain		KSTRG	KTR
NPLNR	Network Number for Account Assignment	NPLNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	NET
AUFPL	Routing number of operations in the order	CO_AUFPL	NUMC	10			AUFPL
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	PS_PSP_PNR	NUMC	8	Assigned to domain	KONPR	PS_POSNR
PAOBJNR	Profitability Segment Number (CO-PA)	RKEOBJNR	NUMC	10			RKEOBJNR
PASUBNR	Profitability segment changes (CO-PA)	RKESUBNR	NUMC	4			RKESUBNR
BTYPE	Payroll Type	JV_BILIND	CHAR	2	Assigned to domain	ALPHA	JV_BILIND
ETYPE	Equity type	JV_ETYPE	CHAR	3	Assigned to domain	ALPHA	JV_ETYPE
XEGDR	Indicator: Triangular deal within the EU ?	XEGDR	CHAR	1			XFELD
HRKFT	Origin Group as Subdivision of Cost Element	HRKFT	CHAR	4	Assigned to domain		HRKFT
FIPOS	Commitment Item	FIPOS	CHAR	14	Assigned to domain		FIPOS	FIP
KOART	Account Type	KOART	CHAR	1			KOART
VPRSV	Price control indicator	VPRSV	CHAR	1			VPRSV
PEINH	Price Unit	PEINH	DEC	5			PACK3
KDEIN	Delivery Schedule Line Number	ETENR	NUMC	4	Assigned to domain		ETENR
ANLN1	Main Asset Number	ANLN1	CHAR	12	Assigned to domain	ALPHA	ANLN1	AN1
ANLN2	Asset Subnumber	ANLN2	CHAR	4	Assigned to domain	ALPHA	ANLN2	AN2
SMWSK	Tax Category in Account Master Record	SMWSK	CHAR	2			SMWSK
SWAER	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
STUNR	Step number	STUNR	NUMC	3	Assigned to domain		STUNR
ZAEHK	Condition counter	DZAEHK	NUMC	2			ZAEHK
XFDIS	Indicator: Cash Management activated?	XFDIS	CHAR	1			XFELD
KBLNR	Document Number for Earmarked Funds	KBLNR_FI	CHAR	10	KBLK	ALPHA	KBLNR	KBL
KBLPOS	Earmarked Funds: Document Item	KBLPOS	NUMC	3	KBLP		KBLPOS	KBP
STTAX	Tax amount as statistical information in document currency	STTAX	CURR	13(2)			WERT7
GEBER	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
FISTL	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
VORNR	Operation/Activity Number	VORNR	CHAR	4		NUMCV	VORNR	VGN
ABPER	Settlement period	ABPER_RF	ACCP	6			BUPER
EREKZ	Final Invoice Indicator	EREKZ	CHAR	1			XFELD
FKBER	Functional Area	FKBER	CHAR	16	TFKB		FKBER	FBE
VBUND	Company ID of trading partner	RASSC	CHAR	6	Assigned to domain	ALPHA	RCOMP	PGS
XREF1	Business partner reference key	XREF1	CHAR	12			CHAR12
XREF2	Business partner reference key	XREF2	CHAR	12			CHAR12
XREF3	Reference key for line item	XREF3	CHAR	20			CHAR20
CCBTC	Payment cards: Settlement run	CCBTC	CHAR	10		ALPHA	CCBTC
RSTGR	Reason Code for Payments	RSTGR	CHAR	3	T053R		RSTGR
GRICD	Activity Code for Gross Income Tax	J_1AGICD_D	CHAR	2	J_1AGICD		J_1AGICD2
GRIRG	STATE (State, Province, County)	REGIO	CHAR	3	T005S		REGIO
GITYP	Distribution Type for Employment Tax	J_1ADTYP_D	CHAR	2	J_1ADTYP		J_1ADTYP
IDXSP	Inflation Index	J_1AINDXSP	CHAR	5	J_1AINFT20		J_1AINDXP
BUZID	Identification of the Line Item	BUZID	CHAR	1			CHAR1
ERLKZ	Completion indicator for line item	KBLERLKZ	CHAR	1			CHAR1_X
BUPLA	Business Place	BUPLA	CHAR	4	Assigned to domain		J_1BBRANCH
LSTAR	Activity Type	LSTAR	CHAR	6	Assigned to domain		LSTAR	LAR	LART_EMPTY
PSTYP	Item Category in Purchasing Document	PSTYP	CHAR	1	Assigned to domain		PSTYP
PRZNR	Business Process	CO_PRZNR	CHAR	12	Assigned to domain	ALPHA	CO_PRZNR	KWP
KONTT	Account Assignment Category for Industry Solution	KONTT_FI	CHAR	2			KONTT_FI
KONTL	Acct assignment string for industry-specific acct assignmnts	KONTL_FI	CHAR	50			CHAR50
GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
BZDAT	Asset value date	BZDAT	DATS	8			DATUM
XNEGP	Indicator: Negative posting	XNEGP	CHAR	1			XFELD
SEGMENT	Segment for Segmental Reporting	FB_SEGMENT	CHAR	10	Assigned to domain	ALPHA	FB_SEGMENT
PSEGMENT	Partner Segment for Segmental Reporting	FB_PSEGMENT	CHAR	10	Assigned to domain	ALPHA	FB_SEGMENT
UZAWE	Payment Method Supplement	UZAWE	CHAR	2	Assigned to domain		UZAWE
PGEBER	Partner Fund	FM_PFUND	CHAR	10	Assigned to domain		BP_GEBER	PARTNER_FUND
PGRANT_NBR	Partner Grant	GM_GRANT_PARTNER	CHAR	20		ALPHA	GM_GRANT_NBR		GRANTS_GENERIC
MEASURE	Funded Program	FM_MEASURE	CHAR	24	Assigned to domain		FM_MEASURE	FM_MEASURE
BUDGET_PD	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
PBUDGET_PD	FM: Partner Budget Period	FM_PBUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
.INCLU--AP				0
FIPEX	Commitment item - Do not use field - see note 447805	FM_FIPEX_DONT_USE	CHAR	24	Assigned to domain	FMCIL	FM_FIPEX	FPS
.INCLU--AP				0
PEROP_BEG	Billing Period of Performance Start Date	FM_PEROP_FI_LOW	DATS	8			DATUM
PEROP_END	Billing Period of Performance End Date	FM_PEROP_FI_HIGH	DATS	8			DATUM
FASTPAY	PPA Fast Pay Indicator	FMFG_FASTPAY_FLG	CHAR	1			XFELD
PPA_EX_IND	PPA Exclude Indicator	EXCLUDE_FLG	CHAR	1			XFELD
.INCLU--AP				0
PRODPER	Production Month (Date to find period and year)	JV_PRODPER	DATS	8			JV_PRODPER
.INCLU--AP				0
CHWRB	Document Parking: Amount not Modifiable	CHWRB	CHAR	1			CHAR1

Key field

Non-key field

< IPRQH - Payment Request Header Data (External Interface) IPRQP - Payment Request Payment Data (For External Interface) >

How do I retrieve data from SAP structure IPRQI using ABAP code?

As IPRQI 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 IPRQI as there is no data to select.

How to access SAP table IPRQI

Within an ECC or HANA version of SAP you can also view further information about IPRQI and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).