[Marco] Universal Function - Beas material list - B1 Up

Answered

Marcelo Medina

• May 26, 2021 02:03

I need to create a macro that reads me the material lines of a beas table and places it in the transfer requests, the problem I have with the beas_ftstl table is that it does not have the linenum for the item jump, I was able to solve the problem with a temporary table but the b1 up macro does not accept temporary tables

Vote

0

• 

  SSP Automation

  • May 26, 2021 02:05

  Thank you for your request. It has been scheduled for review by the development team that will get back to you should there be questions.
  (Please note that as we are user-driven we can't guarantee that your request will be met unless it gets many votes and/or fit the product vision)
  Read more about the Feature Request process here
  [Internal Id: 57646]
  
• 

  Rasmus Jensen

  • May 28, 2021 05:28

  Could you please explain this request in a bit more detail as I'm not 100% I understand it?

  As for temporary tables in general (don't know if that is relevant or if this is MSSQL or HANA), if they do not work, could you not use the SQL as "table" method; aka something like this:

  SELECT Temp.CalculatedValue, Temp.CardCode FROM
  (SELECT DocEntry+DocNum AS CalculatedValue, CardCode FROM OINV) AS Temp

   

Please sign in to leave a comment.