If i have some 5K record and need to be copied to one of SAP table to create/delete is there any possibility to do it at one go instead of creating/deleting one by one

Help
1

If i have some 5K record and need to be copied to one of SAP table to create/delete is there any possibility to do it at one go instead of creating/deleting one by one.

I read the excel using excel scope , stored the required columns data in variables and trying to create one by one in SAP table which is successful. But need to check if any other method of create all at a time is possible and if so how?

Thanks in advacne

2

Does Copy/Paste work?

3

Can you update them all at once manually, like is there a way in SAP? If there is then you should be able to follow that method to update all the records. However, I don’t think you can (I’m not an SAP expert). From my experiences, you need to click on each line and update one at a time.