SAP ABAP Table MHNK (Dunning data (account entries))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBM (Package) Dunning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MHNK	Table Relationship Diagram
Short Description	Dunning data (account entries)

Delivery and Maintenance

Pool/cluster
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	BUSAB	☑	BUSAB_MA	BUSAB	CHAR	2	0	Dunning clerk	T001S
13	AUSDT	☐	AUSDT_F150	DATUM	DATS	8	0	Dunning date
14	GRDAT	☐	GRDAT_F150	DATUM	DATS	8	0	Posting date up to which documents are included
15	KNRMA	☐	KNRMA	KUNNR	CHAR	10	0	Account number of the dunning recipient	KNA1
16	GMVDT	☐	GMVDT	DATUM	DATS	8	0	Date of the legal dunning proceedings
17	MAHNA	☐	MAHNA	MAHNA	CHAR	4	0	Dunning Procedure	T047A
18	MAHNS	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
19	VZSKZ	☐	VZSKZ	VZSKZ	CHAR	2	0	Interest calculation indicator	T056
20	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
21	SALDO	☐	SALFW_MHNK	WRTV8	CURR	15	2	Balance in dunning area in dunning currency
22	SALHW	☐	SALHW_MHNK	WRTV8	CURR	15	2	Balance in dunning area local currency
23	GSFBT	☐	GSFBT_MHNK	WRTV8	CURR	15	2	Total of blocked and due items
24	GSNBT	☐	GSNBT_MHNK	WRTV8	CURR	15	2	Total balance of blocked items not due
25	FAEBT	☐	FAEBT_MHNK	WRTV8	CURR	15	2	Total of line items due
26	FAEHW	☐	FAEHW_MHNK	WRTV8	CURR	15	2	Total of due items in local currency
27	XMFLG	☐	XMFLG_MHNK	XFELD	CHAR	1	0	Indicator: Is a dunning notice sent?
28	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
29	MAHSK	☐	MAHNS_MHNK	MAHNS	NUMC	1	0	Highest dunning level for account in dunning area
30	ZINBT	☐	DZINBT_MHN	WRTV8	CURR	15	2	Interest total for dunning notice in dunning currency
31	ZINHW	☐	DZINHW_MHN	WRTV8	CURR	15	2	Interest total for dunning notice in company code currency
32	XZINS	☐	XZINS_MHNK	XFELD	CHAR	1	0	Indicator: Do not display interest in the dunning notice
33	MGRUP	☐	MGRUP	MGRUP	CHAR	2	0	Key for dunning notice grouping	T047R
34	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
35	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
36	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
37	FAMSM	☐	FAMSM_MHNK	WRTV8	CURR	15	2	Total due itemsin dunning currency from dunning level
38	FAMSH	☐	FAMSH_MHNK	WRTV8	CURR	15	2	Total due items in local currency from dunning level
39	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
40	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
41	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
42	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
43	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
44	AVSID	☐	AVSID	AVSID	CHAR	16	0	Payment Advice Number
45	APPLK	☐	APPLK_BF	APPLK_BF	CHAR	6	0	Application Indicator	*
46	CPDKY_GRP	☐	CPDKY	TEXT16	CHAR	16	0	Sort field for one-time accounts
47	CPDKY_CPD	☐	CPDKY	TEXT16	CHAR	16	0	Sort field for one-time accounts
48	MHNGH	☐	MHNGH_F150	WRTV8	CURR	15	2	Dunning charge in local currency
49	MHNGF	☐	MHNGF_F150	WRTV8	CURR	15	2	Dunning charge in foreign currency
50	PRNDT	☐	PRNDT	DATUM	DATS	8	0	Dunning notice: Date of printing
51	PRNDT_BEFORE	☐	PRNDT_BEFORE	DATUM	DATS	8	0	Print Date of Last Dunning Notice
52	.INCLUDE	☐				0	0	Include for supplements MHNK for SAP applications
53	.INCLU-LO	☐				0	0	Loans: SI Include for MHNK
54	SDUNNDOCLO	☐	SDUNNDOC	SDUNNDOC	CHAR	1	0	Type of Dunning Letter
55	SRANLPOSTLO	☐	RANL	RANL	CHAR	13	0	Contract Number
56	DBUDATLO	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
57	.INCLUDE	☐				0	0	Real Estate
58	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
59	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
60	.INCLU--AP	☐				0	0	Holder for Include PSO
61	.INCLUDE	☐				0	0	ISPS: SI Include for MHNK
62	PSOMD	☐	PSOMD	XFELD	CHAR	1	0	Dunning Notice Already Printed
63	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MHNK	BUKRS	T001	BUKRS	KEY	1	CN
2	MHNK	BUSAB	T001S	BUSAB	KEY	1	CN
3	MHNK	KNRMA	KNA1	KUNNR	REF	C	CN
4	MHNK	KUNNR	KNA1	KUNNR	KEY	1	CN
5	MHNK	LAND1	T005	LAND1	REF	C	CN
6	MHNK	LIFNR	LFA1	LIFNR	KEY	1	CN
7	MHNK	MAHNA	T047A	MAHNA	REF	C	CN
8	MHNK	MANDT	T000	MANDT	KEY	1	CN
9	MHNK	MANSP	T040S	MANSP	REF	C	CN
10	MHNK	MGRUP	T047R	MGRUP	REF	C	CN
11	MHNK	SKNRZE	KNA1	KUNNR	KEY	1	CN
12	MHNK	SMABER	T047M	MABER	KEY	1	CN
13	MHNK	VZSKZ	T056	VZSKZ	REF	1	CN
14	MHNK	WAERS	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in