SAP MHND_GROUP Dunning Data Grouped in Groups Table data and field list

MHND_GROUP is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Dunning Data Grouped in Groups" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MHND_GROUP TYPE MHND_GROUP.

The MHND_GROUP table consists of various fields, each holding specific information or linking keys about Dunning Data Grouped in Groups data available in SAP. These include MANDT (Client), LAUFD (Date on Which the Program Is to Be Run), LAUFI (Additional Identification), KOART (Account Type)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

MHND_GROUP structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP MHND_GROUP structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the MHND_GROUP table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
LAUFD	Date on Which the Program Is to Be Run	LAUFD	DATS	8			DATUM
LAUFI	Additional Identification	LAUFI	CHAR	6			LAUFI
KOART	Account Type	KOART	CHAR	1			KOART
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
KUNNR	Customer Numbers	KUNNR	CHAR	10	KNA1	ALPHA	KUNNR	KUN	C_KUNNR
LIFNR	Account Number of Vendor or Creditor	LIFNR	CHAR	10	LFA1	ALPHA	LIFNR	LIF	KRED_C
CPDKY	Sort field for one-time accounts	CPDKY	CHAR	16			TEXT16
SKNRZE	Head office account number (in branch accounts)	KNRZE	CHAR	10	KNA1	ALPHA	KUNNR
SMABER	Dunning Area	MABER	CHAR	2	T047M		MABER
SMAHSK	Dunning level	MAHNS_D	NUMC	1			MAHNS
BBUKRS	Document company code	BBUKRS	CHAR	4	Assigned to domain		BUKRS
BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
GSBER	Business Area	GSBER	CHAR	4	TGSB		GSBER	GSB
XBLNR	Reference Document Number	XBLNR1	CHAR	16			XBLNR1
ZUONR	Assignment Number	DZUONR	CHAR	18			ZUONR
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
BLDAT	Document Date in Document	BLDAT	DATS	8			DATUM
CPUDT	Day On Which Accounting Document Was Entered	CPUDT	DATS	8			DATUM
ZFBDT	Baseline Date for Due Date Calculation	DZFBDT	DATS	8			DATUM
FAEDT	Due Date for Net Payment	NETDT	DATS	8			DATUM
BLART	Document Type	BLART	CHAR	2	T003		BLART	BAR
BSCHL	Posting Key	BSCHL	CHAR	2	TBSL		BSCHL
MSCHL	Dunning key	MSCHL	CHAR	1	T040		MSCHL
SMSCHL	Dunning key if separate printout is active; otherwise blank	MSCHL_MHND	CHAR	1	T040		MSCHL
MANSP	Dunning block	MANSP	CHAR	1	T040S		MANSP
MABER	Dunning Area	MABER	CHAR	2	T047M		MABER
MADAT	Last dunned on	MADAT	DATS	8			DATUM
MAHNS	Old dunning level	MAHNS_ALT	NUMC	1			MAHNS
MAHNN	Dunning level	MAHNS_D	NUMC	1			MAHNS
ZLSPR	Payment Block Key	DZLSPR	CHAR	1	T008		ZAHLS	SPE
XZALB	Indicator: items payable (not to be dunned) ?	XZALB_MHND	CHAR	1			XFELD
XFAEL	Indicator: line items overdue ?	XFAEL	CHAR	1			XFELD
VERZN	Days in Arrears by Net Due Date	VERZN	DEC	5			WRTV3
UMSKS	Special G/L Transaction Type	UMSKS	CHAR	1			UMSKS
UMSKZ	Special G/L Indicator	UMSKZ	CHAR	1	T074U		UMSKZ
SHKZG	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
WAERS	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
DMSHB	Amount in Local Currency with +/- Signs	DMSHB	CURR	13(2)			WRTV7
WRSHB	Foreign Currency Amount with Signs (+/-)	WRSHB	CURR	13(2)			WRTV7
ZINST	Number of days for which interest is calculated	DZINST	DEC	5			WRTV3
ZINSS	Interest rate	DZINSS	DEC	7(3)			PRZ43
ZSBTR	Interest amount in local currency	DZSBTR	CURR	13(2)			WRTV7
WZSBT	Interest amount in foreign currency	WZSBT	CURR	13(2)			WRTV7
FILKD	Account Number of the Branch	FILKD	CHAR	10		ALPHA	MAXKK
VKORG	Sales Organization	VKORG	CHAR	4	TVKO		VKORG	VKO	C_VKORG
VTWEG	Distribution Channel	VTWEG	CHAR	2	TVTW		VTWEG	VTW	C_VTWEG
SPART	Division	SPART	CHAR	2	TSPA		SPART	SPA	C_SPART
XZINS	Indicator: Do not display interest in the item	XZINS_MHND	CHAR	1			XFELD
REBZG	Number of the Invoice the Transaction Belongs to	REBZG	CHAR	10		ALPHA	BELNR
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	REBZJ	NUMC	4		GJAHR	GJAHR
REBZZ	Line Item in the Relevant Invoice	REBZZ	NUMC	3			BUZEI
VERTN	Contract Number	RANL	CHAR	13		ALPHA	RANL	RAN
VERTT	Contract Type	RANTYP	CHAR	1			RANTYP
ZLSCH	Payment Method	DZLSCH	CHAR	1	Assigned to domain		ZLSCH
BKOART	Document account type (K=BSIK, D=BSID)	BKOART	CHAR	1			KOART
VNAME	Joint Venture	JV_NAME	CHAR	6	Assigned to domain	ALPHA	JV_NAME	JVV
EGRUP	Equity group	JV_EGROUP	CHAR	3	Assigned to domain	ALPHA	JV_EGROUP	GJE
BTYPE	Payroll Type	JV_BILIND	CHAR	2	Assigned to domain	ALPHA	JV_BILIND
XREF1	Business partner reference key	XREF1	CHAR	12			CHAR12
XREF2	Business partner reference key	XREF2	CHAR	12			CHAR12
ZINKZ	Public Sector Industry Solution: Exempt from Interest Calc.	MHND_ZINKZ	CHAR	2
GROUP1	Character field, length 32	CHAR32	CHAR	32			CHAR32
MGRUP	Key for dunning notice grouping	MGRUP	CHAR	2	Assigned to domain		MGRUP
KONTO	Customer Numbers	KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR	KUN	C_KUNNR
KMANSP	Dunning block	MANSP	CHAR	1	Assigned to domain		MANSP
GMVDT	Date of the legal dunning proceedings	GMVDT	DATS	8			DATUM
PSTLZ	Postal Code	PSTLZ	CHAR	10			PSTLZ
ORT01	City	ORT01_GP	CHAR	35			TEXT35
STRAS	House number and street	STRAS_GP	CHAR	35			TEXT35
PFACH	PO Box	PFACH	CHAR	10			PFACH
LAND1	Country Key	LAND1_GP	CHAR	3	Assigned to domain		LAND1		C_LAND1
ZBD1T	Cash discount days 1	DZBD1T	DEC	3			ZBDXT
ZBD2T	Cash discount days 2	DZBD2T	DEC	3			ZBDXT
ZBD3T	Net Payment Terms Period	DZBD3T	DEC	3			ZBDXT
REBZT	Follow-On Document Type	REBZT	CHAR	1			REBZT
NETDT	Due Date for Net Payment	NETDT	DATS	8			DATUM
SK1DT	Due Date for Cash Discount 1	SK1DT	DATS	8			DATUM
SK2DT	Due Date for Cash Discount 2	SK2DT	DATS	8			DATUM
DMBTR	Amount in Local Currency	DMBTR	CURR	13(2)			WERT7
WRBTR	Amount in document currency	WRBTR	CURR	13(2)			WERT7
MANST	Dunning level	MAHNS_D	NUMC	1			MAHNS
CMEMO	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	BOOLE_D	CHAR	1			BOOLE
CASGN	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	BOOLE_D	CHAR	1			BOOLE
DELDU	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	BOOLE_D	CHAR	1			BOOLE
APPLK	Application Indicator	APPLK_BF	CHAR	6	Assigned to domain		APPLK_BF
BLINF	User field for cluster PC (national)	CHAR25	CHAR	25			CHAR25
STATUS	Character field, 8 characters long	CHAR8	CHAR	8			CHAR8
GRUPPE	Natural Number	INT4	INT4	10			INT4
MAINDOC	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	BOOLE_D	CHAR	1			BOOLE

Key field

Non-key field

< MHND_EXTL - mhnd Extended MHND_JV - Additional Sort Fields for Dunning >

How do I retrieve data from SAP structure MHND_GROUP using ABAP code?

As MHND_GROUP is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MHND_GROUP as there is no data to select.

How to access SAP table MHND_GROUP

Within an ECC or HANA version of SAP you can also view further information about MHND_GROUP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).