SAP ABAP Table MHND_EXT (mhnd Extended)

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	INTTAB	Structure
Structure	MHND_EXT	Table Relationship Diagram
Short Description	mhnd Extended

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in	46C