Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

FPRL_ITEM SAP (Item Data) Table details

Dictionary Type: Table
Description: Item Data

ABAP Code to SELECT data from FPRL_ITEM
Related tables to FPRL_ITEM
Access table FPRL_ITEM

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Table field list including key, data, relationships and ABAP select examples

FPRL_ITEM is a standard SAP Table which is used to store Item Data data and is available within R/3 SAP systems depending on the version and release level.

The FPRL_ITEM table consists of various fields, each holding specific information or linking keys about Item Data data available in SAP. These include GUID (UUID in X form (binary)), LIST_ID (Payment Release List ID), STATUS (Item Status ID), ALEVEL (Approval Level).. 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. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP FPRL_ITEM table fields - Full list of fields found in SAP data dictionary

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
GUID	UUID in X form (binary)	SYSUUID_X	RAW	16			SYSUUID
LIST_ID	Payment Release List ID	FPRL_LIST_ID	NUMC	10	FPRL_HEADER		NUMC10	FPRL_LIST_ID
STATUS	Item Status ID	FPRL_ITEM_STATUS	CHAR	3	FPRL_ITEM_STAT		CHAR3
ALEVEL	Approval Level	FPRL_LEVEL	NUMC	2	FPRL_LEVELS		NUM02
CREA_USER	Created By	FPRL_USER	CHAR	12			USNAM
CREA_TIME	Created On	FPRL_CREA_TIME	DEC	15		TSTPS	FPRL_TIMESTAMP
CHANGE_USER	Last Changed By	FPRL_USER_CH	CHAR	12			USNAM
CHANGE_TIME	Last Changed On	FPRL_CHANGE_TIME	DEC	15		TSTPS	FPRL_TIMESTAMP
APPLIC	Payment Release List Application ID	FPRL_APPLICATION	CHAR	10	FPRL_APPLIC		FPRL_APPLICATION	APPL
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
LIFNR	Account Number of Vendor or Creditor	LIFNR	CHAR	10	LFA1	ALPHA	LIFNR	LIF	KRED_C
KUNNR	Customer Numbers	KUNNR	CHAR	10	KNA1	ALPHA	KUNNR	KUN	C_KUNNR
FILKD	Account Number of the Branch	FILKD	CHAR	10		ALPHA	MAXKK
EMPFB	Payee/Payer	EMPFB	CHAR	10		ALPHA	MAXKK
VBUND	Company ID of trading partner	RASSC	CHAR	6	T880	ALPHA	RCOMP	PGS
SHKZG	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
WAERS	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
WRBTR	Amount in document currency	WRBTR	CURR	13(2)			WERT7
SKFBT	Amount Eligible for Cash Discount in Document Currency	SKFBT	CURR	13(2)			WERT7
WSKTO	Cash discount amount in document currency	WSKTO	CURR	13(2)			WERT7
QBSHB	Withholding Tax Amount (in Document Currency)	QBSHB	CURR	13(2)			WERT7
PSWSL	Update Currency for General Ledger Transaction Figures	PSWSL	CUKY	5	Assigned to domain		WAERS
PSWBT	Amount for Updating in General Ledger	PSWBT	CURR	13(2)			WERT7
PSSKT	Cash Discount Deduction for the Item	PSSKT	CURR	13(2)			WRTV7
BLART	Document Type	BLART	CHAR	2	T003		BLART	BAR
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
BLDAT	Document Date in Document	BLDAT	DATS	8			DATUM
KOART	Account Type	KOART	CHAR	1			KOART
BSCHL	Posting Key	BSCHL	CHAR	2	TBSL		BSCHL
HKONT	General Ledger Account	HKONT	CHAR	10	SKB1	ALPHA	SAKNR
SAKNR	G/L Account Number	SAKNR	CHAR	10	SKB1	ALPHA	SAKNR	SAK	C_SAKNR
UMSKZ	Special G/L Indicator	UMSKZ	CHAR	1	T074U		UMSKZ
GSBER	Business Area	GSBER	CHAR	4	TGSB		GSBER	GSB
MWSKZ	Tax on sales/purchases code	MWSKZ	CHAR	2	Assigned to domain		MWSKZ
QSSKZ	Withholding Tax Code	QSSKZ	CHAR	2	Assigned to domain		QSSKZ
SGTXT	Item Text	SGTXT	CHAR	50			TEXT50
ZFBDT	Baseline Date for Due Date Calculation	DZFBDT	DATS	8			DATUM
ZBD1T	Cash discount days 1	DZBD1T	DEC	3			ZBDXT
ZBD2T	Cash discount days 2	DZBD2T	DEC	3			ZBDXT
ZBD3T	Net Payment Terms Period	DZBD3T	DEC	3			ZBDXT
ZBD1P	Cash Discount Percentage 1	DZBD1P	DEC	5(3)			PRZ23
ZBD2P	Cash Discount Percentage 2	DZBD2P	DEC	5(3)			PRZ23
XREBZ	Indicator: Item is an Invoice-Related Credit Memo	XREBZ	CHAR	1			XFELD
ESRNR	ISR Subscriber Number	ESRNR	CHAR	11			ESRNR
ESRRE	ISR Reference Number	ESRRE	CHAR	27		ALPHA	ESRRE
ESRPZ	ISR Check Digit	ESRPZ	CHAR	2			CHAR2
EBELN	Purchasing Document Number	EBELN	CHAR	10	EKKO	ALPHA	EBELN	BES	MEKK_C
EBELP	Item Number of Purchasing Document	EBELP	NUMC	5	EKPO		EBELP	BSP
STCEG	VAT Registration Number	STCEG	CHAR	20			STCEG
XBLNR	Reference Document Number	XBLNR1	CHAR	16			XBLNR1
LZBKZ	State Central Bank Indicator	LZBKZ	CHAR	3	T015L		LZBKZ
LANDL	Supplying Country	LANDL	CHAR	3	T005		LAND1
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
ZUONR	Assignment Number	DZUONR	CHAR	18			ZUONR
VERTN	Contract Number	RANL	CHAR	13		ALPHA	RANL	RAN
REBZT	Follow-On Document Type	REBZT	CHAR	1			REBZT
REBZG	Number of the Invoice the Transaction Belongs to	REBZG	CHAR	10		ALPHA	BELNR
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	REBZJ	NUMC	4		GJAHR	GJAHR
REBZZ	Line Item in the Relevant Invoice	REBZZ	NUMC	3			BUZEI
KOSTL	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
VBEL2	Sales Document	VBELN_VA	CHAR	10	Assigned to domain	ALPHA	VBELN	AUN
POSN2	Sales Document Item	POSNR_VA	NUMC	6	Assigned to domain		POSNR	APO
PRCTR	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
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
DTWS1	Instruction key 1	DTAT16	NUMC	2	Assigned to domain		DTWSX
DTWS2	Instruction key 2	DTAT17	NUMC	2	Assigned to domain		DTWSX
DTWS3	Instruction key 3	DTAT18	NUMC	2	Assigned to domain		DTWSX
DTWS4	Instruction key 4	DTAT19	NUMC	2	Assigned to domain		DTWSX
XCPDD	Indicator: Address and bank data set individually	XCPDD	CHAR	1			XFELD
BUPLA	Business Place	BUPLA	CHAR	4	Assigned to domain		J_1BBRANCH
PPRCT	Partner Profit Center	PPRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PPC
GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
FKBER	Functional Area	FKBER	CHAR	16	Assigned to domain		FKBER	FBE
GEBER	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
XINVE	Indicator: Capital Goods Affected?	XINVE	CHAR	1			XFELD
KEYNO	Key Number for Payment Request	PRQ_KEYNO	CHAR	10	Assigned to domain	ALPHA	PRQ_KEYNO
PAMTF	Payment Request Amount in Payment Currency	PRQ_AMTFC	CURR	13(2)			WERT7
ORIGIN	Origin Indicator	FIBL_ORIGIN	CHAR	8	Assigned to domain		FIBL_ORIGIN
.INCLU--AP				0
EPIC_PROCESSOR	Processor	EPIC_PROCESSOR	CHAR	12	Assigned to domain		XUBNAME
EPIC_STATUS	Item Status	EPIC_ITEM_STATUS	CHAR	3			EPIC_ITEM_STATUS
.INCLU--AP				0
AVC_STATUS	Cash Control Status	FMCCAVC_STATUS	CHAR	1			FMCCAVC_STATUS
AVC_PRIORITY	Cash Control Priority	FMCCAVC_PRIORITY	NUMC	6
.INCLU--AP				0
FIPOS_ES	Commitment Item	FIPOS	CHAR	14	Assigned to domain		FIPOS	FIP
FISTL_ES	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
GRANT_NBR_ES	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
FKBER_ES	Functional Area	FKBER	CHAR	16	Assigned to domain		FKBER	FBE
GEBER_ES	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
PROJK_ES	Work Breakdown Structure Element (WBS Element)	PS_PSP_PNR	NUMC	8	Assigned to domain	KONPR	PS_POSNR
CISUB1_ES	Substring 1 of Commitment Item	FM_CISUB1	CHAR	10			CHAR10
CISUB2_ES	Substring 2 of Commitment Item	FM_CISUB2	CHAR	10			CHAR10
CISUB3_ES	Substring 3 of Commitment Item	FM_CISUB3	CHAR	10			CHAR10
CISUB4_ES	Substring 4 of Commitment Item	FM_CISUB4	CHAR	10			CHAR10
CISUB5_ES	Substring 5 of Commitment Item	FM_CISUB5	CHAR	10			CHAR10
LOTKZ_ES	Lot Number for Requests	PSO_LOTKZ	CHAR	10		ALPHA	LOTKZ	LOT
.INCLU--AP				0
EBELN_CO	Purchasing Document Number	EBELN	CHAR	10	Assigned to domain	ALPHA	EBELN	BES	MEKK_C
SAPLONGNUM	Smart Number	/SAPPSPRO/LONGNUM	CHAR	40			/SAPPSPRO/LONGNUM	/SAPPSPRO/LONG_BES	/SAPPSPRO/MEKK
KBLNR	Document Number for Earmarked Funds	KBLNR	CHAR	10	Assigned to domain	ALPHA	KBLNR	KBL
ACCOUNTANT	Accountant	FPCR_ACCOUNTANT	CHAR	6			FPCR_ACCOUNTANT
CO_STATUS	Status of Garnishment	FPCL_CO_STAT	NUMC	2			FPCL_CO_STAT
STCD2	Tax Number 2	STCD2	CHAR	11			STCD2
POKEN	Item Indicator	POKEN	CHAR	3			CHAR3
ZLSPR	Payment Block Key	DZLSPR	CHAR	1	T008		ZAHLS	SPE
LAUFD_PAY	Date on Which the Program Is to Be Run	LAUFD	DATS	8			DATUM
LAUFI_PAY	Additional Identification	LAUFI	CHAR	6			LAUFI
VBLNR_PAY	Document Number of the Payment Document	VBLNR	CHAR	10		ALPHA	BELNR
PYORD_PAY	Payment Order	PYORD	CHAR	10		ALPHA	PYORD
XF110_EXEC	General Flag	FLAG	CHAR	1			FLAG
LAUFD	Date of Proposal Run	FPRL_LAUFD	DATS	8			DATUM
LAUFI	Payment Proposal	FPRL_LAUFI	CHAR	6			LAUFI
JOBCOUNT	Job ID	BTCJOBCNT	CHAR	8			CHAR8
ZBUKR	Paying company code	DZBUKR	CHAR	4	T001		BUKRS
ABSBU	Sending company code	ABSBU	CHAR	4	Assigned to domain		BUKRS
ZNME1	Name of the payee	DZNME1	CHAR	35			TEXT35
ZPSTL	Postal code of the payee	DZPSTL	CHAR	10			PSTLZ
ZORT1	City of the payee	DZORT1	CHAR	35			TEXT35
ZLAND	Country Key	DZLAND	CHAR	3	Assigned to domain		LAND1	LND
ZREGI	Regional code of the payee	DZREGI	CHAR	3	Assigned to domain		REGIO
ZSPRA	Language key of the payee	DZSPRA	LANG	1	Assigned to domain	ISOLA	SPRAS
NAME1	Name 1	NAME1_GP	CHAR	35			NAME
ZBVTY	Bank Data Indicator for the Payee	DZBVTY	CHAR	4			BVTYP
ZBNKS	Country Key	DZBNKS	CHAR	3	Assigned to domain		LAND1	LND
ZBNKY	Bank key of the payee's bank	DZBNKY	CHAR	15			BANKK
ZBNKL	Bank number of the payee's bank	DZBNKL	CHAR	15			BANKL
ZBNKN	Bank account number of the payee	DZBNKN	CHAR	18			BANKN
ZBKON	Bank Control Key of the Payee's Bank	DZBKON	CHAR	2			BKONT
BKREF	Reference specifications for bank details	BKREF	CHAR	20			CHAR20
ZSWIF	SWIFT/BIC for International Payments	SWIFT	CHAR	11			SWIFT
ZIBAN	IBAN (International Bank Account Number)	IBAN	CHAR	34			IBAN
KOINH	Account Holder Name	KOINH_FI	CHAR	60			KOINH
HKTID	ID for account details	HKTID	CHAR	5	Assigned to domain		HKTID
HBKID	Short Key for a House Bank	HBKID	CHAR	5	T012		HBKID
UBNKS	Bank country key	BANKS	CHAR	3	Assigned to domain		LAND1	BKL
UBNKY	Bank key of our bank	UBNKY	CHAR	15			BANKK
UBNKL	Bank number of our bank	UBNKL	CHAR	15			BANKL
UBKNT	Our account number at the bank	UBKNT	CHAR	18			BANKN
UBKON	Bank control key at our bank	UBKON	CHAR	2			BKONT
UBHKT	G/L Account Number for Our Bank Account / Bank Sub-Account	UBHKT	CHAR	10	Assigned to domain	ALPHA	SAKNR
RZAWE	Payment Method	DZLSCH	CHAR	1	T042Z		ZLSCH
UZAWE	Payment Method Supplement	UZAWE	CHAR	2	T042F		UZAWE
DTAWS	Instruction key for data medium exchange	DTAWS	CHAR	2	Assigned to domain		DTAWS
ZALDT	Posting date of the payment document	DZALDT_ZHL	DATS	8			DATUM
VALUT	Value date	VALUT	DATS	8			DATUM
AUSFD	Due date of the paid items	AUSFD	DATS	8			DATUM
ANFAE	Bill of Exchange Payment Request Due Date	ANFAE	DATS	8			DATUM
WEFAE	Bill of Exchange Due Date	WEFAE	DATS	8			DATUM
WDATE	Bill of Exchange Issue Date	WDATE	DATS	8			DATUM
BUSAB	Accounting clerk	BUSAB	CHAR	2	Assigned to domain		BUSAB
EIKTO	Shipper's (Our) Account Number at the Customer or Vendor	EIKTO	CHAR	12			CHAR12
KIDNO	Payment Reference	KIDNO	CHAR	30			CHAR30
RFTTRN	Payment code	RFTTRN_BF	CHAR	20			RFTTRN_BF
BTYP1	Type of bank in a bank chain (correspondent, intermediary)	BNTYP	CHAR	1			BNTYP
BNKS1	Bank country key	BANKS	CHAR	3	Assigned to domain		LAND1	BKL
BNKL1	Bank Keys	BANKK	CHAR	15			BANKK	BNK
BNKN1	Bank account number	BANKN	CHAR	18			BANKN
BTYP2	Type of bank in a bank chain (correspondent, intermediary)	BNTYP	CHAR	1			BNTYP
BNKS2	Bank country key	BANKS	CHAR	3	Assigned to domain		LAND1	BKL
BNKL2	Bank Keys	BANKK	CHAR	15			BANKK	BNK
BNKN2	Bank account number	BANKN	CHAR	18			BANKN
BTYP3	Type of bank in a bank chain (correspondent, intermediary)	BNTYP	CHAR	1			BNTYP
BNKS3	Bank country key	BANKS	CHAR	3	Assigned to domain		LAND1	BKL
BNKL3	Bank Keys	BANKK	CHAR	15			BANKK	BNK
BNKN3	Bank account number	BANKN	CHAR	18			BANKN
MGUID	SEPA Mandate: GUID of Mandate	SEPA_MGUID	RAW	16
MNDID	Unique Referene to Mandate per Payment Recipient	SEPA_MNDID	CHAR	35			ID035
INV_NO	Document Number or Invoice Reference Number	FPRL_REBZG	CHAR	10		ALPHA	BELNR
INV_YEAR	Fiscal Year of DocNo/Inf.ref.	FPRL_REBZJ	NUMC	4		GJAHR	GJAHR
INV_ITEM	Line Item within Accounting Document or Relevant Invoice	FPRL_REBZZ	NUMC	3			BUZEI

Key field

Non-key field

How do I retrieve data from SAP table FPRL_ITEM using ABAP code

The following ABAP code Example will allow you to do a basic selection on FPRL_ITEM to SELECT all data from the table
DATA: WA_FPRL_ITEM TYPE FPRL_ITEM.

SELECT SINGLE *
FROM FPRL_ITEM
INTO CORRESPONDING FIELDS OF WA_FPRL_ITEM
WHERE...

How to access SAP table FPRL_ITEM

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

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

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!