Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Serial Numbers dowload

Former Member
0 Kudos

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

5 REPLIES 5

raymond_giuseppi
Active Contributor
0 Kudos

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
Active Contributor

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
Active Contributor

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

Jelena
Active Contributor

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

ChrisSolomon
Active Contributor
0 Kudos

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