MHND

Transparent Table Application Table
60 Fields 1 CDS Views

Mahndaten

MHND is an SAP database table in S/4HANA. Mahndaten. It contains 60 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DunningEntryItem view from BASIC Dunning Entry Item

Fields (60)

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 bbukrs bbukrs Doc.Com.Code
KEY belnr belnr_d Document Number
KEY gjahr gjahr Fiscal Year
KEY buzei buzei Item
gsber gsber Business Area
xblnr xblnr1 Reference
zuonr dzuonr Assignment
budat budat Posting Date
bldat bldat Document Date
cpudt cpudt Entered On
zfbdt dzfbdt Baseline Date
faedt netdt Due On
blart blart Document Type
bschl bschl Posting Key
mschl mschl Dunning key
smschl mschl_mhnd Dunning Key
mansp mansp Dunn. Block
maber maber Dunning Area
madat madat Last Dunned
mahns mahns_alt Old Dunn.Level
mahnn mahns_d Dunning Level
zlspr dzlspr Pmnt block
xzalb xzalb_mhnd Payable Items
xfael xfael Lne Itms Overd.
verzn verzn Net arrears
umsks umsks Transact.Type
umskz umskz Special G/L Ind
shkzg shkzg Debit/Credit
waers waers Currency
dmshb dmshb Debit/CreditAmt
wrshb wrshb Amount in FC
zinst dzinst Interest Days
zinss dzinss Interest rate
zsbtr dzsbtr Interest Amount
wzsbt wzsbt Interest Amount
filkd filkd Branch
vkorg vkorg Sales Org.
vtweg vtweg Distr. Channel
spart spart Division
xzins xzins_mhnd No Interest Displ.
rebzg rebzg Invoice Ref.
rebzj rebzj Fiscal Year
rebzz rebzz Item
vertn ranl Contract Number
vertt rantyp Contract Type
zlsch dzlsch Pymt Meth.
bkoart bkoart Doc. Acct. Type
zinkz mhnd_zinkz No Interest Calc.
xref3 xref3 Reference Key 3

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MHND (
    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]
    BBUKRS,  -- Doc.Com.Code [bbukrs]
    BELNR,   -- Document Number [belnr_d]
    GJAHR,   -- Fiscal Year [gjahr]
    BUZEI,   -- Item [buzei]
    GSBER,   -- Business Area [gsber]
    XBLNR,   -- Reference [xblnr1]
    ZUONR,   -- Assignment [dzuonr]
    BUDAT,   -- Posting Date [budat]
    BLDAT,   -- Document Date [bldat]
    CPUDT,   -- Entered On [cpudt]
    ZFBDT,   -- Baseline Date [dzfbdt]
    FAEDT,   -- Due On [netdt]
    BLART,   -- Document Type [blart]
    BSCHL,   -- Posting Key [bschl]
    MSCHL,   -- Dunning key [mschl]
    SMSCHL,  -- Dunning Key [mschl_mhnd]
    MANSP,   -- Dunn. Block [mansp]
    MABER,   -- Dunning Area [maber]
    MADAT,   -- Last Dunned [madat]
    MAHNS,   -- Old Dunn.Level [mahns_alt]
    MAHNN,   -- Dunning Level [mahns_d]
    ZLSPR,   -- Pmnt block [dzlspr]
    XZALB,   -- Payable Items [xzalb_mhnd]
    XFAEL,   -- Lne Itms Overd. [xfael]
    VERZN,   -- Net arrears [verzn]
    UMSKS,   -- Transact.Type [umsks]
    UMSKZ,   -- Special G/L Ind [umskz]
    SHKZG,   -- Debit/Credit [shkzg]
    WAERS,   -- Currency [waers]
    DMSHB,   -- Debit/CreditAmt [dmshb]
    WRSHB,   -- Amount in FC [wrshb]
    ZINST,   -- Interest Days [dzinst]
    ZINSS,   -- Interest rate [dzinss]
    ZSBTR,   -- Interest Amount [dzsbtr]
    WZSBT,   -- Interest Amount [wzsbt]
    FILKD,   -- Branch [filkd]
    VKORG,   -- Sales Org. [vkorg]
    VTWEG,   -- Distr. Channel [vtweg]
    SPART,   -- Division [spart]
    XZINS,   -- No Interest Displ. [xzins_mhnd]
    REBZG,   -- Invoice Ref. [rebzg]
    REBZJ,   -- Fiscal Year [rebzj]
    REBZZ,   -- Item [rebzz]
    VERTN,   -- Contract Number [ranl]
    VERTT,   -- Contract Type [rantyp]
    ZLSCH,   -- Pymt Meth. [dzlsch]
    BKOART,  -- Doc. Acct. Type [bkoart]
    ZINKZ,   -- No Interest Calc. [mhnd_zinkz]
    XREF3,   -- Reference Key 3 [xref3]
    PRIMARY KEY (MANDT, LAUFD, LAUFI, KOART, BUKRS, KUNNR, LIFNR, CPDKY, SKNRZE, SMABER, SMAHSK, BBUKRS, BELNR, GJAHR, BUZEI)
);

Learn More