Beas script for Inventory Transfer with Bin Location

Answered

Alvin Daroy

• May 27, 2019 02:42

Hi,

I'm trying to do Inventory Transfer with Whse Bin Manage in beas. in SAP Window I can see Beas Screen for batch booking with Bin Location right after adding the inventory tranfser. I would like to do this in my c# program via beas script. Is possible? can please provide beas script for me to be able to do this?

Thanks & Regards,

Alvin

Vote

1

• Official comment

  

  Martin Heigl

  • May 27, 2019 06:47

  Hi Alvin,

  - via DataIntegrationHub

  http://www.beascloud.net/docs/help/online_eng/index.html?datenimport_-export.htm

  - via common interface

  http://www.beascloud.net/docs/help/online_eng/index.html?common_service.htm

  - via window event system

  http://www.beascloud.net/docs/help/beasscript2/index.html?win-handle.htm

  - or the "modern way" in beas 9.3 PL 2 via web service (BSL)  - current only BETA Version

  http://www.beascloud.net/docs/help/bsl/index.html  ( <- current BETA )
• 

  Alvin Daroy

  • May 28, 2019 02:12

  Hi Martin,

  Thanks for the reply. I'm currently using the common interface. but I don't know exactly what script to be use to perform the Bin Booking. Can Please provide sample script?

  Thanks,

  Alvin
• 

  Martin Heigl

  • May 28, 2019 07:40

  Hi Alvin,

  which beas version do you use? Is it possible to use beas 9.3 PL 2?
• 

  Alvin Daroy

  • May 28, 2019 07:48

  Hi Martin,

  i"m using beas 9.3 PL2

   
• 

  Martin Heigl

  • May 29, 2019 03:43

  Hi Alvin,

  in beas 9.3 PL 3 you can use the new beas service layer over common service

  Really simple

  
• 

  Martin Heigl

  • May 29, 2019 04:14

  beas script example:

  destroy=res
  declare=res=ue_reservation
  res=planned=new=transfer
  // Add all lines here
  res=planned=addline=itemcode=1111<tab>&
  whscode=BW<tab>&
  bincode=001003<tab>&
  towhscode=BW1<tab>&
  tobincode=A-0102<tab>&
  quantity=1
  // save
  res=planned=updateline
  // execute
  res=transfer=comments=myTransferDoc1
  destroy=res
  
  
  You can test this in server manager
  
  
  
  
  and it is possible to convert this in C# code
  

  if you click on this icon, the system save follow in the clipboard
  
  

  String sql = "insert into \"BEAS_COMMON_INPUT\"";
  sql += "(\"COMMONTYP\", \"PARAMETER1\", \"TEXTPARAMETER\") values('script', '',\r\n";
  sql +="destroy=res\r\n";
  sql += "declare=res=ue_reservation\r\n";
  sql += "res=planned=new=transfer\r\n";
  sql += "res=planned=addline=itemcode=1111<tab>&\r\n";
  sql += "whscode=BW<tab>&\r\n";
  sql += "bincode=001003<tab>&\r\n";
  sql += "towhscode=BW1<tab>&\r\n";
  sql += "tobincode=A-0102<tab>&\r\n";
  sql += "quantity=1\r\n";
  sql += "res=planned=updateline\r\n";
  sql += "res=transfer=comments=myTransferDoc1\r\n";
  sql += "destroy=res )";

  SqlCommand command = new SqlCommand (sql,connection);
  command.ExecuteNonQuery();

   

   
• 

  Alvin Daroy

  • May 29, 2019 09:35

  Hi Martin

  This solved my problem. Thank you so much.

  Regards,

  Alvin

Please sign in to leave a comment.