DATA SPOOLING FROM SAP
Process Overview
| Field | Details |
|---|---|
| Process Name | SAP Data spooling |
| Segment | GSC – Global Supply Chain |
| Process Family | Lenovo India |
| Process Users | Wyzmindz Solutions Pvt Ltd |
| Process Purpose | This report is instrumental in providing actionable insights, tracking performance, and supporting Lenovo’s sales strategies |
Version History
| Version Tag | Prepared By | Date of Update | Validated By | Reviewed By | Approved By | Revision Details |
|---|---|---|---|---|---|---|
| V 1.0 | Goutham | 22-12-2025 | Navneeth | Sushruth Vasista | Vishwanath Mosale | SOP Document Creation |
Distribution & Access List
| Designation | Read | Write | Approval |
|---|---|---|---|
| Analyst | Yes | No | No |
| Team Lead | Yes | Yes | No |
| Manager | Yes | Yes | Yes |
1.1 Purpose
The purpose of this process is to extract Stock Report, COOIS, and Stock Revenue data from SAP using predefined T-codes. These extracted files support downstream reporting activities such as REL Tool processing, Stock Report consolidation, and daily operational analytics for Lenovo India
1.2 Scope
- Geographic Scope: India.
- Business Segment: GSC
- Process Frequency: Daily
- Running T-codes MB52, COOIS, and MM60.
- Applying filters, layouts, and extraction formats.
- Exporting stock, manufacturing order, and revenue-related data into Excel.
- Saving and organizing output files in the appropriate folders for daily reporting
1.3 Business/Segment Overview
SAP spooling is used to extract plant-wise stock, production order status, and material-level data required for Lenovo’s supply chain, revenue analysis, backlog reporting, and stock visibility. These SAP outputs feed into multiple downstream systems such as REL Tool, FF Tool, and daily Stock Reports, helping business teams monitor inventory, plant status, and material movements across Lenovo’s operational segments.
1.4 Responsibility and authority
| Role | Name |
|---|---|
| Analyst | Gautham |
| Process Owner | Navaneeth |
| Process Manager | Dayanand |
| Escalation Manager | Sushruth Vasista |
| Approval Authority | Vishwanath Mosale |
1.5 Escalation Matrix
Escalation Matrix – WyzMindz Solutions Pvt Ltd (India)
| Sl. No | Name | Designation | Email ID |
|---|---|---|---|
| 1 | Sushruth Vasista | Manager | sushruth.vasista@wyzmindz.com |
| 2 | Vishwanath Mosale | Director | vishwanath.mosale@wyzmindz.com |
Escalation Matrix – Lenovo India Pvt Ltd
| Sl. No | Name | Designation | Email ID |
|---|---|---|---|
| 1 | Abhinav Tiwari | Mgr II, Order Fulfillment - AP CF Team | atiwari2@lenovo.com |
|2| Ananda M Lanka| Head - India Order Fulfilment & Order Center GSC - AP PC Customer Fulfillment & Logistics |analanka@lenovo.com |
1.6 RACI Matrix
RACI – WyzMindz Solutions Pvt Ltd (India)
| Report / Process | Responsible | Accountable | Consultation | Informed |
|---|---|---|---|---|
| SAP Data spooling | Goutham | Goutham | Navaneeth K | Lenovo India Pvt Ltd, Wyzmindz – Lenovo Process Team |
1.7 Access Required
- Outlook & Webmail Access
- MS Office Suite Access
- Access to Corporate Website
- Supporting documents will be stored here in the future
- Website: www.example.wyzminz
1.8 Overview of Tools
| Sl. No | Tool Name | URL | Description |
|---|---|---|---|
| 1 | QlikSense | https://owb.lenovo.com/ | Website used to extract data for reporting and analysis |
| 2 | CDMS (Channel Data Management System) | https://cdms.lenovo.com/DCSDM/ | Lenovo’s system used to upload and collect data |
1.9 Legends
- MTM - Machine Type Model (Product Number)
- NA: Not Available
- SAP :
1.10 Data Dependencies
- SAP application – Access to T-code (MB52).
1.11 Schedule of Reporting
- Frequency: Daily.
1.12 Process Flow Chart:
1.13 Steps of Procedure:
Stock Report T-code MB52:
- Login into SAP
- Copy T-Code from table of Spooling sheet and Paste in SAP as "MB52"
- Press "Enter"
- Now, in plant column paste the plants from status sheet
| Plants |
|---|
| I210 |
| I220 |
| IN5A |
| IN51 |
| IN52 |
| IN53 |
| IN54 |
| IN55 |
| IN56 |
| IN57 |
| IN58 |
- Don’t select offshore plants,
- Now apply layout by pressing CTRL+F9 and then select NK Stock Layout
- Then, Press "F8" for Execute
- Right Click on Data and Select "Spreadsheet"
- Select the Excel format from dropdown as "XXL" format and then click on Next
- Select "Table" option and then click on Next
- Click on "OK"
- Extract in the Excel workbook and save it in the present day’s folder as Stock Report DD-MM-YYYY
- Open the Stock Report file and Apply Filter in it
- Delete description column and change it as SL
- Go to plant column and Select "090X" in filter
- Change all the "090X" values into "0908"
- Save this file as "Stock Report REL month-date" in the S4 Files Folder of the present day
COOIS
- Login to SAP
- Create a new Session in SAP by Clicking on "Create Session"
- Copy T-Code from table of Spooling sheet and Paste in SAP as "COOIS"
- Press "Enter"
- Now select delivered[DLV] and exclude and select technically completed[TECO] and exclude
- Then, Press "F8" for Execute
- Right Click on Data and Select "Spreadsheet"
- Select the Excel format from dropdown as "XLSX" format and then click on Next
- Extract into the Excel workbook and save it in the desktop path and named as "COOIS month-date". Ex: COOIS Aug-20
- Click on Allow option.
Stock Revenue
- Select T- code MM60 and press “ENTER”
- Now from the extracted stock Report data copy Material column and paste it in a new workbook and delete duplicates
- Do the same for plant column
- Now in SAP paste the materials from workbook into material and plant into plant and press F8 to execute
- Right Click on Data and Select "Spreadsheet"
- Select the Excel format from dropdown as "XXL" format and then click on Next
- Select "Table" option and then click on Next
- Click on "OK"
- Extract in the Excel workbook and save it in the present day’s folder as Stock Revenue.
1.14 Output Overview
The SAP Spooling process generates three key daily outputs required for Lenovo’s operational reporting. These include the Stock Report (MB52), which provides plant-wise inventory details; the COOIS Report, which contains manufacturing order and production status data; and the Stock Revenue Report (MM60), which delivers material-level revenue-related information. All extracted files are saved in standardized formats and organized in designated folders for use in REL Tool processing, Stock Report consolidation, and other downstream reporting activities.
1.15 Validation checklist
- NA.
1.16 Communication
- NA.
1.17 Repository Details
📊 SAP Data Spooling Report (Excel)
Note
Master File should be manually updated on daily basis based on exceptions.
Video Recordings:
..\KT\KT Recordings\KT 3(Comparison btw CON Manual & CSD DSR)