SAP LIME_EXTDATA MIGO External Data for MTQ Table data and field list

LIME_EXTDATA 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 "MIGO External Data for MTQ" 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_LIME_EXTDATA TYPE LIME_EXTDATA.

The LIME_EXTDATA table consists of various fields, each holding specific information or linking keys about MIGO External Data for MTQ data available in SAP. These include MANDT (Client), MBLNR (Number of Material Document), MJAHR (Material Document Year), LINE_ID (Unique identification of document line)... 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. .

LIME_EXTDATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the LIME_EXTDATA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
MBLNR	Number of Material Document	MBLNR	CHAR	10		ALPHA	BELNR	MBN
MJAHR	Material Document Year	MJAHR	NUMC	4		GJAHR	GJAHR	MJA
LINE_ID	Unique identification of document line	MB_LINE_ID	NUMC	6			MB_LINE_ID
ZEILE	Item in Material Document	MBLPO	NUMC	4			MBLPO	POS
MATNR	Material Number	MATNR	CHAR	18	Assigned to domain	MATN1	MATNR	MAT	S_MAT1
BWART	Movement Type (Inventory Management)	BWART	CHAR	3	Assigned to domain		BWART	BWA
WERKS	Plant	WERKS_D	CHAR	4	Assigned to domain		WERKS	WRK	H_T001W_C
LGORT	Storage Location	LGORT_D	CHAR	4	Assigned to domain		LGORT	LAG
INSMK	Stock Type	MB_INSMK	CHAR	1			MB_INSMK
SOBKZ	Special Stock Indicator	SOBKZ	CHAR	1	Assigned to domain		SOBKZ
XAUTO	Item automatically created	MB_XAUTO	CHAR	1			MB_XAUTO
LIFNR	Vendor Account Number	ELIFN	CHAR	10	Assigned to domain	ALPHA	LIFNR	LIF	KRED_C
KUNNR	Account Number of Customer	EKUNN	CHAR	10	Assigned to domain	ALPHA	KUNNR	KUN
BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
UMWRK	Receiving/Issuing Plant	UMWRK	CHAR	4	Assigned to domain		WERKS
UMLGO	Receiving/Issuing Storage Location	UMLGO	CHAR	4	Assigned to domain		LGORT
UMMAT	Receiving/Issuing Material	UMMAT	CHAR	18	Assigned to domain	MATN1	MATNR
CHARG	Batch Number	CHARG_D	CHAR	10	Assigned to domain		CHARG	CHA
QUAN_IO	Checkbox	XFELD	CHAR	1			XFELD
UNIT	Obsolete as of AP 7.0 Stock Unit of Measure	/LIMEB/UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
QUAN	Obsolete as of AP 7.0 Stock quantity	/LIMEB/QUANTITY	QUAN	31(14)			/LIMEB/QUANTITY

Key field

Non-key field

< LIKPVB - Reference structure for XLIKP/YLIKP LIME_MB - Header Data to Map Material Document >

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

As LIME_EXTDATA 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 LIME_EXTDATA as there is no data to select.

How to access SAP table LIME_EXTDATA

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

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