Value-Added Service Orders
DataStore object: 0WM_DS08
This DataStore object contains value-added service orders extracted from EWM. This DataStore object comprises multiple rows due to the data model it is based on. A value-added service order can contain 1 to n activities. An activity can have 1 to n items and 0 to n auxiliary products. The following information is extracted, for example:
Warehouse number (0WM_LGNUM)
VAS order number (0WM_VAS_ID)
Order type (0WM_VASTYPE)
Order category (0WM_VASCAT)
Overall status of the VAS order (0WM_VASSTAT)
Packaging specification used (0WM_PSID)
Effort code at order header level (0WM_EFFCODE)
Sequence number of activity (0WM_ACSEQ)
Work center where an activity was performed (0WM_WRKCNTR)
External process step of an activity (0WM_PROCS)
Effort code at activity level (0WM_EFFCODE)
Planned start and end dates/times of activities
Actual start and end dates/times of activities
Sequence number of the item of an activity (0WM_ITSEQ)
Product of the item (0WM_ITMATNR)
Planned quantity of the product of an item (0WM_ITPLQTY)
Actual quantity of the product of an item (0WM_ITCPQTY)
Sequence number of the auxiliary product of an activity (0WM_AXSEQ)
Auxiliary product (0WM_AXMATNR)
Planned quantity of an auxiliary product (0WM_AXPLQTY)
Consumed quantity of an auxiliary product (0WM_AXPOQTY)
Example of a value-added service order
Warehouse number (LGNUM) | VASID | VASSTAT | Activity sequence number (ACSEQ) | Ext. process step (PROCS) | Effort code (ACEFCDE) | Work center (WRKCNTR) | Item sequence number (ITSEQ) | Prod. item I (TMATNR) | Prod. item planned qty (ITPLQTY) | Prod. item actual qty (ITCPQTY) | Aux. prod. sequence number (AXSEQ) | Aux. product (AXMATNR) | Aux. product planned qty (AXPLQTY) | Consumed qty aux. product (AXPOQTY) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0001 | 55 | C (Closed) | 1 | Oiling | EF1 | WVI1 | 1 | 4711 (Clutch disk) | 5 | 5 | ||||
0001 | 55 | C | 1 | Oiling | EF1 | WVI1 | 1 | 0815 | 2 | 1 | ||||
0001 | 55 | C | 2 | Pack | WVI2 | 1 | 4711 | 5 | 5 | |||||
0001 | 55 | C | 2 | Pack | WVI2 | 1 | 0816 | 2 | 2 | |||||
0001 | 55 | C | 2 | Pack | WVI2 | 2 | 0817 | 4 | 4 |
Structure
Delta Update
The following delta update is supported for this DataStore object:
Delta update:
DataSource:
Data Modeling
Object Type | Name | Technical Name |
|---|---|---|
Characteristic | Activity Sequence Number | 0WM_ACSEQ |
Characteristic | Aux. Product Sequence Number | 0WM_AXSEQ |
Characteristic | Item Sequence Number | 0WM_ITSEQ |
Characteristic | Warehouse Number | 0WM_LGNUM |
Characteristic | Value Added Service Order | 0WM_VAS_ID |
Object Type | Name | Technical Name |
|---|---|---|
Data packet characteristic | BW Delta Process: Update Mode | 0RECORDMODE |
Characteristic | Activity Changed by | 0WM_ACCHBY |
Key figure | Activity Completed Quantity | 0WM_ACCPQTY |
Key figure | Actual Excecution Duration | 0WM_ACDUR |
Characteristic | Activity Effort Code | 0WM_ACEFCDE |
Characteristic | Actual End Time | 0WM_ACEND |
Characteristic | Activity Kitting | 0WM_ACKIT |
Characteristic | Activity Product | 0WM_ACMATNR |
Characteristic | Activity Planned End Time | 0WM_ACPLEND |
Key figure | Activity Planned Quantity | 0WM_ACPLQTY |
Characteristic | Activity Planned Start Time | 0WM_ACPLST |
Unit of measurement | Activity Planned Qty UoM | 0WM_ACPLUOM |
Characteristic | Actual Start Time | 0WM_ACSTART |
Characteristic | Activity Status | 0WM_ACSTAT |
Characteristic | Auxiliary Product | 0WM_AXMATNR |
Key figure | Auxiliary Planned Quantity | 0WM_AXPLQTY |
Key figure | Auxiliary Posted Quantity | 0WM_AXPOQTY |
Unit of measurement | Auxiliary Product Unit of Measure | 0WM_AXUOM |
Characteristic | Stock Type | 0WM_CAT |
Characteristic | Change Time | 0WM_CHAN_AT |
Characteristic | Changed by | 0WM_CHAN_BY |
Characteristic | Batch | 0WM_CHARG |
Characteristic | Creation Time | 0WM_CREA_AT |
Characteristic | Created by | 0WM_CREA_BY |
Characteristic | Effort Code | 0WM_EFFCODE |
Characteristic | Party Entitled to Dispose | 0WM_ENTL |
Characteristic | Entitled Role | 0WM_ETLROLE |
Characteristic | Relevance for HU Creation | 0WM_HUREL |
Key figure | Item Completed Quantity | 0WM_ITCPQTY |
Characteristic | Item Product | 0WM_ITMATNR |
Key figure | Item Planned Quantity | 0WM_ITPLQTY |
Unit of measurement | Item Planned Qty UoM | 0WM_ITPLUOM |
Characteristic | Owner | 0WM_OWNER |
Characteristic | Owner Role | 0WM_OWNROLE |
Characteristic | Planned End Time | 0WM_PLEND |
Characteristic | External Storage Process Step | 0WM_PROCS |
Characteristic | Warehouse Process Type | 0WM_PROCTY |
Characteristic | Packaging Specification ID | 0WM_PSID |
Characteristic | Doc. Category for Doc. Reference | 0WM_RDOCCAT |
Characteristic | Doc. Number of Doc. Reference | 0WM_RDOCNO |
Characteristic | Doc. Item of Doc. Reference | 0WM_RITMNO |
Characteristic | Type: Sales order stock or project stock | 0WM_SDOCCAT |
Characteristic | Number of the Sales Order or Project for Special Stock | 0WM_SDOCNO |
Characteristic | Sales Order Item for Sales Order Stock | 0WM_SITMNO |
Characteristic | Counter for Stock Separation | 0WM_STCKCNT |
Characteristic | Stock Usage | 0WM_ST_USE |
Unit of measurement | Time Unit | 0WM_UNIT_T |
Characteristic | VAS Order Category | 0WM_VASCAT |
Characteristic | VAS Order Status | 0WM_VASSTAT |
Characteristic | VAS Order Type | 0WM_VASTYPE |
Characteristic | Work Center | 0WM_WRKCNTR |