Serial numbers table?

Answered

Luis Abellaneda

• March 21, 2019 09:57

Is there any table were Beas store the traceability of serial numbers? I've seen the process that the system perform when we launch the traceability of serial and batch number in the WO, but, I think the system is extracting this information in the moment we launch this, but I cannot see if there is any place where the info is stored.

Vote

0

• 

  Martin Heigl

  • April 01, 2019 11:10

  Range = Direct

  

  The System check only table BEAS_FTZUORDNUNG

  select ft.from_item+'' as distnumber,ft.from_version+'' as version,ft.from_itemcode+'' as itemcode, case when OITM.ManSerNum = 'Y' then OSRN.SysNumber else OBTN.SysNumber end as sysnumber FROM BEAS_FTZUORDNUNG ft INNER JOIN OITM on OITM.ItemCode=ft.from_itemcode LEFT OUTER JOIN OBTN on OBTN.ItemCode=ft.from_itemcode and OBTN.DistNumber=ft.from_item LEFT OUTER JOIN OSRN on OSRN.ItemCode=ft.from_itemcode and OSRN.DistNumber=ft.from_item WHERE ft.to_itemcode=N'A11896' and ft.to_item=N'BRM0011'

   

  If you change Range to "all", the system search in the tables of transaction documents.
  You can see every SQL statement in the Debug window

Please sign in to leave a comment.