IBM abap interview Questions phase - final 1

SAP QUESTIONAIRE

Name the reports, interfaces, transactions, sap script programs written? Explain the Functionality?

What is the typical structure of an ABAP/4 program? Ans. = Declarative elements, Operational, control, events.

What are field symbols and field groups? Have you used “component idx of structure” clause with fields groups? Ans.: place holder for existing fields similar to fields point to point Groups. : Common several fields under one Name.

What should be the approach for writing a BDC program? Ans.: 1. Analysis the Data. 2. Generate SAP structure. 3. Develop transfer program 4. Create sequential file. 5. Create batch input program. 6. Process batch input data

What is the alternative to batch input session? Ans. : Call transaction & call dialog

A situation: An ABAP program creates a batch input session. We need to submit the program and the batch session in background. How to do it? (up to 3.1H) Ans.: Run the session by RSBDCSUB explicitly by providing batch input session name Go to batch input, Double click on session name. It gives a pop up screen for run mode enters it and run.

What are the problems in processing batch input sessions? How is batch input process different from processing on line? Ans.: Sessions cannot be run in parallel and not fast.

Name as many SAP Transactions as possible you are familiar with? Ans. : SE38 - ABAP editor , SE80 – Object Browser , SE36 – logical databases SE11 – ABAP data dictionary & SE16 SE37 – Function Module

What are the different types of data dictionary objects? Ans : Tables – Data Elements – Domains - Structure – Foreign Keys

How many types of tables exist and What are they in data dictionary? Ans : Transparent Tables - Pooled Tables – Cluster Tables

What is the step by step process to create a table in data dictionary? Ans : Create Domain – Create Data elements – Create fields – Create Tables

Can a transparent table exist in data dictionary but not in the database physically? Ans : Yes. (Tables in database have different structures, different names and total no. of tables in oracle database is smaller than transparent tables)

What are the domains and data elements? Ans : domain describes Technical Characteristics of a table fields e.g. value range Elements describe role played by a fields in technical contains e.g. Form of field text.

Can you create a table with fields not referring to data elements? Ans : yes

What is the advantage of structures? How do you use them in the ABAP programs? Ans: structure is used to define the construction of data produced when calculations are carried out within programs or when data is transferred between programs. Contain data at runtime only.

What does an extract statement do in the ABAP program? Ans: Fills the fields groups with values.

What is a collect statement? How is it different from append? Ans: Collect – does not allow duplicate keys and append adds a line even if it exists already.

What is open SQL v/s Native SQL? Ans : Native SQL – used to include SQL stmt of RDBMS in ABAP/4 programs Open SQL - subset of standard SQL with enhancements that are specific to SAP.

What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it? Ans: it allows us to execute a SQL stmt relevant to a particular database attached to SAP. It is not transparent. (Disadvantage)

What is the meaning of ABAP/4 editor integrated with ABAP/4 Data dictionary? Ans: the Graphical programming environment. We can write ABAP/4 code, control access to objects under development, create new or access predefined database information.

What are the events in ABAP/4 language? Ans: Interactive reports - At line selection – At user-command – At PF-status Classical reports - Top of page – end of page – start of selection – end of selection.

What is an interactive report? What is the obvious different of such report compared with HTML type report? Ans: Features – Screen oriented – short basic lists – compressed data in basic list Detailed information in secondary lists or windows.

What is drill down report? Ans: A list which you create by selecting on characteristic value of a report and which contains detailed information about that value.

How do you write a function module in SAP? Describe. Ans : using function <> function library : parameters , importing changing tables exporting …. Exceptions. End function