SAP ABAP Table DTRESR (Table for Entering Downtimes)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-PI (Application Component) Production Planning for Process Industries
     ⤷ CRDT (Package) Downtime of the Resource

Basic Data

Table Category	INTTAB	Structure
Structure	DTRESR	Table Relationship Diagram
Short Description	Table for Entering Downtimes

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
2	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
3	ARBID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	*
4	OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
5	RESSOURCE	☐	CR_RESOURC	ARBPL	CHAR	8	0	Resource
6	VERWE	☐	CR_RESSTYP	AP_VERWE	CHAR	4	0	Resource category	*
7	KTEXT	☐	APVERWETXT	TEXT20	CHAR	20	0	Description of the work center category
8	KAPID	☐	KAPID	KAPID	NUMC	8	0	Capacity ID	*
9	KAPAR	☐	KAPART	KAPART	CHAR	3	0	Capacity category	*
10	KATXT	☐	KAPARTTEXT	TEXT20	CHAR	20	0	Description of the capacity category
11	TEAM	☐	MANNSCHAFT	CHAR8	CHAR	8	0	Person Responsible for Control Area
12	DATEFROM	☐	CRDTDATEFR	DATUM	DATS	8	0	From Date of Data Entry Period
13	DATETO	☐	CRDTDATETO	DATUM	DATS	8	0	To Date of Data Entry Period
14	WOCHE	☐	KWEEK	KWEEK	ACCP	6	0	Factory calendar: Week
15	WOCHEX	☐	CRDTWEEKEX	CHAR7	CHAR	7	0	External Display for the Week
16	DATRG	☐	DATRG		INT2	5	0	Period
17	DTDAT	☐	DTDAT	DATUM	DATS	8	0	Downtime Date
18	WEEKDAY	☐	WEEK_DAY	CHAR10	CHAR	10	0	Weekday
19	SCHNR	☐	SCHICHTNR	NUM01	NUMC	1	0	Shift number of the available capacity
20	DTELI	☐	DTELI	DTELID	CHAR	8	0	Downtime Element ID	DTELID
21	DTELT	☐	DTELT	DTELTX	CHAR	40	0	Description of the Downtime Element
22	DTEH	☐	DTEH	MEINS	UNIT	3	0	Downtime Unit	*
23	DTCTI	☐	DTCTI	DTCTID	CHAR	8	0	Downtime Category ID	DTCTID
24	DTCTT	☐	DTCTTEXT	TEXT40	CHAR	40	0	Downtime Category Description
25	DTDER	☐	DTDER	MENG13	QUAN	13	3	Duration Entered for Downtimes
26	DTDVO	☐	DTDVO	MENG13	QUAN	13	3	Default Duration of Downtimes
27	DTDPL	☐	DTDPL	MENG13	QUAN	13	3	Planned Duration of Downtime
28	DTWEEKSUM	☐	DTSUM	MENG13	QUAN	13	3	Total Downtime
29	MONDAY	☐	MONDAY	DATUM	DATS	8	0	Monday
30	TUESDAY	☐	TUESDAY	DATUM	DATS	8	0	Tuesday
31	WEDNESDAY	☐	WEDNESDAY	DATUM	DATS	8	0	Wednesday
32	THURSDAY	☐	THURSDAY	DATUM	DATS	8	0	Thursday
33	FRIDAY	☐	FRIDAY	DATUM	DATS	8	0	Friday
34	SATURDAY	☐	SATURDAY	DATUM	DATS	8	0	Saturday
35	SUNDAY	☐	SONNTAG	DATUM	DATS	8	0	Sunday
36	DTMO	☐	DTMO	MENG13	QUAN	13	3	Downtime on Monday
37	DTDI	☐	DTDI	MENG13	QUAN	13	3	Downtime on Tuesday
38	DTMI	☐	DTMI	MENG13	QUAN	13	3	Downtime on Wednesday
39	DTDO	☐	DTDO	MENG13	QUAN	13	3	Downtime on Thursday
40	DTFR	☐	DTFR	MENG13	QUAN	13	3	Downtime on Friday
41	DTSA	☐	DTSA	MENG13	QUAN	13	3	Downtime on Saturday
42	DTSO	☐	DTSO	MENG13	QUAN	13	3	Downtime on Sunday
43	MARKW	☐	FLG_SEL	XFELD	CHAR	1	0	Selection indicator
44	MARK	☐	FLG_SEL	XFELD	CHAR	1	0	Selection indicator
45	LTFLAG	☐	LTFLAG	CHAR1	CHAR	1	0	Long Text Indicator
46	REF_WERKS	☐	REF_WERKS	WERKS	CHAR	4	0	Reference plant	T001W
47	REF_ARBPL	☐	CR_RESOURC	ARBPL	CHAR	8	0	Resource

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DTRESR	DTCTI	DTCTID	DTCTI
2	DTRESR	DTELI	DTELID	DTELI
3	DTRESR	REF_WERKS	T001W	WERKS
4	DTRESR	WERK	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in