MHND_EXTL SAP (mhnd Extended) Structure details

Dictionary Type: Structure
Description: mhnd Extended




ABAP Code to SELECT data from MHND_EXTL
Related tables to MHND_EXTL
Access table MHND_EXTL




Structure field list including key, data, relationships and ABAP select examples

MHND_EXTL is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "mhnd Extended" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MHND_EXTL TYPE MHND_EXTL.

The MHND_EXTL table consists of various fields, each holding specific information or linking keys about mhnd Extended data available in SAP. These include MANDT (Client), LAUFD (Date on Which the Program Is to Be Run), LAUFI (Additional Identification), KOART (Account Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP MHND_EXTL structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
LAUFDDate on Which the Program Is to Be Run LAUFDDATS8DATUM
LAUFIAdditional Identification LAUFICHAR6LAUFI
KOARTAccount Type KOARTCHAR1KOART
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
CPDKYSort field for one-time accounts CPDKYCHAR16TEXT16
SKNRZEHead office account number (in branch accounts) KNRZECHAR10KNA1ALPHAKUNNR
SMABERDunning Area MABERCHAR2T047MMABER
SMAHSKDunning level MAHNS_DNUMC1MAHNS
BBUKRSDocument company code BBUKRSCHAR4Assigned to domainBUKRS
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
ZUONRAssignment Number DZUONRCHAR18ZUONR
BUDATPosting Date in the Document BUDATDATS8DATUM
BLDATDocument Date in Document BLDATDATS8DATUM
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
FAEDTDue Date for Net Payment NETDTDATS8DATUM
BLARTDocument Type BLARTCHAR2T003BLARTBAR
BSCHLPosting Key BSCHLCHAR2TBSLBSCHL
MSCHLDunning key MSCHLCHAR1T040MSCHL
SMSCHLDunning key if separate printout is active; otherwise blank MSCHL_MHNDCHAR1T040MSCHL
MANSPDunning block MANSPCHAR1T040SMANSP
MABERDunning Area MABERCHAR2T047MMABER
MADATLast dunned on MADATDATS8DATUM
MAHNSOld dunning level MAHNS_ALTNUMC1MAHNS
MAHNNDunning level MAHNS_DNUMC1MAHNS
ZLSPRPayment Block Key DZLSPRCHAR1T008ZAHLSSPE
XZALBIndicator: items payable (not to be dunned) ? XZALB_MHNDCHAR1XFELD
XFAELIndicator: line items overdue ? XFAELCHAR1XFELD
VERZNDays in Arrears by Net Due Date VERZNDEC5WRTV3
UMSKSSpecial G/L Transaction Type UMSKSCHAR1UMSKS
UMSKZSpecial G/L Indicator UMSKZCHAR1T074UUMSKZ
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
DMSHBAmount in Local Currency with +/- Signs DMSHBCURR13(2) WRTV7
WRSHBForeign Currency Amount with Signs (+/-) WRSHBCURR13(2) WRTV7
ZINSTNumber of days for which interest is calculated DZINSTDEC5WRTV3
ZINSSInterest rate DZINSSDEC7(3) PRZ43
ZSBTRInterest amount in local currency DZSBTRCURR13(2) WRTV7
WZSBTInterest amount in foreign currency WZSBTCURR13(2) WRTV7
FILKDAccount Number of the Branch FILKDCHAR10ALPHAMAXKK
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
XZINSIndicator: Do not display interest in the item XZINS_MHNDCHAR1XFELD
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
VERTNContract Number RANLCHAR13ALPHARANLRAN
VERTTContract Type RANTYPCHAR1RANTYP
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
BKOARTDocument account type (K=BSIK, D=BSID) BKOARTCHAR1KOART
VNAMEJoint Venture JV_NAMECHAR6Assigned to domainALPHAJV_NAMEJVV
EGRUPEquity group JV_EGROUPCHAR3Assigned to domainALPHAJV_EGROUPGJE
BTYPEPayroll Type JV_BILINDCHAR2Assigned to domainALPHAJV_BILIND
XREF1Business partner reference key XREF1CHAR12CHAR12
XREF2Business partner reference key XREF2CHAR12CHAR12
ZINKZPublic Sector Industry Solution: Exempt from Interest Calc. MHND_ZINKZCHAR2
SELKEYRow Index of Internal Tables SYTABIXINT410SYST_LONG
ANZNatural Number INT4INT410INT4
DB_ITEMIndicator: Item Contains Dunning Block DB_ITEMCHAR1XFELD
L_INCLDocument to be Dunned XDUNNCHAR1XFELD
HSORT1Field of length 16 CHAR16CHAR16CHAR16
HSORT2Field of length 16 CHAR16CHAR16CHAR16
HSORT3Field of length 16 CHAR16CHAR16CHAR16
HSORT4Field of length 16 CHAR16CHAR16CHAR16
HSORT5Field of length 16 CHAR16CHAR16CHAR16
VERSNConsecutive change number VERSN_MHNKNUMC4NUM04
UNAMEUser Name UNAMECHAR12UNAME
AEDATChanged On AEDATDATS8DATUM
UZEITTime UZEITTIMS6UZEIT
XTEXTLong text exists DU_XTEXTCHAR1XFELD
COMP_CURRLocal Currency HWAERCUKY5Assigned to domainWAERS
ANREDTitle ANREDCHAR15TEXT15
NAME1Name 1 of an address NAME1_ADRSCHAR40TEXT40
NAME2Name 2 of an address NAME2_ADRSCHAR40TEXT40
NAME3Name 3 of an address NAME3_ADRSCHAR40TEXT40
NAME4Name 4 of an address NAME4_ADRSCHAR40TEXT40
STRASHouse number and street STRAS_GPCHAR35TEXT35
PFACHPO box PFACH_BASCHAR10PFACH
PSTL2PO Box postal code PSTL2_BASCHAR10PSTLZ
PFORTPO Box city PFORT_ADRSCHAR40TEXT40
LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
PSTLZPostal code PSTLZ_BASCHAR10PSTLZ
ORT01City ORT01_GPCHAR35TEXT35
ORT02City ORT01_GPCHAR35TEXT35
REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
SPRASLanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
INLNDCountry Key LAND1CHAR3Assigned to domainLAND1LND
ANZZLNumber of lines in address ANZEIDEC2ANZEI
PRIORAddress lines priority PRITY_ADRSCHAR9CHAR9
WARENDelivery address ID WARENCHAR1WAREN
LINE0Address line LINESCHAR80LINES
LINE1Address line LINESCHAR80LINES
LINE2Address line LINESCHAR80LINES
LINE3Address line LINESCHAR80LINES
LINE4Address line LINESCHAR80LINES
LINE5Address line LINESCHAR80LINES
LINE6Address line LINESCHAR80LINES
LINE7Address line LINESCHAR80LINES
LINE8Address line LINESCHAR80LINES
LINE9Address line LINESCHAR80LINES
LINEKAddress line LINESCHAR80LINES
LINEDAddress line LINESCHAR80LINES
LINED0Address line LINESCHAR80LINES
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME

Key field Non-key field



How do I retrieve data from SAP structure MHND_EXTL using ABAP code?

As MHND_EXTL is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MHND_EXTL as there is no data to select.

How to access SAP table MHND_EXTL

Within an ECC or HANA version of SAP you can also view further information about MHND_EXTL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!