SAP Table DTREG

Downtime Entered

DTREG (Downtime Entered) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DTREG to other SAP tables.

DTREG table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
WERK Plant WERKS_D CHAR 4 0
ARBPL Work center ARBPL CHAR 8 0
DTRNU Internal Counter DTRNR NUMC 10 0
OBJTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
OBJID Object ID of the resource CR_OBJID NUMC 8 0
KAPID Capacity ID KAPID NUMC 8 0
KAPAR Capacity category KAPART CHAR 3 0
DTELI Downtime Element ID DTELI DTELID CHAR 8 0
DTELT Description of the Downtime Element DTELT CHAR 40 0
DTDAT Downtime Date DTDAT DATS 8 0
SCHNR Shift number of the available capacity SCHICHTNR NUMC 1 0
TEAM Person Responsible for Control Area MANNSCHAFT CHAR 8 0
DTEH Downtime Unit DTEH UNIT 3 0
DTDVO Default Duration of Downtimes DTDVO QUAN 13 3
DTDPL Planned Duration of Downtime DTDPL QUAN 13 3
DTDER Duration Entered for Downtimes DTDER QUAN 13 3
ANDAT Creation Date of Downtime DTANDAT DATS 8 0
ANLEG Downtimes Created By DTANLEG CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AENZT Changed At AENZT TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
DELTA Last Changed DTDELTA QUAN 13 3
LTFLAG Long Text Indicator LTFLAG CHAR 1 0
RFLAG Work Center Indicator RFLAG CHAR 1 0

DTREG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DTREG DTELI DTREG MANDT DTELID Downtime Element ID MANDT
DTREG DTELI DTREG DTELI DTELID Downtime Element ID DTELI