SAP ABAP Table FPS_ITEM (Sales)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-BL (Application Component) Bank Accounting
     ⤷ FIN_PAYSP (Package) Payment Service Provider Integration

Basic Data

Table Category	INTTAB	Structure
Structure	FPS_ITEM	Table Relationship Diagram
Short Description	Sales

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	BANK	☐			CHAR	12	0
2	KTONR	☐			CHAR	34	0
3	AZNUM	☐	AZNUM_EB	NUM5	NUMC	5	0	Statement number
4	VALUT	☐	VALUT_EB	DATE_EB	DATS	8	0	Value date of the item to be cleared
5	PRIMA	☐	PNOTA_EB	CHAR10	CHAR	10	0	Daybook number
6	VWZ01	☐	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
7	BUTXT	☐	BUTXT_EB	CHAR50	CHAR	50	0	Bank posting text
8	UZEIT	☐	BUTIM_EB	TIME6	CHAR	6	0	Value date time
9	TEXTS	☐	TEXTS_EB	CHAR4	CHAR	4	0	Text key
10	CHECT	☐	CHECT	CHCKN	CHAR	13	0	Check number
11	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
12	WRBTR	☐	KWBTR_EB	WRTV7	CURR	13	2	Amount in account currency
13	SPESK	☐	SPESK_EB	WERT7	CURR	13	2	Fees in account currency
14	BVDAT	☐	BVDAT_EB	DATE_EB	DATS	8	0	Posting date at the bank
15	ZINF1	☐	INFO1_EB	CHAR30	CHAR	30	0	Additional information 1
16	ZINF2	☐	INFO2_EB	CHAR30	CHAR	30	0	Additional information 2
17	VWZ02	☐	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
18	VWZ03	☐	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
19	VWZ04	☐	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
20	VWZ05	☐	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
21	VWZ06	☐	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
22	VWZ07	☐	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
23	VWZ08	☐	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
24	VWZ09	☐	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
25	VWZ10	☐	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
26	VWZ11	☐	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
27	VWZ12	☐	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
28	VWZ13	☐	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
29	VWZ14	☐	VWEZW_EB	CHAR65	CHAR	65	0	Payment Notes
30	PARTN	☐	PARTN_EB	CHAR55	CHAR	55	0	Business Partner
31	PABLZ	☐	PABLZ_EB	BANKK	CHAR	15	0	Bank number of partner bank
32	PAKTO	☐	PAKTO_EB	BANKN	CHAR	18	0	Account number at the partner bank
33	GCODE	☐	VGEXT_EB	VGEXT_EB	CHAR	27	0	External business transaction	*
34	FWAER	☐	FWAER_EB	WAERS	CUKY	5	0	Foreign currency key (unequal to account currency)	TCURC
35	FWBTR	☐	FWBTR_EB	WRTV7	CURR	13	2	Foreign currency amount (different from account cuurency)
36	SPESF	☐	SPESF_EB	WERT7	CURR	13	2	Fees in foreign currency (not same as account currency)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FPS_ITEM	FWAER	TCURC	WAERS

History

Last changed by/on	SAP	20110901
SAP Release Created in	605