DWN04 SAP (Download : Operations) Structure details
Description: Download : Operations
Structure field list including key, data, relationships and ABAP select examples
DWN04 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 "Download : Operations" 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_DWN04 TYPE DWN04.
The DWN04 table consists of various fields, each holding specific information or linking keys about Download : Operations data available in SAP. These include AUFNR (Order Number), APLFL (Sequence), VORNR (Operation/Activity Number), UVORN (Suboperation).. 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 DWN04 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 |
RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | CO_RUECK | RCK | |||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
APLFL | Sequence | PLNFOLGE | CHAR | 6 | ALPHA | PLNFOLGE | |||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
UVORN | Suboperation | UVORN | CHAR | 4 | NUMCV | VORNR | |||
SPLIT | Split Number | CIBD_SPLIT | NUMC | 3 | NUMC3 | ||||
KAPAR | Capacity category | KAPART | CHAR | 3 | Assigned to domain | KAPART | CAA | ||
BDEGR | Grouping for Connection to Subsystem | BDEGR | CHAR | 3 | Assigned to domain | BDEGR | |||
MGVRG | Standard quantity in ASCII | A_MGVRG | CHAR | 15 | CHAR15 | ||||
ASVRG | Scrap quantity in ASCII | A_ASVRG | CHAR | 15 | CHAR15 | ||||
MEINH | Unit of Measure for Activity/Operation | VORME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UMREN | Denominator for conversion | A_UMREN | CHAR | 7 | CHAR7 | ||||
UMREZ | Numerator for conversion | A_UMREZ | CHAR | 7 | CHAR7 | ||||
KMEIN | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UNTMG | Underdelivery quantity | A_UNTMG | CHAR | 15 | CHAR15 | ||||
UNTLI | Check underdelivery tolerance in order | UNTLI | CHAR | 1 | CO_UNTLI | ||||
UEBMG | Overdelivery quantity | A_UEBMG | CHAR | 15 | CHAR15 | ||||
UEBLI | Check overdelivery tolerance in order | CO_UEBLI | CHAR | 1 | CO_UEBLI | ||||
MRFLG | Message Type | MSGTY | CHAR | 1 | MSGAR | ||||
USR00 | User field with 20 characters | USRCHAR20 | CHAR | 20 | USRCHAR20 | ||||
USR01 | User field with 20 characters | USRCHAR20 | CHAR | 20 | USRCHAR20 | ||||
USR04 | User field 3 in operation download | A_USR03 | CHAR | 15 | CHAR15 | ||||
USE04 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ACTI1 | Standard value in ASCII | A_ACTI | CHAR | 15 | CHAR15 | ||||
UNIT1 | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ACTI2 | Standard value in ASCII | A_ACTI | CHAR | 15 | CHAR15 | ||||
UNIT2 | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ACTI3 | Standard value in ASCII | A_ACTI | CHAR | 15 | CHAR15 | ||||
UNIT3 | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ACTI4 | Standard value in ASCII | A_ACTI | CHAR | 15 | CHAR15 | ||||
UNIT4 | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ACTI5 | Standard value in ASCII | A_ACTI | CHAR | 15 | CHAR15 | ||||
UNIT5 | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ACTI6 | Standard value in ASCII | A_ACTI | CHAR | 15 | CHAR15 | ||||
UNIT6 | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LMNGA | Actual yield in ASCII | A_LMNGA | CHAR | 15 | CHAR15 | ||||
XMNGA | ACTUAL scrap quantity in ASCII | A_XMNGA | CHAR | 15 | CHAR15 | ||||
RMNGA | Rework quantity in ASCII | A_RMNGA | CHAR | 15 | CHAR15 | ||||
STATV | Object status | J_STATUS | CHAR | 5 | J_STATUS | ||||
STATA | Status field in operation download (time ticket or event) | STATACHAR | CHAR | 1 | STATACHAR | ||||
STATE | Operation download: Partial finish or finish status | STATECHAR | CHAR | 1 | STATECHAR | ||||
ISM01 | Actual value | ISM0X | CHAR | 15 | CHAR15 | ||||
ISM02 | Actual value | ISM0X | CHAR | 15 | CHAR15 | ||||
ISM03 | Actual value | ISM0X | CHAR | 15 | CHAR15 | ||||
ISM04 | Actual value | ISM0X | CHAR | 15 | CHAR15 | ||||
ISM05 | Actual value | ISM0X | CHAR | 15 | CHAR15 | ||||
ISM06 | Actual value | ISM0X | CHAR | 15 | CHAR15 | ||||
LEK01 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
LEK02 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
LEK03 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
LEK04 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
LEK05 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
LEK06 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
ARBPI | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
WERKI | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
ISMNW | Actual Labor Value in ASCII | A_ISMNW | CHAR | 15 | CHAR15 | ||||
ISMNE | Unit for work | ARBEITE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ARBEI | Character field of 9 digits | CHAR9 | CHAR | 9 | CHAR9 | ||||
ARBEH | Unit of work | ARBEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OFMNW | Forecast Labor in ASCII | A_OFMNW | CHAR | 9 | CHAR9 | ||||
OFMNE | Unit of measure for remaining work | OFMNE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LEKNW | Indicator: No Remaining Work Expected | LEKNW | CHAR | 1 | XFELD | ||||
RUEST | Setup time in ASCII | A_RUEST | CHAR | 15 | CHAR15 | ||||
RSTZE | Unit of measure for setup time | RSTZE | UNIT | 3 | CUNIT | EINHEIT | |||
BEARZ | Processing time in ASCII | A_BEARZ | CHAR | 15 | CHAR15 | ||||
BEAZE | Unit of measure for processing time | BEAZE | UNIT | 3 | CUNIT | EINHEIT | |||
ABRUE | Teardown time in ASCII | A_ARUZE | CHAR | 15 | CHAR15 | ||||
ARUZE | Unit of measure for teardown | ARUZE | UNIT | 3 | CUNIT | EINHEIT | |||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
MAUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
MAPLFL | Sequence number | APLFL | CHAR | 6 | ALPHA | PLNFOLGE | |||
MVORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
LAUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
BEZFL | Reference sequence for a sequence | BEZFL | CHAR | 6 | ALPHA | PLNFOLGE | |||
VORNR1 | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
VORNR2 | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
FSAVD | Earliest scheduled start: Execution (date) | FSAVD | DATS | 8 | DATUM | ||||
FSAVZ | Earliest scheduled start: Execution (time) | FSAVZ | TIMS | 6 | ATIME | ||||
SSEDD | Latest scheduled finish: Execution (date) | SSEDD | DATS | 8 | DATUM | ||||
SSEDZ | Latest scheduled finish: Execution (time) | SSEDZ | TIMS | 6 | ATIME | ||||
PROZ1 | Standard value in ASCII | A_ACTI | CHAR | 15 | CHAR15 | ||||
UNIP1 | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS |
Key field | Non-key field |
How do I retrieve data from SAP structure DWN04 using ABAP code?
As DWN04 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 DWN04 as there is no data to select.How to access SAP table DWN04
Within an ECC or HANA version of SAP you can also view further information about DWN04 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects