Monday, March 10, 2008

SAP Reports Interview Questions And Answers

What is LDB?

Logical Database is an ABAP program which retrieves data from various tables
Which are interrelated and provides a read only view of the data.


What are the EVENTS in Report Program? What are EVENTS In Interactive Report and Explain?


Classical Report Events are

LOAD OF PROGRAM.INITIALIZATION

AT SELECTION-SCREEN.START-OF-SELECTION.
TOP-OF-PAGE.END-OF-PAGE.
END-OF-SELECTION.

Interactive events are

AT LINE-SELECTION.

AT USER-COMMAND.
TOP-OF-PAGE DURING LINE-SELECTION.

AT LINE-SELECTION:Allows the user to interact with the lists.
AT USER-COMMAND:USed for handling Push buttons.
SET PF-STATUS:Provides User Interface.


What are the various techniques of BDC?


call transaction

session method

direct input method


What is SQL Trace?

SQL Tracer is a tool used to measure the performance of ABAP program.
T.code :st05


What is LUW?

It is a span of time during which database records are updated either
commit or rollback.


Have you worked with reading and writing data on to files?

YES, open dataset for output. read dataset from itab. close dataset .


Have you created tables in SAP? What are client dependent and independent tables? How do you create independent tables?


Tables which are having MANDT field is called as client dependent tables. Tables which are not having MANDT field is called as client dependent tables.


Have you used SM30 and SM31 transactions?

sm30 is used to view the ' Call Up View Maintenance ' and SM31 is to view the ' Table maintenance ' with


How many dictionary objects are there and list all

Available Dictionary Objects are Domains, Viwes, Match Codes, Lock Objects, Structures, Data Elements, Intenal Types.


What is the difference between transparent and non transparent database tables?

Transparent tables have 1 - 1 cardinality b/w Data Dictionary and Database, and non transparent ( Cluster and Pooled) tables have Many - 1 cardinality.

Transparent table can access with using OPen & NAtive SQL stmts where as Nontransparent only OPen Sql.

Transparent trables can store Table relevent data and non transparent tables can store system data/ application data based on the transparent tables


What is meant by BDC. How many methods of BDC are there?

BDC -> BATCH DATA COMMUNICATION.
METHODS OF BDC-> Direct Input method, Batch Input Session method, Call transaction method.


What are the difference between table controls and step loops in dialog programming?

1. Function modules use a special screen to define the parameters where as subroutines use the same ABAP/4 editor to define its parameters.

2. Tables work area can be commonly shared by calling program and subroutine where as function modules do not share commonly.

3. Calling a function module syntax (Call function.) is different from calling a subroutine syntax (perform….).

4. With raise statement user can exit from a function module where as exit is used in subroutines.


What is ALE, IDOC , EDI , RFC. Explain briefly.

ALE: application linking enabling

IDOC: intermediatary documents

EDI: electronic data interchange

RFC: remote function call


What is a binary search?

Binary Search is used in internal table for searching the records. its means record searched one by one from top & bottom both side.so its a easy nd fast way to find the record.bt pointer searching is better.


Types of User Exits, what kind of work is done on these exits?

File Exit, Menu Exit, Function Exit.


How will you find out where the user exits are available?


CMOD : This transaction allows you to create a PROJECT by identifying its ENHANCEMENT(S). After determining all of the ENHANCEMENTS that are part of the PROJECT, you will have to activate the PROJECT. You will still need to code your user-exit; therefore, you may want to wait until this step is completed before activating the PROJECT.

§SMOD : This transaction allows you to create an ENHANCEMENT, which you will include in a PROJECT, by identifying its COMPONENT(S). In the case where SAP has already created an ENHANCEMENT for its pre-defined user-exits, you will not need to use transaction SMOD; instead, you should just use transaction CMOD.


Have you created any transactions?

Yes,
We can use TC SE93 for creating our own transaction code.


Difference between Table-Controls and Step-loops?

Table controls are modified / mproved versions of step loops.
in controls we can do,
horizontal scrolling,
vertical scrolling,
scrolling in a perticular field,
resize the table,
can save the settings for future use,
can make selective columns editable,....etc
these things are not possible with step loops.
step loops are controlled by loop-endloop statements.


Import and Export

ABAP memory is a memory area that all ABAP programs within the same internal session can access using the EXPORT and IMPORT statements. Data within this area remains intact during a whole sequence of program calls. To pass data to a program which you are calling, the data needs to be placed in ABAP memory before the call is made. The internal session of the called program then replaces that of the calling program. The program called can then read from the ABAP memory. If control is then returned to the program which made the initial call, the same process operates in reverse.


How many interactive reports did you write?
In an Interactive Report, user can define maximum 20 secondary lists.


What is an “Unpack command” ?
UNPACK field1TO field2 .Unpacks the packed field field1 and places it in the field field2 with leading zeros. If field2 is too short, it is truncated on the left.

No comments:

Tutorials on SAP-ABAP

Adobe Interactive Forms Tutorials

Business Server Pages (BSP)

Userexits/BADIs

Web Dynpro for ABAP (Step by step procedure for web dynpro,Tutorials on Web Dynpro,)

ALV Tutorials

Blog Archive

goodsites