SAP EWM Tables

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.

Introduction 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
  • 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

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 
  •  /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.
  • /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.

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.
  • /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.
  • /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:

  • /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..!

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.
  • BUT000 -> BP: general data1.
  • BUT020 -> BP: address.


Final words:

The SAP EWM Table article explains the core knowledge of warehouse management and the various types of tables being used. From this SAP EWM table article, you will be able to learn and explore more about the extended warehouse management functional modules on a deep learning level. We have been designing the articles in such a way that, readers should understand the concepts thoroughly and also make them work on many real-time projects under expert supervision.

 

Other Related articles: 

SAP EWM Training

Weekday / Weekend Batches

 

Find our upcoming SAP EWM Training Online Classes

  • Batch starts on 13th Dec 2022, Weekday batch

  • Batch starts on 17th Dec 2022, Weekend batch

  • Batch starts on 21st Dec 2022, Weekday batch

Global Promotional Image
 

Categories

Request for more information

Kavya Gowda
Kavya Gowda
Research Analyst
Kavya works for HKR Trainings institute as a technical writer with diverse experience in many kinds of technology-related content development. She holds a graduate education in the Computer science and Engineering stream. She has cultivated strong technical skills from reading tech blogs and also doing a lot of research related to content. She manages to write great content in many fields like Programming & Frameworks, Enterprise Integration, Web Development, SAP, and Business Process Management (BPM). Connect her on LinkedIn and Twitter.