SAP ABAP Table FPRLS_ITEM_DATA (Item Data)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-AP-AP-PT (Application Component) Payment Transactions
     ⤷ FIN_PRL (Package) Payment Release List

Basic Data

Table Category	INTTAB	Structure
Structure	FPRLS_ITEM_DATA	Table Relationship Diagram
Short Description	Item Data

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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
2	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
3	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
5	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
6	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
7	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
8	EMPFB	☐	EMPFB	MAXKK	CHAR	10	0	Payee/Payer
9	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
10	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
11	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
12	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
13	SKFBT	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
14	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
15	QBSHB	☐	QBSHB	WERT7	CURR	13	2	Withholding Tax Amount (in Document Currency)
16	PSWSL	☐	PSWSL	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	*
17	PSWBT	☐	PSWBT	WERT7	CURR	13	2	Amount for Updating in General Ledger
18	PSSKT	☐	PSSKT	WRTV7	CURR	13	2	Cash Discount Deduction for the Item
19	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
20	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
21	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
22	KOART	☐	KOART	KOART	CHAR	1	0	Account type
23	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
24	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKB1
25	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKB1
26	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	T074U
27	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
28	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
29	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
30	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
31	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
32	ZBD1T	☐	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
33	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
34	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
35	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
36	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
37	XREBZ	☐	XREBZ	XFELD	CHAR	1	0	Indicator: Item is an Invoice-Related Credit Memo
38	ESRNR	☐	ESRNR	ESRNR	CHAR	11	0	POR subscriber number
39	ESRRE	☐	ESRRE	ESRRE	CHAR	27	0	POR reference number
40	ESRPZ	☐	ESRPZ	CHAR2	CHAR	2	0	POR check digit
41	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
42	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
43	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
44	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
45	LZBKZ	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	T015L
46	LANDL	☐	LANDL	LAND1	CHAR	3	0	Supplying Country	T005
47	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
48	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
49	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
50	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
51	REBZT	☐	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
52	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
53	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
54	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
55	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
56	VBEL2	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
57	POSN2	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
58	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
59	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
60	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
61	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
62	DTWS1	☐	DTAT16	DTWSX	NUMC	2	0	Instruction key 1	*
63	DTWS2	☐	DTAT17	DTWSX	NUMC	2	0	Instruction key 2	*
64	DTWS3	☐	DTAT18	DTWSX	NUMC	2	0	Instruction key 3	*
65	DTWS4	☐	DTAT19	DTWSX	NUMC	2	0	Instruction key 4	*
66	XCPDD	☐	XCPDD	XFELD	CHAR	1	0	Indicator: Address and Bank Data Set Individually
67	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
68	PPRCT	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
69	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
70	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
71	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
72	XINVE	☐	XINVE	XFELD	CHAR	1	0	Indicator: Capital Goods Affected?
73	KEYNO	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	*
74	PAMTF	☐	PRQ_AMTFC	WERT7	CURR	13	2	Payment Request Amount in Payment Currency
75	ORIGIN	☐	FIBL_ORIGIN	FIBL_ORIGIN	CHAR	8	0	Origin Indicator	*
76	.INCLU--AP	☐				0	0	EPIC Append Structure for FPRLS_ITEM_DATA
77	EPIC_PROCESSOR	☐	EPIC_PROCESSOR	XUBNAME	CHAR	12	0	Processor	*
78	EPIC_STATUS	☐	EPIC_ITEM_STATUS	EPIC_ITEM_STATUS	CHAR	3	0	Item Status
79	.INCLU--AP	☐				0	0	Chorus Erweiterungen
80	EBELN_CO	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
81	SAPLONGNUM	☐	/SAPPSPRO/LONGNUM	/SAPPSPRO/LONGNUM	CHAR	40	0	Smart Number
82	KBLNR	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	*
83	ACCOUNTANT	☐	FPCR_ACCOUNTANT	FPCR_ACCOUNTANT	CHAR	6	0	Accountant
84	CO_STATUS	☐	FPCL_CO_STAT	FPCL_CO_STAT	NUMC	2	0	Status of Garnishment
85	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FPRLS_ITEM_DATA	BLART	T003	BLART	REF	1	CN
2	FPRLS_ITEM_DATA	BSCHL	TBSL	BSCHL	REF	1	CN
3	FPRLS_ITEM_DATA	BUKRS	T001	BUKRS	KEY	1	CN
4	FPRLS_ITEM_DATA	EBELN	EKKO	EBELN	REF	C	CN
5	FPRLS_ITEM_DATA	EBELP	EKPO	EBELP	REF	C	CN
6	FPRLS_ITEM_DATA	GSBER	TGSB	GSBER	REF	C	CN
7	FPRLS_ITEM_DATA	HKONT	SKB1	SAKNR	REF	1	CN
8	FPRLS_ITEM_DATA	KUNNR	KNA1	KUNNR
9	FPRLS_ITEM_DATA	LANDL	T005	LAND1	REF	C	CN
10	FPRLS_ITEM_DATA	LIFNR	LFA1	LIFNR	KEY	1	CN
11	FPRLS_ITEM_DATA	LZBKZ	T015L	LZBKZ	REF	C	CN
12	FPRLS_ITEM_DATA	SAKNR	SKB1	SAKNR	REF	C	CN
13	FPRLS_ITEM_DATA	UMSKZ	T074U	UMSKZ	REF	C	CN
14	FPRLS_ITEM_DATA	VBUND	T880	RCOMP	REF	C	CN
15	FPRLS_ITEM_DATA	WAERS	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in	700