SAP MHND_EXT Table in S/4 HANA - mhnd Extended
MHND_EXT is a standard SAP Table which is used to store mhnd Extended 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_EXT table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: MHND_EXT
MHND_EXT table structure field list
Below is the full MHND_EXT 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) | Assigned to domain | 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) | Assigned to domain | ZLSCH | ||||
| BKOART | Document Account Type (K=BSIK, D=BSID) | BKOART | CHAR | 1(0) | KOART | |||||
| VNAME | Joint venture | JV_NAME | CHAR | 6(0) | Assigned to domain | ALPHA | JV_NAME | JVV | ||
| EGRUP | Equity group | JV_EGROUP | CHAR | 3(0) | Assigned to domain | ALPHA | JV_EGROUP | GJE | ||
| BTYPE | Payroll Type | JV_BILIND | CHAR | 2(0) | Assigned to domain | 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) | ||||||
| GROUP1 | Character field, length 32 | CHAR32 | CHAR | 32(0) | CHAR32 | |||||
| MGRUP | Key for Dunning Notice Grouping | MGRUP | CHAR | 2(0) | MGRUP | |||||
| KONTO | Customer Number | KUNNR | CHAR | 10(0) | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR | |
| KMANSP | Dunning Block | MANSP | CHAR | 1(0) | MANSP | |||||
| GMVDT | Date of the Legal Dunning Proceedings | GMVDT | DATS | 8(0) | DATUM | |||||
| PSTLZ | Postal Code | PSTLZ | CHAR | 10(0) | PSTLZ | |||||
| ORT01 | City | ORT01_GP | CHAR | 35(0) | TEXT35 | |||||
| STRAS | Street and House Number | STRAS_GP | CHAR | 35(0) | TEXT35 | |||||
| PFACH | PO Box | PFACH | CHAR | 10(0) | PFACH | |||||
| LAND1 | Country Key | LAND1_GP | CHAR | 3(0) | LAND1 | C_LAND1 | LAND1 | |||
| ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3(0) | ZBDXT | |||||
| ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3(0) | ZBDXT | |||||
| ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3(0) | ZBDXT | |||||
| REBZT | Follow-On Document Type | REBZT | CHAR | 1(0) | REBZT | |||||
| NETDT | Net Due Date | NETDT | DATS | 8(0) | DATUM | |||||
| SK1DT | Due Date for Cash Discount 1 | SK1DT | DATS | 8(0) | DATUM | |||||
| SK2DT | Due Date for Cash Discount 2 | SK2DT | DATS | 8(0) | DATUM | |||||
| DMBTR | Amount in local currency | DMBTR | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
| WRBTR | Amount in document currency | WRBTR | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
| MANST | Dunning Level | MAHNS_D | NUMC | 1(0) | MAHNS | |||||
| CMEMO | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1(0) | BOOLE | |||||
| CASGN | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1(0) | BOOLE | |||||
| DELDU | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1(0) | BOOLE | |||||
| APPLK | Application Indicator | APPLK_BF | CHAR | 6(0) | APPLK_BF | |||||
| BLINF | User field for cluster PC (national) | CHAR25 | CHAR | 25(0) | CHAR25 | |||||
| STATUS | Character field, 8 characters long | CHAR8 | CHAR | 8(0) | CHAR8 |
Search for further information about these or an SAP related objects