Link between Serial No and Equipment No

[Former Member]

Hi,

What is the difference between Serial No (SERNR) and Equipment No (EQUNR) in MM Module.

What is the link between them?

Which tables contain this data?

Thanks

[Former Member]

Hi Naren,

Check the table : OBJK.

Thanks.

[Former Member]

Hi,

1.You will get the equnr and obknr in OBJK .

SELECT obknr

FROM ser02

UP TO 1 ROWS

INTO lw_obknr

WHERE sdaufnr EQ st_jtab-kdauf_aufk

AND posnr EQ st_jtab-kdpos_aufk.

ENDSELECT.

Regards,

SHIVA(reward if helpful).

[Former Member]

Hi,

Serial numbers are required for unique identification of the material. before the goods issue happens and the material is despatched, the material is scanned for the serial number.

Serial numbers are maintained for a material which is picked scanning of the serial number. (to see the serial number for a particular material, go to MMBE and enter the material and execute. Click on the batch, Go to environment and say display serial numbers). The serial numbers can be created in IQ01 for a material and the status of the serial number can be seen in IQ03. ECUS represents that the material is sold, ESTO represents that the material ia in stores and AVLB represents that the number is available.

For a combination of material and serial number, there is an equipment number. Th equipment number can be created in IE01 and can be viewed in IE03.

Regards

Kiran

[Former Member]

Hi,

Refer to the following code:

DESCRIBE TABLE int_move_mseg LINES wf_total_rec.

SELECT matnr werks xchpf sernp

FROM marc

INTO TABLE int_marc

FOR ALL ENTRIES IN int_move_mseg

WHERE matnr = int_move_mseg-matnr

AND werks = int_move_mseg-werks.

SORT int_marc BY matnr werks.

LOOP AT int_move_mseg.

READ TABLE int_marc WITH KEY matnr = int_move_mseg-matnr

werks = int_move_mseg-werks

BINARY SEARCH.

IF int_marc-sernp IS NOT INITIAL.

MOVE: int_move_mseg-mblnr TO int_equip-mblnr,

int_move_mseg-mjahr TO int_equip-mjahr,

int_move_mseg-matnr TO int_equip-matnr,

int_move_mseg-werks TO int_equip-werks,

int_move_mseg-zeile TO int_equip-zeile,

int_move_mseg-bwart TO int_equip-bwart.

APPEND int_equip.

ENDIF.

ENDLOOP.

IF int_equip[] IS NOT INITIAL.

SELECT obknr equnr matnr mblnr mjahr zeile bwart werk

FROM zvpr_objk_ser03

INTO TABLE int_ser

FOR ALL ENTRIES IN int_equip

WHERE mblnr = int_equip-mblnr

AND mjahr = int_equip-mjahr

AND matnr = int_equip-matnr

AND werk = int_equip-werks

AND zeile = int_equip-zeile

AND bwart = int_equip-bwart.

ENDIF.

Hope this helps.

Reward if helpful.

Regards,

Sipra