SAP ABAB Interview Questions 6

256) How do you find if a logical database exists for your program requirements?
Ans SLDB-F4.

257) How do you find the tables to report from when the user just tell you the transaction he uses? And all the underlying data is from SAP structures?
Ans Transaction code is entered in command field to open the table – Utilities –
Table contents display.

258) How do you find the menu path for a given transaction in SAP?
Ans

259) What are the different modules of SAP?
Ans FI, CO, SD, MM, PP, HR.

260) How do you get help in ABAP?
Ans HELP-SAP LIBRARY, by pressing F1 on a keyword.


261) What are different ABAP/4 editors? What are the differences?
Ans

262) What are the different elements in layout sets?
Ans PAGES, Page windows, Header, Paragraph, Character String, Windows.

263) Can you use if then else, perform..etc statements in sap script?
Ans Yes.

264) What type of variables normally used in sap script to output data?
Ans




265) How do you number pages in SAP Script layout outputs?
Ans & page & &next Page &

266) What takes most time in SAP script programming?
Ans LAYOUT DESIGN AND LOGO INSERTION.

267) How do you use tab sets in layout sets?
Ans Define paragraph with defined tabs.

268) How do you backup SAP Script layout sets? Can you download and upload? How?
Ans SAP script backup :- In transaction SE71 goto Utilities -> Copy from client -> Give source form name, source client (000 default), Target form name.

Download :- SE71, type form name -> Display -> Utilities -> form info -> List -> Save to PC file.

Upload :- Create form with page, window, page window with the help of downloaded PC file. Text elements for Page windows to be copied from PC file.

269) What are presentation and application servers in SAP?
Ans The application layer of an R/3 System is made up of the application servers and the message server. Application programs in an R/3 System are run on application servers. The application servers communicate with the presentation components, the database, and also with each other, using the message server.

270) In an ABAP/4 program, how do you access data that exists on Presentation Server vs on an Application Server?
Ans Using loop statements and Flat

271) What are different data types in ABAP/4?
Ans
Elementary -
Predefined: C, D, F, I, N, P, T, X.
User defined: TYPES.
Structured -
Predefined: TABLES.
User defined: Field Strings and internal tables.

272) What is difference between session method and Call Transaction?
Ans Call Transaction –

1. Single transaction
2. Synchronous processing
3. Asynchronous and Synchronous update
4. No session log is created
5. Faster

Session –

1. Multiple Transaction
2. Asynchronous processing
3. Synchronous update
4. Session log is created
5. Slower

273) Setting up a BDC program where you find information from?
Ans




274) What has to be done to the packed fields before submitting to a BDC session.
Ans Fields converted into character type.

275) What is the structure of a BDC sessions.
Ans BDCDATA (standard structure).

276) What are the fields in a BDC_Tab Table.
Ans PROGRAM, DYNPRO, DYNBEGIN, FNAM, FVAL.

277) What do you define in the domain and data element.
Ans Domain - Technical details are defined in Domain like data type, number of decimal places and length.

Data Element – Functionality details are defined in Data elements – Field Text, Column Captions, Parameters ID, and Online Field Documentation.

278) What is the difference between a pool table and a transparent table and how they are stored at the database level.
Ans Pool tables are a logical representation of transparent tables. Hence no existence at database level.

Where as transparent tables are physical tables and exist at database level.

Pool Table -

4) Many to One Relationship.
5) Table in the Dictionary has the different name, different number of fields, and the fields have the different name as in the R3 Table definition.
6) It can hold only pooled tables.

Transparent Table –
4) One to One relationship.
5) Table in the Dictionary has the same name, same number of fields, and the fields have the same name as in the R3 Table definition.
6) It can hold Application data.
279) What is cardinality?
Ans For cardinality one out of two (domain or data element) should be the same for Ztest1 and Ztest2 tables. M:N Cardinality specifies the number of dependent(Target) and independent (source) entities which can be in a relationship.

280) For Sales Document: Item Data, which table is used?
Ans VBAP – Sales Document, Sales Document Item, Material Number, Material Entered, Batch Number, Material Group, Target Quantity in Sales Document.




281) What are the types of tables?
Ans
1) Transparent table 5) Pool table
2) Cluster table are data dictionary table objects 6) Sorted table
3) Indexed table 7) Hash table
4) Internal tables.

282) What are pooled table?
Ans Table pools (pools) and table clusters (clusters) are special table types in the ABAP Dictionary. The data from several different tables can be stored together in a table pool or table cluster. Tables assigned to a table pool or table cluster are referred to as pooled tables or cluster tables.

A table in the database in which all records from the pooled tables assigned to the table pool are stored corresponds to a table pool. The definition of a pool consists essentially of two key fields (Tabname and Varkey) and a long argument field (Vardata).

Table Clusters Several logical data records from different cluster tables can be stored together in one physical record in a table cluster.

A cluster key consists of a series of freely definable key fields and a field (Pageno) for distinguishing continuation records. A cluster also contains a long field (Vardata) that contains the contents of the data fields of the cluster tables for this key. If the data does not fit into the long field, continuation records are created. Control information on the structure of the data string is still written at the beginning of the Vardata field.

283) What are Hashed Tables?
Ans Hashed tables - This is the most appropriate type for any table where the main operation is key access. You cannot access a hashed table using its index. The response time for key access remains constant, regardless of the number of table entries. Like database tables, hashed tables always have a unique key. Hashed tables are useful if you want to construct and use an internal table, which resembles a database table or for processing large amounts of data.

SAMPLE PROG: THIS DOES NOTHING.
REPORT Z_1 .
TABLES: MARA.
DATA: I TYPE HASHED TABLE OF MARA WITH UNIQUE KEY MATNR

284) How did you test the form u developed? How did you take the print of it?
Ans

285) How many maximum number of fields can be there in a table?
Ans

286) How many primary keys can be there in a table?
Ans

287) What are the steps to perform Performance Tuning? What will you do increase the performance of your system?
Ans

288) What is mandatory in Screen Painter?
Ans


289) If u are entering large amount of data, and system fails, then how many records will be entered or no records or half records will be entered?
Ans

290) In Screen Painter, if two fields are mandatory and user do not want to enter anything but he wants to come out of the screen, then what will he do?
Ans

291) What is At-Exit and User-Exit?
Ans

292) How will you find the standard tables, you only know there names like Customer Master Table?
Ans

293) How will change Development Class?
Ans

294) How will you call both Function Module and Function Group?
Ans

295) What is ALV?
Ans

296) What is Chain-Field & Chain-Loop?
Ans

297) What is Value-Ranges?
Ans

298) How will you provide help for value request particular fields?
Ans

299) How will you find relationship between two or more tables?
Ans

300) In BDC’s, if you forget to write one field, then how will you modify that field in your BDC program?
Ans

301) Detail concept of Transport Organizer.
Ans

302) Which is slower “Select *” and “Select field1,field2”?
Ans

303) What are the errors in “Call Transaction”?
Ans

304) What is QA and production?
Ans


305) How will you display only 10 lines in Report?
Ans

306) In BDC, if out of 10 records, 7 are successful and there are 3 records with some missing fields, how will you modify those fields?
Ans

307) How will you set breakpoint to 100 messages?
Ans

308) How will you set Reports to Background job?
Ans

309) Name the tables, which is used to see all the transaction available.
Ans See tables, TSTC and TSTCT for all the transaction available

310) List of SAP supplied Programs.
Ans
Details (5) Program
Purchase Requisitions RM06BB10
Material Master RMDATIND
Vendor Master RFBIKR00
Customer Master RFBIDE00
Sales Order RVINVB00

SAP SCRIPT PROGRAMS (9)
Logo RSTXLDMC
Debug RSTXDBUG
Upload / Download (Import / Export) RSTXSCRP
Convert Page Format RSTXFCON
Text File Inconsistent RSTXCHK0
Copy Table Across Client RSCLTCOP
Transfer Scripts Files Across System (Not Clients) RSTXSCRP
Comparing The Contents Of A Table RSTBSERV
Change The Development Class RSWBO052

REPORTS (2)
Submit A BDC Job With An Internal Batch Number RSBDCBTC
Release Batch Input Sessions RSBDCSUB

STANDARD PROGRAM (7)
Table Adjustment Across Clients RSAVGL00
Extended Program List RSINCL00
Get The Oracle Release RSORAREL
Display All Instance Parameters RSPARAM
Substitution / Validation Utility RSUGBR00
Check Passwords Of Users SAP And DDIC In All Clients RSUSR003
Last Users Last Login RSUSR006

311) How to schedule a Report in background? what is the use of background job please explain about it?
Ans There are 3 ways to schedule in background:
SM36
SE38
SA38

The easiest of the three is SA38.

Why background? In foreground jobs are only allowed a certain amount of runtime. Long running jobs usually times out in foreground, and have to be run background. Some customers has day-end jobs to fill custom tables, and these only run late at night, so they are scheduled as background jobs as well. There may be any of a hundred reasons why you want a job to run in background instead of foreground, and these are only 2 of them.