serial numbers

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

hello sir,

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

[Former Member]

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

[Former Member]

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.

[Former Member]

gud answers friendz.