In this post, I will try and describe everything you need to know about the SAP v002icbankreturn table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for V002ICBANKRETURN what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from V002ICBANKRETURN....Right lets get started!
Object Name: V002ICBANKRETURN
Dictionary Type: Structure
Description: V002 IC Process Information Bank Return
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| FKKRH | DFKKRH | STRU | 0(0) | |||||||||
| MANDT | MANDT | CLNT | 3(0) | Client | MANDT | TEST | ||||||
| GPART | GPART_KK | CHAR | 10(0) | Business Partner Number | BU_PARTNER | BPA | ||||||
| VKONT | VKONT_KK | CHAR | 12(0) | Contract Account Number | VKONT_KK | KTO | FKKVKP_F4 | VKONT | ||||
| RLBEL | RLBEL_KK | CHAR | 12(0) | Number of the return document | OPBEL_KK | |||||||
| KEYR1 | KEYR1_KK | CHAR | 12(0) | Returns Lot | KEYR1_KK | 8RS | ||||||
| POSRA | POSRA_KK | NUMC | 6(0) | Item number in a returns lot | NUM06 | |||||||
| OPBEL | OPBEL_KK | CHAR | 12(0) | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | 80B | FB | |||||
| URBEL | URBEL_KK | CHAR | 12(0) | Document Number of Receivables Document | OPBEL_KK | |||||||
| BETRWR | BETRWR_KK | CURR | 13(2) | Partial Amount Of Return | WRTV7 | |||||||
| BETRR | BETRR_KK | CURR | 13(2) | Return amount | WRTV7 | |||||||
| BTRB1 | BTRB1_KK | CURR | 13(2) | Charge amount from bank 1 | WRTV7 | |||||||
| BTRB2 | BTRB2_KK | CURR | 13(2) | Charge amount from bank 2 | WRTV7 | |||||||
| STBB1 | STBB1_KK | CURR | 13(2) | Tax Amount: Bank Charge 1 | WRTV7 | |||||||
| STBB2 | STBB2_KK | CURR | 13(2) | Tax amount: Bank charge 2 | WRTV7 | |||||||
| BTRV1 | BTRV1_KK | CURR | 13(2) | Returns Charge 1 | WRTV7 | |||||||
| BTRV2 | BTRV2_KK | CURR | 13(2) | Return charge 2 | WRTV7 | |||||||
| STBV1 | STBV1_KK | CURR | 13(2) | Tax amount: Return charges 1 | WRTV7 | |||||||
| STBV2 | STBV2_KK | CURR | 13(2) | Tax amount: Return charges 2 | WRTV7 | |||||||
| WAERS | WAERS | CUKY | 5(0) | Currency Key | WAERS | FWS | FB | |||||
| BUDAT | BUDAT_KK | DATS | 8(0) | Posting Date in the Document | DATUM | FB | ||||||
| BLDAT | BLDAT | DATS | 8(0) | Document Date in Document | DATUM | FB | ||||||
| VALUT | VALUT | DATS | 8(0) | Value date | DATUM | TEST | ||||||
| RLGRD | RLGRD_KK | CHAR | 3(0) | Return reason | RLGRD_KK | |||||||
| BANKL | GPBANKS | CHAR | 3(0) | Banking Country of Business Partner | CHAR3 | |||||||
| BANKK | GPBANKK | CHAR | 15(0) | Business Partner Bank Number | CHAR15 | |||||||
| BANKN | GPBANKN | CHAR | 18(0) | Account Number of Business Partner | CHAR18 | |||||||
| IBAN | IBAN | CHAR | 34(0) | IBAN (International Bank Account Number) | IBAN | |||||||
| CHECF | CHECF_KK | CHAR | 16(0) | Number of a returned check | CHECF_KK | |||||||
| NRZAS | NRZAS_KK | CHAR | 12(0) | Payment Form Number | NRZAS_KK | |||||||
| HBKID | HBKID | CHAR | 5(0) | Short Key for a House Bank | HBKID | FB | ||||||
| HKTID | HKTID | CHAR | 5(0) | ID for account details | HKTID | FB | ||||||
| RLMOD | RLMOD_KK | CHAR | 1(0) | Returns Posting Type | RLMOD_KK | |||||||
| STODT | STODT_KK | DATS | 8(0) | Reversal Document Posting Date | DATUM | |||||||
| STBLG | STBLG_KK | CHAR | 12(0) | Number of Reverse Document/Reset Document | OPBEL_KK | |||||||
| XSTOR | XSTOR_KK | CHAR | 1(0) | Document Has Been Reversed | XFELD | |||||||
| RLANZ | RLANZ_KK | NUMC | 2(0) | Number Of Returns That Occurred in The Observation Period | RLANZ_KK | |||||||
| BONIT | BONIT_KK | NUMC | 4(0) | Creditworthiness | BONIT_KK | |||||||
| TOGRU | TOGRU_KK | CHAR | 4(0) | Tolerance group for contract account | TOGRU_KK | FB | ||||||
| XGEBV | XGEBV_KK | CHAR | 1(0) | Pass On Bank Charges | XFELD | |||||||
| XGEBS | XGEBS_KK | CHAR | 1(0) | Calculate Graduated Charges | XFELD | |||||||
| XEZSP | XEZSP_KK | CHAR | 1(0) | Field is obsolete | XFELD | |||||||
| XEZSB | XEZSB_KK | CHAR | 1(0) | Field is obsolete | XFELD | |||||||
| XBVBL | XBVBL_KK | CHAR | 1(0) | Delete bank details | XFELD | |||||||
| STUNT | STUNT_KK | NUMC | 3(0) | Deferral days | STUNT_KK | |||||||
| STUDT | STUDT_KK | DATS | 8(0) | Deferral to | DATUM | |||||||
| MSPOP | MSPOP_KK | CHAR | 1(0) | Dunning Lock Reason for Line Item | MANSP_KK | |||||||
| MSPOP_DAYS | MSPOP_DAYS_KK | INT4 | 10(0) | Item dunning lock: days | INT4 | |||||||
| PSPOP | PSPOP_KK | CHAR | 1(0) | Payment lock reason for item | SPZAH_KK | |||||||
| PSPOP_DAYS | PSPOP_DAYS_KK | INT4 | 10(0) | Payment lock for incoming payments: Duration in days | INT4 | |||||||
| MSPKO | MSPKO_KK | CHAR | 1(0) | Dunning lock reason for contract account | MANSP_KK | |||||||
| MSPKO_DAYS | MSPKO_DAYS_KK | INT4 | 10(0) | Contract acct dunn. lock: days | INT4 | |||||||
| EZSKO | EZSKO_KK | CHAR | 1(0) | Reason for Lock on Incoming Payment for Contract Account | SPZAH_KK | |||||||
| EZSKO_DAYS | EZSKO_DAYS_KK | INT4 | 10(0) | Contract account incoming payment lock: Duration in days | INT4 | |||||||
| AZSKO | AZSKO_KK | CHAR | 1(0) | Reason for Outgoing Payment Lock for Contract Account | SPZAH_KK | |||||||
| AZSKO_DAYS | AZSKO_DAYS_KK | INT4 | 10(0) | Contract account outgoing payments lock: Duration in days | INT4 | |||||||
| EZAWE | EZAWE_KK | CHAR | 1(0) | Incoming Payment Method | CHAR1 | |||||||
| GEBST | GEBST_KK | CHAR | 1(0) | Post Charges Statistically | XFELD | |||||||
| XDELEZAWE | XDELEZAWE_KK | CHAR | 1(0) | Delete payment method with account instead of changing | XDELEZAWE_KK | |||||||
| XDELAZAWE | XDELAZAWE_KK | CHAR | 1(0) | Returns Activity: Delete Outgoing Payment Method in Account | XFELD | |||||||
| MACHG | MACHG_KK | CHAR | 1(0) | Activate Event for Changing Master Data | XFELD | |||||||
| BSNTE | BSNTE_KK | CHAR | 1(0) | Inform Specialist | XFELD | |||||||
| BCORR | BCORR_KK | CHAR | 1(0) | Activate Event for Creating Correspondence | XFELD | |||||||
| EZVTG | EZVTG_KK | CHAR | 1(0) | Incoming Payment Lock in Contract | SPZAH_KK | |||||||
| EZVTG_DAYS | EZVTG_DAYS_KK | INT4 | 10(0) | Incoming Payment Lock in Contract: Duration in Days | ||||||||
| AZVTG | AZVTG_KK | CHAR | 1(0) | Outgoing Payment Lock Reason for Contract | SPZAH_KK | |||||||
| AZVTG_DAYS | AZVTG_DAYS_KK | INT4 | 10(0) | Outgoing Payment Lock Contract: Duration in Days | ||||||||
| MSVTG | MSVTG_KK | CHAR | 1(0) | Dunning Lock Reason for Contract | MANSP_KK | |||||||
| MSVTG_DAYS | MSVTG_DAYS_KK | INT4 | 10(0) | Dunning Lock in Contract: Duration in Days | ||||||||
| XDELPZAWE | XDELPZAWE_KK | CHAR | 1(0) | Delete Payment Method in Item | XDELPZAWE_KK | |||||||
| XCORPZAWE | XCORPZAWE_KK | CHAR | 1(0) | Change Pymt Meth. in Item | XCORPZAWE_KK | |||||||
| VERSN | VERSN_KK | CHAR | 3(0) | Version Number | CHAR3 | |||||||
| INFCON | INFCON_KK | CHAR | 1(0) | Write Entry in Information Container | XFELD | |||||||
| SWIFT | SWIFT | CHAR | 11(0) | SWIFT/BIC for International Payments | SWIFT | FB |