problem while to display serial number with current stock

[former_member611383]

Dear all,

               I am facing problem in mmbe t-code .i have developed one zscreen in that screen i am going to display serial number for particular stock of material in mmbe for  e.g : In MMBE tcode for particular material sto.location and plant having 4 stock when i m going display stock of particular material. system not showing me correct stock means if in MMBE 4 stock is available then system must be showing me 4 serial numbers of that 4 quantity.still i am using EQUI and EQBS TABLE..

2. another issue is system showing me unrestriced and quality inspection serial numbers simutaneously but user want only display unrestricted stock in my zscreen  please find below attached screen shots.

e.g : if 4 quantity in unrestriced stock and 1 in quanlity inspection stock by drill it down i am getting 5 serial number on my zscreen but i want to display only 4 serial numbers which in unrestried stock for 4 quantity

Please find below select query

this query currently i am using in my program

SELECT   matnr

                sernr

                b_lager

        FROM equi

        INNER JOIN

        eqbs ON equi~equnr = eqbs~equnr

        INTO CORRESPONDING FIELDS OF TABLE IT_EQUI

        WHERE matnr = it_conf-matnr2            " it_conf-matnr2 is my screen field

        AND b_lager   = it_conf-lgort2               " it_conf_lgort2 is my screen field

Please tell me to fulfil this requirement.

please find below attached screen shots of mmbe material and zscreen serial numbers

Thanks,

Yogesh

[sabirshah1]

There would be some indicator field in table which will indicate unrestricted stock or quality inspection stock, cjeck it and add in ur query where condition

and about serial number : what u r really want to do , u want to create new serial number or get it from table only , specify

[former_member611383]

Hi Sabir,

               Thanks for ur reply but i have already created serial number just want to fetch on my zscreen e.g. : suposse in MMBE t-code for  let say material (ABC) plant= 1004 and storage location is g007  have 10 quantity. when i enter above material plant and storage location on my zscreen that time i want system must be show  have 10 serial numbers for that 10 quantity on my zscreen.

tell me which indicator field avaialble in EQUI OR EQBS table.

Thanks,

Yogesh

[Former Member]

Hi Yogesh,

     Check the field LBBSA in table EQBS.

     Table for Inventory Status for Serialized mater... | SCN

     Hope this help!

Regards,

Vinoth

[former_member611383]

Hi Vinoth,

               Thanks for ur reply but i have already created serial number just want to fetch on my zscreen e.g. : suposse in MMBE t-code for  let say material (ABC) plant= 1004 and storage location is g007  have 10 quantity. when i enter above material plant and storage location on my zscreen that time i want system must be show  have 10 serial numbers for that 10 quantity on my zscreen.

tell me which indicator field avaialble in EQUI OR EQBS table.

Thanks,

Yogesh

[former_member611383]

Thanks Vinoth i will works fine again Thaks a lot .

[former_member611383]

Thanks vinoth it will works. thanks a lot.

[Former Member]

Hi Yogesh,

LBBSA in table EQBS is the field which differentiates the stock type like unrestricted, quality inspection, etc.,

You can count the serial numbers from EQUI and EQBS table and show the total quantity.

If you want to show only the unrestricted stock,

then put a condition in your select query that EQBS-LBBSA = '01'.

Regards,

Vinoth

[former_member462025]

Hi Yougesh,

Please confirm do you want to display Unrestricted stock & Stock in quality inspection separately?

Regards

Venkatesh

[former_member611383]

Hi venkatesh,

                     I want to display only unrestriced stock on my z screen