1. Home
  2. Resources
  3. SAP Tables
  4. TFK047B - Dunning level control

SAP Table TFK047B

Dunning level control

TFK047B (Dunning level control) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TFK047B to other SAP tables.

TFK047B table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MAHNV Dunning Procedure MAHNV_KK TFK047A CHAR 2 0
MAHNS Dunning Level MAHNS_KK NUMC 2 0
VERTG Number Of Days in Arrears VERTG_KK NUMC 4 0
RHYTH Dunning frequency in days RHYTH_KK NUMC 3 0
FRIST Payment Deadline in Days FRIST_KK NUMC 3 0
XPOST Print All Items XPOST_KK CHAR 1 0
X Yes
NULL No
XAEND Always Dun Dunning Level XAEND_KK CHAR 1 0
X Yes
NULL No
BONIG Creditworthiness number BONIZ_KK NUMC 2 0
XMFAK Dunning Level is Optional XMFAK_KK CHAR 1 0
X Yes
NULL No
XMSUS Entry in Dunning History only Technically Conditional XMSUS_KK CHAR 1 0
X Yes
NULL No
IKEY Interest Key IKEY_KK TFK056A CHAR 2 0
IPOST Posting Key for Dunning Interest IPOST_KK CHAR 1 0
NULL Do not update
1 Statistical update
2 Update related to G/L
ICALC Determine Interest ICALC_KK CHAR 1 0
X Yes
NULL No
CHGID Charges Schedule CHGID_KK TFK047E CHAR 2 0
MSTYP Dunning Level Category MSTYP_KK TFK047G CHAR 2 0
CHGT1 Field Not to be Used (Previously Charge Type) UNUSED_CHGTY_KK TFK047H CHAR 2 0
CHGT2 Field Not to be Used (Previously Charge Type) UNUSED_CHGTY_KK TFK047H CHAR 2 0
CHGT3 Field Not to be Used (Previously Charge Type) UNUSED_CHGTY_KK TFK047H CHAR 2 0
XEXTM Set Dunning Level XEXTM_KK CHAR 1 0
NULL No Restriction
1 Dunning Level Set Only by Dunning Run
2 Dunning Level Set Only by Invoicing
3 Do Not Consider Dunning Level for Broker Dunning Status
AVERT Number of days in arrears for external program AVERT_KK NUMC 4 0
ARHYT Dunning frequency in days for external program ARHYT_KK NUMC 3 0
XNBGM Only Items from Previous Dunning Level XNBGM_KK CHAR 1 0
X Yes
NULL No
MEMPF Control for Dunning Recipient MEMPF_KK CHAR 1 0
NULL Control from contract account
1 Dunning recipient gets dunning notice
2 Business partner gets dunning notice
3 Business partner and dunning recipient get dunning notice
INTFIRST Calculation of Interest before Charges in Dunning Program INTFIRST_KK CHAR 1 0
X Yes
NULL No
ERITG Number of Days for Reminder before Due Date ERITG_KK NUMC 3 0
MINPZ Dunning Proposal: Limit Percentage Rate MINPZ_KK DEC 3 1
NEWDC Dun New Documents Immediately NEWDC_KK CHAR 1 0
X Yes
NULL No
XDSUC Subsequent Success Valuation of Dunning XDSUC_KK CHAR 1 0
X Yes
NULL No

TFK047B foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TFK047B CHGID TFK047B MANDT TFK047E Charges Schedule MANDT
TFK047B CHGID TFK047B CHGID TFK047E Charges Schedule CHGID
TFK047B CHGT1 TFK047B MANDT TFK047H Charges Categories MANDT
TFK047B CHGT1 TFK047B CHGT1 TFK047H Charges Categories CHGTY
TFK047B CHGT2 TFK047B MANDT TFK047H Charges Categories MANDT
TFK047B CHGT2 TFK047B CHGT2 TFK047H Charges Categories CHGTY
TFK047B CHGT3 TFK047B MANDT TFK047H Charges Categories MANDT
TFK047B CHGT3 TFK047B CHGT3 TFK047H Charges Categories CHGTY
TFK047B IKEY TFK047B MANDT TFK056A Interest Key Table for FI-CA MANDT
TFK047B IKEY TFK047B IKEY TFK056A Interest Key Table for FI-CA IKEY
TFK047B MAHNV TFK047B MANDT TFK047A Dunning procedure MANDT
TFK047B MAHNV TFK047B MAHNV TFK047A Dunning procedure MAHNV
TFK047B MANDT TFK047B MANDT T000 Clients MANDT
TFK047B MSTYP TFK047B MSTYP TFK047G Dunning Level Categories MSTYP
TFK047B MSTYP TFK047B MANDT TFK047G Dunning Level Categories MANDT