MHNK
Mahndaten (Kontoeintraege)
MHNK is an SAP database table in S/4HANA. Mahndaten (Kontoeintraege). It contains 53 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_DunningEntry | view | from | BASIC | Dunning Entry |
Fields (53)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | laufd | laufd | Run On | |||
| KEY | laufi | laufi | Identification | |||
| KEY | koart | koart | Account type | |||
| KEY | bukrs | bukrs | Company Code | |||
| KEY | kunnr | kunnr | Customer | |||
| KEY | lifnr | lifnr | Supplier | |||
| KEY | cpdky | cpdky | Sort Field CPD | |||
| KEY | sknrze | knrze | Head Office | |||
| KEY | smaber | maber | Dunning Area | |||
| KEY | smahsk | mahns_d | Dunning Level | |||
| KEY | busab | busab_ma | Dunning Clerk | |||
| ausdt | ausdt_f150 | Dunning Date | ||||
| grdat | grdat_f150 | Docmnts Posted up To | ||||
| knrma | knrma | Dunn.Recipient | ||||
| gmvdt | gmvdt | Leg.Dunn.Proc. | ||||
| mahna | mahna | Dunn.Procedure | ||||
| mahns | mahns_d | Dunning Level | ||||
| vzskz | vzskz | Interest Indic. | ||||
| waers | waers | Currency | ||||
| saldo | salfw_mhnk | Balance | ||||
| salhw | salhw_mhnk | Balance | ||||
| gsfbt | gsfbt_mhnk | Blocked and Due | ||||
| gsnbt | gsnbt_mhnk | Blocked Not Due | ||||
| faebt | faebt_mhnk | Due | ||||
| faehw | faehw_mhnk | Due | ||||
| xmflg | xmflg_mhnk | To Be Sent | ||||
| mansp | mansp | Dunn. Block | ||||
| mahsk | mahns_mhnk | Highest Dun.Level | ||||
| zinbt | dzinbt_mhn | Interest Total | ||||
| zinhw | dzinhw_mhn | Total Interest | ||||
| xzins | xzins_mhnk | No Intrst in Dun.Not | ||||
| mgrup | mgrup | Grouping Key | ||||
| vertn | ranl | Contract Number | ||||
| vertt | rantyp | Contract Type | ||||
| imkey | imkey | Real Estate Key | ||||
| famsm | famsm_mhnk | Due from dunning lev | ||||
| famsh | famsh_mhnk | Due from dunning lev | ||||
| pstlz | pstlz | Postal Code | ||||
| ort01 | ort01_gp | City | ||||
| stras | stras_gp | Street | ||||
| pfach | pfach | PO Box | ||||
| land1 | land1 | Country/Reg. | ||||
| avsid | avsid | Payt Advice No. | ||||
| applk | applk_bf | Application ID | ||||
| cpdky_grp | cpdky | Sort Field CPD | ||||
| cpdky_cpd | cpdky | Sort Field CPD | ||||
| mhngh | mhngh_f150 | Dunning Charge | ||||
| mhngf | mhngf_f150 | Dun.Chge.in FC | ||||
| prnform | form_types | Form Type | ||||
| prnnacha | fi_nacha | Transm. Medium | ||||
| prndt | prndt | Print Date | ||||
| prndt_before | prndt_before | Last Dunning |
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.
-- Mahndaten (Kontoeintraege)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MHNK (
MANDT, -- Client [mandt]
LAUFD, -- Run On [laufd]
LAUFI, -- Identification [laufi]
KOART, -- Account type [koart]
BUKRS, -- Company Code [bukrs]
KUNNR, -- Customer [kunnr]
LIFNR, -- Supplier [lifnr]
CPDKY, -- Sort Field CPD [cpdky]
SKNRZE, -- Head Office [knrze]
SMABER, -- Dunning Area [maber]
SMAHSK, -- Dunning Level [mahns_d]
BUSAB, -- Dunning Clerk [busab_ma]
AUSDT, -- Dunning Date [ausdt_f150]
GRDAT, -- Docmnts Posted up To [grdat_f150]
KNRMA, -- Dunn.Recipient [knrma]
GMVDT, -- Leg.Dunn.Proc. [gmvdt]
MAHNA, -- Dunn.Procedure [mahna]
MAHNS, -- Dunning Level [mahns_d]
VZSKZ, -- Interest Indic. [vzskz]
WAERS, -- Currency [waers]
SALDO, -- Balance [salfw_mhnk]
SALHW, -- Balance [salhw_mhnk]
GSFBT, -- Blocked and Due [gsfbt_mhnk]
GSNBT, -- Blocked Not Due [gsnbt_mhnk]
FAEBT, -- Due [faebt_mhnk]
FAEHW, -- Due [faehw_mhnk]
XMFLG, -- To Be Sent [xmflg_mhnk]
MANSP, -- Dunn. Block [mansp]
MAHSK, -- Highest Dun.Level [mahns_mhnk]
ZINBT, -- Interest Total [dzinbt_mhn]
ZINHW, -- Total Interest [dzinhw_mhn]
XZINS, -- No Intrst in Dun.Not [xzins_mhnk]
MGRUP, -- Grouping Key [mgrup]
VERTN, -- Contract Number [ranl]
VERTT, -- Contract Type [rantyp]
IMKEY, -- Real Estate Key [imkey]
FAMSM, -- Due from dunning lev [famsm_mhnk]
FAMSH, -- Due from dunning lev [famsh_mhnk]
PSTLZ, -- Postal Code [pstlz]
ORT01, -- City [ort01_gp]
STRAS, -- Street [stras_gp]
PFACH, -- PO Box [pfach]
LAND1, -- Country/Reg. [land1]
AVSID, -- Payt Advice No. [avsid]
APPLK, -- Application ID [applk_bf]
CPDKY_GRP, -- Sort Field CPD [cpdky]
CPDKY_CPD, -- Sort Field CPD [cpdky]
MHNGH, -- Dunning Charge [mhngh_f150]
MHNGF, -- Dun.Chge.in FC [mhngf_f150]
PRNFORM, -- Form Type [form_types]
PRNNACHA, -- Transm. Medium [fi_nacha]
PRNDT, -- Print Date [prndt]
PRNDT_BEFORE, -- Last Dunning [prndt_before]
PRIMARY KEY (MANDT, LAUFD, LAUFI, KOART, BUKRS, KUNNR, LIFNR, CPDKY, SKNRZE, SMABER, SMAHSK, BUSAB)
);
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