Serial Numbers dowload

[Former Member]

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

[RaymondGiuseppi]

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

[Jelena_Perfiljeva]

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.

[ChrisSolomon]

Wonder who wrote that original Visio-turned-PDF of SAP tables. haha

[Jelena_Perfiljeva]

Dunno, some random dude with "various SAP Professionals". 🙂

[ChrisSolomon]

Ahhhhh the good ol' days.....hahahahahaha