Important SAP EWM Tables

11 Replies

Feature Posts SAP EWM SAP WMS

After a long time, I am writing this blog post not in WM but in SAP EWM with an important list that i may refer more often. Being SAP EWM Functional consultant, I come across several important tables during my work. I thought to arrange the list in one palace with a title of important SAP EWM tables. The list contains as per function wise so that we can refer easily.

Please find below list of Important SAP EWM Tables :

 

Function Table Description
Wave /SCWM/WAVEHDR Wave – Header Information
/SCWM/WAVEITM Wave Item
ODO /SCDL/DB_PROCH_O Outbound Delivery Order Header
/SCDL/DB_PROCI_O Outbound Delivery Order Item
OD /SCDL/DB_DLVH_O Outbound Delivery Header
/SCDL/DB_DLVI_O Outbound Delivery Item
ID /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
Status /SCDL/DB_STATUS Status
/SCDL/V_STATUS Generated Table for View /SCDL/V_STATUS
HU /SCWM/HUHDR Handling unit header
/SCWM/HUSSTAT Individual Status for Each Handling Unit
/SCWM/HUREF Handling Unit Reference
/SCWM/HUSTOBJ Information about HU Status Object
/SCWM/GMHUSTAT HU Status of HUs from Goods Movement Log
TJ02T  Status table
/LIME/NTREE Important LIME table. Example to see new HU or location, Input GUID and get GUID_PARENT and look in LAGP with GUID_LOC to see BIN number for a HU
WT /SCWM/ORDIM_O Warehouse Tasks Open
/SCWM/ORDIM_C Warehouse Tasks Confirmed
WO /SCWM/WHO Warehouse Order
/SCWM/WHOHU Warehouse Order: HU Information
 /SCWM/WO_RSRC_TY  Resource Type for Warehouse Order
Quantity /SCWM/AQUA Available Quantity
/SCWM/QUAN Quant Attributes
/LIME/NQUAN LIME – Stock Quantities
/SCWM/STOCK_IW01  Stock GUID from table
/SCWM/STOCK_IW02  Stock GUID from Batch managed stock
/SCWM/STOCK_IW03  Stock GUID from refernce stock PDI and PDO
/SCWM/STOCK_IW04  Stock GUID from Special stock
BINS /SCWM/LAGP Storage Bins
/SCWM/LAGPS Bins for Execution Areas and Activities
 /SCWM/BINMAT  Assignment Table for Fixed Bins – Product
 /SCWM/BINSTAT  Individual Status per Storage Bin
 /SCWM/TPSASTAGE  SA Assignment to Bin by Entitled/Product
PI /LIME/PI_DOC_IT Table of Physical Inventory Document Items
/LIME/PI_LOGHEAD Log Table for Header Data of a Physical Inventory document
/LIME/PI_LOGITEM/LIME/PI_DOC_TB Log Table for Item Data of a Physical Inventory documentQuantities for Physical Inventory Document
 /LIME/PI_DOC_TB  Quantities for Physical Inventory Document
TU /SCWM/TU_DLV Assignment of Deliveries and HUs to Transportation Units
/SCWM/TU_STATUS Status of Transportation Unit Activities
 /SCWM/TUNIT  TU number
 /SCWM/TU_SR_ACT   Contains start date/times and end dates/times
Masterdata /SAPAPO/MATKEY Product
/SAPAPO/MATMAP Mapping Table for Products
/SAPAPO/MATLWH Location Product for Location Warehouse
/SAPAPO/MATEXEC Product: Execution Data
/SAPAPO/MATLWHST Location Product for Location Whse and Subloc. Storage Type
/SAPAPO/MATTXT Material Descriptions
 /SAPAPO/MATPACK  Product: Packing/Packaging Data
 /SCWM/SERH  Serial Number Header
 /SCWM/TPSA   Production Supply Area
BP ADRC Addresses (Business Address Services)
/SCDL/DB_BPLOC Partner/Location
BUT000 BP: General data I
BUT020 BP: Addresses
 Route  /SCMB/ROUTE  Route
/SCMB/ROUTET  Route name
/SCMB/TOENTITYT  Supply chain unit : Text
 /SCDL/TSRVLVLT  Shipping condition :Text
 /SCMB/ROUTE_SC  Shipping condition for Route
 /SCMB/ROUTE_RT  Request type for Route
 /SCMB/STOP  Stop Along a Leg
 /SCMB/LEG  /SCMB/LEG
 /SCMB/ZONE  Transportation Zone
/SCMB/ZONE_D Transportation Zone Defined Unassignment of Location
 SCMB/TOENTITY  Supply chain unit header table
 Location /SCWM/LOC_IW01  WME – Location Table Whse Number, Storage type,Storage Bin
 /SCWM/LOC_IW02  WME – Location Table Warehouse Number, Resource
 /SCWM/LOC_IW03  WME – Location Table Warehouse Number, View
 /SCWM/LOC_IW04  WME – Location Table Transport Unit
 APO Loc /SAPAPO/LOC  Locations
 /SAPAPO/LOCMAP  Mapping Table for Locations
 /SAPAPO/LOCT  Short Text for Locations
 /SAPAPO/LOCVER  Location: Version-Dependent Fields
 Valuation  /SCWM/T_VALUATE  Valuation Data for Physical Inventory
 /SCWM/T_VAL_SPLT  Split Valuation Data
 TRFCQIN  tRFC Queue Description (Inbound Queue)
 EDIDC  Control record (IDoc)

ERP                            FRET                         Assignment of Procurement to Issue Docs in Mdse Distribution

ERP                          /n/spe/cdmon           Transportation Cross-dock Monitor

If you would like to know more SAP EWM tables then download the big list of of SAP EWM Tables  here but you need to search the list to get what you want

I know currently many people searching SAP EWM content with keywords of SAP EWM PDF, SAP EWM Basics, SAP configuration guide, SAP tutorial or SAP EWM  technical and many more words. I suggest first search your content in help portal from SAP and then only look SAP EWM content in other sites or blogs. So please read SAP EWM from help.sap.com here

 

11 comments

Leave a Reply

Your email address will not be published. Required fields are marked *