SAP Inventory Inquiry T-Code Summary

SAP Inventory Inquiry T-Code Summary

To effectively manage inventory in the SAP system, various T-Codes (transaction codes) are utilized. This summary organizes key T-Codes by their primary purpose and functionality, such as inventory status, stock availability, and material movement analysis.

1. Key T-Codes for Inventory Inquiry

Basic Inventory Inquiry

• MB52: Warehouse Stocks of Material
  • Used to check inventory status by storage location and warehouse for specific materials.
• MMBE: Stock Overview
  • Suitable for viewing stock status by plant, storage location, and batch for specific materials.
• MB5B: Stock for Posting Date
  • Used to view inventory status on a specific date.
• FI T-CODE

Stock Availability and Requirements Management

• MD04: Stock/Requirements List
  • Allows checking material availability status and demand/supply requirements.
• CO09: Availability Check
  • Used to check available stock on specific dates.

Material Movement and Goods Issue/Receipt

• MB51: Material Document List
  • Retrieves records of material movements and goods issue/receipt transactions.
• MB5T: Stock in Transit
  • Displays the status of stock in transit.
• MB90: Output Processing for Material Documents
  • Reprocesses output related to material documents.

Batch Management

• MSC3N: Display Batch Master
  • Allows viewing detailed batch information for specific materials.
• BMBC: Batch Information Cockpit
  • Suitable for analyzing stock status and additional details by batch.

2. Special Stock and Material Management T-Codes

Special Stock Inquiry

• MB54: Customer Consignment Stocks
  • Displays inventory status for customer consignment materials.
• MMB1: Project Stock Overview
  • Retrieves stock data assigned to specific projects.
• MMBE: Sales Order Stock
  • Checks stock status allocated to sales orders.

Inventory Difference and Adjustment

• MI04: Enter Inventory Count
  • Inputs physical inventory counts and checks discrepancies.
• MI20: Batch Input: Post Differences
  • Analyzes discrepancies between physical and system inventory.

3. Reporting and Analysis T-Codes

• MC.9: Stock Turnover Analysis
  • Used to analyze stock turnover rates during specific periods.
• MCBE: Material Analysis by Material Group
  • Provides inventory analysis by material groups.
• MCBC: Stock/Consumption Analysis
  • Compares material consumption data with inventory levels.
• MB5L: Stock Value
  • Displays valuation data for inventory.

4. Practical Usage Tips

• Enter material numbers, plant codes, and storage location details accurately to retrieve specific inventory data.
• Utilize F4 Help to quickly search for material codes and storage location details.
• Regularly monitor inventory using MB52 and MMBE to prevent overstocking or stock shortages.

5. Additional Reference Materials

• SAP Help Portal: https://help.sap.com
• Refer to official SAP user guides and manuals.
• Note that the results of T-Codes may vary based on the SAP configuration in your organization. Always refer to internal manuals for precise information.