RIP_DATA SAP (U.S. I.P.: Incoming Pymt Data from Manual Account Statement) Structure details
Description: U.S. I.P.: Incoming Pymt Data from Manual Account Statement
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 | ||||||||
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 |
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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects