DTRESR SAP (Table for Entering Downtimes) Structure details

Dictionary Type: Structure
Description: Table for Entering Downtimes




ABAP Code to SELECT data from DTRESR
Related tables to DTRESR
Access table DTRESR




Structure field list including key, data, relationships and ABAP select examples

DTRESR is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Table for Entering Downtimes" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DTRESR TYPE DTRESR.

The DTRESR table consists of various fields, each holding specific information or linking keys about Table for Entering Downtimes data available in SAP. These include ARBPL (Work center), ARBID (Object ID of the resource), OBJTY (Object types of the CIM resource), RESSOURCE (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. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP DTRESR structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
WERKPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
ARBPLWork center ARBPLCHAR8ARBPLAGR
ARBIDObject ID of the resource CR_OBJIDNUMC8Assigned to domainCR_OBJID
OBJTYObject types of the CIM resource CR_OBJTYCHAR2CR_OBJTY
RESSOURCEResource CR_RESOURCCHAR8ARBPLAGR
VERWEResource category CR_RESSTYPCHAR4Assigned to domainAP_VERWECRA
KTEXTDescription of the work center category APVERWETXTCHAR20TEXT20
KAPIDCapacity ID KAPIDNUMC8Assigned to domainKAPID
KAPARCapacity category KAPARTCHAR3Assigned to domainKAPARTCAA
KATXTDescription of the capacity category KAPARTTEXTCHAR20TEXT20
TEAMPerson Responsible for Control Area MANNSCHAFTCHAR8CHAR8
DATEFROMFrom Date of Data Entry Period CRDTDATEFRDATS8DATUM
DATETOTo Date of Data Entry Period CRDTDATETODATS8DATUM
WOCHEFactory calendar: Week KWEEKACCP6KWEEK
WOCHEXExternal Display for the Week CRDTWEEKEXCHAR7CHAR7
DATRGPeriod DATRGINT25
DTDATDowntime Date DTDATDATS8DATUM
WEEKDAYWeekday WEEK_DAYCHAR10CHAR10
SCHNRShift number of the available capacity SCHICHTNRNUMC1NUM01
DTELIDowntime Element ID DTELICHAR8DTELIDDTELID
DTELTDescription of the Downtime Element DTELTCHAR40DTELTX
DTEHDowntime Unit DTEHUNIT3Assigned to domainCUNITMEINS
DTCTIDowntime Category ID DTCTICHAR8DTCTIDDTCTID
DTCTTDowntime Category Description DTCTTEXTCHAR40TEXT40
DTDERDuration Entered for Downtimes DTDERQUAN13(3) MENG13
DTDVODefault Duration of Downtimes DTDVOQUAN13(3) MENG13
DTDPLPlanned Duration of Downtime DTDPLQUAN13(3) MENG13
DTWEEKSUMTotal Downtime DTSUMQUAN13(3) MENG13
MONDAYMonday MONDAYDATS8DATUM
TUESDAYTuesday TUESDAYDATS8DATUM
WEDNESDAYWednesday WEDNESDAYDATS8DATUM
THURSDAYThursday THURSDAYDATS8DATUM
FRIDAYFriday FRIDAYDATS8DATUM
SATURDAYSaturday SATURDAYDATS8DATUM
SUNDAYSunday SONNTAGDATS8DATUM
DTMODowntime on Monday DTMOQUAN13(3) MENG13
DTDIDowntime on Tuesday DTDIQUAN13(3) MENG13
DTMIDowntime on Wednesday DTMIQUAN13(3) MENG13
DTDODowntime on Thursday DTDOQUAN13(3) MENG13
DTFRDowntime on Friday DTFRQUAN13(3) MENG13
DTSADowntime on Saturday DTSAQUAN13(3) MENG13
DTSODowntime on Sunday DTSOQUAN13(3) MENG13
MARKWSelection indicator FLG_SELCHAR1XFELD
MARKSelection indicator FLG_SELCHAR1XFELD
LTFLAGLong Text Indicator LTFLAGCHAR1CHAR1
REF_WERKSReference plant REF_WERKSCHAR4T001WWERKSRWK
REF_ARBPLResource CR_RESOURCCHAR8ARBPLAGR

Key field Non-key field



How do I retrieve data from SAP structure DTRESR using ABAP code?

As DTRESR is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DTRESR as there is no data to select.

How to access SAP table DTRESR

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!