In this post, I will try and describe everything you need to know about the SAP v001icdunning 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 V001ICDUNNING 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 V001ICDUNNING....Right lets get started!
Object Name: V001ICDUNNING
Dictionary Type: Structure
Description: V001 IC Process Information Dunning
Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
TFK047L | TFK047L | STRU | 0(0) | |||||||||
MANDT | MANDT | CLNT | 3(0) | Client | MANDT | TEST | ||||||
ACKEY | ACKEY_KK | CHAR | 4(0) | Activity | ACKEY_KK | |||||||
ACTYP | ACTYP_KK | CHAR | 2(0) | Activity Category | ACTYP_KK | |||||||
XUNIT | XUNIT_CM_KK | CHAR | 1(0) | Determine Collection Specialist | XFELD | |||||||
ACTFB | ACTFB_KK | CHAR | 30(0) | Function Module for Activity | FUNCNAME | |||||||
ACTFR | ACTFR_KK | CHAR | 30(0) | Application Form for Correspondence | FORMKEY | |||||||
DATEN | FKKACTIV | STRU | 0(0) | |||||||||
MANDT | MANDT | CLNT | 3(0) | Client | MANDT | TEST | ||||||
FKKMAZE | FKKMAZE_T | TTYP | 0(0) | |||||||||
FKKMAKT | FKKMAKT_T | TTYP | 0(0) | |||||||||
FKKOP | FKKOP_T | TTYP | 0(0) | |||||||||
FKKOPK | FKKOPK_T | TTYP | 0(0) | |||||||||
FIMSG | TY_FIMSG | TTYP | 0(0) | |||||||||
FKKMAKO | FKKMAKO | STRU | 0(0) | |||||||||
MANDT | MANDT | CLNT | 3(0) | Client | MANDT | TEST | ||||||
LAUFD | LAUFD_KK | DATS | 8(0) | Date ID | DATUM | |||||||
LAUFI | MLFID_KK | CHAR | 6(0) | Additional Identification Characteristic | LAUFI_KK | |||||||
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 | ||||
MAZAE | MAZAE_KK | NUMC | 6(0) | Counter for several dunning notices to a business partner | NUMC6 | |||||||
AUSDT | AUSDT_KK | DATS | 8(0) | Date of issue | DATUM | |||||||
MDRKD | MDRKD_KK | DATS | 8(0) | Execution Date of Dunning Notice | DATUM | |||||||
MAHNV | MAHNV_KK | CHAR | 2(0) | Dunning Procedure | MAHNV_KK | FKK_MAHNV | MAHNV | |||||
MGRUP | MGRUP_KK | CHAR | 2(0) | Grouping fur Dunning Notices | MGRUP_KK | |||||||
VKONTGRP | VKGRP_CM_KK | CHAR | 12(0) | Collection Management: Contract Account Group | CHAR12 | |||||||
VTREFGRP | VTGRP_CM_KK | CHAR | 20(0) | Collection Management: Contract Group | CHAR20 | |||||||
ITEMGRP | ITEMGRP_CM_KK | DEC | 15(0) | Closed Item Group for Dunning | TZNTSTMPS | |||||||
ITEMGRP_LAST | ITEMGRP_LAST_CM_KK | DEC | 15(0) | Item Group in Last Dunning Notice | TZNTSTMPS | |||||||
GRPFIELD | GRPFIELD_CM_KK | CHAR | 12(0) | Grouping Field for Dunning | CHAR012 | |||||||
GRPFIELD_LAST | GRPFIELD_LAST_CM_KK | CHAR | 12(0) | Grouping Field in Last Dunning Notice | CHAR012 | |||||||
STRAT | STRAT_CM_KK | CHAR | 2(0) | Collection Strategy | STRAT_CM_KK | |||||||
STEP | STEP_CM_KK | CHAR | 4(0) | Collection Step | STEP_CM_KK | |||||||
STEP_LAST | STEP_LAST_CM_KK | CHAR | 4(0) | Collection Step of Last Dunning | STEP_CM_KK | |||||||
STEP_REPLACED | STEP_REPL_CM_KK | CHAR | 4(0) | Replaced Collection Step (Capacity Restriction) | STEP_CM_KK | |||||||
STRAT_CHAMP | STRAT_CHAMP_CM_KK | CHAR | 2(0) | Champion Collection Strategy | STRAT_CM_KK | |||||||
TESTS | TESTS_CM_KK | CHAR | 10(0) | Collection Management: Test Series for Collection Strategies | TESTS_CM_KK | 80TS | ||||||
LIMITED | LIMITED_CM_KK | CHAR | 1(0) | Capacity for Dunning Activity Restricted | XFELD | |||||||
RELEA | RELEA_CM_KK | CHAR | 1(0) | Release Dunning | XFELD | |||||||
RELDATE | RELDATE_CM_KK | DATS | 8(0) | Latest Release Date | DATS | |||||||
RELGROUP | RELGROUP_CM_KK | CHAR | 4(0) | Release Group | CHAR04 | |||||||
NEXDT | NEXDT_CM_KK | DATS | 8(0) | Date of Next Dunning | DATUM | |||||||
OPBUK | OPBUK_KK | CHAR | 4(0) | Company Code Group | OPBUK_KK | OPBUK | OPBUK | |||||
STDBK | BUKRS | CHAR | 4(0) | Company Code | BUKRS | BUK | FB | C_T001 | BUKRS | |||
GSBER | GSBER | CHAR | 4(0) | Business Area | GSBER | GSB | FB | |||||
SPART | SPART | CHAR | 2(0) | Division | SPART | SPA | V | C_SPART | SPART | |||
VTREF | VTREF_KK | CHAR | 20(0) | Reference Specifications from Contract | VTREF_KK | VTZ | ||||||
SUBAP | SUBAP_KK | CHAR | 1(0) | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | 8SA | ||||||
VKNT1 | VKNT1_KK | CHAR | 12(0) | Leading Contract Account in Dunning | VKONT_KK | KTO | FKKVKP_F4 | VKONT | ||||
ABWMA | ABWMA_KK | CHAR | 10(0) | Alternative dunning recipient | BU_PARTNER | BUPA | PARTNER | |||||
MAHNS | MAHNS_KK | NUMC | 2(0) | Dunning Level | MAHNS_KK | |||||||
MSTYP | MSTYP_KK | CHAR | 2(0) | Dunning Level Category | MSTYP_KK | |||||||
WAERS | WAERS | CUKY | 5(0) | Currency Key | WAERS | FWS | FB | |||||
MSALM | MSALM_KK | CURR | 13(2) | Dunning Balance | WRTV7 | |||||||
MSALH | UNUSED_KK | DEC | 13(2) | Not used (formerly dunned amount in local currency) | UNUSED | |||||||
RSALM | RSALM_KK | CURR | 13(2) | Total of Dunning Reductions | WRTV7 | |||||||
CHGID | CHGID_KK | CHAR | 2(0) | Charges Schedule | CHGID_KK | |||||||
MGE1M | MGE1M_KK | CURR | 13(2) | Dun. charge 1 | WRTV7 | |||||||
MG1BL | MG1BL_KK | CHAR | 12(0) | Doc no. for charge 1 | OPBEL_KK | |||||||
MG1TY | MG1TY_KK | CHAR | 2(0) | Charge type f. charge 1 | CHGTY_KK | |||||||
POST1 | CPOST_KK | CHAR | 1(0) | Posting Key for Charges | CPOST_KK | |||||||
MGE2M | MGE2M_KK | CURR | 13(2) | Dun.charge 2 | WRTV7 | |||||||
MG2BL | MG2BL_KK | CHAR | 12(0) | Doc number for charge 2 | OPBEL_KK | |||||||
MG2TY | MG2TY_KK | CHAR | 2(0) | Charge type f. charge 2 | CHGTY_KK | |||||||
POST2 | CPOST_KK | CHAR | 1(0) | Posting Key for Charges | CPOST_KK | |||||||
MGE3M | MGE3M_KK | CURR | 13(2) | Dun.charge 3 | WRTV7 | |||||||
MG3BL | MG3BL_KK | CHAR | 12(0) | Doc number for charge 3 | OPBEL_KK | |||||||
MG3TY | MG3TY_KK | CHAR | 2(0) | Charge type f. charge 3 | CHGTY_KK | |||||||
POST3 | CPOST_KK | CHAR | 1(0) | Posting Key for Charges | CPOST_KK | |||||||
MINTM | MINTM_KK | CURR | 13(2) | Dunning interest in transaction currency | WRTV7 | |||||||
MIBEL | MIBEL_KK | CHAR | 12(0) | Doc no. of interest posting | OPBEL_KK | |||||||
BONIT | BONDU_KK | NUMC | 4(0) | Creditworthiness | BONIT_KK | |||||||
XMSTO | XMSTO_KK | CHAR | 1(0) | Dunning Notice Reversed | XFELD | |||||||
NRZAS | NRZAS_KK | CHAR | 12(0) | Payment Form Number | NRZAS_KK | |||||||
XINFO | XINFG_KK | CHAR | 1(0) | Group Not Due For Dunning/Information Only | XFELD | |||||||
FRDAT | FRDAT_KK | DATS | 8(0) | Payment Target in Dunning Notice | DATUM | |||||||
COKEY | COKEY_KK | CHAR | 36(0) | Correspondence key | COKEY_KK | |||||||
XCOLL | XCOLL_KK | CHAR | 1(0) | Submission to Collection Agency | XFELD | |||||||
RFZAS | RFZAS_KK | CHAR | 30(0) | External key payment form | RFZAS_KK | |||||||
TODAT | TODAT_KK | DATS | 8(0) | Date Up to Which Payments Were Considered (Dunning) | DATUM | |||||||
STAKZ | STAKZ_KK | CHAR | 1(0) | Type of statistical item | STAKZ_KK | |||||||
CHECKBOX | CKBOX_KK | CHAR | 1(0) | Technical Checkbox | XFELD | |||||||
SUCPC | SUCPC_KK | DEC | 5(2) | Success Percentage Rate Determined for Dunning | PRZ32 | |||||||
ABWTP | ABWTP_KK | CHAR | 1(0) | Category of substitute document in FI-CA | ABWTP_KK | |||||||
ABWBL | ABWBL_KK | CHAR | 12(0) | Number of the substitute FI-CA document | ABWBL_KK | FB | ||||||
STUDT | STUDT_MAX_KK | DATS | 8(0) | Maximum Deferral Date for Related Items | DATUM | |||||||
SUCDT | SUCDT_KK | DATS | 8(0) | Date of Success Valuation | DATUM | |||||||
SCDST | SCDST_KK | CHAR | 1(0) | Status of Success Valuation | SCDST_KK | |||||||
SCORE | SCORE_CM_KK | NUMC | 4(0) | Valuation Number | NUMC04 | |||||||
RANK | RANK_CM_KK | NUMC | 4(0) | Ranking | NUMC04 | |||||||
FKKKO | FKKKO | STRU | 0(0) | |||||||||
MANDT | MANDT | CLNT | 3(0) | Client | MANDT | TEST | ||||||
OPBEL | OPBEL_KK | CHAR | 12(0) | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | 80B | FB | |||||
FIKEY | FIKEY_KK | CHAR | 12(0) | Reconciliation Key for General Ledger | FIKEY_KK | FB | FKFI1 | FIKEY | ||||
APPLK | APPLK_KK | CHAR | 1(0) | Application area | APPLK_KK | |||||||
BLART | BLART_KK | CHAR | 2(0) | Document Type | BLART_KK | FB | ||||||
HERKF | HERKF_KK | CHAR | 2(0) | Document Origin Key | HERKF_KK | |||||||
ERNAM | ERNAM | CHAR | 12(0) | Name of Person who Created the Object | USNAM | SAP | ||||||
CPUDT | CPUDT | DATS | 8(0) | Day On Which Accounting Document Was Entered | DATUM | MB | ||||||
CPUTM | CPUTM | TIMS | 6(0) | Time of Entry | UZEIT | MB | ||||||
WAERS | BLWAE_KK | CUKY | 5(0) | Transaction Currency | WAERS | FWS | FB | |||||
BLDAT | BLDAT | DATS | 8(0) | Document Date in Document | DATUM | FB | ||||||
BUDAT | BUDAT_KK | DATS | 8(0) | Posting Date in the Document | DATUM | FB | ||||||
WWERT | WWERT_D | DATS | 8(0) | Translation Date | DATUM | FB | ||||||
XBLNR | XBLNR_KK | CHAR | 16(0) | Reference document number | XBLNR_KK | FB | ||||||
RLGRD | RLGRD_KK | CHAR | 3(0) | Return reason | RLGRD_KK | |||||||
ABGRD | BUGRD_KK | CHAR | 2(0) | Posting Reason (For Write-Offs And Transfer Postings) | BUGRD_KK | |||||||
XEIBH | XEIBH_KK | CHAR | 1(0) | Create Separate Document in General Ledger | XFELD | |||||||
XBWER | XBWER_KK | CHAR | 1(0) | Document Created by Foreign Currency Valuation or Reclass. | XBWER_KK | |||||||
AWTYP | AWTYP | CHAR | 5(0) | Reference Transaction | AWTYP | FB | ||||||
AWKEY | AWKEY | CHAR | 20(0) | Reference Key | AWKEY | FB | ||||||
STBEL | STBEL_KK | CHAR | 12(0) | Number of Reversed Document | OPBEL_KK | |||||||
STMET | STMET_INT_KK | CHAR | 1(0) | Reversal Method Selected Internally | STMET_INT_KK | |||||||
BLTYP | BLTYP_KK | CHAR | 1(0) | Document Class | BLTYP_KK | |||||||
AGINF | AGINF_KK | CHAR | 1(0) | Clearing Information | AGINF_KK | |||||||
STBUK | STBUK_KK | CHAR | 4(0) | Tax Company Code | BUKRS | BUK | FB | |||||
STORB | STORB_KK | CHAR | 12(0) | Number of Reversal Document | OPBEL_KK | |||||||
APPDX | APPDX_KK | CHAR | 1(0) | Existing document supplements | APPDX_KK | |||||||
XMBEL | XMBEL_KK | CHAR | 1(0) | Sample document | XFELD | |||||||
AWSYS | AWSYS | CHAR | 10(0) | Logical system of source document | LOGSYS | |||||||
VERSN | VERSN_KK | CHAR | 3(0) | Version Number | CHAR3 | |||||||
BRANCH | J_1BBRANC_ | CHAR | 4(0) | Business Place | J_1BBRANCH | |||||||
C4EYE | C4EYE_KK | CHAR | 2(0) | Check Reason for Workflows Acc. to Dual Control Principle | C4EYE_KK | |||||||
C4EYP | C4EYP_KK | CHAR | 1(0) | Editing Process To Be Confirmed | C4EYP_KK | |||||||
TATYP | TATYP_KK | CHAR | 1(0) | Transaction Class of Document | TATYP_KK | |||||||
HBBLA | HBBLA_KK | CHAR | 2(0) | Document Type for Transfer to General Ledger | BLART | |||||||
XCSHA | XCSHA_KK | CHAR | 1(0) | Document Contains Assignments from Cash Flows | XFELD | |||||||
PRTID | PRTID_KK | CHAR | 32(0) | Identification of Partner Message from SAP Credit Management | CHAR32 | |||||||
UTLOC | UTLOC_UT_KK | CHAR | 2(0) | Storage Location of Tax Supplement for Telco Tax (U.S.A) | CHAR2 | |||||||
XTXCH | XTXCH_KK | CHAR | 1(0) | Tax Codes Were Exchanged | XFELD | |||||||
VATDATE | VATDATE_KK | DATS | 8(0) | Tax Reporting Date | DATUM | |||||||
XDOCA | XDOCA_KK | CHAR | 1(0) | Document Was Read from Archive | XFELD | |||||||
WNPER | WNPER_KK | NUMC | 2(0) | Requested Special Period for Transfer to General Ledger | MONAT | |||||||
XSING | XSING_KK | CHAR | 1(0) | Individual Posting | XFELD |