SAP ABAP Table MHND (Dunning Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBAS (Package) Financial accounting 'Basis'

Basic Data

Table Category	CLUSTER	Cluster table
Cluster table	MHND	Table Relationship Diagram
Short Description	Dunning Data

Delivery and Maintenance

Pool/cluster	RFMHN
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LAUFD	☑	LAUFD	DATUM	DATS	8	0	Date on Which the Program Is to Be Run
3	LAUFI	☑	LAUFI	LAUFI	CHAR	6	0	Additional Identification
4	KOART	☑	KOART	KOART	CHAR	1	0	Account type
5	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
7	LIFNR	☑	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
8	CPDKY	☑	CPDKY	TEXT16	CHAR	16	0	Sort field for one-time accounts
9	SKNRZE	☑	KNRZE	KUNNR	CHAR	10	0	Head office account number (in branch accounts)	KNA1
10	SMABER	☑	MABER	MABER	CHAR	2	0	Dunning Area	T047M
11	SMAHSK	☑	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
12	BBUKRS	☑	BBUKRS	BUKRS	CHAR	4	0	Document company code	*
13	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
14	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
15	BUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
16	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
17	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
18	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
19	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
20	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
21	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
22	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
23	FAEDT	☐	NETDT	DATUM	DATS	8	0	Due Date for Net Payment
24	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
25	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
26	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
27	SMSCHL	☐	MSCHL_MHND	MSCHL	CHAR	1	0	Dunning key if separate printout is active; otherwise blank	T040
28	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
29	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
30	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
31	MAHNS	☐	MAHNS_ALT	MAHNS	NUMC	1	0	Old dunning level
32	MAHNN	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
33	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
34	XZALB	☐	XZALB_MHND	XFELD	CHAR	1	0	Indicator: items payable (not to be dunned) ?
35	XFAEL	☐	XFAEL	XFELD	CHAR	1	0	Indicator: line items overdue ?
36	VERZN	☐	VERZN	WRTV3	DEC	5	0	Days in Arrears by Net Due Date
37	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
38	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	T074U
39	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
40	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
41	DMSHB	☐	DMSHB	WRTV7	CURR	13	2	Amount in Local Currency with +/- Signs
42	WRSHB	☐	WRSHB	WRTV7	CURR	13	2	Foreign Currency Amount with Signs (+/-)
43	ZINST	☐	DZINST	WRTV3	DEC	5	0	Number of days for which interest is calculated
44	ZINSS	☐	DZINSS	PRZ43	DEC	7	3	Interest rate
45	ZSBTR	☐	DZSBTR	WRTV7	CURR	13	2	Interest amount in local currency
46	WZSBT	☐	WZSBT	WRTV7	CURR	13	2	Interest amount in foreign currency
47	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
48	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
49	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
50	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
51	XZINS	☐	XZINS_MHND	XFELD	CHAR	1	0	Indicator: Do not display interest in the item
52	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
53	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
54	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
55	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
56	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
57	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
58	BKOART	☐	BKOART	KOART	CHAR	1	0	Document account type (K=BSIK, D=BSID)
59	.INCLUDE	☐				0	0	Additional Sort Fields for Dunning
60	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
61	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	*
62	BTYPE	☐	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type	*
63	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
64	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
65	ZINKZ	☐	MHND_ZINKZ		CHAR	2	0	Public Sector Industry Solution: Exempt from Interest Calc.

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MHND	BLART	T003	BLART	REF	1	CN
2	MHND	BSCHL	TBSL	BSCHL	REF	1	CN
3	MHND	BUKRS	T001	BUKRS	KEY	1	CN
4	MHND	GSBER	TGSB	GSBER	REF	C	CN
5	MHND	KUNNR	KNA1	KUNNR	KEY	1	CN
6	MHND	LIFNR	LFA1	LIFNR	KEY	1	CN
7	MHND	MABER	T047M	MABER	REF	C	CN
8	MHND	MANDT	T000	MANDT	KEY	1	CN
9	MHND	MANSP	T040S	MANSP	REF	C	CN
10	MHND	MSCHL	T040	MSCHL	REF	C	CN
11	MHND	SKNRZE	KNA1	KUNNR	KEY	1	CN
12	MHND	SMABER	T047M	MABER	KEY	1	CN
13	MHND	SMSCHL	T040	MSCHL	REF	C	CN
14	MHND	SPART	TSPA	SPART	REF	C	CN
15	MHND	UMSKZ	T074U	UMSKZ	REF	C	CN
16	MHND	VKORG	TVKO	VKORG	REF	C	CN
17	MHND	VTWEG	TVTW	VTWEG	REF	C	CN
18	MHND	WAERS	TCURC	WAERS	REF	1	CN
19	MHND	ZLSPR	T008	ZAHLS	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in