EWM 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 /SCWM/ORDIM_C Warehouse tasks confirmed
(WT)
/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 /SCWM/TU_DLV Assignment of Deliveries and HUs
UNIT (TU) to Transportation Units
1
FUNCTION TABLE DESCRIPTION
/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 /SCDL/DB_DLVH_O Outbound Delivery Header
DELIVERY
/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
2
FUNCTION TABLE DESCRIPTION
/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
3
FUNCTION TABLE DESCRIPTION
Warehouse and sub location storage
type
/SAPAPO/MATLWH Location product for Location
Warehouse
ntroduction to SAP EWM (extended warehouse management):
The SAP EWM is also a type of functional module which helps organizations to
maintain the inventories and also supports the movement of the goods processing.
The main functions of the SAP EWM include are, to manage both inbound and
outbound delivery processes, maintaining the receipt of the goods, fulfilling the
customer orders, and goods distributions.
SAP EWM tables:
SAP EWM tables are used to store and maintain the information which is related to
warehouse management and inventories. There are various types of SAP EWM
tables are available;
Stock
Warehouse task
Transportation unit
Wave
Outbound delivery
Inbound delivery
Reference
Handling unit (HU)
Storage bins
Master data
Physical inventory documents
4
Route
Location
APO location
RF (radio frequency)
Communication
BP (business partners)
Become a master of SAP EWM by going through this HKR SAP EWM Online
Training!
SAP EWM Training
Master Your Craft
Lifetime LMS & Faculty Access
24/7 online expert support
Real-world & Project Based Learning
Explore Curriculum
Let me explain each table along with descriptions;
Stock
/SCWM/AQUA -> this table describes the available quantity.
/SCWM/QUAN -> this table defines the quant attributes
/LIME/NQUAN -> this table describes the LIME - quantity attributes
/SCWM/STOCK_IW01 -> WME - stock key material
5
/SCWM/STOCK_IW02 -> WME - stock key material, batch
/SCWM/STOCK_IW03 -> WME - stock key material, batch, reference
documents.
/SCWM/STOCK_IW04 -> WME - stock key material, sales order, and project.
Warehouse task
/SCWM/ORDIM_C -> this table defines the warehouse tasks that have been
confirmed.
/SCWM/ORDIM_CS -> this table defines the serial numbers for confirmed
warehouses for task items.
/SCWM/ORDIM_E -> this table defines the exception codes for the
warehouse tasks.
/SCWM/ORDIM_H -> this table defines the warehouse task: movement of HU
items.
/SCWM/ORDIM_HS -> serial number for HU item movements processing.
/SCWM/ORDIM_L -> Warehouse tasks log table
/SCWM/ORDIM_LS -> serial numbers for warehouse task log tables.
/SCWM/ORDIM_O -> warehouse tasks open
/SCWM/ORDIM_OS -> Serial number items for open warehouse tasks.
Transportation unit:
SCWM/TU_DLV -> this table describes the assignment of deliveries and HUs
to transportation units.
/SCWM/TU_DOOR -> Assign transport units to doors
/SCWM/TUNIT -> this table defines the transportation units.
/SCWM/TU_SR_ACT -> this table defines the S & R activity of a transportation
units.
/SCWM/TU_STATUS -> this table defines the status of transportation unit
activities.
/SCWM/TU_VEH -> this table defines the assigned transport units to the
vehicles.
6
/SCWM/DOOR_SRACT -> this table defines the S & R activities of a door.
Wave:
/SCWM/WAVEHDR -> this table defines the Wave - header information
/SCWM/WAVEITM -> this table defines the wave - item information.
Outbound delivery:
/SCDL/DB_DLVH_O -> this table defines the outbound delivery header.
SCDL/DB_DLVI_O -> this table defines the outbound delivery items.
/SCDL/DB_PROCH_O -> this table defines the outbound delivery order
header.
/SCDL/DB_PROCI_O -> this table defines the outbound delivery order items.
Inbound delivery:
/SCDL/DB_PROCH_I-> this table defines the inbound delivery header
information.
/SCDL/DB_PROCI_I -> this table defines the inbound delivery item
information.
Interested in learning python Join HKR Python certification training !
References:
/SCDL/DB_REFDOC -> this table determines the reference information.
/SCDL/DB_REQH -> this table defines the header inbound delivery notification
or outbound delivery request.
/SCDL/DB_REQI -> this table defines the item inbound delivery notification or
outbound delivery request.
Handling units (HUs):
/SCWM/HUHDR -> this table defines the handling unit header information.
7
/SCWM/GMHUIDENT -> this table defines the additional handling unit for a
goods movement log.
/SCWM/HUSSTAT -> this table defines the individual status for each handling
unit.
/SCWM/HUREF -> this table defines the handling unit references.
/SCWM/HUSTOBJ -> this table defines the information about the handling unit
status objects.
/SCWM/GMHUSTAT -> HU status of the handling unit from the goods
movement logs.
/SCWM/GMHUITM -> handling unit items.
/SCWM/GMHUHDR -> handling unit header of the goods movement logs.
Storage bins:
/SCWM/LAGP -> this table defines the storage bins details.
/SCWM/LAGPS -> this table provides the complete information on storage
bins that are available for the execution areas and activities.
Master data:
/SAPAPO/MATKEY -> this table defines the product details.
/SAPAPO/MATMAP -> this table defines mapping table details for the
products.
/SAPAPO/MATEXEC -> it defines the product execution data.
/SAPAPO/MATTXT -> this table defines the material description.
/SAPAPO/MATLWHST -> location product for the location wise and subblock.
Storage types.
/SAPAPO/MATLWH -> this table defines the location product for the location
warehouse.
Physical inventory document :
/LIME/PI_DCTYTXT -> this table provides a description of physical inventory
procedures.
8
/LIME/PI_DOCTYPE -> document types of physical inventory and also define
the internal settings.
/LIME/PI_DOC_IT -> table of physical inventory document items.
/LIME/PI_DOC_SER -> describes the serial number for physical inventory
document items.
/LIME/PI_DOC_TB -> this table defines the quantities for the physical inventory
document items.
/LIME/PI_IT_BIZ -> this table defines the physical inventory document
business key objects.
/LIME/PI_LOGHEAD -> this table defines the log table for header data of
physical inventory log entries.
/LIME/PI_LOGHIST -> history table for the physical inventory LOG entries.
/LIME/PI_LOGITEM -> this table defines the log table for item data of a
physical inventory document.
/LIME/PI_PAR_BIZ-> this table defines the physical inventory document
business key parent objects.
Route:
/SCMB/ROUTE -> this table gives the route information.
/SCMB/ROUTET -> this table gives the route table information.
/SCMB/TOENTITYT -> this table gives the supply chain units about the text
information.
/SCDL/ TSRVLVLT -> it gives the shipping condition: text details.
/SCMB/ROUTE_SC -> this table gives the shipping condition for route.
/SCMB/ROUTE_RT -> request types for the route.
/SCMB/STOP -> it gives the stop login information about the route.
/SCMB/ZONE -> this table describes the transportation zone details .
/SCMB/ZONE_D -> this table gives the transportation unavailability zone
details.
/SCMB/TOENTITY -> it gives the supply chain unit header details.
Location:
9
/SCWM/LOC_IW01 -> it gives the location table number types and storage bin
details.
/SCWM/LOC_IW02 -> it gives the warehouse resource details.
/SCWM/ LOC_IWO3 -> it gives the location table warehouse view.
/SCWM/ LOC_IWO4 -> location table transport details.
APO Location:
/SAPAPO/ LOC -> this table describes the location details.
/SAPAPO/LOCMAP -> it defines the mapping table for the location.
/SAPAPO/LOCT -> short text for the location.
/SAPAPO/LOCVER -> this table defines the location version dependent files.
frequently asked SAP EWM Interview Questions and Answers
Subscribe To Our Youtube Channel To Get New Updates..!
Subscribe
RF(radio frequency):
/SCWM/TTRNS_CAT -> logical transactions.
/SCWM/TSTEP_CAT -> steps of logical transactions.
/SCWM/TPRDV_CAT -> presentation devices.
/SCWM/TPRES_CAT -> presentation profiles.
Communications:
TRFCQIN -> TRFC queue description (inbound delivery process).
EDIDC -> Control record details.
BP (Business partner):
ADRC -> this table gives business address server details.
SCDL/DB_BPLOC -> this table describes the partner location search for the
delivery details.
10
BUT000 -> BP: general data1.
BUT020 -> BP: address.
11
