04-20-2007 9:51 AM
Hi All,
Could any one of you tell me what is LQUA and LINV used for.
I am working for WM module, what do you mean by cycle counting in this.
Thanks,
Mark
04-20-2007 9:57 AM
Hi,
LQUA is used for Quants which is a
Unique code within a warehouse number used to identify a material stock of a particular category in a storage bin of a warehouse
where as LINV is used for Inventory data per quant
The Inventory record number Number is the one that identifies an inventory process within the annual inventory procedure, the continuous inventory procedure, inventory based on a stock placement, or inventory based on a zero stock check.
The inventory number groups together all the different storage bins under one common number.
reward if useful
regards,
ANJI
Message was edited by:
Anji Reddy Vangala
04-20-2007 9:59 AM
Hi
LQUA table is to store the quantity of a material in astorage bin : for example the qty transfered by a certain movement or the qty of a certain batch.
LINV is the table for the inventory.
Max
04-20-2007 10:15 AM
To be more specific, I need to list out numer of materials for physical inventory based on ABC category in cycle counting. I also want that how many times a material has come in the inventory in the current fiscal year LINV-NANUM
Can any one of you suggest me as to how to go about it.
I guess table LQUA, LINV and MARC are of use to achieve this. But how to go about doing it I do not know, As I am not familiar with the functionality of these table apart from MARC.
Thanks,
Mark
04-25-2007 2:51 PM
Mark,
Please see the details below. Reward Points if helpful.
thanks,
Cycle counting involves creating of System Inventory record, recording count results and clearing the differences in WM and IM.
MARC - Plant Data for Material (Contains cycle count indicator ABCIN)
LINK Inventory document header in WM (Inventory Record Header)
LINV Inventory data per quant (Inventory Record Detail. Links to LINK)
LQUA Quants (Links to LINV)
Please check the following configuration for intervals defined for each ABC indicator:
Cycle count indicators and their intervals are stored in configuration in the following location: Materials Management -> Inventory Management and Physical Inventory -> Physical Inventory -> Cycle Counting.
Cycle Counting Procedure:
LI01n/Li02n/LI03n Create/Modify/Display System Inventory record, or use LX26 by Cycle counting method.
LI11n Record count Results
LI20 Clear Differences in WM
LI21 Clear differences in IM
If you are looking at this data with compliance perspective, I suggest you to build a custom report as SAP cycle counting reports dont show the result at material level. Cycle counting by SAP ensures that all the bins are counted, but not necessarily all materials in each ABC class are counted as per the predefined intervals.
You can have the report with
Material Number - One record per material number for the selected warehouse, plant, storage location.
Cycle Count Class - Found on the Plant/Data Store 1 view of the material master. Table MARC, field ABCIN.
Last Count Date - Found by taking the last inventory record for the material in table LINV and finding the count date for that record in table LINK.
Indicator - An indicator to flag the line as a material that needs to be counted. Materials Management -> Inventory Management and Physical Inventory -> Physical Inventory -> Cycle Counting. Go to this table for the plant and each cycle count indicator to determine the interval workdays. Calculate the first interval by adding the interval workdays to the first workday of the year. If the current date is between the two dates then this is the current period. Otherwise add the interval to the end of the first interval to find the end date of the next interval. Once the correct interval has been found determine whether the last count date is within the interval. If it is not the indicator should be set. This means the material should be counted atleast once in this period.
Other useful transactions:
MC40/MC41 Cycle count indicator classification of materials by usage/requirement
LX25 Inventory Status report at warehouse level
LX26 Carry out inventory using cycle counting method (Check this program on the logic about how the configuration results into selection of quants for count creation)
MIDO Display Physical Inventory Overview
MIBC ABC analysis for cycle counting.
05-03-2011 12:32 PM