SAP MHND Table in S/4 HANA - Dunning Data
MHND is a standard SAP Table which is used to store Dunning Data data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MHND table(ECC)
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Transparent table
Database Table: MHND
MHND table structure field list
Below is the full MHND field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
| LAUFD | Date on Which the Program Is to Be Run | LAUFD | DATS | 8(0) | DATUM | |||||
| LAUFI | Additional Identification | LAUFI | CHAR | 6(0) | LAUFI | |||||
| KOART | Account type | KOART | CHAR | 1(0) | KOART | |||||
| BUKRS | Company Code | BUKRS | CHAR | 4(0) | T001 | BUKRS | BUK | C_T001 | BUKRS | |
| KUNNR | Customer Number | KUNNR | CHAR | 10(0) | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | LFA1 | ALPHA | LIFNR | LIF | KRED_C | LIFNR |
| CPDKY | Sort Field for One-Time Accounts | CPDKY | CHAR | 16(0) | TEXT16 | |||||
| SKNRZE | Head office account number (in branch accounts) | KNRZE | CHAR | 10(0) | KNA1 | ALPHA | KUNNR | |||
| SMABER | Dunning Area | MABER | CHAR | 2(0) | T047M | MABER | ||||
| SMAHSK | Dunning Level | MAHNS_D | NUMC | 1(0) | MAHNS | |||||
| BBUKRS | Document Company Code | BBUKRS | CHAR | 4(0) | BUKRS | |||||
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3(0) | BUZEI | BUZ | ||||
| GSBER | Business Area | GSBER | CHAR | 4(0) | TGSB | GSBER | GSB | |||
| XBLNR | Reference Document Number | XBLNR1 | CHAR | 16(0) | XBLNR1 | |||||
| ZUONR | Assignment number | DZUONR | CHAR | 18(0) | ZUONR | |||||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8(0) | DATUM | |||||
| BLDAT | Document Date in Document | BLDAT | DATS | 8(0) | DATUM | |||||
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8(0) | DATUM | |||||
| ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8(0) | DATUM | |||||
| FAEDT | Net Due Date | NETDT | DATS | 8(0) | DATUM | |||||
| BLART | Document type | BLART | CHAR | 2(0) | T003 | BLART | BAR | |||
| BSCHL | Posting Key | BSCHL | CHAR | 2(0) | TBSL | BSCHL | ||||
| MSCHL | Dunning Key | MSCHL | CHAR | 1(0) | T040 | MSCHL | ||||
| SMSCHL | Dunning Key If Separate Printout Is Active; Otherwise Blank | MSCHL_MHND | CHAR | 1(0) | T040 | MSCHL | ||||
| MANSP | Dunning Block | MANSP | CHAR | 1(0) | T040S | MANSP | ||||
| MABER | Dunning Area | MABER | CHAR | 2(0) | T047M | MABER | ||||
| MADAT | Date of Last Dunning Notice | MADAT | DATS | 8(0) | DATUM | |||||
| MAHNS | Old Dunning Level | MAHNS_ALT | NUMC | 1(0) | MAHNS | |||||
| MAHNN | Dunning Level | MAHNS_D | NUMC | 1(0) | MAHNS | |||||
| ZLSPR | Payment Block Key | DZLSPR | CHAR | 1(0) | T008 | ZAHLS | SPE | |||
| XZALB | Indicator: Items Payable (Not to Be Dunned) ? | XZALB_MHND | CHAR | 1(0) | XFELD | |||||
| XFAEL | Indicator: Line Items Overdue ? | XFAEL | CHAR | 1(0) | XFELD | |||||
| VERZN | Days in Arrears by Net Due Date | VERZN | DEC | 5(0) | WRTV3 | |||||
| UMSKS | Special G/L Transaction Type | UMSKS | CHAR | 1(0) | UMSKS | |||||
| UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1(0) | T074U | UMSKZ | ||||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1(0) | SHKZG | |||||
| WAERS | Currency Key | WAERS | CUKY | 5(0) | TCURC | WAERS | FWS | |||
| DMSHB | Amount in Local Currency with +/- Signs | DMSHB | CURR | 23(2) | AC132 | AFLE13D2O18S_TO_23D2O31S | ||||
| WRSHB | Foreign Currency Amount with Signs (+/-) | WRSHB | CURR | 23(2) | AC132 | AFLE13D2O18S_TO_23D2O31S | ||||
| ZINST | Number of Days for Which Interest Is Calculated | DZINST | DEC | 5(0) | WRTV3 | |||||
| ZINSS | Interest rate | DZINSS | DEC | 7(3) | PRZ43 | |||||
| ZSBTR | Interest Amount in Local Currency | DZSBTR | CURR | 23(2) | AC132 | AFLE13D2O18S_TO_23D2O31S | ||||
| WZSBT | Interest Amount in Foreign Currency | WZSBT | CURR | 23(2) | AC132 | AFLE13D2O18S_TO_23D2O31S | ||||
| FILKD | Account Number of the Branch | FILKD | CHAR | 10(0) | ALPHA | MAXKK | ||||
| VKORG | Sales Organization | VKORG | CHAR | 4(0) | TVKO | VKORG | VKO | C_VKORG | VKORG | |
| VTWEG | Distribution Channel | VTWEG | CHAR | 2(0) | TVTW | VTWEG | VTW | C_VTWEG | VTWEG | |
| SPART | Division | SPART | CHAR | 2(0) | TSPA | SPART | SPA | C_SPART | SPART | |
| XZINS | Indicator: Do Not Display Interest in the Item | XZINS_MHND | CHAR | 1(0) | XFELD | |||||
| REBZG | Document No. of the Invoice to Which the Transaction Belongs | REBZG | CHAR | 10(0) | ALPHA | BELNR | ||||
| REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4(0) | GJAHR | GJAHR | ||||
| REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3(0) | BUZEI | |||||
| VERTN | Contract Number | RANL | CHAR | 13(0) | ALPHA | RANL | RAN | |||
| VERTT | Contract Type | RANTYP | CHAR | 1(0) | RANTYP | |||||
| ZLSCH | Payment Method | DZLSCH | CHAR | 1(0) | ZLSCH | |||||
| BKOART | Document Account Type (K=BSIK, D=BSID) | BKOART | CHAR | 1(0) | KOART | |||||
| VNAME | Joint venture | JV_NAME | CHAR | 6(0) | ALPHA | JV_NAME | JVV | |||
| EGRUP | Equity group | JV_EGROUP | CHAR | 3(0) | ALPHA | JV_EGROUP | GJE | |||
| BTYPE | Payroll Type | JV_BILIND | CHAR | 2(0) | ALPHA | JV_BILIND | ||||
| XREF1 | Business Partner Reference Key | XREF1 | CHAR | 12(0) | CHAR12 | |||||
| XREF2 | Business Partner Reference Key | XREF2 | CHAR | 12(0) | CHAR12 | |||||
| ZINKZ | Public Sector Industry Solution: Exempt from Interest Calc. | MHND_ZINKZ | CHAR | 2(0) |
Search for further information about these or an SAP related objects