Hi,
there are various tables to get the data.
tables SER01, SER02... are correct but that will show the relationships between the serial number and other documents in its life.
This way, having the serial number you can get the results in table OBJK, filtering with the SERNR. Ordering this by date will give you the history of the serial number, the same that you can see in IQ03, for example. This table has the OBKNR and a table stored in TASER. With both of these data you can go to that tables in TASER and filter them with the OBKNR to get the document related to the serial number or where the serial number was assigned.
SER01 has the deliveries, SER02 has the sales orders, SER03 has the material documents (MIGO), SER04 has the inspection lots from QM, SER05 has the production orders, SER06 has the handling units, SER07 has the inventory documents, SER08 has the purchse orders and SER09 has the purchase requisitions.
This way you can get the history as it's shown in IQ03.
But, if what you need is the action log, you can check JCDS table. Entering this table with the OBJNR, which is in my case IE + bunch of 0s + serial number, will net you the statuses in the serial number's life and the date that status became active or inactive. The statuses that have been activated will have INACT field devoid and the ones that have been de-activated that date will have it marked with X.
To get the meaning of these statuses you can always use table TJ02T, so you can get for example that status I0099 equals "Available".
Hope it helps.
Best regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.