DTEFW SAP table for – Downtime Values Entered

Here we would like to draw your attention to DTEFW table in SAP. As we know it is being mainly used with the SAP PP-PI (Production Planning for Process Industries – PP) component which is coming under PP module (Production Planning). DTEFW is a SAP standard transparent table used for storing Downtime Values Entered related data in SAP. It comes under the package CRDT.

SAP DTEFW table

Table DTEFW technical data

TableDTEFW
Data storingDowntime Values Entered
ModulePP
ComponentPP-PI
SAP PackageCRDT
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP DTEFW Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in DTEFW table.

  • DTEH
    Its data type is C (Character String) with field length 3
  • ANDAT : Date record created on
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • DELTA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LTFLAG
    Its data type is C (Character String) with field length 1
  • RFLAG
    Its data type is C (Character String) with field length 1
  • DTELI
    Its data type is C (Character String) with field length 8
  • OBJID : Accrual Object (Internal Display in Form of a GUID)
    Its data type is N (Character String with Digits Only) with field length 8
  • KAPID : Capacity ID
    Its data type is N (Character String with Digits Only) with field length 8
  • DTDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SCHNR
    Its data type is N (Character String with Digits Only) with field length 1