SAP DIACL_LOG_ENTRY Logbook: log entry Table data and field list

DIACL_LOG_ENTRY is a standard SAP Table which is used to store Logbook: log entry data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The DIACL_LOG_ENTRY table consists of various fields, each holding specific information or linking keys about Logbook: log entry data available in SAP. These include LOGID (Logbook: ID of log entry), STXT (Logbook: log entry short text), COCE (Logbook: flag for certified completion), MDOCM_OPTIME (Measurement Document)... 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. .

DIACL_LOG_ENTRY 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 DIACL_LOG_ENTRY 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 DIACL_LOG_ENTRY 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
LOGIDLogbook: ID of log entry DIACL_LOGIDCHAR12ALPHADIACL_LOGID
STXTLogbook: log entry short text DIACL_STXTCHAR40DIACL_STXT
COCELogbook: flag for certified completion DIACL_COCECHAR1DIACL_COCE
MDOCM_OPTIMEMeasurement Document IMRC_MDOCMCHAR20Assigned to domainALPHAIMRC_MDOCMIMDIMRM
MDOCM_CYCLESMeasurement Document IMRC_MDOCMCHAR20Assigned to domainALPHAIMRC_MDOCMIMDIMRM
STARTTMLogbook: start of operation time DIACL_START_TMTIMS6DIACL_START_TM
ENDTMLogbook: end of operation time DIACL_END_TMTIMS6DIACL_END_TM
STARTDTLogbook: start of operation date DIACL_START_DTDATS8DIACL_START_DT
ENDDTLogbook: end of operation date DIACL_END_DTDATS8DIACL_END_DT
STARTTZLogbook: time zone for start of operation time DIACL_START_TZCHAR6TTZZTZNZONEDIACL_STARTTIMEZONE
ENDTZLogbook: time zone for end of operation time DIACL_END_TZCHAR6TTZZTZNZONEDIACL_ENDTIMEZONE
CYCLESLogbook: number of performed cycles DIACL_CYCLESCHAR22FLTP_INOUT
LETYPLog Entry Type DIACL_LETYPCHAR2DIACL_LETYP_TDIACL_LETYP
OBJNRObject Number for Log Entry DIACL_LEOBJCHAR22Assigned to domainJ_OBJNR
ORIGINLogbook: Flight Origin DIACL_ORIGINCHAR40DIACL_ORIGIN
DESTINATIONLogbook: Flight Destination DIACL_DESTINATIONCHAR40DIACL_DESTINATION
FLIDOrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
FREE_TEXTText (80 Characters) TEXT80CHAR80TEXT80UEB
UTYPELog Entry Usage Type DIACL_LGE_UTYPECHAR1DIACL_LGE_UTYPE

Key field Non-key field



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

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

SELECT SINGLE *
FROM DIACL_LOG_ENTRY
INTO CORRESPONDING FIELDS OF WA_DIACL_LOG_ENTRY
WHERE...

How to access SAP table DIACL_LOG_ENTRY

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

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