Skip to Content
author's profile photo
Former Member

Table LQUA

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • author's profile photo
    Former Member
    Posted on Apr 20, 2007 at 08: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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 20, 2007 at 08: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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 20, 2007 at 09: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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • author's profile photo
    Former Member
    Posted on May 03, 2011 at 11:32 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded