SAP DDLOADD R3load-data table for migration Table data and field list

DDLOADD is a standard SAP Table which is used to store R3load-data table for migration data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The DDLOADD table consists of various fields, each holding specific information or linking keys about R3load-data table for migration data available in SAP. These include OBJECTTYPE (ObjType for Location Analysis during Migration with R3load), TABART (Data class in technical settings), WITH_DATA (Flag for empty copies (table DDLOADD)), NAMETABLN (Integer 4 for Table DDLOADD (DB Migration))... 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. .

DDLOADD table Technical Details:

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP DDLOADD 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 DDLOADD 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
OBJECTNAMEObject Name in Object Directory SOBJ_NAMECHAR40SOBJ_NAME
OBJECTTYPEObjType for Location Analysis during Migration with R3load S_OBJ_TYPECHAR5S_OBJ_TYPE
TABARTData class in technical settings TABARTCHAR5Assigned to domainTABART
WITH_DATAFlag for empty copies (table DDLOADD) DDWITHDATACHAR1BOOLEAN
NAMETABLNInteger 4 for Table DDLOADD (DB Migration) DDINTINT410
SUMCHARLNInteger 4 for Table DDLOADD (DB Migration) DDINTINT410
ROW_COUNTNumber of rows of a table EWEFATABRWNUMC16EWEFATABRW
AVG_BLOBLNInteger 4 for Table DDLOADD (DB Migration) DDINTINT410
AVG_ROWLNInteger 4 for Table DDLOADD (DB Migration) DDINTINT410
DBSRCSIZEFloating Point Field for Table DDLOADD (DB Migration) DDFLOATFLTP16(16) FLTP
DDSRCSIZEFloating Point Field for Table DDLOADD (DB Migration) DDFLOATFLTP16(16) FLTP
TARGETSIZEFloating Point Field for Table DDLOADD (DB Migration) DDFLOATFLTP16(16) FLTP

Key field Non-key field



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

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

SELECT SINGLE *
FROM DDLOADD
INTO CORRESPONDING FIELDS OF WA_DDLOADD
WHERE...

How to access SAP table DDLOADD

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

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