Ans
162) What is the client concept in SAP? What is the meaning of client independent?
Ans In commercial, organizational and technical terms, the client is a self-contained unit in the R3 system, with separate set of Master data and its own set of Tables. When a change is made in one client all other clients are affected in the system - this type of objects are called Client independent objects.
163) Are programs client dependent?
Ans Yes, group of users can access these programs with a client number.
164) Name a few system global variables you can use in ABAP programs?
Ans SY-SUBRC, SY-DBCNT, SY-LILLI, SY-DATUM, SY-UZEIT, SY-UCOMM,
SY-TABIX.....
SY-LILLI is absolute number of lines from which the event was triggered.
165) What are internal tables? How do you get the number of lines in an internal table? How to use a specific number occurs statement?
Ans
1) It is a standard data type object, which exists only during the runtime of the program. They are used to perform table calculations on subsets of database tables and for re-organizing the contents of database tables according to users need.
2) Using SY-DBCNT.
3) The number of memory allocations the system need to allocate for the next record population.
166) How do you take care of performance issues in your ABAP programs?
Ans Performance of ABAP programs can be improved by minimizing the amount of data to be transferred. The data set must be transferred through the network to the applications, so reducing the amount of time and also reduces the network traffic.
Some measures that can be taken are:
- Use views defined in the ABAP/4 DDIC (also has the advantage of better reusability).
- Use field list (SELECT clause) rather than SELECT *.
- Range tables should be avoided (IN operator)
- Avoid nested SELECTS.
167) What are datasets?
Ans The sequential files (ON APPLICATION SERVER) are called datasets. They are used for file handling in SAP.
168) How to find the return code of an stmt in ABAP programs?
Ans Open SQL has 2 system fields with return codes:
1) SY-SUBRC
2) SY-DBCNT
Using function modules
169) What are Conversion & Interface programs in SAP?
Ans CONVERSION: Legacy system to flat file.
INTERFACE: Flat file to SAP system.
170) Have you used SAP supplied programs to load master data?
Ans SAP supplied BDC programs
RM06BBI0 (Purchase Requisitions)
RMDATIND (Material Master)
RFBIKR00 (Vendor Masters)
RFBIDE00 (Customer Master)
RVINVB00 (Sales Order)
171) What are the techniques involved in using SAP supplied programs? Do you prefer to
write your own programs to load master data? Why?
Ans
Þ Identify relevant fields
Þ Maintain transfer structure ( Predefined – first one is always session record)
Þ Session record structure, Header Data, Item ( STYPE – record type )
Þ Fields in session structure – STYPE, GROUP , MANDT, USERNAME , NO DATA
Þ Fields in header structure – consists of transaction code also – STYPE, BMM00, TCODE, MATNR and Fields in Item - ITEMS …
Þ Maintain transfer file – sample data set creation
172) What are logical databases? What are the advantages/disadvantages of logical databases?
Ans To read data from a database tables we use logical database.
A logical database provides read-only access to a group of related tables to an ABAP/4 program.
Advantages: - The programmer need not worry about the primary key for each table. Because Logical database knows how the different tables relate to each other, and can issue the SELECT command with proper where clause to retrieve the data.
1) An easy-to-use standard user interface.
2) Check functions, which check that user input is complete, correct, and plausible.
3) Meaningful data selection.
4) Central authorization checks for database accesses.
5) Good read access performance while retaining the hierarchical data view determined by the application logic.
6) No need of programming for retrieval, meaning for data selection
Disadvantages: -
1) If you do not specify a logical database in the program attributes, the GET events never occur.
2) There is no ENDGET command, so the code block associated with an event ends with the next event statement (such as another GET or an END-OF-SELECTION).
3) Fast in case of lesser no. of tables But if the table is in the lowest level of hierarchy, all upper level tables should be read so performance is slower.
173) What specific statements do you using when writing a drill down report?
Ans AT LINE-SELECTION
AT USER-COMMAND
AT PF.
174) What are different tools to report data in SAP? What all have you used?
Ans
175) What are the advantages and disadvantages of ABAP query tool?
Ans Advantages: No programming knowledge is required.
Disadvantages: Depending on the complexity of the database tables, it may not be easy for the user to select the necessary data correctly.
176) What are the functional areas? User groups? How does ABAP query work in relation to
these?
Ans Functional Areas - By creating functional areas, we can initially select this data. This ensures that the data is presented to the ABAP Query user in a meaningful way to accomplish the task, and that only the data that the user may use is presented.
User Groups – A user group is a collection of users that work with about the same data and carry out similar tasks. The members of a user group can use all programs (queries) created by any user of the group. Changes to such a program are at once visible to all users. This ensures that all members of a user group use the same evaluation programs.
ABAP Query: It consists of three components – queries, functional areas and user groups. The functional areas provide the user with an initial set of data in accordance with the task to be accomplished. All users must be members of at least one user group. All members of one user group can access the same data as well as the same program (queries) to create lists.
177) Is a logical database a requirement/must to write an ABAP query?
Ans No, it is not must to use LDB. Apart from it, we have other options:
1) Table join by Basis Table
2) Direct Read of table
3) Data Retrieval by Program
178) What is the structure of a BDC sessions.
Ans BDCDATA
179) What are Change header and detail tables? Have you used them?
Ans
180) What do you do when the system crashes in the middle of a BDC batch session?
Ans We will look into the error log file (SM35). Check number of records already updated and delete them from input file and run BDC again.
181) What do you do with errors in BDC batch sessions?
Ans We look into the list of incorrect session and process it again. To correct incorrect session, we analyze the session to determine which screen and value produced the error. For small errors in data we correct them interactively otherwise modify batch input program that has generated the session or many times even the data file.
182) How do you set up background jobs in SAP? What are the steps? What are the events
driven batch jobs?
Ans Go to SM36 and create background job by giving job name, job class and job steps
(JOB SCHEDULING)
183) Is it possible to run host command from SAP environment? How do you run?
Ans
184) What kind of financial periods exist in SAP? What is the relevant table for that?
Ans
185) Does SAP handle multiple currencies? Multiple languages?
Ans Yes.
186) What is a currency factoring technique?
Ans
187) How do you document ABAP programs? Do you use program documentation menu
option?
Ans
188) What is SAP Script and layout set?
Ans The tool, which is used to create layout set is called SAP Script. Layout set is a design, appearance and structure of document.
189) What are the ABAP commands that link to a layout set?
Ans Control Commands, System Commands
190) What is output determination?
Ans
191) What is the field length of Packed Number? What is the default decimal of packed
number?
Ans
192) What are the different types of data types?
Ans There are three types of data types:
Data Types
Elementary Complex References
Fixed Variable Structure Table Data Object
Variable
193) What is the syntax of Packed Number?
Ans Data : NUM type P decimals 2.
194) What are different types of attributes of Function Module?
Ans There are 6 attributes of FM:
1. Import
2. Export
3. Table
4. Changing
5. Source
6. Exception
195) List of Screen elements.
Ans There are 13 screen elements:
i. Input / output fields
ii. Text fields
iii. Checkbox
iv. Radio button
v. Push Button
vi. Drop down list
vii. Subscreen
viii. Table control
ix. Tabstrip control
x. Custom control
xi. Box
xii. Status icons
xiii. OK_CODE fields
196) How many default Tab Strips are there? How to insert more Tabs in it?
Ans There 2 default Tab strips. Screen painter attributes contain Tab Title, which is used to insert more tabs in tab strip.
197) How to define Selection Screen?
Ans There are 3 ways of defining selection screen:
1. Parameters
2. Select-options
3. Selection-Screen
198) What are the properties of Selection Screen?
Ans There are 11 properties of selection screen:
1) Default
2) Memory ID
3) Lowercase
4) Visible length
5) Obligatory
6) Matchcode
7) Check
8) Checkbox
9) Radiobutton Group
10) No-display
11) Modif ID
199) What are the components of Selection Table?
Ans There are four components of selection table:
Low, High, Sign, Options
200) How to display or know if the value entered contains records or not?
Ans SY-SUBRC
201) What are the sequences of event block?
Ans
i. Reports
ii. Nodes
iii. Data
iv. Initialization
v. At selection-screen
vi. Start-of-selection
vii. Get deptt
viii. Get emp
ix. Get deptt late
x. End-of-selection
xi. Form
xii. Endform
202) What are types of Select statements?
Ans SELECT SINGLE
SELECT [DISTINCT]
SELECT
203) What are DML commands?
Ans Select, Insert, Delete, Modify, Update.
204) What is Asynchronous and Synchronous Update?
Ans Asynchronous Update – The program does not wait for the work process to finish the
update. Commit Work.
Synchronous Update – The program wait for the work process to finish the update.
Commit Work and Wait.
205) Write syntax for Message Error (Report)?
Ans AT SELECTION-SCREEN.
SELECT * FROM ZREKHA_DEPTT INTO CORRESPONDING FIELDS OF ITAB
WHERE DEPTNO IN DEPTNO.
ENDSELECT.
If SY-DBCNT = 0.
MESSAGE E000 WITH ‘NO RECORDS FOUND’.
ENDIF.
No comments:
Post a Comment