Tuesday, January 29, 2008

SAP Interview Questions Part5

22. 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.

23. What is AWB?. What is its purpose?

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

24. What is the significance of ODS in BIW?

An ODS Object serves to store consolidated and debugged transaction data on a document level (atomic level). It describes a consolidated dataset from one or more InfoSources. This dataset can be analyzed with a BEx Query or InfoSet Query. The data of an ODS Object can be updated with a delta update into InfoCubes and/or other ODS Objects in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in ODS Objects is stored in transparent, flat database tables.

25. What are the different types of source system?

SAP R/3 Source Systems, SAP BW, Flat Files and External Systems.

26. What is Extractor?

Extractors is a data retrieval mechanisms in the SAP source system. Which can fill the extract structure of a data source with the data from the SAP source system datasets. The extractor may be able to supply data to more fields than exist in the extract structure.

27.What are internal tables ? How do you get the number of lines in an internal table ? How to use a specific number occurs statement ?

28.How do you take care of performance issues in your ABAP programs ?

29.What are datasets ?

30.How to find the return code of a statement in ABAP programs?

31.What are interface/conversion programs in SAP?

32.Have you used SAP supplied programs to load master data?

33.What are the techniques involved in using SAP supplied programs? Do you prefer to write your own programs to load master data? Why?

34.What are logical databases? What are the advantages/disadvantages of logical databases?

35.What specific statements do you use when writing a drill-down report ?

36.What are different tools to report data in SAP? What all have you used?

37.What are the advantages and disadvantages of ABAP/4 query tools?

38.What are the functional areas ? User groups ? How does ABAP/4 work in relation to these?

39.How do you validate the selection criteria of a report?

40.What are selection texts?

41.What is CTS and what do you know about it ?

42.When a program is created and need to be transported to production, does selection texts always go with it ? if not, how do you make sure ? Can you change the CTS entries ? How do you do it ?

43.What is the client concept in SAP?What is the meaning of client independent?