FKKMAZE

Transparent Table Application Table
52 Fields 4 CDS Views

Dunning history of line items

FKKMAZE is an SAP database table in S/4HANA. Dunning history of line items. It contains 52 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_CADunningItem view from BASIC Dunning History Document Item
I_DunHistLineItem view from BASIC Dunning History for Line Item
view_o2c_fica_dun_doc view from Current date of issue for a dunned open item
view_o2c_fica_woh_dun view left_outer CDS View Writeoff History For Dunning Data

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY laufd LAUFD_KK Date ID
KEY laufi MLFID_KK Identification
KEY gpart GPART_KK Bus. Partner
KEY vkont VKONT_KK Contract Acct
KEY mazae MAZAE_KK Dunning counter
KEY opbel OPBEL_KK Document Number
KEY opupw OPUPW_KK Repetition Item
KEY opupk OPUPK_KK Item
KEY opupz OPUPZ_KK Subitem
bukrs BUKRS Company Code
waers WAERS Currency
mbetm MBETM_KK Dunning amount
mbeth UNUSED_KK unused
faedn FAEDN_KK Net Due Date
mibel MIBEL_KK Interest doc.
mintm MINTM_KK Dunn.int.
mahns MAHNS_KK Dunning Level
mstyp MSTYP_KK Dunn.Level Cat.
mahnn MAHNN_KK New level
mansp MANSP_KK DunnLockReason
xmfak XMFAK_KK Optional dun. l
xmsus XMSUS_KK Suspension level
xmsto XMSTO_KK Dunning canceled
xinfo XINFO_KK Info item
mdrkd MDRKD_KK Print Date
stakz STAKZ_KK Statistical key
xmvkt XMVKT_KK Contract Account Not Unique
vtref VTREF_KK Contract
subap SUBAP_KK Subapplication
segment SEGMT_KK Segment
prctr PRCTR Profit Center
mahnv MAHNV_KK Dunning Proc.
ausdt AUSDT_KK Date of Issue
spart SPART_KK Division
xtaus XTAUS_KK Sub-Item
mopupz MOPUPZ_KK Maximum Subitem Number
higherdl HIGHERDL_KK Item has higher dunning level
dalin DALIN_KK Dunning Activy
discno DISCNO Disconnect.doc.
vkont_dreg VKONT_KK Contract Acct
vtref_dreg VTREF_KK Contract
xmstv XMSTO_KK Dunning canceled
blart BLART Document Type
abrzu ABRZU_KK Billing Period
abrzo ABRZO_KK Bill Period
pdunn PDUNN_KK For dunn. bal.
gdunn GDUNN_VK No Dunn. Charge Calc
broker BROKERPA_BRO Rep. Broker
bro_contract BROOBJ_BRO Broker Contract
xfile IST_XFILE Flag file
btdoc IST_BTDOC Disc.no.IS-T

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 history of line items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FKKMAZE (
    MANDT,         -- Client [MANDT]
    LAUFD,         -- Date ID [LAUFD_KK]
    LAUFI,         -- Identification [MLFID_KK]
    GPART,         -- Bus. Partner [GPART_KK]
    VKONT,         -- Contract Acct [VKONT_KK]
    MAZAE,         -- Dunning counter [MAZAE_KK]
    OPBEL,         -- Document Number [OPBEL_KK]
    OPUPW,         -- Repetition Item [OPUPW_KK]
    OPUPK,         -- Item [OPUPK_KK]
    OPUPZ,         -- Subitem [OPUPZ_KK]
    BUKRS,         -- Company Code [BUKRS]
    WAERS,         -- Currency [WAERS]
    MBETM,         -- Dunning amount [MBETM_KK]
    MBETH,         -- unused [UNUSED_KK]
    FAEDN,         -- Net Due Date [FAEDN_KK]
    MIBEL,         -- Interest doc. [MIBEL_KK]
    MINTM,         -- Dunn.int. [MINTM_KK]
    MAHNS,         -- Dunning Level [MAHNS_KK]
    MSTYP,         -- Dunn.Level Cat. [MSTYP_KK]
    MAHNN,         -- New level [MAHNN_KK]
    MANSP,         -- DunnLockReason [MANSP_KK]
    XMFAK,         -- Optional dun. l [XMFAK_KK]
    XMSUS,         -- Suspension level [XMSUS_KK]
    XMSTO,         -- Dunning canceled [XMSTO_KK]
    XINFO,         -- Info item [XINFO_KK]
    MDRKD,         -- Print Date [MDRKD_KK]
    STAKZ,         -- Statistical key [STAKZ_KK]
    XMVKT,         -- Contract Account Not Unique [XMVKT_KK]
    VTREF,         -- Contract [VTREF_KK]
    SUBAP,         -- Subapplication [SUBAP_KK]
    SEGMENT,       -- Segment [SEGMT_KK]
    PRCTR,         -- Profit Center [PRCTR]
    MAHNV,         -- Dunning Proc. [MAHNV_KK]
    AUSDT,         -- Date of Issue [AUSDT_KK]
    SPART,         -- Division [SPART_KK]
    XTAUS,         -- Sub-Item [XTAUS_KK]
    MOPUPZ,        -- Maximum Subitem Number [MOPUPZ_KK]
    HIGHERDL,      -- Item has higher dunning level [HIGHERDL_KK]
    DALIN,         -- Dunning Activy [DALIN_KK]
    DISCNO,        -- Disconnect.doc. [DISCNO]
    VKONT_DREG,    -- Contract Acct [VKONT_KK]
    VTREF_DREG,    -- Contract [VTREF_KK]
    XMSTV,         -- Dunning canceled [XMSTO_KK]
    BLART,         -- Document Type [BLART]
    ABRZU,         -- Billing Period [ABRZU_KK]
    ABRZO,         -- Bill Period [ABRZO_KK]
    PDUNN,         -- For dunn. bal. [PDUNN_KK]
    GDUNN,         -- No Dunn. Charge Calc [GDUNN_VK]
    BROKER,        -- Rep. Broker [BROKERPA_BRO]
    BRO_CONTRACT,  -- Broker Contract [BROOBJ_BRO]
    XFILE,         -- Flag file [IST_XFILE]
    BTDOC,         -- Disc.no.IS-T [IST_BTDOC]
    PRIMARY KEY (MANDT, LAUFD, LAUFI, GPART, VKONT, MAZAE, OPBEL, OPUPW, OPUPK, OPUPZ)
);

Learn More