26) Difference between UPLOAD and WS_UPLOAD?
Ans UPLOAD - File transfer with dialog from presentation server file to internal table. Data which is available in a file on the presentation server is transferred in an internal table. ASCII & Binary files can be transferred.
WS_UPLOAD - To read data from the presentation server into an internal table without a user dialog, use the function module WS_UPLOAD. The most important parameters are listed below.
Parameters Function
CODEPAGE Only for upload under DOS: Value IBM
FILENAME Filename
FILETYPE File type
27) Why did u switch to SAP?
Ans
28) What is a Logical Database?
Ans Logical Databases are special ABAP programs that retrieve data and make it available to application programs.
Use of LDB – is used to read data from database tables by linking them to executable ABAP programs.
29) What are the events used for Logical Database?
Ans Two Events –
1) GET - This is the most important event for executable programs that use a logical database. It occurs when the logical database has read a line from the node
and made it available to the program in the work area declared using the statement NODES . The depth to which the logical database is read is determined by the GET statements
2) PUT - The PUT statement directs the program flow according to the structure of
the logical database.
30) What is the difference between Get and Get Late?
Ans GET - After the logical database has read an entry from the node .
GET LATE - After all of the nodes of the logical database have been processed that are below in the database hierarchy.
31) What are the data types of Internal Tables?
Ans There are three types:
1) Line
2) Key
3) Table
32) What are the events used in ABAP in the order of execution?
Ans Events are:
1. INITIALIZATION
2. AT SELECTION-SCREEN
3. AT SELECTION-SCREEN ON
4. START-OF-SELECTION
5. TOP-OF-PAGE
6. TOP-OF-PAGE DURING LINE SELECTION
7. END-OF-PAGE
8. END-OF-SELECTION
9. AT USER-COMMAND
10. AT LINE-SELECTION
11. AT PF
12. GET
13. GET LATE.
14. AT User Command
33) What are Interactive Reports?
Ans An output list which displays just the basic details & allow user to interact, so that a new list is populated based on user-selection. With interactive list, the user can actively control data retrieval and display during the session.
34) What are the commands used for interactive reports?
Ans Top-of-Page during line-selection
35) What are the system fields u have worked with? Explain?
Ans I had worked with the following (30) system fields:
1) SY-DBSYS - Central Database
2) SY-HOST - Server
3) SY-OPSYS - Operating System
4) SY-SAPRL - SAP Release
5) SY-SYSID - System Name
6) SY-LANGU - User Logon Language
7) SY-MANDT - Client
8) SY-UNAME - Logon User Name
9) SY-DATLO - Local Date
10) SY-DATUM - Server Date
11) SY-TIMLO - Local Time
12) SY-UZEIT - Server Time
13) SY-DYNNR - Screen Number
14) SY-REPID - Current ABAP program
15) SY-TCODE - Transaction Code
16) SY-ULINE - Horizontal Line
17) SY-VLINE - Vertical Line
18) SY-INDEX - Number of current loop Pass
19) SY-TABIX - Current line of internal table
20) SY-DBCNT - Number of table entries processed
21) SY-SUBRC - Return Code
22) SY-UCOMM - Function Code
23) SY-LINCT - Page Length of list
24) SY-LINNO - Current Line
25) SY-PAGNO - Current Page Number
26) SY-LSIND - Index of List
27) SY-MSGID - Message Class
28) SY-MSGNO - Message Number
29) SY-MSGTY - Message Type
30) SY-SPONO - Spool number during printing
36) What is the difference between Primary key and Unique Key?
Ans Primary Key – It can accepts 0 value and cannot be NULL.
Unique Key – It can be NULL.
37) What is the transaction code for Table maintenance?
Ans SM30
38) If u are using Logical Databases how will u modify the selection-screen elements?
Ans Select-options : dname for deptt-dname.
39) What is an RFC?
Ans Remote Function Call
40) If u are using RFC and passing values to a remote system how does it work?
Ans
41) What are the events in Screen Programming?
Ans There are two events in Screen Programming:
PBO (Process Before Output) – Before the screen is displayed, the PBO event is processed.
PAI (Process After Input) – When the user interacts with the screen, the PAI event is processed.
POH (Process On Help) - are triggered when the user requests field help (F1). You can program the appropriate coding in the corresponding event blocks. At the end of processing, the system carries on processing the current screen.
POV (Process On Value) - are triggered when the user requests possible values help (F4). You can program the appropriate coding in the corresponding event blocks. At the end of processing, the system carries on processing the current screen.
42) What is the significance of HIDE?
Ans Its stores the click value and display the related record in the secondary list.
43) Where do u code the HIDE statement?
Ans In a LOOP statement
44) Types of BDC's?
Ans There are two types of BDC’s:
1) Transaction Method
2) Session Method
45) Advantages & Disadvantages of different types of BDC's?
Ans Transaction Method:
1) It is faster than session method.
2) While executing, it starts from starting.
Session Method:
1) It is slower than transaction method.
2) While executing, it does not start from starting.
46) What are the events used in Interactive Reports.
Ans There are three events of Interactive Reports:
I. At PF(nn)
II. At line-selection
III. At user-command
47) What is an RDBMS?
Ans RDBMS – Relational Database Management System. It helps to create relationship between two or more table.
48) What standards u use to follow while coding ABAP programs?
Ans
49) What will you code in START-OF-SELECTION & END-OF-SELECTON & why?
Ans START-OF-SELECTION
SELECT * FROM DEPTT INTO CORRESPONDING FIELDS OF ITAB
WHERE DEPTNO IN DEPTNO.
APPEND ITAB.
ENDSELECT.
LOOP AT ITAB.
WRITE : / 10 ITAB-DEPTNO.
HIDE : ITAB-DEPTNO.
ENDLOOP.
END-OF-SELECTION
50) What are joins and different types joins?
Ans There are four types of Joins:
1) Self Join
2) Inner Join
3) Outer Join
4) Equi Join
51) Which is the default join?
Ans
52) How do u display a data in a Detail List?
Ans By using two statements:
1) Top-of-page during line-selection
2) At line-selection
53) What are the types of windows in SAP Script?
Ans There are five Standard Layouts in SAP Script:
1) Page
2) Window
3) Page Window
4) Paragraph Format
5) Character Format
54) What are the function modules used in a SAP Script driver program?
Ans There are three functions used in SAP Script:
1) OPEN_FORM
2) WRITE_FORM
3) CLOSE_FORM
55) What are Extracts?
Ans Extracts are dynamic sequential datasets in which different lines can have different structures. We can access the individual records in an extract dataset using a LOOP.
56) How would u go about improving the performance of a Program, which selects data from MSEG & MKPF?
Ans
57) How does System work in case of an Interactive Report?
Ans
58) What is LUW?
Ans Logical Unit of Work
59) Different types of LUWs. What r they?
Ans Two types of LUW are:
1) DB LUW - A database LUW is the mechanism used by the database to ensure that its data is always consistent. A database LUW is an inseparable sequence of database operations that ends with a database commit. The database LUW is either fully executed by the database system or not at all. Once a database LUW has been successfully executed, the database will be in a consistent state. If an error occurs within a database LUW, all of the database changes since the beginning of the database LUW are reversed. This leaves the database in the state it had before the transaction started.
2) SAP LUW - A logical unit consisting of dialog steps, whose changes are written to the database in a single database LUW is called an SAP LUW. Unlike a database LUW, an SAP LUW can span several dialog steps, and be executed using a series of different work processes.
60) What is First event triggered in program?
Ans
61) What are various Joins? What is right outer join?
Ans
62) How do u find out whether a file exits on the presentation server?
Ans eps_get_directory_listing for directory
63) Systems fields used for Interactive Lists AND Lists
Ans Interactive System Fields: SY-LSIND, SY-CPAGE, SY-LILLI, SY-LISEL, SY-LISTI,
SY-LSTAT, SY-STACO, SY-STARO
Lists: SY-COLNO, SY-LINCT, SY-LINNO, SY-LINSZ, SY-PAGNO,
SY-TVAR0…..SY-TVAR9, SY-WTITL
64) Logo in SAP Script?
Ans RSTXLDMC OR
Steps for making and inserting Logo in SAP Script:
First Procedure:
1) Draw the picture
2) Save it
3) /nSE78
4) Write name & Choose Color
5) Click on Import
6) Browse picture
7) Enter
Second Procedure
1) /nSE71
2) Insert
3) Graphics
4) Click on stored on document server
5) Execute
6) Choose name of BMAP
65) What are the difference between call screen and leave screen?
Ans Call Screen: Calling a single screen is a special case of embedding a screen sequence. If you want to prevent the called screen from covering the current screen completely, you can use the CALL SCREEN statement with the STARTING AT and ENDING AT
CALL SCREEN 1000.
CALL SCREEN 1000 STARTING AT 10 10 ENDING AT 20 20.
LEAVE SCREEN statement ends the current screen and calls the subsequent screen.
LEAVE SCREEN.
LEAVE TO SCREEN 2000.
66) If internal table used in for all entries in empty then what happens
Ans No, records will be displayed.
67) If I forgot some command in SAP Script e.g.: suppress zero display - How to do find it?
Ans Suppressing of entire screens is possible with this command. This command allows us to perform screen processing “in the background”. Suppressing screens is useful when we are branching to list-mode from a transaction dialog step.
68) How to write a BDC - how do u go about it?
Ans Steps for writing BDC
1) /nSE38
2) Declare Tables, Data (for ITAB) and Data (for BDCITAB)
3) Call function ‘Upload’.
4) Write code for the First Screen, Radio Button, Filename, Change Button, Second Screen, Utilities (Create Entries), Third Screen and Save.
5) Call transaction ‘SE11’ using BDCITAB mode ‘A’.
6) Save, Check Errors, Activate and Execute.
69) What is Performance tuning?
Ans
70) Define Documentation.
Ans
No comments:
Post a Comment