Executed Workload
DataSource Transactional Data 0WM_EWL
Use
This DataSource provides you with the executed workload.
Technical Data
| Application Component | Warehouse Management (0WM) |
|---|---|
| Exchange Available as of Release | SAP SCM 5.1 and SAP EWM 5.1 |
| Shipment | SAP NetWeaver 2004s BI Content Add-On 3 |
| Content Versions | EWM900 |
| RemoteCube-Capable | No |
| Delta-Capable | Yes, delta process AIE; generic delta |
| Extraction from Archives | No |
| Verifiable | No |
Data Modeling
Fields of Origin for the Extraction Structure
| Fields in the Extraction Structure | Description of the Field in the Extraction Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
| EWL_GUID | GUID in 'RAW' format | /SCWM/EWRKL | GUID_WL |
| STATUS | Executed Workload Status | /SCWM/EWRKL | STATUS |
| LGNUM | Warehouse Number/Warehouse Complex | ||
| PROCS | External Storage Process Step | /SCWM/EWRKL | PROCS |
| LMAREA | LM Activity Area | /SCWM/EWRKL | LMAREA |
| LMOBJTY | Reference Obj. Type | /SCWM/EWRKL | LMOBJTY |
| GUID_REF | GUID in 'RAW' format | /SCWM/EWRKL | GUID_REF |
| PC_ID_REF | Identification of Partial Confirmation | /SCWM/EWRKL | PC_ID_REF |
| ID_REF | Reference Document | /SCWM/EWRKL | ID_REF |
| DURA_PLAN | Planned Execution Duration | /SCWM/EWRKL | DURA_PLAN |
| DURA_PLAN_ADJ | Adjusted Planned Execution Duration | /SCWM/EWRKL | DURA_PLAN_ADJ |
| DURA_ACT | Actual Execution Duration | /SCWM/EWRKL | DURA_ACT |
| UNIT_T | Time Unit | /SCWM/EWRKL | UNIT_T |
| START_ACT | Actual Start Date/Time | /SCWM/EWRKL | START_ACT |
| FINISH_ACT | Actual End Date/Time | /SCWM/EWRKL | FINISH_ACT |
| PRR_GUID | Business Partner GUID | /SCWM/EWRKL | PRR_GUID |
| PRR | Processor | ||
| CREATED_AT | Created at | /SCWM/EWRKL | CREATED_AT |
| CREATED_BY | Created By | /SCWM/EWRKL | CREATED_BY |
| CHANGED_AT | Time of Data Entry/Data Change | /SCWM/EWRKL | CHANGED_AT |
| CHANGED_BY | Changed by | /SCWM/EWRKL | CHANGED_BY |
| ALTERED_DIR | EWL Changed Manually | /SCWM/EWRKL | ALTERED_DIR |
| ENTITLED | Party Entitled to Dispose | /SCWM/EWRKL | ENTITLED |
| WEIGHT | Weight | /SCWM/EWRKL | WEIGHT |
| UNIT_W | Weight Unit | /SCWM/EWRKL | UNIT_W |
| VOLUM | Volume | /SCWM/EWRKL | VOLUM |
| UNIT_V | Volume Unit | /SCWM/EWRKL | UNIT_V |
| TRDIST | Calculated Travel Distance | /SCWM/EWRKL | TRDIST |
| UNIT_D | Unit of Length | /SCWM/EWRKL | UNIT_D |
| QUANTITY | Quantity Field | /SCWM/EWRKL | QUANTITY |
| UNIT_Q | Unit of Measure | /SCWM/EWRKL | UNIT_Q |
| CAPA | Capacity Consumption | /SCWM/EWRKL | CAPA |
| NUMSO | Number of Sublevel Documents/Items | /SCWM/EWRKL | NUMSO |
| WHS_TZONE | Time Zone of Warehouse | /SCMB/TOENTITY | TZONE |
| TYPE |
Executed Workload Type |
/SCWM/EWRKL | TYPE |
| IN_PROCESS |
Executed Workload in Process |
/SCWM/EWRKL | IN_PROCESS |
| APD_CHANGED |
Adjusted Planned Duration Entered Manually |
/SCWM/EWRKL | APD_CHANGED |
| TRDIST_VERT |
Calculated Travel Distance in Vertical Direction |
/SCWM/EWRKL | TRDIST_VERT |
| TRDIST_PLAN |
Travel Distance from Planned Workload |
/SCWM/EWRKL | TRDIST_PLAN |
| TRDIST_VERT_PLAN |
Travel Distance in Vertical Direction from Planned Workload |
/SCWM/EWRKL | TRDIST_VERT_PLAN |
| TRTIME_ADJ |
Adjusted Travel Time |
/SCWM/EWRKL | TRTIME_ADJ |
| TRTIME_PLAN |
Travel Time from Planned Workload |
/SCWM/EWRKL | TRTIME_PLAN |
| LA_CODE |
Labor Activity Code |
/SCWM/EWRKL | LA_CODE |
| LA_CODE_PLAN |
Labor Activity Code from Planned Workload |
/SCWM/EWRKL | LA_CODE_PLAN |
| LA_GRP |
Labor Activity Group |
/SCWM/EWRKL | LA_GRP |
| EVAL_TYPE |
Evaluation Type of Working Time |
/SCWM/EWRKL | EVAL_TYPE |
| PRR_GR |
Processor Group |
/SCWM/EWRKL | PRR_GR |
| TEAM_LEAD |
Team Lead |
/SCWM/EWRKL | TEAM_LEAD |
| PRR_REPG |
Reporting Group for Processor |
/SCWM/EWRKL | PRR_REPG |
| PRR_TYPE |
Processor Type |
/SCWM/EWRKL | PRR_TYPE |
| WORKCAT |
Work Category of Processor |
/SCWM/EWRKL | WORKCAT |
| SRV_START_DATE |
Service Start Date |
/SCWM/EWRKL | SRV_START_DATE |
| PFD_FACTOR |
Adjustment for Personal Needs, Fatigue, Unavoidable Delays |
/SCWM/EWRKL | PFD_FACTOR |
| PFD_ALLOWANCE |
Allowance for Personal Needs, Fatigue, Unavoidable Delays |
/SCWM/EWRKL | PFD_ALLOWANCE |
| SHIFT |
Shift (Warehouse-Dependent) |
/SCWM/EWRKL | SHIFT |
| SHIFT_SEQ |
Shift Sequence (Warehouse-Dependent) |
/SCWM/EWRKL | SHIFT_SEQ |
| SHIFT_SQ_DOFFSET |
Shift Sequence Day Number |
/SCWM/EWRKL | SHIFT_SEQ_DOFFSET |
| SHIFT_START_DAY |
Shift Start Day |
/SCWM/EWRKL | SHIFT_START_DAY |
| SHIFT_LEAD |
Shift Lead |
/SCWM/EWRKL | SHIFT_LEAD |
Extractor Logic
The fields in the table of origin for the extract structure largely consist of a 1:1 relation to data-based fields. For an explanation of how the other fields are instead determined by the extractor, see the table below.
|
Fields in the Extract Structure |
Field Determined by Extractor |
|---|---|
|
LGNUM |
Determined by extractor of supply chain unit |
|
PRR |
Determined by extractor of the processor GUID |
|
QUANTITY |
Note that the default setting leaves the quantity field unfilled, apart from data records for value-added service. To fill this field, BAdI /SCWM/EX_LM_EWRWL_QUAN in enhancement spot /SCWM/ES_LM_WL_QUAN must be implemented in the EWM system. |