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