TFK047B
Dunning level control
TFK047B is an SAP database table in S/4HANA. Dunning level control. It contains 29 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CADunningLevel | view_entity | from | BASIC | Dunning Level |
Fields (29)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | mahnv | MAHNV_KK | Dunning Proc. | |||
| KEY | mahns | MAHNS_KK | Dunning Level | |||
| vertg | VERTG_KK | Days in arrears | ||||
| rhyth | RHYTH_KK | Dunning freq. | ||||
| frist | FRIST_KK | Pymt Deadline | ||||
| xpost | XPOST_KK | All Items | ||||
| xaend | XAEND_KK | Always dun | ||||
| bonig | BONIZ_KK | Creditw. no. | ||||
| xmfak | XMFAK_KK | Optional dun. l | ||||
| xmsus | XMSUS_KK | Suspension level | ||||
| ikey | IKEY_KK | Interest key | ||||
| ipost | IPOST_KK | Update | ||||
| icalc | ICALC_KK | Calculate Intrt | ||||
| chgid | CHGID_KK | Charges Sched. | ||||
| mstyp | MSTYP_KK | Dunn.Level Cat. | ||||
| chgt1 | UNUSED_CHGTY_KK | Field Not to be Used (Previously Charge Type) | ||||
| chgt2 | UNUSED_CHGTY_KK | Field Not to be Used (Previously Charge Type) | ||||
| chgt3 | UNUSED_CHGTY_KK | Field Not to be Used (Previously Charge Type) | ||||
| xextm | XEXTM_KK | Set dun. level | ||||
| avert | AVERT_KK | alt.days/arrear | ||||
| arhyt | ARHYT_KK | Alt. dun. freq. | ||||
| xnbgm | XNBGM_KK | already dunned | ||||
| mempf | MEMPF_KK | Dunn.recipient | ||||
| intfirst | INTFIRST_KK | Interest before Charges | ||||
| eritg | ERITG_KK | Reminder Days | ||||
| minpz | MINPZ_KK | Limit Percent. | ||||
| newdc | NEWDC_KK | Documents Immed | ||||
| xdsuc | XDSUC_KK | Success Valuatn |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Dunning level control
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TFK047B (
MANDT, -- Client [MANDT]
MAHNV, -- Dunning Proc. [MAHNV_KK]
MAHNS, -- Dunning Level [MAHNS_KK]
VERTG, -- Days in arrears [VERTG_KK]
RHYTH, -- Dunning freq. [RHYTH_KK]
FRIST, -- Pymt Deadline [FRIST_KK]
XPOST, -- All Items [XPOST_KK]
XAEND, -- Always dun [XAEND_KK]
BONIG, -- Creditw. no. [BONIZ_KK]
XMFAK, -- Optional dun. l [XMFAK_KK]
XMSUS, -- Suspension level [XMSUS_KK]
IKEY, -- Interest key [IKEY_KK]
IPOST, -- Update [IPOST_KK]
ICALC, -- Calculate Intrt [ICALC_KK]
CHGID, -- Charges Sched. [CHGID_KK]
MSTYP, -- Dunn.Level Cat. [MSTYP_KK]
CHGT1, -- Field Not to be Used (Previously Charge Type) [UNUSED_CHGTY_KK]
CHGT2, -- Field Not to be Used (Previously Charge Type) [UNUSED_CHGTY_KK]
CHGT3, -- Field Not to be Used (Previously Charge Type) [UNUSED_CHGTY_KK]
XEXTM, -- Set dun. level [XEXTM_KK]
AVERT, -- alt.days/arrear [AVERT_KK]
ARHYT, -- Alt. dun. freq. [ARHYT_KK]
XNBGM, -- already dunned [XNBGM_KK]
MEMPF, -- Dunn.recipient [MEMPF_KK]
INTFIRST, -- Interest before Charges [INTFIRST_KK]
ERITG, -- Reminder Days [ERITG_KK]
MINPZ, -- Limit Percent. [MINPZ_KK]
NEWDC, -- Documents Immed [NEWDC_KK]
XDSUC, -- Success Valuatn [XDSUC_KK]
PRIMARY KEY (MANDT, MAHNV, MAHNS)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA