Important SAP EWM Tables [PDF]

Zitiervorschau

9/30/2014

Important SAP EWM Tables |

TKREDDY'S PERSONAL BLOG EXPERIENCING IN SAP SUPPLY CHAIN EXECUTION SAP EWM, SAP WMS

Important SAP EWM Tables POSTED BY TKREDDY ⋅ JUNE 28, 2012 ⋅ 7 COMMENTS 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: Function

Table

Description

Wave

/SCWM/WAVEHDR

Wave – Header Information

/SCWM/WAVEITM

Wave Item

/SCDL/DB_PROCH_O

Outbound Delivery Order Header

/SCDL/DB_PROCI_O

Outbound Delivery Order Item

/SCDL/DB_DLVH_O

Outbound Delivery Header

/SCDL/DB_DLVI_O

Outbound Delivery Item

/SCDL/DB_PROCH_I

Inbound Delivery: Header

/SCDL/DB_PROCI_I

Inbound Delivery Item

/SCDL/DB_REFDOC

Reference

/SCDL/DB_REQH

Header Inbound Delivery Notification / Outbound Delivery Request

/SCDL/DB_REQI

Item Inbound Delivery Notification / Outbound Delivery Request

/SCDL/DB_STATUS

Status

/SCDL/V_STATUS

Generated Table for View /SCDL/V_STATUS

ODO OD

ID

Reference

Status

http://blog.tkreddy.com/2012/06/28/important-sap-ewm-tables/

1/4

9/30/2014

HU

Important SAP EWM Tables |

/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

/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

/SCWM/LAGP

Storage Bins

/SCWM/LAGPS

Bins for Execution Areas and Activities

/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

/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

/SAPAPO/MATKEY

Product

/SAPAPO/MATMAP

Mapping Table for Products

WT

BINS

PI

TU

Masterdata

/SAPAPO/MATLWH http://blog.tkreddy.com/2012/06/28/important-sap-ewm-tables/

Location Product for Location 2/4

9/30/2014

Important SAP EWM Tables |

Warehouse

BP

/SAPAPO/MATEXEC

Product: Execution Data

/SAPAPO/MATLWHST

Location Product for Location Whse and Subloc. Storage Type

/SAPAPO/MATTXT

Material Descriptions

ADRC

Addresses (Business Address Services)

/SCDL/DB_BPLOC

Partner/Location

BUT000

BP: General data I

BUT020

BP: Addresses

ERP Distribution

FRET

Assignment of Procurement to Issue Docs in Mdse

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 these ads

You May Like 1.

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. View all posts by TKReddy »

Discussion http://blog.tkreddy.com/2012/06/28/important-sap-ewm-tables/

3/4

9/30/2014

Important SAP EWM Tables |

7 thoughts on “Important SAP EWM Tables” 1. Hi Thanks Very useful information!!!!!!! POSTED BY VENKAT MAGANTI | JUNE 28, 2012, 8:28 PM REPLY TO THIS COMMENT Is there a place where I can get a list of ALL EWM customizing table names and what they are? POSTED BY B | OCTOBER 18, 2012, 2:37 PM REPLY TO THIS COMMENT 2. Very useful. Martin @ sapjobseurope.com POSTED BY MARTIN SAP | MAY 27, 2013, 5:08 PM REPLY TO THIS COMMENT 3. Super – thanks a million TK POSTED BY THOMAS F | OCTOBER 14, 2013, 2:50 PM REPLY TO THIS COMMENT 4. Thanks TKR, Very useful info that every EWM consultant shd know! POSTED BY DATTATRAYA CHOUGULE | DECEMBER 8, 2013, 9:07 PM REPLY TO THIS COMMENT 5. Dear, how can I get inbound delivery status header?? POSTED BY MARLON | JANUARY 29, 2014, 8:34 AM REPLY TO THIS COMMENT 6. Sorry.. correct name is /SAPAPO/MATPACK POSTED BY RC | FEBRUARY 26, 2014, 3:17 PM REPLY TO THIS COMMENT

Create a free website or blog at WordPress.com. The Morning After Theme. Follow

Follow “” Powered by WordPress.com http://blog.tkreddy.com/2012/06/28/important-sap-ewm-tables/

4/4