Skip to Content
0
Mar 09, 2020 at 10:41 PM

SAP B1 Studio project

111 Views Last edit May 21, 2020 at 07:04 PM 3 rev

Hello everyone, I hope someone can guide me. I want to use SAP B1 Studio to create a data entry form with a grid to copy and paste multiple rows from Excel into and then have a button to trigger writing the data to a UDO/UDT when the button is pressed. Data could easily be managed in a single Table or Split - Whichever is easier. Data Table would need the following columns:

UDO Header: GRPO # Batch Number#

Rows: Can Code, Production Date, Expiry Date, Qty.

Batch Numbers would always be unique for a UDO as header info, but there could be multiple Entries for the rest .

Or I could format as Record #, GRPO#, Batch #, Can Code, Production Date, Expiry Date, Qty

I specifically do not want the end users to be able to view or access the master data table. This is critical information and I don't want users to be able to edit / Delete the existing data.

This is the last piece of a much larger project that I am working on and could really use some help. Completely new to SAP B1 Studio.

Thanks

Ken