SAP DTEFW Downtime Values Entered Table data and field list

DTEFW is a standard SAP Table which is used to store Downtime Values Entered data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The DTEFW table consists of various fields, each holding specific information or linking keys about Downtime Values Entered data available in SAP. These include DTRNU (Internal Counter), DTELI (Downtime Element ID), OBJTY (Object types of the CIM resource), OBJID (Object ID of the resource)... 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. .

DTEFW 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 DTEFW 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 DTEFW 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
DTRNUInternal Counter DTRNRNUMC10DT_COUNT
DTELIDowntime Element ID DTELICHAR8DTELIDDTELID
OBJTYObject types of the CIM resource CR_OBJTYCHAR2CR_OBJTY
OBJIDObject ID of the resource CR_OBJIDNUMC8Assigned to domainCR_OBJID
KAPIDCapacity ID KAPIDNUMC8Assigned to domainKAPID
DTDATDowntime Date DTDATDATS8DATUM
SCHNRShift number of the available capacity SCHICHTNRNUMC1NUM01
TEAMPerson Responsible for Control Area MANNSCHAFTCHAR8CHAR8
DTEHDowntime Unit DTEHUNIT3Assigned to domainCUNITMEINS
DTDERDuration Entered for Downtimes DTDERQUAN13(3) MENG13
ANDATCreation Date of Downtime DTANDATDATS8DATUM
ANLEGDowntimes Created By DTANLEGCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AENZTChanged At AENZTTIMS6TIME
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
DELTALast Changed DTDELTAQUAN13(3) MENG13
LTFLAGLong Text Indicator LTFLAGCHAR1CHAR1
RFLAGWork Center Indicator RFLAGCHAR1CHAR1
KAPARCapacity category KAPARTCHAR3Assigned to domainKAPARTCAA

Key field Non-key field



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

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

SELECT SINGLE *
FROM DTEFW
INTO CORRESPONDING FIELDS OF WA_DTEFW
WHERE...

How to access SAP table DTEFW

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

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