21. When to use logical database?

Advantage of Logical databases: less coding s required to retrieve data compared to normal internal tables. Tables used LDB are in hierarchical structure.

22. What is the use of ‘table index’?

Index is used for faster access of data base tables.

23. What is the use of ‘FOR ALL ENTRIES’?

To avoid nested select statements we use SELECT FOR ALL ENTRIES statement. If there are more than 10000 records SELECT FOR ALL ENTRIES is used. Performance wise SELECT FOR ALL ENTRIES is better to use.

24. Can you set up background processing using CALL TRANSACTION?

Yes, Using No Screen Mode.

25. What are table buffers?

Table buffers reside locally on each application server in the system. The data of buffered tables can thus be accessed directly from the buffer of the application server. This avoids the time-consuming process of accessing the database. Buffering is useful if table needs to be accessed more no. of times in a program.

26. How do I set a flag for a field in any table?

Create a char field of length 1. For example field STAS-LKENZ is Deletion Indicator. It means that if the value in the field is ‘X’ then that record has been deleted.

27. Can I execute user exits? If yes, how?

Yes you can. After finding the user exit, you need to use, goto CMOD add your user-exit to your project. Then activate the FM which you require. Now go into that function module there will be a Include program wit name ZX*. Double click on it, it will ask to create an object, answer is yes and then write your code in it.

28. How do I find the output type of a table or a program?

Table TNAPR / NAST.

29. What are variables?

Variables are parameters of a query that are set in the parameter query definition and are not filled with values until the queries are inserted into workbooks. There are different types of variables which are used in different application: Characteristics variables, Hierarchies and hierarchy node, Texts, Formulas, Processing types, User entry/Default type, Replacement Path.

30. What is AWB? What is its purpose?

AWB stands for Administrator Work Bench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information warehousing.