queryviz
tables/relationship path
open in builder
TPAR
PARVW
KNVP
KUNNR
KNA1
KUNNR
KNB5

KNB5

customer master - dunning data (per company code and dunning area)
sd15f · 4k · 2r

fields (15)

fieldtypelengthkeydescription
BUKRSchar4pkcompany code
KUNNRchar10pkcustomer number
MABERchar2pkdunning area (subdivision of company code for dunning; blank = company code level)
MANDTclnt3pkclient
GRUPPchar10dunning recipient customer number (if dunning notices go to a different customer)
LOEVMchar1deletion flag for dunning data
MADATdats8date of last dunning notice
MAHDTdats8last dunned date
MAHNAchar4dunning procedure (e.g., 0001=standard 4-level dunning)
MAHNDdats8date of last dunning notice
MAHNLnumc2dunning level of last dunning notice (1=first reminder, 4=final demand, etc.)
MAHNSnumc1dunning level
MAHNZnumc2number of dunning notices run
MANSPchar1dunning block
XDUNLchar1lock key for dunning (x=customer locked from dunning runs)

relationships (2)

configuration

reference to config tables

references
T001
BUKRSBUKRS
N:1
master lookup

reference to master data

references
KNA1
KUNNRKUNNR
N:1
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms