SAP ABAP Table RIP_DATA (U.S. I.P.: Incoming Pymt Data from Manual Account Statement)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML-AC-RPM (Application Component) Receivables/Payment Management
     ⤷ FVVD_PAYMENT_US (Package) US Specific Payment Processing for Loans

Basic Data

Table Category	INTTAB	Structure
Structure	RIP_DATA	Table Relationship Diagram
Short Description	U.S. I.P.: Incoming Pymt Data from Manual Account Statement

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	FEBKO	☐	FEBKO		STRU	0	0
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
3	ANWND	☐	ANWND_EBKO	ANWND_EBKO	CHAR	4	0	Application using bank data storage
4	ABSND	☐	ABSND_EB	CHAR50	CHAR	50	0	Sending bank (electronic bank statement)
5	AZIDT	☐	AZIDT_EB	CHAR20	CHAR	20	0	Bank statement identification
6	EMKEY	☐	EMKEY_EB	CHAR20	CHAR	20	0	Payee Keys
7	KUKEY	☐	KUKEY_EB	KUKEY_EB	NUMC	8	0	Short key (surrogate)
8	ASTAT	☐	ASTAT_EB	CHAR1	CHAR	1	0	Statement status
9	DSTAT	☐	DSTAT_EB	CHAR1	CHAR	1	0	Print status
10	VB1OK	☐	VB1OK_EBKO	CHAR1	CHAR	1	0	All postings in area 1 are OK
11	VB2OK	☐	VB2OK_EBKO	CHAR1	CHAR	1	0	All postings in area 2 are OK
12	KIPRE	☐	KIPRE_EB	CHAR1	CHAR	1	0	All items on header record were interpreted
13	VFDAT	☐	VFDAT_EB	DATUM	DATS	8	0	Data expiry date
14	GRP01	☐	GRP01_EB	CHAR12	CHAR	12	0	Session name for bank postings
15	XKEP1	☐	XKEP1_EB	CHAR1	CHAR	1	0	Keep session 1 after processing
16	GRP02	☐	GRP02_EB	CHAR12	CHAR	12	0	Session name for subledger accounting
17	XKEP2	☐	XKEP2_EB	CHAR1	CHAR	1	0	Keep session 2 after processing
18	WVDAT	☐	WVDAT_EB	DATUM	DATS	8	0	Further processing date
19	WVTIM	☐	WVTIM_EB	TIMES	TIMS	6	0	Further processing time
20	WVART	☐	WVART_EB	CHAR1	CHAR	1	0	Further processing type
21	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account
22	KTONR	☐	BANKN	BANKN	CHAR	18	0	Bank account number
23	KTOIH	☐	KTOIH_EB	CHAR35	CHAR	35	0	Bank account holder
24	KTOSB	☐	KTOSB_EB	CHAR35	CHAR	35	0	Special account name
25	AZNUM	☐	AZNUM_EB	NUM5	NUMC	5	0	Statement number
26	AZSNR	☐	AZSNR_EB	NUM3	NUMC	3	0	Statement page number
27	AZDAT	☐	AZDAT_EB	DATE_EB	DATS	8	0	Statement Date
28	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code
29	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts
30	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key
31	SSTYP	☐	SSTYP_EB	CHAR1	CHAR	1	0	Beginning balance type (F=begin balance, M=interim balance)
32	SSVOZ	☐	SSVOZ_EB	CHAR1	CHAR	1	0	Starting balance +/- sign
33	SSBTR	☐	SSBTR_EB	WERT9	CURR	17	2	Opening balance amount
34	SUMSO	☐	SUMSO_EB	WERT9	CURR	17	2	Total Debit
35	SUMHA	☐	SUMHA_EB	WERT9	CURR	17	2	Total Credit
36	ESTYP	☐	ESTYP_EB	CHAR1	CHAR	1	0	Ending balance type (F=ending balance, M=interim balance)
37	ESVOZ	☐	ESVOZ_EB	CHAR1	CHAR	1	0	Closing balance +/- sign
38	ESBTR	☐	ESBTR_EB	WERT9	CURR	17	2	Ending balance amount
39	ESDMB	☐	ESDMB_EB	WERT9	CURR	17	2	Ending balance equivalent in local currency
40	BLAUF	☐	BLAUF_EB	DATUM	DATS	8	0	Life start
41	ELAUF	☐	ELAUF_EB	DATUM	DATS	8	0	Life end
42	HZINS	☐	HZINS_EB	HZINS_EB	DEC	9	3	Credit interest
43	TEILN	☐	TEILN_EB	CHAR20	CHAR	20	0	Customer/vendor EB number
44	BKTOA	☐	BKTOA_EB	CHAR23	CHAR	23	0	Bank account type
45	ANZES	☐	ANZES_EB	NUM5	NUMC	5	0	Number of memo records from the bank statement
46	VGTYP	☐	VGTYP_EB	VGTYP_EB	CHAR	8	0	Transaction type
47	EFART	☐	EFART_EB	CHAR1	CHAR	1	0	Input Type
48	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank
49	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details
50	EUSER	☐	EUSER_EB	CHAR12	CHAR	12	0	User who fills the bank data buffer
51	EDATE	☐	EDATE_EB	DATUM	DATS	8	0	Import date into bank data puffer
52	ETIME	☐	ETIME_EB	UZEIT	TIMS	6	0	Import time into bank data buffer
53	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
54	XFDIS	☐	XFDIS_EB	XFELD	CHAR	1	0	X - cash management payment advice notes were created
55	DSART	☐	DSART	DSART	CHAR	2	0	Planning type
56	XVERD	☐	FFDISXVERD	XFELD	CHAR	1	0	Summarize bank statement items
57	XBENR	☐	AWKEY	AWKEY	CHAR	20	0	Object key
58	XBTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure
59	SEQ_NUMBER	☐	SEQ_NUMBER	SEQ_NUMBER	NUMC	4	0	Bank statement sequential number
60	SEQ_STATUS	☐	SEQ_STATUS	SEQ_STATUS	CHAR	1	0	Sequence status
61	INPUT_FORMAT	☐	INPUT_FORMAT	INPUT_FORMAT	CHAR	2	0	Input format
62	SIBAN	☐	SIBAN_EB	IBAN	CHAR	34	0	Sender Bank Account: IBAN
63	FEBEP	☐	FEBEP		STRU	0	0
64	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
65	KUKEY	☐	KUKEY_EB	KUKEY_EB	NUMC	8	0	Short key (surrogate)
66	ESNUM	☐	ESNUM_EB	NUM5	NUMC	5	0	Memo record number (line item number in bank statement)
67	EPERL	☐	EPERL_EB	CHAR1	CHAR	1	0	Line item completed
68	VB1OK	☐	VB1OK_EB	CHAR1	CHAR	1	0	Update 1 OK
69	VB2BA	☐	VB2BA_EB	CHAR1	CHAR	1	0	2nd update processed
70	VB2OK	☐	VB2OK_EB	CHAR1	CHAR	1	0	2nd update OK
71	PIPRE	☐	PIPRE_EB	CHAR1	CHAR	1	0	Line items were interpreted
72	GRPNR	☐	GRPNR_EB	CHAR2	CHAR	2	0	Bundle number for grouping line items
73	ESTAT	☐	ESTAT_EB	CHAR4	CHAR	4	0	Error status
74	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
75	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
76	BVDAT	☐	BVDAT_EB	DATE_EB	DATS	8	0	Posting date at the bank
77	BUDAT	☐	BUDAT_EB	DATE_EB	DATS	8	0	Posting date in the document
78	VALUT	☐	VALUT_EB	DATE_EB	DATS	8	0	Value date of the item to be cleared
79	BUTIM	☐	BUTIM_EB	TIME6	CHAR	6	0	Value date time
80	VOZEI	☐	VOZEI_EB	CHAR2	CHAR	2	0	do not use-> now EPVOZ_EP signs (C,RC,D,RD)
81	KWAER	☐	KWAER_EB	WAERS	CUKY	5	0	Account Currency Key
82	KWBTR	☐	KWBTR_EB	WRTV7	CURR	13	2	Amount in account currency
83	SPESK	☐	SPESK_EB	WERT7	CURR	13	2	Fees in account currency
84	FWAER	☐	FWAER_EB	WAERS	CUKY	5	0	Foreign currency key (unequal to account currency)
85	FWBTR	☐	FWBTR_EB	WRTV7	CURR	13	2	Foreign currency amount (different from account cuurency)
86	SPESF	☐	SPESF_EB	WERT7	CURR	13	2	Fees in foreign currency (not same as account currency)
87	VORGC	☐	VORGC_EB	CHAR3	CHAR	3	0	Business transaction code
88	TEXTS	☐	TEXTS_EB	CHAR4	CHAR	4	0	Text key
89	VGEXT	☐	VGEXT_EB	VGEXT_EB	CHAR	27	0	External business transaction
90	VGMAN	☐	VGMAN_EB	VGMAN_EB	CHAR	4	0	Transaction
91	VGINT	☐	VGINT_EB	VGINT_EB	CHAR	4	0	Posting rule
92	VGDEF	☐	VGDEF_EB	BOOLE	CHAR	1	0	Posting rule determined using standard value
93	KFMOD	☐	KFMOD_EB	KFMOD_EB	CHAR	10	0	Account modification
94	VGSAP	☐	VGSAP_EB	CHAR4	CHAR	4	0	SAP bank transaction
95	BUTXT	☐	BUTXT_EB	CHAR50	CHAR	50	0	Bank posting text
96	ANZSP	☐	ANZSP_EB	NUM5	NUMC	5	0	Number of collective items
97	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
98	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
99	PABKS	☐	PABKS_EB	LAND1	CHAR	3	0	Country key of partner bank
100	PABLZ	☐	PABLZ_EB	BANKK	CHAR	15	0	Bank number of partner bank
101	PASWI	☐	PASWI_EB	SWIFT	CHAR	11	0	SWIFT code of partner bank
102	PAKTO	☐	PAKTO_EB	BANKN	CHAR	18	0	Account number at the partner bank
103	PARTN	☐	PARTN_EB	CHAR55	CHAR	55	0	Business Partner
104	BUSAB	☐	BUSAB_EB	CHAR2	CHAR	2	0	Accounting Clerk
105	KOSTL	☐	KOSTL_EB	CHAR10	CHAR	10	0	Cost center
106	GSBER	☐	GSBER_EB	CHAR4	CHAR	4	0	Business area
107	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
108	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
109	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
110	PNOTA	☐	PNOTA_EB	CHAR10	CHAR	10	0	Daybook number
111	CHECT	☐	CHECT	CHCKN	CHAR	13	0	Check number
112	STAVV	☐	STAVV_EB	CHAR2	CHAR	2	0	Financial Assets Management status
113	TXTVV	☐	TXTVV_EB	CHAR40	CHAR	40	0	Financial Assets Management Information Field
114	EPVOZ	☐	EPVOZ_EB	CHAR1	CHAR	1	0	Debit/credit key for line items (for bank purposes)
115	INFO1	☐	INFO1_EB	CHAR30	CHAR	30	0	Additional information 1
116	INFO2	☐	INFO2_EB	CHAR30	CHAR	30	0	Additional information 2
117	AVSID	☐	AVSID	AVSID	CHAR	16	0	Payment Advice Number
118	INTAG	☐	INTAG_EB	INTAG_EB	NUMC	3	0	Interpretation algorithm
119	NBBLN	☐	NBBLN_EB	BELNR	CHAR	10	0	Subledger document number
120	AK1BL	☐	AKBLN_EB	BELNR	CHAR	10	0	Payment on account document number
121	AKBLN	☐	AKBLN_EB	BELNR	CHAR	10	0	Payment on account document number
122	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer
123	AVKOA	☐	KOART_AV	KOART_AV	CHAR	1	0	Payment Advice Account Type
124	AVKON	☐	KTONR_AV	KTONR	CHAR	10	0	Account Number
125	BATCH	☐	BATCH_EB	CHAR3	CHAR	3	0	Batch number (bundle number)
126	ITMNR	☐	ITMNR_FLB	NUM3	NUMC	3	0	Batch Item Number for Lockbox
127	KURSF	☐	KURSF_EB	KURSF	DEC	9	5	Exchange rate (different from local currency)
128	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
129	JPDAT	☐	JPDAT_EB	DATE_EB	DATS	8	0	Date of failed bills of exchange in Japan
130	POSAG	☐	POSAG_EB	CHAR3	CHAR	3	0	Posting algorithm (lockbox only)
131	SDOC2	☐	SDOC2_EB	BELNR	CHAR	10	0	Number of second subledger document
132	VGREF	☐	REFBK	CHAR35	CHAR	35	0	Bank Reference Number
133	XBENR	☐	AWKEY	AWKEY	CHAR	20	0	Object key
134	XBTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure
135	ARRSK	☐	ARRSK_EB	WERT7	CURR	13	2	Overdue charges from/to partners in account currency
136	PFORM	☐	PFORM_EB	PFORM	NUMC	2	0	Processing Type
137	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
138	KKREF	☐	REFNR_EB	CHAR35	CHAR	35	0	Customer-to-customer reference
139	KKRF2	☐	REFNR_EB	CHAR35	CHAR	35	0	Customer-to-customer reference
140	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block
141	FNAM1	☐	BDC_FNAM	DYNFNAM	CHAR	132	0	BDC field name
142	FVAL1	☐	BDC_FVAL	F4CHAR132	CHAR	132	0	BDC field value
143	FKOA1	☐	KOART_BDC	BDCFKOA	CHAR	1	0	BDC-Account Type
144	FNAM2	☐	BDC_FNAM	DYNFNAM	CHAR	132	0	BDC field name
145	FVAL2	☐	BDC_FVAL	F4CHAR132	CHAR	132	0	BDC field value
146	FKOA2	☐	KOART_BDC	BDCFKOA	CHAR	1	0	BDC-Account Type
147	FNAM3	☐	BDC_FNAM	DYNFNAM	CHAR	132	0	BDC field name
148	FVAL3	☐	BDC_FVAL	F4CHAR132	CHAR	132	0	BDC field value
149	FKOA3	☐	KOART_BDC	BDCFKOA	CHAR	1	0	BDC-Account Type
150	IDENR	☐	IDENR	IDENR	NUMC	10	0	ID number for cash management and forecast
151	B1APP	☐	APPLK_BF	APPLK_BF	CHAR	6	0	Application Indicator
152	B1ERR	☐	ESTAT_EB	CHAR4	CHAR	4	0	Error status
153	B1STD	☐	ADDST_EB	XFELD	CHAR	1	0	X - Standard (FI) posting should be suppressed
154	B1DOC	☐	DOC_NUMBER	CHAR70	CHAR	70	0	Doc. no. (IDoc number, application document no., etc.)
155	B1TYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure
156	B2APP	☐	APPLK_BF	APPLK_BF	CHAR	6	0	Application Indicator
157	B2ERR	☐	ESTAT_EB	CHAR4	CHAR	4	0	Error status
158	B2STD	☐	ADDST_EB	XFELD	CHAR	1	0	X - Standard (FI) posting should be suppressed
159	B2DOC	☐	DOC_NUMBER	CHAR70	CHAR	70	0	Doc. no. (IDoc number, application document no., etc.)
160	B2TYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure
161	PIBAN	☐	PIBAN_EB	IBAN	CHAR	34	0	Partner Bank Account: IBAN
162	N2PCH	☐	FEB_N2PCHGIND	FEB_N2PCHGIND	CHAR	1	0	Note to Payee Has Been Changed Manually
163	SVBUK	☐	BUKRS	BUKRS	CHAR	4	0	Company Code
164	SVKOA	☐	KOART_AV	KOART_AV	CHAR	1	0	Payment Advice Account Type
165	SVKON	☐	KTONR_AV	KTONR	CHAR	10	0	Account Number
166	SVAVS	☐	AVSID	AVSID	CHAR	16	0	Payment Advice Number
167	REPRO	☐	REPRO_EB	FLAG	CHAR	1	0	Indicator: Process Enhancements for Reinterpretation
168	TRNID	☐	EB_TRANSID		CHAR	35	0	Transaction ID
169	.INCLU--AP	☐				0	0	Enhancement for FEB_BSPROC
170	TATYP	☐	FEB_BSPROC_TATYP	FEB_BSPROC_TATYP	CHAR	4	0	Transaction
171	X_FWBTR_CHG	☐	FEB_X_FWBTR_CHG	FEB_X_FWBTR_CHG	CHAR	1	0	Status of Changes Regarding Foreign Currency
172	CURR_RATE	☐	FEB_CURR_RATE	KURSF	DEC	9	5	Exchange Rate: Foreign Currency to Account Currency
173	.INCLU--AP	☐				0	0	IS-PS: Additional Data on Line Items on Electr. Statement
174	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
175	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item
176	ERD	☐	RIP_ERD		STRU	0	0
177	LOCAL_AMOUNT_GL	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
178	LOCAL_AMOUNT_USAGE	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
179	ZUONR	☐	RIP_ZUONR		STRU	0	0
180	KUKEY	☐	KUKEY_EB	KUKEY_EB	NUMC	8	0	Short key (surrogate)
181	ESNUM	☐	ESNUM_EB	NUM5	NUMC	5	0	Memo record number (line item number in bank statement)
182	KWAER	☐	KWAER_EB	WAERS	CUKY	5	0	Account Currency Key
183	IKOFI	☐	IKOFI		STRU	0	0
184	ANWND	☐	ANWND_AD	ANWND_AD	CHAR	4	0	Account Determination: Application
185	EIGR1	☐	WERTN_AD	WERTN_AD	CHAR	10	0	Account determination: Account determination key value
186	EIGR2	☐	WERTN_AD	WERTN_AD	CHAR	10	0	Account determination: Account determination key value
187	EIGR3	☐	WERTN_AD	WERTN_AD	CHAR	10	0	Account determination: Account determination key value
188	EIGR4	☐	WERTN_AD	WERTN_AD	CHAR	10	0	Account determination: Account determination key value
189	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts
190	KOMO1	☐	KOMOK_AD	CHAR10	CHAR	10	0	Account Determination: Modification for Acct Establishment
191	KOMO2	☐	KOMOK_AD	CHAR10	CHAR	10	0	Account Determination: Modification for Acct Establishment
192	SAKIN	☐	SAKNR_AD	SAKNR	CHAR	10	0	Account Determination: G/L Account To Be Replaced
193	BSCH1	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key
194	KTOS1	☐	KTOSY_AD	KTOSY_AD	CHAR	15	0	Account Determination: Account Symbols
195	SHBK1	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator
196	KOMK1	☐	KOMKZ_AD	XFELD	CHAR	1	0	Account Determination: Indicator for Compression
197	SAKN1	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number
198	BSCH2	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key
199	KTOS2	☐	KTOSY_AD	KTOSY_AD	CHAR	15	0	Account Determination: Account Symbols
200	SHBK2	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator
201	KOMK2	☐	KOMKZ_AD	XFELD	CHAR	1	0	Account Determination: Indicator for Compression
202	SAKN2	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number
203	FPART	☐	FPART_AD	CHAR1	CHAR	1	0	Acct Determ.: Section of the Funct.Module To Be Carried Out
204	ATTR1	☐	ATTRN_AD	WERTN_AD	CHAR	10	0	Account Determination: Attribute Value
205	ATTR2	☐	ATTRN_AD	WERTN_AD	CHAR	10	0	Account Determination: Attribute Value
206	KOMO1B	☐	KOMOK_AD	CHAR10	CHAR	10	0	Account Determination: Modification for Acct Establishment
207	KOMO2B	☐	KOMOK_AD	CHAR10	CHAR	10	0	Account Determination: Modification for Acct Establishment
208	SAKINB	☐	SAKNR_AD	SAKNR	CHAR	10	0	Account Determination: G/L Account To Be Replaced
209	STGRD	☐	STGRD	STGRD	CHAR	2	0	Reason for Reversal
210	BSCAK	☐	BSCHL_AK	BSCHL	CHAR	2	0	Posting key for posting on account

History

Last changed by/on	SAP	20130529
SAP Release Created in	500