SAP RIP_DATA U.S. I.P.: Incoming Pymt Data from Manual Account Statement Table data and field list

RIP_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "U.S. I.P.: Incoming Pymt Data from Manual Account Statement" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_RIP_DATA TYPE RIP_DATA.

The RIP_DATA table consists of various fields, each holding specific information or linking keys about U.S. I.P.: Incoming Pymt Data from Manual Account Statement data available in SAP. These include MANDT (Client), ANWND (Application using bank data storage), ABSND (Sending bank (electronic bank statement)), AZIDT (Bank statement identification)... 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. .

RIP_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP RIP_DATA structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the RIP_DATA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
FEBKO				0
MANDT	Client	MANDT	CLNT	3			MANDT
ANWND	Application using bank data storage	ANWND_EBKO	CHAR	4			ANWND_EBKO
ABSND	Sending bank (electronic bank statement)	ABSND_EB	CHAR	50			CHAR50
AZIDT	Bank statement identification	AZIDT_EB	CHAR	20			CHAR20
EMKEY	Payee Keys	EMKEY_EB	CHAR	20			CHAR20
KUKEY	Short key (surrogate)	KUKEY_EB	NUMC	8			KUKEY_EB
ASTAT	Statement status	ASTAT_EB	CHAR	1			CHAR1
DSTAT	Print status	DSTAT_EB	CHAR	1			CHAR1
VB1OK	All postings in area 1 are OK	VB1OK_EBKO	CHAR	1			CHAR1
VB2OK	All postings in area 2 are OK	VB2OK_EBKO	CHAR	1			CHAR1
KIPRE	All items on header record were interpreted	KIPRE_EB	CHAR	1			CHAR1
VFDAT	Data expiry date	VFDAT_EB	DATS	8			DATUM
GRP01	Session name for bank postings	GRP01_EB	CHAR	12			CHAR12
XKEP1	Keep session 1 after processing	XKEP1_EB	CHAR	1			CHAR1
GRP02	Session name for subledger accounting	GRP02_EB	CHAR	12			CHAR12
XKEP2	Keep session 2 after processing	XKEP2_EB	CHAR	1			CHAR1
WVDAT	Further processing date	WVDAT_EB	DATS	8			DATUM
WVTIM	Further processing time	WVTIM_EB	TIMS	6			TIMES
WVART	Further processing type	WVART_EB	CHAR	1			CHAR1
HKONT	General Ledger Account	HKONT	CHAR	10		ALPHA	SAKNR
KTONR	Bank account number	BANKN	CHAR	18			BANKN
KTOIH	Bank account holder	KTOIH_EB	CHAR	35			CHAR35
KTOSB	Special account name	KTOSB_EB	CHAR	35			CHAR35
AZNUM	Statement number	AZNUM_EB	NUMC	5			NUM5
AZSNR	Statement page number	AZSNR_EB	NUMC	3			NUM3
AZDAT	Statement Date	AZDAT_EB	DATS	8		DATEX	DATE_EB
BUKRS	Company Code	BUKRS	CHAR	4			BUKRS	BUK	C_T001
KTOPL	Chart of Accounts	KTOPL	CHAR	4			KTOPL	KPL	C_KTOPL
WAERS	Currency Key	WAERS	CUKY	5			WAERS	FWS
SSTYP	Beginning balance type (F=begin balance, M=interim balance)	SSTYP_EB	CHAR	1			CHAR1
SSVOZ	Starting balance +/- sign	SSVOZ_EB	CHAR	1			CHAR1
SSBTR	Opening balance amount	SSBTR_EB	CURR	17(2)			WERT9
SUMSO	Total Debit	SUMSO_EB	CURR	17(2)			WERT9
SUMHA	Total Credit	SUMHA_EB	CURR	17(2)			WERT9
ESTYP	Ending balance type (F=ending balance, M=interim balance)	ESTYP_EB	CHAR	1			CHAR1
ESVOZ	Closing balance +/- sign	ESVOZ_EB	CHAR	1			CHAR1
ESBTR	Ending balance amount	ESBTR_EB	CURR	17(2)			WERT9
ESDMB	Ending balance equivalent in local currency	ESDMB_EB	CURR	17(2)			WERT9
BLAUF	Life start	BLAUF_EB	DATS	8			DATUM
ELAUF	Life end	ELAUF_EB	DATS	8			DATUM
HZINS	Credit interest	HZINS_EB	DEC	9(3)			HZINS_EB
TEILN	Customer/vendor EB number	TEILN_EB	CHAR	20			CHAR20
BKTOA	Bank account type	BKTOA_EB	CHAR	23			CHAR23
ANZES	Number of memo records from the bank statement	ANZES_EB	NUMC	5			NUM5
VGTYP	Transaction type	VGTYP_EB	CHAR	8			VGTYP_EB
EFART	Input Type	EFART_EB	CHAR	1			CHAR1
HBKID	Short Key for a House Bank	HBKID	CHAR	5			HBKID
HKTID	ID for account details	HKTID	CHAR	5			HKTID
EUSER	User who fills the bank data buffer	EUSER_EB	CHAR	12			CHAR12
EDATE	Import date into bank data puffer	EDATE_EB	DATS	8			DATUM
ETIME	Import time into bank data buffer	ETIME_EB	TIMS	6			UZEIT
BKREF	Reference specifications for bank details	BKREF	CHAR	20			CHAR20
XFDIS	X - cash management payment advice notes were created	XFDIS_EB	CHAR	1			XFELD
DSART	Planning type	DSART	CHAR	2			DSART	FFA
XVERD	Summarize bank statement items	FFDISXVERD	CHAR	1			XFELD
XBENR	Reference Key	AWKEY	CHAR	20			AWKEY
XBTYP	Reference Transaction	AWTYP	CHAR	5			AWTYP
SEQ_NUMBER	Bank statement sequential number	SEQ_NUMBER	NUMC	4			SEQ_NUMBER
SEQ_STATUS	Sequence status	SEQ_STATUS	CHAR	1			SEQ_STATUS
INPUT_FORMAT	Input format	INPUT_FORMAT	CHAR	2			INPUT_FORMAT
SIBAN	Sender Bank Account: IBAN	SIBAN_EB	CHAR	34			IBAN
FEBEP				0
MANDT	Client	MANDT	CLNT	3			MANDT
KUKEY	Short key (surrogate)	KUKEY_EB	NUMC	8			KUKEY_EB
ESNUM	Memo record number (line item number in bank statement)	ESNUM_EB	NUMC	5			NUM5
EPERL	Line item completed	EPERL_EB	CHAR	1			CHAR1
VB1OK	Update 1 OK	VB1OK_EB	CHAR	1			CHAR1
VB2BA	2nd update processed	VB2BA_EB	CHAR	1			CHAR1
VB2OK	2nd update OK	VB2OK_EB	CHAR	1			CHAR1
PIPRE	Line items were interpreted	PIPRE_EB	CHAR	1			CHAR1
GRPNR	Bundle number for grouping line items	GRPNR_EB	CHAR	2			CHAR2
ESTAT	Error status	ESTAT_EB	CHAR	4			CHAR4
BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
BVDAT	Posting date at the bank	BVDAT_EB	DATS	8		DATEX	DATE_EB
BUDAT	Posting date in the document	BUDAT_EB	DATS	8		DATEX	DATE_EB
VALUT	Value date of the item to be cleared	VALUT_EB	DATS	8			DATE_EB
BUTIM	Value date time	BUTIM_EB	CHAR	6			TIME6
VOZEI	do not use-> now EPVOZ_EP signs (C,RC,D,RD)	VOZEI_EB	CHAR	2			CHAR2
KWAER	Account Currency Key	KWAER_EB	CUKY	5			WAERS
KWBTR	Amount in account currency	KWBTR_EB	CURR	13(2)			WRTV7
SPESK	Fees in account currency	SPESK_EB	CURR	13(2)			WERT7
FWAER	Foreign currency key (unequal to account currency)	FWAER_EB	CUKY	5			WAERS
FWBTR	Foreign currency amount (different from account cuurency)	FWBTR_EB	CURR	13(2)			WRTV7
SPESF	Fees in foreign currency (not same as account currency)	SPESF_EB	CURR	13(2)			WERT7
VORGC	Business transaction code	VORGC_EB	CHAR	3			CHAR3
TEXTS	Text key	TEXTS_EB	CHAR	4			CHAR4
VGEXT	External business transaction	VGEXT_EB	CHAR	27			VGEXT_EB
VGMAN	Transaction	VGMAN_EB	CHAR	4			VGMAN_EB
VGINT	Posting rule	VGINT_EB	CHAR	4			VGINT_EB
VGDEF	Posting rule determined using standard value	VGDEF_EB	CHAR	1			BOOLE
KFMOD	Account modification	KFMOD_EB	CHAR	10			KFMOD_EB
VGSAP	SAP bank transaction	VGSAP_EB	CHAR	4			CHAR4
BUTXT	Bank posting text	BUTXT_EB	CHAR	50			CHAR50
ANZSP	Number of collective items	ANZSP_EB	NUMC	5			NUM5
XBLNR	Reference Document Number	XBLNR1	CHAR	16			XBLNR1
ZUONR	Assignment Number	DZUONR	CHAR	18			ZUONR
PABKS	Country key of partner bank	PABKS_EB	CHAR	3			LAND1
PABLZ	Bank number of partner bank	PABLZ_EB	CHAR	15			BANKK
PASWI	SWIFT code of partner bank	PASWI_EB	CHAR	11			SWIFT
PAKTO	Account number at the partner bank	PAKTO_EB	CHAR	18			BANKN
PARTN	Business Partner	PARTN_EB	CHAR	55			CHAR55
BUSAB	Accounting Clerk	BUSAB_EB	CHAR	2			CHAR2
KOSTL	Cost center	KOSTL_EB	CHAR	10			CHAR10
GSBER	Business area	GSBER_EB	CHAR	4			CHAR4
PRCTR	Profit Center	PRCTR	CHAR	10		ALPHA	PRCTR	PRC	PRCTR_EMPTY
VERTN	Contract Number	RANL	CHAR	13		ALPHA	RANL	RAN
VERTT	Contract Type	RANTYP	CHAR	1			RANTYP
PNOTA	Daybook number	PNOTA_EB	CHAR	10			CHAR10
CHECT	Check number	CHECT	CHAR	13			CHCKN	CHK
STAVV	Financial Assets Management status	STAVV_EB	CHAR	2			CHAR2
TXTVV	Financial Assets Management Information Field	TXTVV_EB	CHAR	40			CHAR40
EPVOZ	Debit/credit key for line items (for bank purposes)	EPVOZ_EB	CHAR	1			CHAR1
INFO1	Additional information 1	INFO1_EB	CHAR	30			CHAR30
INFO2	Additional information 2	INFO2_EB	CHAR	30			CHAR30
AVSID	Payment Advice Number	AVSID	CHAR	16			AVSID	AVN
INTAG	Interpretation algorithm	INTAG_EB	NUMC	3			INTAG_EB
NBBLN	Subledger document number	NBBLN_EB	CHAR	10		ALPHA	BELNR
AK1BL	Payment on account document number	AKBLN_EB	CHAR	10		ALPHA	BELNR
AKBLN	Payment on account document number	AKBLN_EB	CHAR	10		ALPHA	BELNR
KNRZA	Account number of an alternative payer	KNRZA	CHAR	10		ALPHA	KUNNR
AVKOA	Payment Advice Account Type	KOART_AV	CHAR	1			KOART_AV
AVKON	Account Number	KTONR_AV	CHAR	10		ALPHA	KTONR
BATCH	Batch number (bundle number)	BATCH_EB	CHAR	3			CHAR3
ITMNR	Batch Item Number for Lockbox	ITMNR_FLB	NUMC	3			NUM3
KURSF	Exchange rate (different from local currency)	KURSF_EB	DEC	9(5)			KURSF
SGTXT	Item Text	SGTXT	CHAR	50			TEXT50
JPDAT	Date of failed bills of exchange in Japan	JPDAT_EB	DATS	8		DATEX	DATE_EB
POSAG	Posting algorithm (lockbox only)	POSAG_EB	CHAR	3			CHAR3
SDOC2	Number of second subledger document	SDOC2_EB	CHAR	10		ALPHA	BELNR
VGREF	Bank Reference Number	REFBK	CHAR	35			CHAR35
XBENR	Reference Key	AWKEY	CHAR	20			AWKEY
XBTYP	Reference Transaction	AWTYP	CHAR	5			AWTYP
ARRSK	Overdue charges from/to partners in account currency	ARRSK_EB	CURR	13(2)			WERT7
PFORM	Processing Type	PFORM_EB	NUMC	2			PFORM
KIDNO	Payment Reference	KIDNO	CHAR	30			CHAR30
KKREF	Customer-to-customer reference	REFNR_EB	CHAR	35			CHAR35
KKRF2	Customer-to-customer reference	REFNR_EB	CHAR	35			CHAR35
MANSP	Dunning block	MANSP	CHAR	1			MANSP
FNAM1	BDC field name	BDC_FNAM	CHAR	132			DYNFNAM
FVAL1	BDC field value	BDC_FVAL	CHAR	132			F4CHAR132
FKOA1	BDC-Account Type	KOART_BDC	CHAR	1			BDCFKOA
FNAM2	BDC field name	BDC_FNAM	CHAR	132			DYNFNAM
FVAL2	BDC field value	BDC_FVAL	CHAR	132			F4CHAR132
FKOA2	BDC-Account Type	KOART_BDC	CHAR	1			BDCFKOA
FNAM3	BDC field name	BDC_FNAM	CHAR	132			DYNFNAM
FVAL3	BDC field value	BDC_FVAL	CHAR	132			F4CHAR132
FKOA3	BDC-Account Type	KOART_BDC	CHAR	1			BDCFKOA
IDENR	ID number for cash management and forecast	IDENR	NUMC	10			IDENR	FFI
B1APP	Application Indicator	APPLK_BF	CHAR	6			APPLK_BF
B1ERR	Error status	ESTAT_EB	CHAR	4			CHAR4
B1STD	X - Standard (FI) posting should be suppressed	ADDST_EB	CHAR	1			XFELD
B1DOC	Doc. no. (IDoc number, application document no., etc.)	DOC_NUMBER	CHAR	70			CHAR70
B1TYP	Reference Transaction	AWTYP	CHAR	5			AWTYP
B2APP	Application Indicator	APPLK_BF	CHAR	6			APPLK_BF
B2ERR	Error status	ESTAT_EB	CHAR	4			CHAR4
B2STD	X - Standard (FI) posting should be suppressed	ADDST_EB	CHAR	1			XFELD
B2DOC	Doc. no. (IDoc number, application document no., etc.)	DOC_NUMBER	CHAR	70			CHAR70
B2TYP	Reference Transaction	AWTYP	CHAR	5			AWTYP
PIBAN	Partner Bank Account: IBAN	PIBAN_EB	CHAR	34			IBAN
N2PCH	Note to Payee Has Been Changed Manually	FEB_N2PCHGIND	CHAR	1			FEB_N2PCHGIND
SVBUK	Company Code	BUKRS	CHAR	4			BUKRS	BUK	C_T001
SVKOA	Payment Advice Account Type	KOART_AV	CHAR	1			KOART_AV
SVKON	Account Number	KTONR_AV	CHAR	10		ALPHA	KTONR
SVAVS	Payment Advice Number	AVSID	CHAR	16			AVSID	AVN
REPRO	Indicator: Process Enhancements for Reinterpretation	REPRO_EB	CHAR	1			FLAG
TRNID	Transaction ID	EB_TRANSID	CHAR	35
.INCLU--AP				0
TATYP	Transaction	FEB_BSPROC_TATYP	CHAR	4			FEB_BSPROC_TATYP
X_FWBTR_CHG	Status of Changes Regarding Foreign Currency	FEB_X_FWBTR_CHG	CHAR	1			FEB_X_FWBTR_CHG
CURR_RATE	Exchange Rate: Foreign Currency to Account Currency	FEB_CURR_RATE	DEC	9(5)		EXCRT	KURSF
.INCLU--AP				0
XREF1	Business partner reference key	XREF1	CHAR	12			CHAR12
FIPEX	Commitment Item	FM_FIPEX	CHAR	24			FM_FIPEX	FPS
ERD				0
LOCAL_AMOUNT_GL	Amount in document currency	WRBTR	CURR	13(2)			WERT7
LOCAL_AMOUNT_USAGE	Amount in document currency	WRBTR	CURR	13(2)			WERT7
ZUONR				0
KUKEY	Short key (surrogate)	KUKEY_EB	NUMC	8			KUKEY_EB
ESNUM	Memo record number (line item number in bank statement)	ESNUM_EB	NUMC	5			NUM5
KWAER	Account Currency Key	KWAER_EB	CUKY	5			WAERS
IKOFI				0
ANWND	Account Determination: Application	ANWND_AD	CHAR	4			ANWND_AD
EIGR1	Account determination: Account determination key value	WERTN_AD	CHAR	10			WERTN_AD
EIGR2	Account determination: Account determination key value	WERTN_AD	CHAR	10			WERTN_AD
EIGR3	Account determination: Account determination key value	WERTN_AD	CHAR	10			WERTN_AD
EIGR4	Account determination: Account determination key value	WERTN_AD	CHAR	10			WERTN_AD
KTOPL	Chart of Accounts	KTOPL	CHAR	4			KTOPL	KPL	C_KTOPL
KOMO1	Account Determination: Modification for Acct Establishment	KOMOK_AD	CHAR	10			CHAR10
KOMO2	Account Determination: Modification for Acct Establishment	KOMOK_AD	CHAR	10			CHAR10
SAKIN	Account Determination: G/L Account To Be Replaced	SAKNR_AD	CHAR	10		ALPHA	SAKNR
BSCH1	Posting Key	BSCHL	CHAR	2			BSCHL
KTOS1	Account Determination: Account Symbols	KTOSY_AD	CHAR	15			KTOSY_AD
SHBK1	Special G/L Indicator	UMSKZ	CHAR	1			UMSKZ
KOMK1	Account Determination: Indicator for Compression	KOMKZ_AD	CHAR	1			XFELD
SAKN1	G/L Account Number	SAKNR	CHAR	10		ALPHA	SAKNR	SAK	C_SAKNR
BSCH2	Posting Key	BSCHL	CHAR	2			BSCHL
KTOS2	Account Determination: Account Symbols	KTOSY_AD	CHAR	15			KTOSY_AD
SHBK2	Special G/L Indicator	UMSKZ	CHAR	1			UMSKZ
KOMK2	Account Determination: Indicator for Compression	KOMKZ_AD	CHAR	1			XFELD
SAKN2	G/L Account Number	SAKNR	CHAR	10		ALPHA	SAKNR	SAK	C_SAKNR
FPART	Acct Determ.: Section of the Funct.Module To Be Carried Out	FPART_AD	CHAR	1			CHAR1
ATTR1	Account Determination: Attribute Value	ATTRN_AD	CHAR	10			WERTN_AD
ATTR2	Account Determination: Attribute Value	ATTRN_AD	CHAR	10			WERTN_AD
KOMO1B	Account Determination: Modification for Acct Establishment	KOMOK_AD	CHAR	10			CHAR10
KOMO2B	Account Determination: Modification for Acct Establishment	KOMOK_AD	CHAR	10			CHAR10
SAKINB	Account Determination: G/L Account To Be Replaced	SAKNR_AD	CHAR	10		ALPHA	SAKNR
STGRD	Reason for Reversal	STGRD	CHAR	2			STGRD	FSG
BSCAK	Posting key for posting on account	BSCHL_AK	CHAR	2			BSCHL

Key field

Non-key field

< RIPW0 - Internal Table for Object List Editing/Serial Numbers RIP_ERD - U.S. Incoming Payment: Exchange Rate Difference >

How do I retrieve data from SAP structure RIP_DATA using ABAP code?

As RIP_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on RIP_DATA as there is no data to select.

How to access SAP table RIP_DATA

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

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