DOWNTIME_ALV SAP (ALV Structure for Downtimes) Structure details

Dictionary Type: Structure
Description: ALV Structure for Downtimes




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




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

DOWNTIME_ALV 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 "ALV Structure for 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_DOWNTIME_ALV TYPE DOWNTIME_ALV.

The DOWNTIME_ALV table consists of various fields, each holding specific information or linking keys about ALV Structure for Downtimes data available in SAP. These include ARBPL (Work center), DTDAT (Downtime Date), SCHNR (Shift number of the available capacity), DTSUM (Duration Entered for Downtimes).. 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 DOWNTIME_ALV 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
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
ARBPLWork center ARBPLCHAR8ARBPLAGR
DTDATDowntime Date DTDATDATS8DATUM
SCHNRShift number of the available capacity SCHICHTNRNUMC1NUM01
DTSUMDuration Entered for Downtimes DTDERQUAN13(3) MENG13
KEINHDowntime Unit DTEHUNIT3Assigned to domainCUNITMEINS
ANGEBAvailable Capacity KPANG_DTDEC5(2) DTDEC5_2
EINZTOperating Time of the Capacity KPESZ_DTDEC5(2) DTDEC5_2
IDLEHIdle Time IDLEHDEC5(2) DTDEC5_2
GRPRHPlanned Production Hours GRPRHDEC5(2) DTDEC5_2
NTPRHNet Production Hours NTPRHDEC5(2) DTDEC5_2
DOWNTDowntime DOWNTDEC5(2) DTDEC5_2
TARGHComparison Value for Hours TARGHDEC5(2) DTDEC5_2
ELOSSEfficiency Loss ELOSSDEC5(2) DTDEC5_2
EFFICEfficiency EFFICDEC5(2) DTDEC5_2
PERFOPerformance PERFODEC5(2) DTDEC5_2
TEAMPerson Responsible for Control Area MANNSCHAFTCHAR8CHAR8
KAPARCapacity category KAPARTCHAR3Assigned to domainKAPARTCAA

Key field Non-key field



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

As DOWNTIME_ALV 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 DOWNTIME_ALV as there is no data to select.

How to access SAP table DOWNTIME_ALV

Within an ECC or HANA version of SAP you can also view further information about DOWNTIME_ALV 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!