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.

Data Modeling: Field Determination by the Extractor

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.