SAP Stock Overview: Stock Tcodes, SAP Stock Tables and BAPI
SAP stock Overview covers all related subjects for SAP Materiel Stock in MM.
It starts with how to check Material Stock.
Then comes the important SAP Tcodes for handing Stocks in SAP MM/SD (Material Management / Sales and Distribution ) and SAP WM ( Warehouse Management ).
The next part will introduce the different SAP Stock Types .
The last section lists the the most important BAPI when dealing with SAP Stock.
Display SAP Stock Overview for a material
You can directly check the stock on a SAP Material.
To do, Go to Material (MM03) and go to Environment > Stock Overview
The stock will be displayed by:
- Unit of Measure: the default Unit of Measure for the SAP Material ( MARA-MEINS )
- Company Code
- Plant : MARD-WERKS
- Storage location: MARD-LGORT
- SAP Stock Type
SAP Stock Tcodes
Use the transaction MMBE to get overview of SAP Stock for a particular material and access the previous screen.
To sum up, the most important Tcodes for displaying stocks in SAP MM are
|SAP Stock Tcodes||Description|
|MB51||Material Doc. List|
|MB52||List of Warehouse Stocks on Hand|
|MB53||Display Plant Stock Availability|
|MB55||Display Quantity String|
|MB56||Analyze batch where-used list|
|MB57||Compile Batch Where-Used List|
|MB58||Consgmt and Ret. Packag. at Customer|
|MB59||Material Doc. List|
|MB5A||Evaluate Batch Where-Used Archive|
|MB5B||Stocks for Posting Date|
|MB5D||Delete Docs of Batch Where-Used File|
|MB5E||Create Batch Where-Used Archive|
|MB5K||Stock Consistency Check|
|MB5L||List of Stock Values: Balances|
|MB5OA||Display Valuated GR Blocked Stock|
|MB5S||Display List of GR/IR Balances|
|MB5T||Stock in transit CC|
|MB5TD||Stock in Transit on Key Date|
|MB5U||Analyze Conversion Differences|
|MB5V||Manage Batch Where-Used Archive|
|MB5W||List of Stock Values|
|MMB1||Create Semifinished Product|
SAP WM Stock Transactions
On SAP WM, check rather these SAP Tcodes:
|SAP WMStock Tcodes||Description|
|LS24||Display Quants for Material|
|LS25||Display Quants per Storage Bin|
|LS26||Warehouse stocks per material|
|LS27||Display quants for storage unit|
|LS28||Display storage units / bin|
SAP Stocks Types
There is 2 types of stocks: Normal stocks and special stocks.
SAP Normal Stocks
For Normal Stocks :
SAP Special Stocks
Special stocks are stocks that are managed separately as a result of their not belonging to your company or being stored at a particular location
Special stocks and special procurement types are divided into the following areas:
- Stock transfer using stock transport order
- Third-party processing
- Returnable transport packaging
- Pipeline handling
- Sales order stock
- Project stock
SAP Stock Tables
Check this post for SAP SAP Stocks Tables and Types
You will find the above link:
SAP Stock BAPI
Find here some relevant BAPI to retrieve a material Stock in SAP.
The first SAP STock BAPI we will detail is MARD_SINGLE_READ to read stock line.
The next one is MB_READ_MATERIAL_STOCKS.
The BAPI MARD_SINGLE_READ read the table MARD where the sum of stock is stored.
The field for free stock (available stock) is MARD-LABST.
The SAP Stock BAPI MB_READ_MATERIAL_STOCKS is used to read Stock in detail for a SAP material.
Note that data can retrieve directly from tables/fields: TRTYP, XNEUP, XAENP, MBEQU, SHKZG, XENQU, KZDZV, XMBWL, MBVAL, XWERT
CALL FUNCTION 'MB_READ_MATERIAL_STOCKS' "
mtcom = " mtcom
trtyp = " t158-trtyp
xneup = " t063f-xneup
xaenp = " t063f-xaenp
mbequ = " tcurm-mbequ
shkzg = " mseg-shkzg
xenqu = " c
kzdzv = " tcuch-kzdzv
mkpf = " mkpf
xmbwl = " c
mbefu = " mbefu
mtcor = " mtcor
mtper = " mtper
x156m = " t156m
x156w = " t156w
xstru = " wsos_stuli
xmchb = " smchb
dm07m = " dm07m
vm07m = " vm07m
mseg = " mseg
LOCK_ON_BATCH = 1 "
SAP Stock Movement BAPI
Check here the List of important SAP Good Movement BAPI (Create,Cancel and Getdetails) in the following link: List of important SAP Good Movement BAPI (Create,Cancel & Getdetails).
You will find also an useful tip on how Create a Material Document with Equipment ( Serial number ).