When any organization plans to go for implementing the warehouse management; it has major concern about the physical inventory process, particularly last physical inventory date.
When system goes live with warehouse management functionality and material is maintained with CC indicator for cycle count, and then it is common problem that at the time of cycle count inventory creation all materials are shown as due for physical inventory. This is because inventory document is not available in the system and last inventory date is not updated in quant data table. It is a big challenge for the organization to manage this situation.
In my previous project, we have implemented the below solution to tackle this issue so that we can streamline the physical inventory process.
Recommandation: Take the help from ABAP expert, not from beginer ABAP developer to use this solution.
1. Maintain stock datasheet with last inventory date:
The business should maintain a data sheet which contains the stock details along with last physical inventory date. This date can be downloaded from the legacy system. The data sheet should contain Material number, Plant, SLoc, Last physical inventory date.
2. Download the WM stock details from the current SAP system
When we upload the stock data in the warehouse system during the cutover activity, the system displays this stock detail in quant (LQUA) table. We need to download this quant details into datasheet with Quant number, material number, Plant, Storage location.
3. Match Quant datasheet with last inventory date
Now, you have two different datasheet, one from legacy system with last inventory date for material and another is quant details from SAP system. You need to update the quant datasheet with last inventory date from your legacy system datasheet. There might be more than one quant for the same material so in that case, you need to keep the last inventory date same for all the quant in particular storage location.
4. Upload last inventory date in Quant table
After updating the last inventory date in quant datasheet, it is required to upload this last inventory date in quant data table (LQUA). So to upload this inventory date in quant table, you need to develop program. In our case, our developed program is available here.
5. Make changes in cycle counting (LICC) program
Once you uploaded the last inventory date in quant table, then you need to modify the cycle count inventory creation (LICC) program. The system uses the following logic when it calculates the due date. First it looks the quant table and checks whether inventory document (LQUA-IVNUM) is available. Incase, inventory document is available then it considers the last inventory date (LQUA-IDATU) and calculates the due date based on CC indicator from the material master. And if inventory document date is not initiated then it will consider that quant is not counted in the past and it will show up as due.
Just keep in mind that, you have uploaded last inventory date, not inventory document number so you need to make the changes in the program to consider last inventory date from quant table even though inventory document is not available so make the following changes in Cycle count program (2RLINV060).
*…….accepting IDATU only when quant has an IVNUM………………*
if not lqua-ivnum is initial.
move: lqua-idatu to xwmim-idatu, ” Date of inventory by quant
lqua-idatu to tab-idatu.
* endif.*…….if there is no inventory data: take date of quant creation….
This customized / changed program you can use only for first year and later on you can switch over to the standard program.