SAP table TFK047B (Dunning level control)
SAP table TFK047B has 3 primary key fields being MANDT,MAHNV,MAHNS.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| MAHNV | Dunning Procedure | CHAR | 2 | 0 | TFK047A | MAHNV_KK | |||||||||
| MAHNS | Dunning Level | NUMC | 2 | 0 | MAHNS_KK | ||||||||||
| VERTG | Number Of Days in Arrears | NUMC | 4 | 0 | VERTG_KK | ||||||||||
| RHYTH | Dunning frequency in days | NUMC | 3 | 0 | RHYTH_KK | ||||||||||
| FRIST | Payment Deadline in Days | NUMC | 3 | 0 | FRIST_KK | ||||||||||
| XPOST | Print All Items | CHAR | 1 | 0 | XPOST_KK | ||||||||||
| XAEND | Always Dun Dunning Level | CHAR | 1 | 0 | XAEND_KK | ||||||||||
| BONIG | Creditworthiness number | NUMC | 2 | 0 | BONIZ_KK | ||||||||||
| XMFAK | Dunning Level is Optional | CHAR | 1 | 0 | XMFAK_KK | ||||||||||
| XMSUS | Entry in Dunning History only Technically Conditional | CHAR | 1 | 0 | XMSUS_KK | ||||||||||
| IKEY | Interest Key | CHAR | 2 | 0 | TFK056A | IKEY_KK | |||||||||
| IPOST | Posting Key for Dunning Interest | CHAR | 1 | 0 | IPOST_KK | ||||||||||
| ICALC | Determine Interest | CHAR | 1 | 0 | ICALC_KK | ||||||||||
| CHGID | Charges Schedule | CHAR | 2 | 0 | TFK047E | CHGID_KK | |||||||||
| MSTYP | Dunning Level Category | CHAR | 2 | 0 | TFK047G | MSTYP_KK | |||||||||
| CHGT1 | Field Not to be Used (Previously Charge Type) | CHAR | 2 | 0 | TFK047H | UNUSED_CHGTY_KK | |||||||||
| CHGT2 | Field Not to be Used (Previously Charge Type) | CHAR | 2 | 0 | TFK047H | UNUSED_CHGTY_KK | |||||||||
| CHGT3 | Field Not to be Used (Previously Charge Type) | CHAR | 2 | 0 | TFK047H | UNUSED_CHGTY_KK | |||||||||
| XEXTM | Set Dunning Level | CHAR | 1 | 0 | XEXTM_KK |
|
|||||||||
| AVERT | Number of days in arrears for external program | NUMC | 4 | 0 | AVERT_KK | ||||||||||
| ARHYT | Dunning frequency in days for external program | NUMC | 3 | 0 | ARHYT_KK | ||||||||||
| XNBGM | Only Items from Previous Dunning Level | CHAR | 1 | 0 | XNBGM_KK | ||||||||||
| MEMPF | Control for Dunning Recipient | CHAR | 1 | 0 | MEMPF_KK |
|
|||||||||
| INTFIRST | Calculation of Interest before Charges in Dunning Program | CHAR | 1 | 0 | INTFIRST_KK | ||||||||||
| ERITG | Number of Days for Reminder before Due Date | NUMC | 3 | 0 | ERITG_KK | ||||||||||
| MINPZ | Dunning Proposal: Limit Percentage Rate | DEC | 3 | 1 | MINPZ_KK | ||||||||||
| NEWDC | Dun New Documents Immediately | CHAR | 1 | 0 | NEWDC_KK | ||||||||||
| XDSUC | Subsequent Success Valuation of Dunning | CHAR | 1 | 0 | XDSUC_KK |
TFK047B foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TFK047B | CHGID | TFK047E | Charges Schedule | MANDT |
| 0 TFK047B | CHGID | TFK047E | Charges Schedule | CHGID |
| 1 TFK047B | CHGT1 | TFK047H | Charges Categories | MANDT |
| 1 TFK047B | CHGT1 | TFK047H | Charges Categories | CHGTY |
| 0 TFK047B | CHGT2 | TFK047H | Charges Categories | MANDT |
| 0 TFK047B | CHGT2 | TFK047H | Charges Categories | CHGTY |
| 1 TFK047B | CHGT3 | TFK047H | Charges Categories | MANDT |
| 1 TFK047B | CHGT3 | TFK047H | Charges Categories | CHGTY |
| 0 TFK047B | IKEY | TFK056A | Interest Key Table for FI-CA | IKEY |
| 1 TFK047B | MAHNV | TFK047A | Dunning procedure | MAHNV |
| 0 TFK047B | MSTYP | TFK047G | Dunning Level Categories | MSTYP |