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

Dictionary Type: Structure
Description: U.S. I.P.: Incoming Pymt Data from Manual Account Statement




ABAP Code to SELECT data from RIP_DATA
Related tables to RIP_DATA
Access table RIP_DATA




Structure field list including key, data, relationships and ABAP select examples

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. .

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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
FEBKO 0
MANDTClient MANDTCLNT3MANDT
ANWNDApplication using bank data storage ANWND_EBKOCHAR4ANWND_EBKO
ABSNDSending bank (electronic bank statement) ABSND_EBCHAR50CHAR50
AZIDTBank statement identification AZIDT_EBCHAR20CHAR20
EMKEYPayee Keys EMKEY_EBCHAR20CHAR20
KUKEYShort key (surrogate) KUKEY_EBNUMC8KUKEY_EB
ASTATStatement status ASTAT_EBCHAR1CHAR1
DSTATPrint status DSTAT_EBCHAR1CHAR1
VB1OKAll postings in area 1 are OK VB1OK_EBKOCHAR1CHAR1
VB2OKAll postings in area 2 are OK VB2OK_EBKOCHAR1CHAR1
KIPREAll items on header record were interpreted KIPRE_EBCHAR1CHAR1
VFDATData expiry date VFDAT_EBDATS8DATUM
GRP01Session name for bank postings GRP01_EBCHAR12CHAR12
XKEP1Keep session 1 after processing XKEP1_EBCHAR1CHAR1
GRP02Session name for subledger accounting GRP02_EBCHAR12CHAR12
XKEP2Keep session 2 after processing XKEP2_EBCHAR1CHAR1
WVDATFurther processing date WVDAT_EBDATS8DATUM
WVTIMFurther processing time WVTIM_EBTIMS6TIMES
WVARTFurther processing type WVART_EBCHAR1CHAR1
HKONTGeneral Ledger Account HKONTCHAR10ALPHASAKNR
KTONRBank account number BANKNCHAR18BANKN
KTOIHBank account holder KTOIH_EBCHAR35CHAR35
KTOSBSpecial account name KTOSB_EBCHAR35CHAR35
AZNUMStatement number AZNUM_EBNUMC5NUM5
AZSNRStatement page number AZSNR_EBNUMC3NUM3
AZDATStatement Date AZDAT_EBDATS8DATEXDATE_EB
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
KTOPLChart of Accounts KTOPLCHAR4KTOPLKPLC_KTOPL
WAERSCurrency Key WAERSCUKY5WAERSFWS
SSTYPBeginning balance type (F=begin balance, M=interim balance) SSTYP_EBCHAR1CHAR1
SSVOZStarting balance +/- sign SSVOZ_EBCHAR1CHAR1
SSBTROpening balance amount SSBTR_EBCURR17(2) WERT9
SUMSOTotal Debit SUMSO_EBCURR17(2) WERT9
SUMHATotal Credit SUMHA_EBCURR17(2) WERT9
ESTYPEnding balance type (F=ending balance, M=interim balance) ESTYP_EBCHAR1CHAR1
ESVOZClosing balance +/- sign ESVOZ_EBCHAR1CHAR1
ESBTREnding balance amount ESBTR_EBCURR17(2) WERT9
ESDMBEnding balance equivalent in local currency ESDMB_EBCURR17(2) WERT9
BLAUFLife start BLAUF_EBDATS8DATUM
ELAUFLife end ELAUF_EBDATS8DATUM
HZINSCredit interest HZINS_EBDEC9(3) HZINS_EB
TEILNCustomer/vendor EB number TEILN_EBCHAR20CHAR20
BKTOABank account type BKTOA_EBCHAR23CHAR23
ANZESNumber of memo records from the bank statement ANZES_EBNUMC5NUM5
VGTYPTransaction type VGTYP_EBCHAR8VGTYP_EB
EFARTInput Type EFART_EBCHAR1CHAR1
HBKIDShort Key for a House Bank HBKIDCHAR5HBKID
HKTIDID for account details HKTIDCHAR5HKTID
EUSERUser who fills the bank data buffer EUSER_EBCHAR12CHAR12
EDATEImport date into bank data puffer EDATE_EBDATS8DATUM
ETIMEImport time into bank data buffer ETIME_EBTIMS6UZEIT
BKREFReference specifications for bank details BKREFCHAR20CHAR20
XFDISX - cash management payment advice notes were created XFDIS_EBCHAR1XFELD
DSARTPlanning type DSARTCHAR2DSARTFFA
XVERDSummarize bank statement items FFDISXVERDCHAR1XFELD
XBENRReference Key AWKEYCHAR20AWKEY
XBTYPReference Transaction AWTYPCHAR5AWTYP
SEQ_NUMBERBank statement sequential number SEQ_NUMBERNUMC4SEQ_NUMBER
SEQ_STATUSSequence status SEQ_STATUSCHAR1SEQ_STATUS
INPUT_FORMATInput format INPUT_FORMATCHAR2INPUT_FORMAT
SIBANSender Bank Account: IBAN SIBAN_EBCHAR34IBAN
FEBEP 0
MANDTClient MANDTCLNT3MANDT
KUKEYShort key (surrogate) KUKEY_EBNUMC8KUKEY_EB
ESNUMMemo record number (line item number in bank statement) ESNUM_EBNUMC5NUM5
EPERLLine item completed EPERL_EBCHAR1CHAR1
VB1OKUpdate 1 OK VB1OK_EBCHAR1CHAR1
VB2BA2nd update processed VB2BA_EBCHAR1CHAR1
VB2OK2nd update OK VB2OK_EBCHAR1CHAR1
PIPRELine items were interpreted PIPRE_EBCHAR1CHAR1
GRPNRBundle number for grouping line items GRPNR_EBCHAR2CHAR2
ESTATError status ESTAT_EBCHAR4CHAR4
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BVDATPosting date at the bank BVDAT_EBDATS8DATEXDATE_EB
BUDATPosting date in the document BUDAT_EBDATS8DATEXDATE_EB
VALUTValue date of the item to be cleared VALUT_EBDATS8DATE_EB
BUTIMValue date time BUTIM_EBCHAR6TIME6
VOZEIdo not use-> now EPVOZ_EP signs (C,RC,D,RD) VOZEI_EBCHAR2CHAR2
KWAERAccount Currency Key KWAER_EBCUKY5WAERS
KWBTRAmount in account currency KWBTR_EBCURR13(2) WRTV7
SPESKFees in account currency SPESK_EBCURR13(2) WERT7
FWAERForeign currency key (unequal to account currency) FWAER_EBCUKY5WAERS
FWBTRForeign currency amount (different from account cuurency) FWBTR_EBCURR13(2) WRTV7
SPESFFees in foreign currency (not same as account currency) SPESF_EBCURR13(2) WERT7
VORGCBusiness transaction code VORGC_EBCHAR3CHAR3
TEXTSText key TEXTS_EBCHAR4CHAR4
VGEXTExternal business transaction VGEXT_EBCHAR27VGEXT_EB
VGMANTransaction VGMAN_EBCHAR4VGMAN_EB
VGINTPosting rule VGINT_EBCHAR4VGINT_EB
VGDEFPosting rule determined using standard value VGDEF_EBCHAR1BOOLE
KFMODAccount modification KFMOD_EBCHAR10KFMOD_EB
VGSAPSAP bank transaction VGSAP_EBCHAR4CHAR4
BUTXTBank posting text BUTXT_EBCHAR50CHAR50
ANZSPNumber of collective items ANZSP_EBNUMC5NUM5
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
ZUONRAssignment Number DZUONRCHAR18ZUONR
PABKSCountry key of partner bank PABKS_EBCHAR3LAND1
PABLZBank number of partner bank PABLZ_EBCHAR15BANKK
PASWISWIFT code of partner bank PASWI_EBCHAR11SWIFT
PAKTOAccount number at the partner bank PAKTO_EBCHAR18BANKN
PARTNBusiness Partner PARTN_EBCHAR55CHAR55
BUSABAccounting Clerk BUSAB_EBCHAR2CHAR2
KOSTLCost center KOSTL_EBCHAR10CHAR10
GSBERBusiness area GSBER_EBCHAR4CHAR4
PRCTRProfit Center PRCTRCHAR10ALPHAPRCTRPRCPRCTR_EMPTY
VERTNContract Number RANLCHAR13ALPHARANLRAN
VERTTContract Type RANTYPCHAR1RANTYP
PNOTADaybook number PNOTA_EBCHAR10CHAR10
CHECTCheck number CHECTCHAR13CHCKNCHK
STAVVFinancial Assets Management status STAVV_EBCHAR2CHAR2
TXTVVFinancial Assets Management Information Field TXTVV_EBCHAR40CHAR40
EPVOZDebit/credit key for line items (for bank purposes) EPVOZ_EBCHAR1CHAR1
INFO1Additional information 1 INFO1_EBCHAR30CHAR30
INFO2Additional information 2 INFO2_EBCHAR30CHAR30
AVSIDPayment Advice Number AVSIDCHAR16AVSIDAVN
INTAGInterpretation algorithm INTAG_EBNUMC3INTAG_EB
NBBLNSubledger document number NBBLN_EBCHAR10ALPHABELNR
AK1BLPayment on account document number AKBLN_EBCHAR10ALPHABELNR
AKBLNPayment on account document number AKBLN_EBCHAR10ALPHABELNR
KNRZAAccount number of an alternative payer KNRZACHAR10ALPHAKUNNR
AVKOAPayment Advice Account Type KOART_AVCHAR1KOART_AV
AVKONAccount Number KTONR_AVCHAR10ALPHAKTONR
BATCHBatch number (bundle number) BATCH_EBCHAR3CHAR3
ITMNRBatch Item Number for Lockbox ITMNR_FLBNUMC3NUM3
KURSFExchange rate (different from local currency) KURSF_EBDEC9(5) KURSF
SGTXTItem Text SGTXTCHAR50TEXT50
JPDATDate of failed bills of exchange in Japan JPDAT_EBDATS8DATEXDATE_EB
POSAGPosting algorithm (lockbox only) POSAG_EBCHAR3CHAR3
SDOC2Number of second subledger document SDOC2_EBCHAR10ALPHABELNR
VGREFBank Reference Number REFBKCHAR35CHAR35
XBENRReference Key AWKEYCHAR20AWKEY
XBTYPReference Transaction AWTYPCHAR5AWTYP
ARRSKOverdue charges from/to partners in account currency ARRSK_EBCURR13(2) WERT7
PFORMProcessing Type PFORM_EBNUMC2PFORM
KIDNOPayment Reference KIDNOCHAR30CHAR30
KKREFCustomer-to-customer reference REFNR_EBCHAR35CHAR35
KKRF2Customer-to-customer reference REFNR_EBCHAR35CHAR35
MANSPDunning block MANSPCHAR1MANSP
FNAM1BDC field name BDC_FNAMCHAR132DYNFNAM
FVAL1BDC field value BDC_FVALCHAR132F4CHAR132
FKOA1BDC-Account Type KOART_BDCCHAR1BDCFKOA
FNAM2BDC field name BDC_FNAMCHAR132DYNFNAM
FVAL2BDC field value BDC_FVALCHAR132F4CHAR132
FKOA2BDC-Account Type KOART_BDCCHAR1BDCFKOA
FNAM3BDC field name BDC_FNAMCHAR132DYNFNAM
FVAL3BDC field value BDC_FVALCHAR132F4CHAR132
FKOA3BDC-Account Type KOART_BDCCHAR1BDCFKOA
IDENRID number for cash management and forecast IDENRNUMC10IDENRFFI
B1APPApplication Indicator APPLK_BFCHAR6APPLK_BF
B1ERRError status ESTAT_EBCHAR4CHAR4
B1STDX - Standard (FI) posting should be suppressed ADDST_EBCHAR1XFELD
B1DOCDoc. no. (IDoc number, application document no., etc.) DOC_NUMBERCHAR70CHAR70
B1TYPReference Transaction AWTYPCHAR5AWTYP
B2APPApplication Indicator APPLK_BFCHAR6APPLK_BF
B2ERRError status ESTAT_EBCHAR4CHAR4
B2STDX - Standard (FI) posting should be suppressed ADDST_EBCHAR1XFELD
B2DOCDoc. no. (IDoc number, application document no., etc.) DOC_NUMBERCHAR70CHAR70
B2TYPReference Transaction AWTYPCHAR5AWTYP
PIBANPartner Bank Account: IBAN PIBAN_EBCHAR34IBAN
N2PCHNote to Payee Has Been Changed Manually FEB_N2PCHGINDCHAR1FEB_N2PCHGIND
SVBUKCompany Code BUKRSCHAR4BUKRSBUKC_T001
SVKOAPayment Advice Account Type KOART_AVCHAR1KOART_AV
SVKONAccount Number KTONR_AVCHAR10ALPHAKTONR
SVAVSPayment Advice Number AVSIDCHAR16AVSIDAVN
REPROIndicator: Process Enhancements for Reinterpretation REPRO_EBCHAR1FLAG
TRNIDTransaction ID EB_TRANSIDCHAR35
.INCLU--AP 0
TATYPTransaction FEB_BSPROC_TATYPCHAR4FEB_BSPROC_TATYP
X_FWBTR_CHGStatus of Changes Regarding Foreign Currency FEB_X_FWBTR_CHGCHAR1FEB_X_FWBTR_CHG
CURR_RATEExchange Rate: Foreign Currency to Account Currency FEB_CURR_RATEDEC9(5) EXCRTKURSF
.INCLU--AP 0
XREF1Business partner reference key XREF1CHAR12CHAR12
FIPEXCommitment Item FM_FIPEXCHAR24FM_FIPEXFPS
ERD 0
LOCAL_AMOUNT_GLAmount in document currency WRBTRCURR13(2) WERT7
LOCAL_AMOUNT_USAGEAmount in document currency WRBTRCURR13(2) WERT7
ZUONR 0
KUKEYShort key (surrogate) KUKEY_EBNUMC8KUKEY_EB
ESNUMMemo record number (line item number in bank statement) ESNUM_EBNUMC5NUM5
KWAERAccount Currency Key KWAER_EBCUKY5WAERS
IKOFI 0
ANWNDAccount Determination: Application ANWND_ADCHAR4ANWND_AD
EIGR1Account determination: Account determination key value WERTN_ADCHAR10WERTN_AD
EIGR2Account determination: Account determination key value WERTN_ADCHAR10WERTN_AD
EIGR3Account determination: Account determination key value WERTN_ADCHAR10WERTN_AD
EIGR4Account determination: Account determination key value WERTN_ADCHAR10WERTN_AD
KTOPLChart of Accounts KTOPLCHAR4KTOPLKPLC_KTOPL
KOMO1Account Determination: Modification for Acct Establishment KOMOK_ADCHAR10CHAR10
KOMO2Account Determination: Modification for Acct Establishment KOMOK_ADCHAR10CHAR10
SAKINAccount Determination: G/L Account To Be Replaced SAKNR_ADCHAR10ALPHASAKNR
BSCH1Posting Key BSCHLCHAR2BSCHL
KTOS1Account Determination: Account Symbols KTOSY_ADCHAR15KTOSY_AD
SHBK1Special G/L Indicator UMSKZCHAR1UMSKZ
KOMK1Account Determination: Indicator for Compression KOMKZ_ADCHAR1XFELD
SAKN1G/L Account Number SAKNRCHAR10ALPHASAKNRSAKC_SAKNR
BSCH2Posting Key BSCHLCHAR2BSCHL
KTOS2Account Determination: Account Symbols KTOSY_ADCHAR15KTOSY_AD
SHBK2Special G/L Indicator UMSKZCHAR1UMSKZ
KOMK2Account Determination: Indicator for Compression KOMKZ_ADCHAR1XFELD
SAKN2G/L Account Number SAKNRCHAR10ALPHASAKNRSAKC_SAKNR
FPARTAcct Determ.: Section of the Funct.Module To Be Carried Out FPART_ADCHAR1CHAR1
ATTR1Account Determination: Attribute Value ATTRN_ADCHAR10WERTN_AD
ATTR2Account Determination: Attribute Value ATTRN_ADCHAR10WERTN_AD
KOMO1BAccount Determination: Modification for Acct Establishment KOMOK_ADCHAR10CHAR10
KOMO2BAccount Determination: Modification for Acct Establishment KOMOK_ADCHAR10CHAR10
SAKINBAccount Determination: G/L Account To Be Replaced SAKNR_ADCHAR10ALPHASAKNR
STGRDReason for Reversal STGRDCHAR2STGRDFSG
BSCAKPosting key for posting on account BSCHL_AKCHAR2BSCHL

Key field Non-key field



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).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!