Hi experts Which table to refer to view physical qty in sap ewm with reference to WH No and ST

[Hitheshrao]

Hi experts 

Which table to refer to view physical quantity in sap ewm with reference to WH No and ST.

I need to create a custom table in order to do stock reconciliation with 3pl and ewm stock similar to /scwm/rep_stockcheck.

Please provide your input on this as well

Regards

Hithesh

[Faraz_Rahim]

Hi Hiteshrao,

Below are some important tables related to EWM. I hope you find them helpful.

/SCWM/QUAN Quant Attributes
/LIME/NQUANLIME - Stock Quantities
/SCWM/STOCK_IW01WME - Stock Key Material Batch
/SCWM/STOCK_IW03WME - Stock Key Material, Batch, Reference Document
/SCWM/STOCK_IW04WME - Stock Key Material, Sales Order, Project
/SCWM/ORDIM_C Warehouse Tasks Confirmed
/SCWM/ORDIM_CS Serial Numbers for Confirmed Warehouse Task Item
/SCWM/ORDIM_E Exception Codes for Warehouse Task
/SCWM/ORDIM_O Warehouse Tasks Open
/SCWM/ORDIM_OS Serial Number Items for Open Warehouse Tasks
/SCWM/WAVEHDR Wave - Header Information
/SCWM/WAVEITM Wave - Item
/SCDL/DB_DLVH_O Outbound Delivery Header
/SCDL/DB_DLVI_O Outbound Delivery Item
/SCDL/DB_PROCH_O Outbound Delivery Order Header
/SCDL/DB_PROCI_O Outbound Delivery Order 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 Req.
/SCDL/DB_REQI Item Inbound Delivery Notification / Outbound Del. Request
/SCWM/HUHDR Handling unit header
/HUSSTAT Individual Status for Each Handling
/SCWM Unit/SCWM/HUREF Handling Unit
/SCWM/HUSTOBJ Information about HU Status
/SCWM/GMHUHDR Handling Unit Header of a Goods Movement Log
/SCWM/GMHUITM Handling Unit Item
/SCWM/GMHUSTATHU Status of HUs from Goods Movement Log
/SCWM/GMHUIDENT Additional HU Identificationss for a Goods Movement Log Reference Object
/SCWM/LAGP Storage Bins
/SCWM/LAGPS Bins for Execution Areas and Activit
/SAPAPO/MATKEY Product
/SAPAPO/MATLWH Location Product for Location Warehouse
/SAPAPO/MATLWHST Location Product for Location Whse and Subloc. Storage Type
/SAPAPO/MATTXT Material Descriptions
/SAPAPO/MATEXEC Product: Execution Data
/SAPAPO/MATMAP Mapping Table for Products
/LIME/PI_PAR_BIZ Physical Inventory Document Business Key Parent Object#project #warehouse #ewm
/LIME/PI_LOGITEM Log Table for Item Data of a Physical Inventory Document
/LIME/PI_LOGHIST History Table for Physical Inventory LOG Entries
/LIME/PI_LOGHEAD Log Table for Header Data of a Physical Inventory Document
/LIME/PI_IT_BIZ Physical Inventory Document Business Key Item Object
/LIME/PI_DOC_TB Quantities for Physical Inventory Document Items
/LIME/PI_DOC_SER Serial Numbers for Physical Inventory Document Items
/LIME/PI_DOC_IT Table of Physical Inventory Document Items
/LIME/PI_DOCTYPE Document Types of Physical Inventory (Internal Settings)
/LIME/PI_DCTYTXT Description of Phys. Inventory ProcedureM 

Regards
Faraz Rahim

[Hitheshrao]

Hi Faraz Rahim , Thank you for your response