topic Re: serial numbers in Application Development and Automation Discussions

serial numbers

Former Member — Fri, 04 Sep 2009 08:09:52 GMT

dear sir,

can u plz tell me how i can fetch my serial numbers of my product in my daily production report. (alv report). through that i can recognise which products belongs to which serial number.through functionality i can check my serial numbers.but i want to show those serial numbers in my alv report.

through this subquery i can fecth my only first one serial no with respect to my material document no..and leaving the reamaning ones. how i can fetch the remaning ones. my query is:

select sernr from objk into it_so-sernr where obknr in ( select obknr from ser03 where mblnr = it_so-mblnr ) .

Re: serial numbers

Former Member — Fri, 04 Sep 2009 08:45:01 GMT

Hi,

Try this function module : SERIAL_NUMBER_GET_MATERIALS

MB_SERIAL_COPY Copy serial numbers of material documents

MB_SERIAL_PREPARE Prepare serial numbers of material documents

Re: serial numbers

Former Member — Fri, 04 Sep 2009 08:52:44 GMT

where i will have to declare these function..actually there is already made report and on rthat report i have to add one more fireld whose name is sernr. i have used above qury but it fetches only first serial number.what i have to do so i can get rest ones's.

Re: serial numbers

Former Member — Fri, 04 Sep 2009 09:39:34 GMT

Hi,

select sernr from objk into it_so-sernr where obknr in ( select obknr from ser03 where mblnr = it_so-mblnr ) .

I think it is need to provide an internal table it that Bold location.

Re: serial numbers

Former Member — Fri, 04 Sep 2009 09:51:06 GMT

hi,

my query is running without any error but there is some problem that i have i said it earlier.

it fetches only first one serial no. leaving reamaning ones.

Re: serial numbers

Former Member — Fri, 04 Sep 2009 09:54:43 GMT

Hi,

What i am saying here is you are providing work area with field at that time it is always getting only one value for one time execution.

Better is create an internal table with SERNR field and assign there instead of work area.

like Select sernr from objk into table it_sernr xxxxxxxxxxxxxxxxxxxxxxx.

at that time only you will get all values at a time into internal table.

Re: serial numbers

Former Member — Fri, 04 Sep 2009 11:35:44 GMT

Hi,

Please modify your query as :

select sernr from objk into table it_so-sernr

where obknr in

( select obknr from ser03 where mblnr = it_so-mblnr ) .

I think you are using IT_SO as Internal for Serial Numbers.

So include word 'TABLE' in your query as i hve written above.

Regds,

Anil

Re: serial numbers

Former Member — Sat, 05 Sep 2009 06:15:58 GMT

Hi,

use this code.


      SELECT *
        FROM ser03
        INTO TABLE i_ser03
       WHERE mblnr in mblnr
         AND mjahr eq mjahr.
     LOOP AT i_ser03 INTO w_ser03.
        SELECT *
          FROM objk
          INTO TABLE i_objk
         WHERE obknr EQ w_ser03-obknr.
        SORT i_objk BY sernr.
        LOOP AT i_objk INTO w_objk.
          itab-matnr = w_objk-matnr.
          itab-serno = w_objk-sernr.
          itab-mblnr = w_ser03-mblnr.
          itab-mjahr = w_ser03-mjahr.
        append itab.
       ENDLOOP.
ENDLOOP.

Re: serial numbers

Former Member — Tue, 08 Sep 2009 08:52:04 GMT

hello sir,

i dont know how we can deaclare that can u plz write that with synatx...

Re: serial numbers

Former Member — Mon, 21 Sep 2009 13:07:28 GMT

gud answers friendz.