Create an SQL to link Production Orders from Sales Order Line Items

TI Hybel

• March 02, 2022 12:28

Hi!

How I can link an Production Order that has been created from a Sales Order Line?

On BEAS_FTHAUPT table, I can get the Sale Order Docnum, but I am haveing some issues when my Sales Order have many rows with the same Item Code.

SAP B1 9.3

Thanks in advance1

 

Vote

0

• 

  Martin Heigl

  • March 02, 2022 12:39

  Hi, do you work with reservation?
• 

  TI Hybel

  • March 02, 2022 12:41

  Not yet, but we are planning to
• 

  Martin Heigl

  • March 02, 2022 13:39

  Hi,
  
  if you create a work order from sales order, the work order is linked automatically. Why do you need to link again?
  
  
  BEAS_FTPOS
  basetype = 17 (sales order)
  auftragint = ORDR.DocEntry
  basedocnum = ORDR.DocNum
  auftragpos (rdr1.linenum)
  baseline (rdr1.linenum)
  auftragherkunft "K"
  
  
• 

  TI Hybel

  • March 02, 2022 13:46

  Hi Martin!

  My report didn't like with linenum of Sales Order... Your asnwer solve my question!

  these two columns are the conection that I was looking for!

  auftragpos (rdr1.linenum)
  baseline (rdr1.linenum)

  Thank you so much!

   

   

Please sign in to leave a comment.