SAP ABAP Table MHND_GROUP (Dunning Data Grouped in Groups)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM-PO (Application Component) Funds Management-Specific Postings
     ⤷ FMKW (Package) IS-PS: Fiscal Cash Accounting

Basic Data

Table Category	INTTAB	Structure
Structure	MHND_GROUP	Table Relationship Diagram
Short Description	Dunning Data Grouped in Groups

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	mhnd Extended
2	.INCLUDE	☐				0	0	Dunning Data
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	LAUFD	☐	LAUFD	DATUM	DATS	8	0	Date on Which the Program Is to Be Run
5	LAUFI	☐	LAUFI	LAUFI	CHAR	6	0	Additional Identification
6	KOART	☐	KOART	KOART	CHAR	1	0	Account type
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
9	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
10	CPDKY	☐	CPDKY	TEXT16	CHAR	16	0	Sort field for one-time accounts
11	SKNRZE	☐	KNRZE	KUNNR	CHAR	10	0	Head office account number (in branch accounts)	KNA1
12	SMABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
13	SMAHSK	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
14	BBUKRS	☐	BBUKRS	BUKRS	CHAR	4	0	Document company code	*
15	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
16	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
17	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
18	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
19	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
20	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
21	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
22	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
23	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
24	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
25	FAEDT	☐	NETDT	DATUM	DATS	8	0	Due Date for Net Payment
26	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
27	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
28	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
29	SMSCHL	☐	MSCHL_MHND	MSCHL	CHAR	1	0	Dunning key if separate printout is active; otherwise blank	T040
30	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
31	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
32	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
33	MAHNS	☐	MAHNS_ALT	MAHNS	NUMC	1	0	Old dunning level
34	MAHNN	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
35	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
36	XZALB	☐	XZALB_MHND	XFELD	CHAR	1	0	Indicator: items payable (not to be dunned) ?
37	XFAEL	☐	XFAEL	XFELD	CHAR	1	0	Indicator: line items overdue ?
38	VERZN	☐	VERZN	WRTV3	DEC	5	0	Days in Arrears by Net Due Date
39	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
40	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	T074U
41	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
42	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
43	DMSHB	☐	DMSHB	WRTV7	CURR	13	2	Amount in Local Currency with +/- Signs
44	WRSHB	☐	WRSHB	WRTV7	CURR	13	2	Foreign Currency Amount with Signs (+/-)
45	ZINST	☐	DZINST	WRTV3	DEC	5	0	Number of days for which interest is calculated
46	ZINSS	☐	DZINSS	PRZ43	DEC	7	3	Interest rate
47	ZSBTR	☐	DZSBTR	WRTV7	CURR	13	2	Interest amount in local currency
48	WZSBT	☐	WZSBT	WRTV7	CURR	13	2	Interest amount in foreign currency
49	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
50	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
51	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
52	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
53	XZINS	☐	XZINS_MHND	XFELD	CHAR	1	0	Indicator: Do not display interest in the item
54	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
55	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
56	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
57	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
58	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
59	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
60	BKOART	☐	BKOART	KOART	CHAR	1	0	Document account type (K=BSIK, D=BSID)
61	.INCLUDE	☐				0	0	Additional Sort Fields for Dunning
62	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
63	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	*
64	BTYPE	☐	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type	*
65	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
66	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
67	ZINKZ	☐	MHND_ZINKZ		CHAR	2	0	Public Sector Industry Solution: Exempt from Interest Calc.
68	GROUP1	☐	CHAR32	CHAR32	CHAR	32	0	Character field, length 32
69	MGRUP	☐	MGRUP	MGRUP	CHAR	2	0	Key for dunning notice grouping	*
70	KONTO	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
71	KMANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
72	GMVDT	☐	GMVDT	DATUM	DATS	8	0	Date of the legal dunning proceedings
73	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
74	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
75	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
76	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
77	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
78	ZBD1T	☐	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
79	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
80	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
81	REBZT	☐	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
82	NETDT	☐	NETDT	DATUM	DATS	8	0	Due Date for Net Payment
83	SK1DT	☐	SK1DT	DATUM	DATS	8	0	Due Date for Cash Discount 1
84	SK2DT	☐	SK2DT	DATUM	DATS	8	0	Due Date for Cash Discount 2
85	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
86	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
87	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
88	CMEMO	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
89	CASGN	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
90	DELDU	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
91	APPLK	☐	APPLK_BF	APPLK_BF	CHAR	6	0	Application Indicator	*
92	BLINF	☐	CHAR25	CHAR25	CHAR	25	0	User field for cluster PC (national)
93	STATUS	☐	CHAR8	CHAR8	CHAR	8	0	Character field, 8 characters long
94	GRUPPE	☐	INT4	INT4	INT4	10	0	Natural number

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in