SAP ABAP Table MHND_EXTL (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_EXTL   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 SELKEY SYTABIX SYST_LONG INT4 10   0   Row Index of Internal Tables  
68 ANZ INT4 INT4 INT4 10   0   Natural number  
69 DB_ITEM DB_ITEM XFELD CHAR 1   0   Indicator: Item Contains Dunning Block  
70 L_INCL XDUNN XFELD CHAR 1   0   Document to be Dunned  
71 HSORT1 CHAR16 CHAR16 CHAR 16   0   Field of length 16  
72 HSORT2 CHAR16 CHAR16 CHAR 16   0   Field of length 16  
73 HSORT3 CHAR16 CHAR16 CHAR 16   0   Field of length 16  
74 HSORT4 CHAR16 CHAR16 CHAR 16   0   Field of length 16  
75 HSORT5 CHAR16 CHAR16 CHAR 16   0   Field of length 16  
76 VERSN VERSN_MHNK NUM04 NUMC 4   0   Consecutive change number  
77 UNAME UNAME UNAME CHAR 12   0   User Name  
78 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
79 UZEIT UZEIT UZEIT TIMS 6   0   Time  
80 XTEXT DU_XTEXT XFELD CHAR 1   0   Long text exists  
81 COMP_CURR HWAER WAERS CUKY 5   0   Local Currency *
82 .INCLUDE       0   0   Address formating function module transfer structure  
83 ANRED ANRED TEXT15 CHAR 15   0   Title  
84 NAME1 NAME1_ADRS TEXT40 CHAR 40   0   Name 1 of an address  
85 NAME2 NAME2_ADRS TEXT40 CHAR 40   0   Name 2 of an address  
86 NAME3 NAME3_ADRS TEXT40 CHAR 40   0   Name 3 of an address  
87 NAME4 NAME4_ADRS TEXT40 CHAR 40   0   Name 4 of an address  
88 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
89 PFACH PFACH_BAS PFACH CHAR 10   0   PO box  
90 PSTL2 PSTL2_BAS PSTLZ CHAR 10   0   PO Box postal code  
91 PFORT PFORT_ADRS TEXT40 CHAR 40   0   PO Box city  
92 LAND1 LAND1 LAND1 CHAR 3   0   Country Key *
93 PSTLZ PSTLZ_BAS PSTLZ CHAR 10   0   Postal code  
94 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
95 ORT02 ORT01_GP TEXT35 CHAR 35   0   City  
96 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) *
97 SPRAS SPRAS SPRAS LANG 1   0   Language Key *
98 INLND LAND1 LAND1 CHAR 3   0   Country Key *
99 ANZZL ANZEI ANZEI DEC 2   0   Number of lines in address  
100 PRIOR PRITY_ADRS CHAR9 CHAR 9   0   Address lines priority  
101 WAREN WAREN WAREN CHAR 1   0   Delivery address ID  
102 LINE0 LINES LINES CHAR 80   0   Address line  
103 LINE1 LINES LINES CHAR 80   0   Address line  
104 LINE2 LINES LINES CHAR 80   0   Address line  
105 LINE3 LINES LINES CHAR 80   0   Address line  
106 LINE4 LINES LINES CHAR 80   0   Address line  
107 LINE5 LINES LINES CHAR 80   0   Address line  
108 LINE6 LINES LINES CHAR 80   0   Address line  
109 LINE7 LINES LINES CHAR 80   0   Address line  
110 LINE8 LINES LINES CHAR 80   0   Address line  
111 LINE9 LINES LINES CHAR 80   0   Address line  
112 LINEK LINES LINES CHAR 80   0   Address line  
113 LINED LINES LINES CHAR 80   0   Address line  
114 LINED0 LINES LINES CHAR 80   0   Address line  
115 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
116 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service  
117 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
118 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
119 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
120 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 MHND_EXTL BLART T003 BLART REF 1 CN
2 MHND_EXTL BSCHL TBSL BSCHL REF 1 CN
3 MHND_EXTL BUKRS T001 BUKRS KEY 1 CN
4 MHND_EXTL GSBER TGSB GSBER REF C CN
5 MHND_EXTL KUNNR KNA1 KUNNR KEY 1 CN
6 MHND_EXTL LIFNR LFA1 LIFNR KEY 1 CN
7 MHND_EXTL MABER T047M MABER REF C CN
8 MHND_EXTL MANDT T000 MANDT KEY 1 CN
9 MHND_EXTL MANSP T040S MANSP REF C CN
10 MHND_EXTL MSCHL T040 MSCHL REF C CN
11 MHND_EXTL SKNRZE KNA1 KUNNR KEY 1 CN
12 MHND_EXTL SMABER T047M MABER KEY 1 CN
13 MHND_EXTL SMSCHL T040 MSCHL REF C CN
14 MHND_EXTL SPART TSPA SPART REF C CN
15 MHND_EXTL UMSKZ T074U UMSKZ REF C CN
16 MHND_EXTL VKORG TVKO VKORG REF C CN
17 MHND_EXTL VTWEG TVTW VTWEG REF C CN
18 MHND_EXTL WAERS TCURC WAERS REF 1 CN
19 MHND_EXTL ZLSPR T008 ZAHLS REF C CN
History
Last changed by/on SAP  20140121 
SAP Release Created in 46C