SAP MDM_TESTDATA_1 Test Data Directory Table data and field list

MDM_TESTDATA_1 is a standard SAP Table which is used to store Test Data Directory data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The MDM_TESTDATA_1 table consists of various fields, each holding specific information or linking keys about Test Data Directory data available in SAP. These include GUID (Key for Test Data), BUSINESS_OBJECT (Business Object), SOFTWARE_LAYER (Level), CRDATE (Creation Date)... 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. .

MDM_TESTDATA_1 table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP MDM_TESTDATA_1 table 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 MDM_TESTDATA_1 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	T000		MANDT
GUID	Key for Test Data	MDM_GUID_TESTDATA	RAW	16			MDM_GUID_TESTDATA	MDM_GUID_TESTDATA
BUSINESS_OBJECT	Business Object	MDM_BUSINESS_OBJECT	CHAR	2		ALPHA	MDM_BUSINESS_OBJECT
SOFTWARE_LAYER	Level	MDM_LAYER	CHAR	1			MDM_LAYER
CRDATE	Creation Date	MDM_CREATION_DATE	DATS	8			DATUM
CRTIME	Creation Time	MDM_CREATION_TIME	TIMS	6			TIME
CR_BY	User Name in User Master Record	XUBNAME	CHAR	12	USR02		XUBNAME	XUS
NUMBER_OBJECTS	Number of Business Objects	MDM_NUMBER_BUSINESS_OBJECTS	INT4	10
NUMBER_CALLS	Number of Read Calls	MDM_NUMBER_CALLS	INT4	10
LAST_CALL_DATE	Date of Last Read Call	MDM_LAST_CALL_DATE	DATS	8			DATUM
LAST_CALL_TIME	Time of Last Read Call	MDM_LAST_CALL_TIME	TIMS	6			TIME
PRECALC_RESULT	Precalculated Results	MDM_PRECALCULATED_RESULTS	CHAR	1			MDM_PRECALCULATED_RESULTS
LOGNUMBER	Application log: log number	BALOGNR	CHAR	20	BALHDR		BALOGNR

Key field

Non-key field

< MDM_SEL_TRANS_PR - MDM: Storage of Selections and Transfer Segments (Copy) MDM_TRANSFER - Structure for Transfer Segment >

How do I retrieve data from SAP table MDM_TESTDATA_1 using ABAP code

The following ABAP code Example will allow you to do a basic selection on MDM_TESTDATA_1 to SELECT all data from the table
DATA: WA_MDM_TESTDATA_1 TYPE MDM_TESTDATA_1.

SELECT SINGLE *
FROM MDM_TESTDATA_1
INTO CORRESPONDING FIELDS OF WA_MDM_TESTDATA_1
WHERE...

How to access SAP table MDM_TESTDATA_1

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

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