Skip to Content
0

Serial Numbers dowload

Dec 27, 2016 at 02:44 PM

74

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jelena Perfiljeva
Jan 03, 2017 at 08:13 PM
1

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.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

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

1

Dunno, some random dude with "various SAP Professionals". :)

image.jpg (28.2 kB)
1

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

0
Raymond Giuseppi
Jan 03, 2017 at 08:37 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded