topic Re: Serial Numbers dowload in Application Development and Automation Discussions

Serial Numbers dowload

Former Member — Tue, 27 Dec 2016 14:44:41 GMT

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

Re: Serial Numbers dowload

RaymondGiuseppi — Tue, 03 Jan 2017 08:37:55 GMT

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

Re: Serial Numbers dowload

Jelena_Perfiljeva — Tue, 03 Jan 2017 20:13:51 GMT

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.

Re: Serial Numbers dowload

ChrisSolomon — Tue, 03 Jan 2017 20:32:12 GMT

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

Re: Serial Numbers dowload

Jelena_Perfiljeva — Wed, 04 Jan 2017 14:25:48 GMT

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

Re: Serial Numbers dowload

ChrisSolomon — Wed, 04 Jan 2017 15:14:25 GMT

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