you're reading...

Important SAP EWM Tables

I am posting this blog after a long time, this time i would like to share some of the tables which we should come across every day in SAP EWM  system.These are very important tables that every functional consultant should know and work mostly.The SAP EWM Tables list is as follows:

SAP EWM Tables

Function Table Description
Wave /SCWM/WAVEHDR Wave – Header Information
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
WT /SCWM/ORDIM_O Warehouse Tasks Open
/SCWM/ORDIM_C Warehouse Tasks Confirmed
WO /SCWM/WHO Warehouse Order
Quantity /SCWM/AQUA Available Quantity
/SCWM/QUAN Quant Attributes
/LIME/NQUAN LIME – Stock Quantities
/SCWM/STOCK_IW01  Stock GUID from table
BINS /SCWM/LAGP Storage Bins
/SCWM/LAGPS Bins for Execution Areas and Activities
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
TU /SCWM/TU_DLV Assignment of Deliveries and HUs to Transportation Units
/SCWM/TU_STATUS Status of Transportation Unit Activities
 /SCWM/TUNIT  TU &other GUID’s
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
BP ADRC Addresses (Business Address Services)
/SCDL/DB_BPLOC Partner/Location
BUT000 BP: General data I
BUT020 BP: Addresses

ERP                            FRET                         Assignment of Procurement to Issue Docs in Mdse Distribution

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

few more table details from SAP Help for BI data analytics. Please click here to view tables 

Please also find the attached link where you get to see a lot more SAP EWM tables from external website.

Few more tables list from knowscm.net

About TKReddy

Working in SAP environment. This is a blog of my personal experience. Most of my posts are related to SAP, Websites and other personal topics.


11 thoughts on “Important SAP EWM Tables

  1. Hi
    Thanks Very useful information!!!!!!!

    Posted by Venkat Maganti | June 28, 2012, 8:28 pm
  2. Very useful. Martin @ sapjobseurope.com

    Posted by Martin SAP | May 27, 2013, 5:08 pm
  3. Super – thanks a million TK

    Posted by Thomas F | October 14, 2013, 2:50 pm
  4. Thanks TKR, Very useful info that every EWM consultant shd know!

    Posted by Dattatraya Chougule | December 8, 2013, 9:07 pm
  5. Dear, how can I get inbound delivery status header??

    Posted by Marlon | January 29, 2014, 8:34 am
  6. /SCWM/MATPACK missing.

    Posted by RC | February 26, 2014, 3:15 pm
  7. Hi

    Nice!!!! after long time.


    Posted by Verma | February 17, 2015, 8:33 pm
  8. Can you please tell me, The table name for Inbound delivery in EWM, thatt holds warehouse no,.

    Posted by Priyanka | April 7, 2015, 7:25 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s



Blog Stats

  • 451,277 hits
Note: if you see ads on this site, they are placed by WordPress, not me
All product names and images are trademarks of their respective companies.

Get every new post delivered to your Inbox.

Join 126 other followers

%d bloggers like this: