Skip to Content

SD Delivery Serial Number auto generation ?????

Hi All,

Hope some one is able to provide some points on this!!

Basis Release 620.

Client requires that the serial numbers be automatically generated for items copied from a sales order to a delivery note.

Anyone got a clue as to how this can be accomplished?

Copy requirements (vofm) for deliveries works on the delivery header level and not the item which is required.

Data Transfer requirements like wise works at the header level.

While the user exit "MOVE_FIELDS_TO_LIPS" does not have the required fields available, but does work at the item level.

Where does SAP save the serial numbers for the actual number of items to be delivered? EG

Delivery Item (LIPS) links to Serial Numbers (????).

Thanks in advance for any advice

David Cooper

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • author's profile photo
    Former Member
    Sep 22, 2005 at 09:19 AM

    I am again not sure what you are trying to achieve.

    While creating a delivery LIPS-VBELN will not be available as delivery is not created by that time.

    ( Then how to goto LIPS -> SER01 -> OBJK ).

    Also you emntioned EQUI.

    What I understand is when you are creating a Delivery for a sales order , you already have some serial number in dataase( most likely in EQUI ) which you would like to copy to SER01 , which sounds absurd .

    See the field descriptions -

    EQUI-EQUNR -> Equipment Numbers

    SER01-OBKNR ->Object list number

    You have to be more specific.

    Cheers

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 22, 2005 at 08:08 AM

    By Serial Numbers do you mean VBAP-POSNR ( Sales Doc Item ) or is it something else. Can you give more details as to which field you want to copy from Sales order to Delivery??

    Cheers

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Sanjay,

      The field is not on VBAP, it is on EQUI. IE EQUI-SERNR.

      Use this as a basis as follows:

      IF LIPS-LFIMG gt 0.

      select * from eqbs

      where kdauf = lips-vgbel

      and kdpos = lips-vgpos.

      select single * from equi

      where equnr = eqbs-equnr.

      ?????-???? = equi-sernr.

      -


      lips-sernr is not suitable as it is only 8 characters where equi-sernr is 18.

      Screen SAPLIPW01-0200 is used to enter the serial numbers in screen field RIPW0-SERNR, but this is not available for input in the user exit.

      Any ideas?

  • author's profile photo
    Former Member
    Sep 22, 2005 at 08:35 AM

    Hi,

    The database table is SER01. (Link - LIPS to Serial Numbers)

    Sri

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member David Cooper

      hi,

      try this one to find the serial number

      select a~sernr into gt_sno-serialno from equi as a

      inner join eqbs as b on aequnr = bequnr

      where amatnr = gt_upload-matnr and blbbsa = '01'

      and b~b_werk = gt_upload-werks

      and b~b_lager = gt_upload-lgort.

      serial number is related with material number, plant and storage location

      cheers,

      sasi

  • Oct 05, 2005 at 02:12 PM

    Hi,

    in SD customizing you can modify the serial number profile (Sales and Distribution->Basic Function->Serial Number Profile) for the SDLS Serializing Procedure, so that the serial number usage is automatic.

    SAP store the last serial number for a material in the table MASE.

    I hope this help.

    Francesco

    Add comment
    10|10000 characters needed characters exceeded