|
We want to move a SAP table to an Access table using TABLE_EXPORT_TO_MSACCESS_RFC Importing parameters are ...
SAP ABAP questions and answers
(Continued from previous question...)
We want to move a SAP table to an Access table using TABLE_EXPORT_TO_MSACCESS_RFC Importing parameters are ...
Q: We want to move a SAP table to an Access table using TABLE_EXPORT_TO_MSACCESS_RFC
Importing parameters are
DBNAME
DEST
FLG_APPEND
FLG_POPUP
LANGU
The table has three columns:
TABNAM
MANDT
SDATA
We have no Exporting parameters.
How shall we set the parameters?
A: Install the PS utilities, which are part of SAPGUI install CD. You may run report RIACCESS from SE38. Go to SALE -> Communication -> Define RFC Destination. Setup two RFC destinations PS_ACCESS_1 and PS_ACCESS_2 and will have to get them to point to wdpsastr.exe and wdpsatab.exe respectively. Then execute RIACCESS and choose PS_ACCESS_1 to generate access tables. Please note that Access only supports tables with up 255 fields.
(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?
| 