Currently there is a nice feature to allow user batch upload from Excel/CSV files into child table / Grid in the document by activating the Allow Bulk Edit check box for the child table field in the doctype, check the below attached screen shot for purchase order form
There are the following steps/clicks needed:
- save the Excel file,
- click upload button
- click browse button and locate to the target folder, choose the file
- click upload file button
- click update button
For same function in SAP, user do the following
- Select the rows to be copied in Excel, Ctrl + C
2. Place the cursor in the current active cell, Ctrl + V
then it is done.
It is suggested to further enhance the child table bulk edit feature to allow direct copy and paste mode as in SAP.