|
From Excel to ABAP - Is batch mode possible ?
SAP ABAP questions and answers
(Continued from previous question...)
From Excel to ABAP - Is batch mode possible ?
DATA w_file TYPE string.
* Convert the file path into string
w_file = p_input.
* Internal Table should have same field sequence as EXL File.
CLEAR t_upload.
REFRESH t_upload.
* Call function to upload the data into internal table
CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = w_file
filetype = 'ASC'
has_field_separator = 'X'
TABLES
data_tab = t_upload
EXCEPTIONS
file_open_error = 1
file_read_error = 2
no_batch = 3
gui_refuse_filetransfer = 4
invalid_type = 5
no_authority = 6
unknown_error = 7
bad_data_format = 8
header_not_allowed = 9
separator_not_allowed = 10
header_too_long = 11
unknown_dp_error = 12
access_denied = 13
dp_out_of_memory = 14
disk_full = 15
dp_timeout = 16
OTHERS = 17.
IF sy-subrc NE 0.
* MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
* WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ELSE.
* Delete the first row of heading from the uploaded table
DELETE t_upload INDEX 1.
ENDIF. " IF sy-subrc EQ 0.
(Continued on next question...)
Other Interview Questions
- What is an ABAP?
- What is an ABAP data dictionary?
- What are domains and data element?
- What is foreign key relationship?
- Describe data classes.
- What are indexes?
- Difference between transparent tables and pooled tables.
- What is an ABAP/4 Query?
- What is BDC programming?
- What are the functional modules used in sequence in BDC?
- What are internal tables?
- What is ITS?
- What is DynPro?
- What are screen painter and menu painter?
- What are the components of SAP scripts?
- What is ALV programming in ABAP? When is this grid used in ABAP?
- What are the events in ABAP/4 language?
- What is CTS and what do you know about it?
- What are logical databases? What are the advantages/ dis-advantages of logical databases?
- What is a batch input session?
- How to upload data using CATT ?
- What is Smart Forms?
- How can I make a differentiation between dependent and independent data?
- What is the difference between macro and subroutine?
- What is the differrences between structure and table in data dictionary in ABAP?
- What is the difference between collect and sum?
- How we format the data beofore before write statment in report ?
- What is the difference between Table and Template?
- When do we use End-of-selection?
- In evevts start-of-selection is default event. When we have to use this event explicitly? Why?
- What is the differences between ABAP and OOABAP. In which situation we use OOABAP?
- What is table buffer? Which type of tables used this buffer?
- What is the use of pretty printer ? Exactly where can we link the functional module to abap coding.
- What is the difference between SAP memory and ABAP memory?
- What is the difference between Type and Like?
- What is Tcode SE16. For what is it used. Explain briefly?
- What are different ABAP/4 editors? What are the differences?
- What is difference between dialog program and a report?
- How do you connect to the remote server if you are working from the office for the client in remote place.
- Explain about roll area , Dispatcher, ABAP-Processor.
- Which one is not an exit comand ? (Exit, cencle, stop, back)
- What is Field sysmbol ?
- What is lock object ?
- Why BAPI need then BDC ?
- What are the advantages and disadvantages of using views in ABAP porgramming ?
- How data is stored in cluster table?
- Have you used performance tuning? What major steps will you use for these?
- How to create client independent tables?
- What type of user exits have you written?
- How can you debugg a script form?
- How do we debug sapscript?
- What are the different types of data dictionary objects?
- What is the step by step process to create a table in data dictionary?
- Can a transparent table exist in data dictionary but not in the data base physically?
- What are the domains and data elements?
- What is a collect statement? How is it different from append?
- On ABAP: Did you set up a workflow? Are you familiar with all steps for setting up a workflow?
- In the ‘select’ statement what is “group by”?
- How can I copy a standard table to make my own z_table?
- From Excel to ABAP - Is batch mode possible ?
- Q: Is there any standard SAP report which gives a count of the number of times a program is executed ?
- Q: When we create a customer the information is updated in structure RF02D and the some tables like KNA1 are updated. How can we find the tables for master data transactions?
- Q: How can we use CAD with SAP ?
- Q: How can I access SAP through Internet?
- Q: How can we transport the standard text?
- Q: How to find what transactions a particular user was running for a given period in the past (Eg: from 1st of a month )
- Q: We want protect/lock a field so that only selected people can change the value while others can only read. How to set the authorizations?
- Q: How to lock an user defined transaction for some time during which no user can access the same?
- Q: Our ABAP program is working properly in Foreground. Can I schedule it for background processing on the weekend?
- Q: How can we send a mail to the user intimating him that his report/BDC is completed in background?
- We get the total number of pages as expected by using 'SAPSCRIPT-FORMPAGES' in a duplex layout....
- Q: Can I Print a logo on an Invoice?
- We want to move a SAP table to an Access table using TABLE_EXPORT_TO_MSACCESS_RFC Importing parameters are ...
- Q: We want an RFC do the following transactions - MB1A, MB1C,>MB01 (goods receipt/issue).
- Q: In a Dev instance, we want to transport a modification to a layout set from one client to another. What is the best way?
- Q: We need to keep track of the transports that need to flow through to other systems (ie, DEV, TST, TRN, PRD etc). Is there a way do this?
- How can we want to add this additional field from a different table?
- We need to download an internal table to the Presentation Server(local workstation) ....
- We are calling transaction VL01 in batch input to create deliveries using a program for delivery due list ...
- Q: What are some sample Direct input data transfer programs?
| 