12-27-2016 2:44 PM
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
01-03-2017 8: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
01-03-2017 8: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.
01-03-2017 8:32 PM
Wonder who wrote that original Visio-turned-PDF of SAP tables. haha
01-04-2017 2:25 PM
01-04-2017 3:14 PM