Uploading Engineered Labor Standards (ELS) 

Use

You can use this function to upload engineered labor standards from another external system.

There are two ways to copy existing data:

●      By uploading a local file, such as a Comma-Separated-Values file (CSV file).

●      By uploading a file from an application server.

In this case, Extended Warehouse Management (EWM) uses a connection to the Legacy System Migration Workbench (LSMW).

For more information about the LSMW, see SAP Library under SAP ERP ® SAP Oil & Gas ® SAP Oil & Gas (IS-Oil Downstream) ® Integration of SAP Oil & Gas with SAP CRM ® F&A Pricing in Integration with SAP CRM ® Legacy System Migration Workbench.

 

You can upload existing data for the following objects in Labor Management:

●      Formula or condition

●      Work step

●      Labor standard of the work step

●      Work step sequence

●      Assignment of work step sequence

 

Prerequisites

The CSV file has a header line and the following column format

Formula or condition

LGNUM	PROCS	FORMULA	FORMULA_TYPE	VALID
Char 4	Char 4	Char 4	Char 1	Char 1

 

Formula or condition

WGT_UOM	VOL_UOM	DIST_UOM	TIME_UOM	FORMULA_TXT	FORMULA_ELEMENT
Char 3	Char 3	Char 3	Char 3	Char 40	Char 100

 

Work step

LGNUM	STEP	DESCRIPTION
Char 4	Char 4	Char 40

 

Labor standard of the work step

LGNUM	STEP	NUM	CONDI TION	CONSTANT	UNIT	FORMULA	ACTIVE
Char 4	Char 4	Char 5	Char 4	Char 16	Char 3	Char 4	Char 1

 

Work step sequence

LGNUM	SEQUENCE	NUM	STEP	SEQUENCE (included)	ACTIVE
Char 4	Char 4	Char 5	Char 4	Char 4	Char 1

 

Assignment of work step sequence

LGNUM	PROCS	ACTIVITY AREA	OBJECT TYPE	NUM	SEQUENCE	ACTIVE
Char 4	Char 4	Char 4	Char 1	Char 5	Char 4	Char 1

 

The LSMW uses the following structures:

●      /SCWM/S_ELS_LSMW_FRML – Formula or condition

●      /SCWM/S_ELS_LSMW_ST – Work step

●      /SCWM/S_ELS_LSMW_STE – Labor standards of the work step

●      /SCWM/S_ELS_LSMW_SEQ _  - Work step sequence

●      /SCWM/S_ELS_LSMW_ASS – Assignment of work step sequence

Activities

You call the function from the SAP Easy Access screen, by choosing Extended Warehouse Management ®  Settings ®  Labor Management ®  Upload Engineered Labor Standards.

 

       1.      Specify the type of host from which you want to upload the file:

○       From a local computer

○       From an application server

       2.      Use the Delete Existing Data field to select whether the uploaded data is allowed to overwrite existing settings.

       3.      Enter the file name and choose Upload.

The system uploads the data and displays it on the Loaded Data tab page. If you are working with a file on an application server, the system fetches the data from the application server, and displays it to you.

       4.      Make corrections if required.

You are using a local CSV file A. After the system has uploaded file A and is showing you the data, you notice that the formatting of the Excel file is incorrect. You correct the formatting and upload the file again.

If you upload a file from an application server, you can make corrections directly in the LSMW and then upload the file again.

       5.      Choose Execute with the quick info Start Data Transfer.

The system stores the data in the database. On the Successful Changes tab page, you can find all the data that has been successfully created. On the Failed Changes tab page, you can find all the data that EWM was unable to create. The Message column on this tab page also shows you the additional message text.