Microsoft Excel Question:

Download Job Interview Questions and Answers PDF

Upload data from Excel into SAP?

MS Excel Interview Question
MS Excel Interview Question

Answer:

* Some of the Business functions (BAPI's / RFC unctions) offer data upload
* The general tool in SAP for data upload is the Batch input / call transactions

In the batch input file you specify screen by screen and field by field the input to SAP.

SAP has a recorder to create the sample file. Just run trans SHDB. Within this transaction, you run a case of the changes you want to do. On exit of the trans you will have a batch input file that you can download and from excel. Manipulate the file before you call the RFC function RFC_CALL_TRANSACTION.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
What are Excel Spreadsheet Number Formats?Show Excel Toolbars on Two Rows?