MHNK

Transparent Table Application Table
59 Fields 1 CDS Views

Dunning data (account entries)

MHNK is an SAP database table in S/4HANA. Dunning data (account entries). It contains 59 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DunningEntry view from BASIC Dunning Entry

Fields (59)

KeyField Data ElementDescription DomainTypeLength
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
sdunndoclo SDUNNDOC Dunning letter
sranlpostlo RANL Contract Number
dbudatlo BUDAT Posting Date
swenr SWENR Business Entity
smenr SMENR Rental Unit
psomd PSOMD Dnning Notice Prntd

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 data (account entries)
-- 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]
    SDUNNDOCLO,    -- Dunning letter [SDUNNDOC]
    SRANLPOSTLO,   -- Contract Number [RANL]
    DBUDATLO,      -- Posting Date [BUDAT]
    SWENR,         -- Business Entity [SWENR]
    SMENR,         -- Rental Unit [SMENR]
    PSOMD,         -- Dnning Notice Prntd [PSOMD]
    PRIMARY KEY (MANDT, LAUFD, LAUFI, KOART, BUKRS, KUNNR, LIFNR, CPDKY, SKNRZE, SMABER, SMAHSK, BUSAB)
);

Learn More