FPRL_ITEM - Item Data

Item Data information is stored in SAP table FPRL_ITEM.
It is part of development package FIN_PRL in software component FI-AP-AP-B. This development package consists of objects that can be grouped under "Payment Release List".

Fields for table FPRL_ITEM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
GUID	UUID in X form (binary)	X	SYSUUID_X	RAW	16
.INCLUDE				FPRLS_ITEM_STATUS	0
LIST_ID	Payment Release List ID		FPRL_LIST_ID	NUMC	20	FPRL_HEADER
STATUS	Item Status ID		FPRL_ITEM_STATUS	CHAR	6	FPRL_ITEM_STAT
ALEVEL	Approval Level		FPRL_LEVEL	NUMC	4	FPRL_LEVELS
.INCLUDE				FPRLS_DATA	0
CREA_USER	Created By		FPRL_USER	CHAR	24
CREA_TIME	Created On		FPRL_CREA_TIME	DEC	8
CHANGE_USER	Last Changed By		FPRL_USER_CH	CHAR	24
CHANGE_TIME	Last Changed On		FPRL_CHANGE_TIME	DEC	8
APPLIC	Payment Release List Application ID		FPRL_APPLICATION	CHAR	20	FPRL_APPLIC
.INCLUDE				FPRLS_ITEM_DATA	0
BUKRS	Company Code		BUKRS	CHAR	8	T001
BELNR	Document Number of an Accounting Document		BELNR_D	CHAR	20
GJAHR	Fiscal Year		GJAHR	NUMC	8
BUZEI	Number of Line Item Within Accounting Document		BUZEI	NUMC	6
LIFNR	Account Number of Supplier		LIFNR	CHAR	20	LFA1
KUNNR	Customer Number		KUNNR	CHAR	20	KNA1
FILKD	Account Number of the Branch		FILKD	CHAR	20
EMPFB	Payee/Payer		EMPFB	CHAR	20
VBUND	Company ID of Trading Partner		RASSC	CHAR	12	T880
SHKZG	Debit/Credit Indicator		SHKZG	CHAR	2
WAERS	Currency Key		WAERS	CUKY	10	TCURC
WRBTR	Amount in document currency		WRBTR	CURR	12
SKFBT	Amount Eligible for Cash Discount in Document Currency		SKFBT	CURR	12
WSKTO	Cash Discount Amount in Document Currency		WSKTO	CURR	12
QBSHB	Withholding Tax Amount (in Document Currency)		QBSHB	CURR	12
PSWSL	Update Currency for General Ledger Transaction Figures		PSWSL	CUKY	10	*
PSWBT	Amount for Updating in General Ledger		PSWBT	CURR	12
PSSKT	Cash Discount Deduction for the Item		PSSKT	CURR	12
BLART	Document Type		BLART	CHAR	4	T003
BUDAT	Posting Date in the Document		BUDAT	DATS	16
BLDAT	Document Date in Document		BLDAT	DATS	16
KOART	Account type		KOART	CHAR	2
BSCHL	Posting Key		BSCHL	CHAR	4	TBSL
HKONT	General Ledger Account		HKONT	CHAR	20	SKB1
SAKNR	G/L Account Number		SAKNR	CHAR	20	SKB1
UMSKZ	Special G/L Indicator		UMSKZ	CHAR	2	T074U
GSBER	Business Area		GSBER	CHAR	8	TGSB
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	*
QSSKZ	Withholding Tax Code		QSSKZ	CHAR	4	*
SGTXT	Item Text		SGTXT	CHAR	100
XREBZ	Indicator: Item Is an Invoice-Related Credit Memo		XREBZ	CHAR	2
ESRNR	ISR subscriber number		ESRNR	CHAR	22
ESRRE	ISR/QR Reference Number		ESRRE	CHAR	54
ESRPZ	POR check digit		ESRPZ	CHAR	4
EBELN	Purchasing Document Number		EBELN	CHAR	20	EKKO
EBELP	Item Number of Purchasing Document		EBELP	NUMC	10	EKPO
STCEG	VAT Registration Number		STCEG	CHAR	40
XBLNR	Reference Document Number		XBLNR1	CHAR	32
LZBKZ	State Central Bank Indicator		LZBKZ	CHAR	6	T015L
LANDL	Supplying Country/Region		LANDL	CHAR	6	T005
NPLNR	Network Number for Account Assignment		NPLNR	CHAR	24	*
AUFPL	Routing number of operations in the order		CO_AUFPL	NUMC	20
VERTN	Contract Number		RANL	CHAR	26
REBZT	Follow-On Document Type		REBZT	CHAR	2
REBZG	Document No. of the Invoice to Which the Transaction Belongs		REBZG	CHAR	20
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)		REBZJ	NUMC	8
REBZZ	Line Item in the Relevant Invoice		REBZZ	NUMC	6
KOSTL	Cost Center		KOSTL	CHAR	20	*
VBEL2	Sales Document		VBELN_VA	CHAR	20
POSN2	Sales Document Item		POSNR_VA	NUMC	12
PRCTR	Profit Center		PRCTR	CHAR	20
XREF1	Business Partner Reference Key		XREF1	CHAR	24
XREF2	Business Partner Reference Key		XREF2	CHAR	24
XREF3	Reference key for line item		XREF3	CHAR	40
DTWS1	Instruction Key 1		DTAT16	NUMC	4	*
DTWS2	Instruction Key 2		DTAT17	NUMC	4	*
DTWS3	Instruction key 3		DTAT18	NUMC	4	*
DTWS4	Instruction key 4		DTAT19	NUMC	4	*
XCPDD	Indicator: Address and Bank Data Set Individually		XCPDD	CHAR	2
BUPLA	Business Place		BUPLA	CHAR	8	*
PPRCT	Partner Profit Center		PPRCTR	CHAR	20	*
GRANT_NBR	Grant		GM_GRANT_NBR	CHAR	40
FKBER	Functional Area		FKBER	CHAR	32	*
GEBER	Fund		BP_GEBER	CHAR	20	*
XINVE	Indicator: Capital Goods Affected?		XINVE	CHAR	2
KEYNO	Key Number for Payment Request		PRQ_KEYNO	CHAR	20	*
PAMTF	Payment Request Amount in Payment Currency		PRQ_AMTFC	CURR	12
ORIGIN	Origin Indicator		FIBL_ORIGIN	CHAR	16	*
.INCLU--AP				EPIC_FPRLS_ITEM_DATA	0
EPIC_PROCESSOR	Processor		EPIC_PROCESSOR	CHAR	24	*
EPIC_STATUS	Item Status		EPIC_ITEM_STATUS	CHAR	6
EPIC_EDITED	General Flag		FLAG	CHAR	2
.INCLU--AP				FMCCAVC_PRLS_ITEM_DATA	0
AVC_STATUS	Cash Control Status		FMCCAVC_STATUS	CHAR	2
AVC_PRIORITY	Cash Control Priority		FMCCAVC_PRIORITY	NUMC	12
.INCLU--AP				FMPRLS_ES_ITEM_DATA	0
FIPOS_ES	Commitment Item		FIPOS	CHAR	28	*
FISTL_ES	Funds Center		FISTL	CHAR	32	*
GRANT_NBR_ES	Grant		GM_GRANT_NBR	CHAR	40
FKBER_ES	Functional Area		FKBER	CHAR	32	*
GEBER_ES	Fund		BP_GEBER	CHAR	20	*
PROJK_ES	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	*
CISUB1_ES	Substring 1 of Commitment Item		FM_CISUB1	CHAR	20
CISUB2_ES	Substring 2 of Commitment Item		FM_CISUB2	CHAR	20
CISUB3_ES	Substring 3 of Commitment Item		FM_CISUB3	CHAR	20
CISUB4_ES	Substring 4 of Commitment Item		FM_CISUB4	CHAR	20
CISUB5_ES	Substring 5 of Commitment Item		FM_CISUB5	CHAR	20
LOTKZ_ES	Lot Number for Requests		PSO_LOTKZ	CHAR	20
.INCLU--AP				FPCLS_CO_ITEM_DATA	0
EBELN_CO	Purchasing Document Number		EBELN	CHAR	20
SAPLONGNUM	Smart Number		/SAPPSPRO/LONGNUM	CHAR	80
KBLNR	Document Number for Earmarked Funds		KBLNR	CHAR	20	*
ACCOUNTANT	Accountant		FPCR_ACCOUNTANT	CHAR	12
CO_STATUS	Status of Garnishment		FPCL_CO_STAT	NUMC	4
STCD2	Tax Number 2		STCD2	CHAR	22
.INCLUDE				FPRLS_EXCEPTION_DATA	0
POKEN	Item Indicator		POKEN	CHAR	6
.INCLUDE				FPRLS_PAYMENT_DATA	0
LAUFD_PAY	Date on Which the Program Is to Be Run		LAUFD	DATS	16
LAUFI_PAY	Additional Identification		LAUFI	CHAR	12
VBLNR_PAY	Document Number of the Payment Document		VBLNR	CHAR	20
PYORD_PAY	Payment Order		PYORD	CHAR	20
XF110_EXEC	General Flag		FLAG	CHAR	2
LAUFD	Date of Proposal Run		FPRL_LAUFD	DATS	16
LAUFI	Payment Proposal		FPRL_LAUFI	CHAR	12
KURST	Alternative Ex.Rate Type for Payments in Foreign Currency		KURST_REGU	CHAR	8	*
JOBCOUNT	Job ID		BTCJOBCNT	CHAR	16
ABSBU	Sending company code		ABSBU	CHAR	8	*
NAME1	Name 1		NAME1_GP	CHAR	70
BKREF	Reference Details for Bank Details		BKREF	CHAR	40
KOINH	Account Holder Name		KOINH_FI	CHAR	120
HKTID	ID for Account Details		HKTID	CHAR	10	*
HBKID	Short Key for a House Bank		HBKID	CHAR	10	T012
UBNKS	Country/Region Key of Bank		BANKS	CHAR	6	*
UBNKY	Bank Key of Our Bank		UBNKY	CHAR	30
UBNKL	Bank number of our bank		UBNKL	CHAR	30
UBKNT	Our account number at the bank		UBKNT	CHAR	36
UBKON	Bank control key at our bank		UBKON	CHAR	4
UBHKT	G/L Account Number for Our Bank Account / Bank Subaccount		UBHKT	CHAR	20	*
RZAWE	Payment Method		DZLSCH	CHAR	2	T042Z
UZAWE	Payment method supplement		UZAWE	CHAR	4	T042F
DTAWS	Instruction Key for Data Medium Exchange		DTAWS	CHAR	4	*
VALUT	Value date		VALUT	DATS	16
AUSFD	Due date of the paid items		AUSFD	DATS	16
ANFAE	Bill of Exchange Payment Request Due Date		ANFAE	DATS	16
WEFAE	Bill of Exchange Due Date		WEFAE	DATS	16
WDATE	Bill of Exchange Issue Date		WDATE	DATS	16
BUSAB	Accounting Clerk Abbreviation		BUSAB	CHAR	4	*
EIKTO	Shipper's (Our) Account Number at the Customer or Vendor		EIKTO	CHAR	24
KIDNO	Payment Reference		KIDNO	CHAR	60
RFTTRN	Payment code		RFTTRN_BF	CHAR	40
BTYP1	Type of bank in a bank chain (correspondent, intermediary)		BNTYP	CHAR	2
BNKS1	Country/Region Key of Bank		BANKS	CHAR	6	*
BNKL1	Bank Keys		BANKK	CHAR	30
BNKN1	Bank account number		BANKN	CHAR	36
BTYP2	Type of bank in a bank chain (correspondent, intermediary)		BNTYP	CHAR	2
BNKS2	Country/Region Key of Bank		BANKS	CHAR	6	*
BNKL2	Bank Keys		BANKK	CHAR	30
BNKN2	Bank account number		BANKN	CHAR	36
BTYP3	Type of bank in a bank chain (correspondent, intermediary)		BNTYP	CHAR	2
BNKS3	Country/Region Key of Bank		BANKS	CHAR	6	*
BNKL3	Bank Keys		BANKK	CHAR	30
BNKN3	Bank account number		BANKN	CHAR	36
MGUID	SEPA Mandate: GUID of Mandate		SEPA_MGUID	RAW	16
MNDID	Unique Reference to Mandate for each Payee		SEPA_MNDID	CHAR	70
.INCLUDE				FPRLS_ITEM_DATA_INV	0
INV_NO	Document Number or Invoice Reference Number		FPRL_REBZG	CHAR	20
INV_YEAR	Fiscal Year of DocNo/Inf.ref.		FPRL_REBZJ	NUMC	8
INV_ITEM	Line Item within Accounting Document or Relevant Invoice		FPRL_REBZZ	NUMC	6
.INCLUDE				CI_FPRL_ITEM	0