Skip to Content

Serial Numbers dowload

Dear all,

I would like to know if there is a table i can use to download all the Delivery Notes created for an article number and the Serial numbers.

Thanks in advance for your help

Andrea

capture.png

capture.png (8.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 03, 2017 at 08:13 PM

    Use ST05 for SQL Trace to find any tables. There is also a PDF floating around the internet with most common SAP tables by module. Can be easily found in Google.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03, 2017 at 08:37 AM

    You could start with a join between following tables

     SELECT *
       INTO CORRESPONDING FIELDS OF TABLE itab
       FROM objk
       INNER JOIN ser01
          ON objk~obknr = ser01~obknr
       INNER JOIN ser03
          ON objk~obknr = ser03~obknr
       INNER JOIN lips
          ON ser01~lief_nr = lips~vbeln
       WHERE
          objk~taser IN ('SER01', 'SER03' ).

    (fast written, may will require adjustement, main table for selection should be SER01)

    Regards,
    Raymond

    Add comment
    10|10000 characters needed characters exceeded