EWM Main Tables

http://www.cnblogs.com/byfhd/archive/2012/02/27/2369900.html

 

Purpose

The purpose of this page is to provide a list of the EWM main tables separated by area.

Overview

Below you will find listed the EWM main tables and its description.

Main Tables

FUNCTION	TABLE	DESCRIPTION
STOCK	/SCWM/AQUA	Available stock for warehouse task creation
	/SCWM/QUAN	Physical stock attributes
	/LIME/NQUAN	Physical stock
	/SCWM/STOCK_IW01	Normal stock
	/SCWM/STOCK_IW02	Batch managed stock
	/SCWM/STOCK_IW03	Reference stock (PDI, PDO)
	/SCWM/STOCK_IW04	Special stock
WAREHOUSE TASK (WT)	/SCWM/ORDIM_C	Warehouse tasks confirmed
	/SCWM/ORDIM_CS	Serial number for confirmed warehouse task item
	/SCWM/ORDIM_E	Exception codes for warehouse task
	/SCWM/ORDIM_H	Warehouse task: Movements of HU items
	/SCWM/ORDIM_HS	Serial numbers for HU item movements
	/SCWM/ORDIM_L	Warehouse tasks log table
	/SCWM/ORDIM_LS	Serial numbers for warehouse task log table
	/SCWM/ORDIM_O	Warehouse tasks opened
TRANSPORTATION UNIT (TU)	/SCWM/TU_DLV	Assignment of Deliveries and HUs to Transportation Units
	/SCWM/TU_DOOR	Relationship between TU activities and door activities
	/SCWM/TUNIT	Data for the TU itself
	/SCWM/TU_SR_ACT	Contains start date/times and end dates/times
	/SCWM/TU_STATUS	Status of the TU activities
	/SCWM/TU_VEH	Contains one or more vehicle activities with which a TU activity can be linked
	/SCWM/DOOR_SRACT	S&R Activities of a Door
WAVE	/SCWM/WAVEHDR	Wave header information
	/SCWM/WAVEITM	Wave item
OUTBOUND DELIVERY	/SCDL/DB_DLVH_O	Outbound Delivery Header
	/SCDL/DB_DLVI_O	Outbound Delivery Item
	/SCDL/DB_PROCH_O	Outbound Delivery Order Header
	/SCDL/DB_PROCI_O	Outbound Delivery Order Item
INBOUND DELIVERY	/SCDL/DB_PROCH_I	Inbound Delivery Header
	/SCDL/DB_PROCI_I	Inbound Delivery Item
REFERENCE	/SCDL/DB_REFDOC	Reference
	/SCDL/DB_REQH	Header Inbound Delivery Notification / Outbound Delivery Request
	/SCDL/DB_REQI	Item Inbound Delivery Notification / Outbound Delivery Request
HANDLING UNIT (HU)	/SCWM/HUHDR	Handling unit header
	/SCWM/GMHUIDENT	Additional HU Identifications for a Goods Movement Log
	/SCWM/HUSSTAT	Individual status for each handling unit
	/SCWM/HUREF	Handling unit reference
	/SCWM/HUSTOBJ	Information about handling unit status object
	/SCWM/GMHUSTAT	HU Status of HUs from Goods Movement Log
	/SCWM/GMHUITM	Handling Unit Item
	/SCWM/GMHUHDR	Goods Movement Handling Unit Header
Reading details in a HU
STORAGE BINS	/SCWM/LAGP	Storage Bins
	/SCWM/LAGPS	Bins for execution areas and activities
MASTER DATA	/SAPAPO/MATKEY	Product
	/SAPAPO/MATMAP	Mapping table for products
	/SAPAPO/MATEXEC	Product execution data
	/SAPAPO/MATTXT	Material Descriptions
	/SAPAPO/MATLWHST	Location product for Location Warehouse and sub location storage type
	/SAPAPO/MATLWH	Location product for Location Warehouse