SAP ABAP View DOWNTIME_V (View for Downtime Element)

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

View Type	D	Database View
Database View	DOWNTIME_V
Short Description	View for Downtime Element
Root table	DTELID	Downtime Element ID

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	DTELID	DTELID
2	DTCTID
3	DTELTX
4	DTCTTX

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	DTELID	MANDT	JL	EQ				0	0
2	DTCTID	MANDT	JR	EQ			AND	0	0
3	DTCTID	MANDT	JL	EQ				0	0
4	DTCTTX	MANDT	JR	EQ			AND	0	0
5	DTELID	MANDT	JL	EQ				0	0
6	DTELTX	MANDT	JR	EQ			AND	0	0
7	DTCTTX	SPRAS	JL	EQ				0	0
8	DTELTX	SPRAS	JR	EQ			AND	0	0
9	DTELID	DTCTI	JL	EQ				0	0
10	DTCTID	DTCTI	JR	EQ			AND	0	0
11	DTELID	DTELI	JL	EQ				0	0
12	DTELTX	DTELI	JR	EQ			AND	0	0
13	DTCTTX	DTCTI	JL	EQ				0	0
14	DTCTID	DTCTI	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	DTELID	MANDT		☐	MANDT	☐	Client
2	DTELI	DTELID	DTELI		☐	DTELI	☐	Downtime Element ID
3	SPRAS	DTELTX	SPRAS		☐	SPRAS	☐	Language Key
4	DTELT	DTELTX	DTELT		☐	DTELT	☐	Description of the Downtime Element
5	DTCTT	DTCTTX	DTCTT		☐	DTCTTEXT	☐	Downtime Category Description

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in