topic Re: Table LQUA in Application Development and Automation Discussions

Table LQUA

Former Member — Fri, 20 Apr 2007 08:51:08 GMT

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

Re: Table LQUA

Former Member — Fri, 20 Apr 2007 08:57:40 GMT

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

Re: Table LQUA

Former Member — Fri, 20 Apr 2007 08:59:41 GMT

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

Re: Table LQUA

Former Member — Fri, 20 Apr 2007 09:15:31 GMT

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

Re: Table LQUA

sarvesh_gudapati2 — Wed, 25 Apr 2007 13:51:01 GMT

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 don’t 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.

Re: Table LQUA

Former Member — Tue, 03 May 2011 11:32:32 GMT

This message was moderated.