Upload Stock
Application component: Warehouse Order Processing
App type: SAP GUI
Scope items: Initial Stock Upload for Warehouse
Description: You can use report /SCWM/R_INITIALSTOCKUPLOAD to perform an initial stock data transfer in Extended Warehouse Management (EWM). There are two ways to copy existing data: You upload a local comma-separated values file (CSV file), which contains the data that EWM is to copy.The structure of this file must correspond to the fields of structure /SCWM/S_STOCK_UPLOAD_EXT. When EWM imports the data, the system ignores the first line of this file, as it usually contains the column headers. You upload a file from an application server, which contains the data that is to be transferred by EWM.In this case, 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.  
Key features: Note If you are using a template for your product numbers, you have to specify the products in file you want to upload without this template. When EWM imports the data, the system checks the data. If the data contains no errors, you can then post it in EWM. If the data contains errors, EWM displays the error messages in a log. If you want to copy existing data using a file, you can map the physical structure of your stock in the file. You can import different item categories, for example:   Stock directly in storage bins   Stock in handling units (HUs) in storage bins and stock in nested HUs in storage bins   HUs with auxiliary packaging materials in storage bins   You can specify valid UoMs for the given product in the column UNIT. If you specify an alternative UoM other than the base UoM, the system creates the stock in that UoM. This alternative UoM can be used for processes connected to the stock-specific UoM feature. The following table shows the different item categories that you can use in the file. All fields that you must specify for the respective item category are marked with an X, and all fields that are optional are marked with an O. If you want to upload stock to HUs, you must specify the storage bin in the column 1 Highest-Level HU. If you want to load stock without HUs, you must specify the storage bin in the column 4 Stock. This is indicated in the following table with an (X) symbol. You can map the hierarchy of an HU using the fields HUIDENT, PARHUIDENT and TOPHUIDENT.    Item Category   1 Highest-Level HU   2 HU   3 Auxiliary Packaging Material   4 Stock      MATNR         x   x     OWNER            x     OWNER_ROLE            x     BATCH            O     CAT            x     STOCK_DOCCAT            O     STOCK_DOCNO            O     STOCK_ITMNO            O     STOCK_USAGE            O     ENTITLED            x     ENTITLED_ROLE            x     COO            O     QUAN         x   x     UNIT         x   x     HUTYP   x   x           LGPLA   x         (X)     GR_DATE            O     GR_TIME            O     VFDAT            O     PMAT   x   x           EXTNO   O   O   O        HUIDENT   x   x   x   O     PARENTHUIDENT      x           TOPHUIDENT   x   x   x   O     ROW   x   x   x   x     REFROW                 G_WEIGHT   O   O   O        N_WEIGHT   O   O   O        UNIT_GW   O   O   O        T_WEIGHT   O   O   O        UNIT_TW   O   O   O        G_VOLUME   O   O   O        N_VOLUME   O   O   O        UNIT_GV   O   O   O        T_VOLUME   O   O   O        UNIT_TV   O   O   O        G_CAPA   O   O   O        N_CAPA   O   O   O        T_CAPA   O   O   O        LENGTH   O   O   O        WIDTH   O   O   O        HEIGHT   O   O   O        UNIT_LWH   O   O   O        MAX_WEIGHT   O   O   O        TOLW   O   O   O        TARE_VAR   O   O   O        MAX_VOLUME   O   O   O        TOLV   O   O   O        CLOSED_PACKAGE   O   O   O        MAX_CAPA   O   O   O        MAX_LENGTH   O   O   O        MAX_WIDTH   O   O   O        MAX_HEIGHT   O   O   O        UNIT_MAX_LWH   O   O   O        SERID                 CWQUAN            O     CWUNIT   O              CWEXACT   O              LOGPOS   O              UII                 ZEUGN   O              AMOUNT_LC                 Specifying HU Numbers You can set the value X in the file in the column EXT_NO. This allows EWM to use the specified external numbers for HUs. Prerequisite for this is that the external number lies within an external number range interval that you have defined in Customizing for EWM under Define Number Ranges for HU Identification. For more information, see Customizing for EWM under Cross-Process Settings  Handling Units  External Identification  Define Number Ranges for HU Identification.   Specifying Serial Numbers If you specify item category 6 in the file, you can specify serial numbers for a stock item with item category 4 by connecting the values in columns ROW and REFROW with each other. To do this, proceed as follows:   If you specify a serial number with item category 6, you must specify in the row of the serial number in field REFROW the value of the field ROW in the row of the related stock item as a reference to item category 4. By doing this, you assign the serial number to a stock item that is valid for the data that you want to process.   Count the columns ROW up for every data row so that the row is unique.   You must also specify the serial number in the SERID field.     Specifications for Catch-Weight-Relevant Products   If the stock item belongs to a product that is relevant for Catch Weight, you must specify the catch weight quantity and its unit in the fields CWQUAN and CWUNIT.   If you want to display the fact that the catch weight quantity was measured, you must specify the CWEXACT field.   You can also make no entries in all of the above fields. In this case, EWM calculates the catch weight quantity and uses the planned factor from the product master for it.   Specifying External Amount and Split Valuation   If the stock item is to be valuated at a different price than the price maintained in the product master, you can enter a different amount in local currency. Specify the amount in the AMOUNT_LC field.   If the product is both split valuated and batch managed, the valuation type is determined from the batch master for the batch that is specified in the BATCH field.   If the product is split valuated but not batch managed, you must specify the valuation type in the BATCH field.   
Business roles: Warehouse Clerk (EWM)
Warehouse Clerk (Extended Warehouse Management) : 
Plans and controls processes in a simple warehouse with a strong focus on inbound, outbound, physical inventory, and maintenance of warehouse specific master data.