SAP Interview Questions -14

SAP Interview Questions -14

1.How does u recognize an attribute whether it is a display attribute or  not?
In Edit characteristics of char, on general tab checked as attribute only.

2.What are the extra fields does PSA contain?

(4) Record id, Data packet

3.Partitioning possible for ODS?

No, It's possible only for Cube.

4.Why partitioning?

For performance tuning.

5.Have you ever tried to load data from 2 InfoPackages into one cube?


6.How do we convert Master data InfoObject to a Data target?

InfoArea â ' Infoprovider (context menu) â ' Insert characteristic Data  as DataTarget.

7.How do we load the data if a FlatFile consists of both Master and  Transaction data?

Using Flexible update method while creating InfoSource.

8.Steps in LO are Extraction?

* Maintain extract structures. (R/3)
* Maintain DataSources. (R/3)
* Replicate DataSource in BW.
* Assign InfoSources.
* Maintain communication structures/transfer rules.
* Maintain InfoCubes & Update rules.
* Activate extract structures. (R/3)
* Delete setup tables/setup extraction. (R/3)
* InfoPackage for the Delta initialization.
* Set-up periodic V3 update. (R/3)
* InfoPackage for Delta uploads.

9.Different types in LO's?

Direct Delta, Queued Delta, Serialized V3 update, Unserialized V3 Update.
Direct Delta: - With every document posted in R/3, the extraction data is  transferred directly into the BW delta queue. Each document posting with delta  extraction becomes exactly one LUW in the corresponding Delta queue.
Queued Delta: - The extraction data from the application is collected in  extraction queue instead of as update data and can be transferred to the BW  delta queue by an update collection run, as in the V3 update.

10.Transitive Attributes?

Navigational attributes having nav attrthese nav attrs are called transitive  attributes

11.Navigational attribute?

Are used for drill down reporting (RRI).

12.Display attributes?

You can show DISPLAY attributes in a report, which are used only for  displaying.

13.When are Dimension ID's created?

When Transaction data is loaded into InfoCube.

14.When are SID's generated?

When Master data loaded into Master Tables (Attr, Text, Hierarchies).

15.How would we delete the data in ODS?

By request IDs, Selective deletion & change log entry deletion.

16.How would we delete the data in change log table of ODS?

Context menu of ODS â ' Manage â ' Environment â ' change log entries.

17.Partitioning possible for ODS?

No, It's possible only for Cube.

18.What are the system fields? Explain?

The ABAP system fields are active in all ABAP programs. They are filled by the runtime environment, and you can query their values in a program to find out particular states of the system. Although they are variables, you should not assign your own values to them, since this may overwrite information that is important for the normal running of the program. However, there are some isolated cases in which you may need to overwrite a system variable. For example, by assigning a new value to the field SY-LSIND, you can control navigation within details lists.

19.What is SAP Script? What is the purpose of SAP Script? Difference between SAP Script and Report?

• SAP Script – It is the integrated text management system of the SAP R/3 System. Two types – PC Editor & Line Editor.
• Reports - It is the way to display data fetched from database table onto screen or directly output it to a printer. Two types – Classical and Interactive.

20.What is the use of occurs in internal table? Can u change occurs value in program?

Use of Occurs - If you use the OCCURS parameter, the value of the INITIAL SIZE of the table is returned to the variable
Data : Begin of ITAB occurs 0,End of ITAB.Occurs or Initial Size – to specify the initial amount of memory that should be assigned to the table.
Yes, we can change the occurs value in program but output remains the same.

21.Difference between SY-TABIX and SY-INDEX? Where it is used? Can u check SY-SUBRC after perform?

SY-TABIX - Current line of an internal table. SY-TABIX is set by the statements below, but only for index tables. The field is either not set or is set to 0 for hashed tables.
* APPEND sets SY-TABIX to the index of the last line of the table, that is, it contains the overall number of entries in the table.
* COLLECT sets SY-TABIX to the index of the existing or inserted line in the table. If the table has the type HASHED TABLE, SY-TABIX is set to 0.
* LOOP AT sets SY-TABIX to the index of the current line at the beginning of each loop lass. At the end of the loop, SY-TABIX is reset to the value that it had before entering the loop. It is set to 0 if the table has the type HASHED TABLE.
* READ TABLE sets SY-TABIX to the index of the table line read. If you use a binary search, and the system does not find a line, SY-TABIX contains the total number of lines, or one more than the total number of lines. SY-INDEX is undefined if a linear search fails to return an entry.
SEARCH FOR sets SY-TABIX to the index of the table line in which the search string is found.
SY_INDEX - In a DO or WHILE loop, SY-INDEX contains the number of loop passes including the current pass.

22.What are the different functions used in sap script? What are the parameters used in each Function?

There are three different functions used in SAP Script:
Parameters in Each Function:

23.What is sequence of event triggered in report?

There are 6 events in report:
1) Initialization
2) At Selection-Screen
3) Start-of-Selection
4) Get
5) Get Late
6) End-of-Selection
7) Top-of-Page
9) At Line Selection
10) At User Command
11) At PF (nn)

24.What are standard layouts sets in the SAP Script?

There are four standard layouts in the SAP Script:

1) Header
2) Logo
3) Main Window
4) Footer

25.Difference between UPLOAD and WS_UPLOAD?

UPLOAD - File transfer with dialog from presentation server file to internal table. Data which is available in a file on the presentation server is transferred in an internal table. ASCII & Binary files can be transferred.
WS_UPLOAD - To read data from the presentation server into an internal table without a user dialog, use the function module WS_UPLOAD. The most important parameters are listed below.
Parameters Function
CODEPAGE Only for upload under DOS: Value IBM
FILETYPE File type

26.What is a Logical Database?

Logical Databases are special ABAP programs that retrieve data and make it available to application programs.
Use of LDB – is used to read data from database tables by linking them to executable ABAP programs.

27.What are the events used for Logical Database?

Two Events –
1) GET - This is the most important event for executable programs that use a logical database. It occurs when the logical database has read a line from the node
and made it available to the program in the work area declared using the statement NODES . The depth to which the logical database is read is determined by the GET statements2) PUT - The PUT statement directs the program flow according to the structure of the logical database.

28.What is the difference between Get and Get Late?

GET - After the logical database has read an entry from the node
.GET LATE - After all of the nodes of the logical database have been processed that are below in the database hierarchy.

29.What are the data types of Internal Tables?

There are three types:
1) Line
2) Key
3) Table

30.What are the events used in ABAP in the order of execution?

 Events are:
11. AT PF
12. GET
14. AT User Command

31.What are Interactive Reports?

An output list which displays just the basic details & allow user to interact, so that a new list is populated based on user-selection. With interactive list, the user can actively control data retrieval and display during the session.

32.What are the commands used for interactive reports?

Top-of-Page during line-selection

33.What is the difference between Primary key and Unique Key?

Primary Key – It can accepts 0 value and cannot be NULL.
Unique Key – It can be NULL.

34.What is the transaction code for Table maintenance?


35.If u are using Logical Databases how will u modify the selection-screen elements?

Select-options : dname for deptt-dname.

36.What is an RFC?

Remote Function Call

37.What are the events in Screen Programming?

There are two events in Screen Programming:
1. PBO (Process Before Output) – Before the screen is displayed, the PBO event is processed.
2. PAI (Process After Input) – When the user interacts with the screen, the PAI event is processed.
3. POH (Process On Help) - are triggered when the user requests field help (F1). You can program the appropriate coding in the corresponding event blocks. At the end of processing, the system carries on processing the current screen.
4. POV (Process On Value) - are triggered when the user requests possible values help (F4). You can program the appropriate coding in the corresponding event blocks. At the end of processing, the system carries on processing the current screen.

38.What is the significance of HIDE?

Its stores the click value and display the related record in the secondary list.

39.Where do u code the HIDE statement?

In a LOOP statement

40.Types of BDC’s?

There are two types of BDC’s:
1) Transaction Method
2) Session Method

41.Advantages & Disadvantages of different types of BDC’s?

Transaction Method:
1) It is faster than session method.
2) While executing, it starts from starting.
Session Method:
1) It is slower than transaction method.
2) While executing, it does not start from starting.

42.What are the events used in Interactive Reports.

There are three events of Interactive Reports:
I. At PF(nn)
II. At line-selection
III. At user-command

43.What is an RDBMS?

RDBMS – Relational Database Management System. It helps to create relationship between two or more table.

44.What will you code in START-OF-SELECTION & END-OF-SELECTON & why?


45.What are joins and different types joins?

There are four types of Joins:
1) Self Join
2) Inner Join
3) Outer Join
4) Equi Join
51) Which is the default join?

46.How do u display a data in a Detail List?

By using two statements:
1) Top-of-page during line-selection
2) At line-selection

47.What are the types of windows in SAP Script?

There are five Standard Layouts in SAP Script:
1) Page
2) Window
3) Page Window
4) Paragraph Format
5) Character Format

48.What are the function modules used in a SAP Script driver program?

There are three functions used in SAP Script:

49.Why partitioning?

For performance tuning.

50.Have you ever tried to load data from 2 InfoPackages into one cube?


51.Different types of Attributes?

Navigational attribute, Display attributes, Time dependent attributes,  Compounding attributes, Transitive attributes, Currency attributes.

52.Transitive Attributes?

Navigational attributes having nav attrthese nav attrs are called transitive  attrs

53.Navigational attribute?

Are used for drill down reporting (RRI).

54.Display attributes?

You can show DISPLAY attributes in a report, which are used only for  displaying.

55.How does u recognize an attribute whether it is a display attribute or  not?

In Edit characteristics of char, on general tab checked as attribute only.

56.How do we convert Master data InfoObject to a Data target?

InfoArea â ' Infoprovider (context menu) â ' Insert characteristic Data  as DataTarget.

57.How do we load the data if a FlatFile consists of both Master and  Transaction data?

Using Flexible update method while creating InfoSource.

58.What are Process Types & Process variant?

Process types are General services, Load Process & subsequent processing,  Data Target Administration, Reporting agent & Other BW services.
Process variant (start variant) is the place the process type knows when & where  to start.

59.What are the contents in technical specifications?

There are five contents in Technical Settings: Data Class, Size Category, Buffering Permission, Buffering Type and Logging.

60.What is an instance?

When you call a function module, an instance of its function group plus its data, is loaded into the memory area of the internal session. An ABAP program can load several instances by calling function modules from different function groups.

61.What are control tables?

The values specified for the size category and data class are mapped to database-specific values via control tables.

62.What is the function of the transport system and workbench organizer?

The function of the transport system and the Workbench Organizer is to manage any changes made to objects of the ABAP/4 Development Workbench and to transport these changes between different SAP systems.

63.What is a table pool?

A table pool (or pool) is used to combine several logical tables in the ABAP/4 Dictionary. The definition of a pool consists of at least two key fields and a long argument field (VARDATA).

64.What are pooled tables?

These are logical tables, which must be assigned to a table pool when they are defined. Pooled tables can be used to store control data (such as screen sequences or program parameters).

65.What is a table cluster?

A table cluster combines several logical tables in the ABAP/4 Dictionary. Several logical rows from different cluster tables are brought together in a single physical record. The records from the cluster tables assigned to a cluster are thus stored in a single common table in the database.

66.How can we access the correction and transport system?

Each time you create a new object or change an existing object in the ABAP/4 Dictionary, you branch automatically to the Workbench Organizer or correction and transport system.

67.Which objects are independent transport objects?

Domains, Data elements, Tables, Technical settings for tables, Secondary indexes for transparent tables, Structures, Views, Matchcode objects, Matchcode Ids, Lock objects.

68.How is conversion of data types done between ABAP/4 & DB layer?

Conversion between ABAP/4 data types and the database layer is done within the database interface.

69.How is conversion of data types done between ABAP/4 & external level?

Conversion between the external layer and the ABAP/4 layer is done in the SAP dialog manager DYNP.

70.What are the Data types of the external layer?


71.What are the Data types of the ABAP/4 layer?

Possible ABAP/4 data types:

C: Character.
D: Date, format YYYYMMDD.
F: Floating-point number in DOUBLE PRECISION (8 bytes).
I: Integer.
N: Numerical character string of arbitrary length.
P: Amount of counter field (packed; implementation depends on h/w platform).
V: Character string of variable length, length is given in the first two bytes.
X: Hexadecimal (binary) storage.

72.How can we set the table spaces and extent sizes?

You can specify the extent sizes and the table space (physical storage area in the database) in which a transparent table is to be stored by setting the size category and data class.

73.What is the function of the correction system?

The correction system manages changes to internal system components. Such as objects of the ABAP/4 Dictionary.

74.What are local objects?

Local objects (Dev class$TMP) are independent of correction and transport system.

75.What is a Development class?

Related objects from the ABAP/4 repository are assigned to the same development class. This enables you to correct and transport related objects as a unit.

76.What is a data dictionary?

Data Dictionary is a central source of data in a data management system. Its main function is to support the creation and management of data definitions. It has details about
· what data is contained?
· What are the attributes of the data?
· What is the relationship existing between the various data elements?

77.What functions does a data dictionary perform?

In a data management system, the principal functions performed by the data dictionary are
· Management of data definitions.
· Provision of information for evaluation.
· Support for s/w development.
· Support form documentation.
· Ensuring that the data definitions are flexible and up-to-date.

78.What are the features of ABAP/4 Dictionary?

The most important features are:
· Integrated to aABAP/4 Development Workbench.
· Active in the runtime environment.

79.What are the uses of the information in the Data dictionary?

The following information is directly taken from the Data dictionary:
· Information on fields displayed with F1 help.
· Possible entries for fields displayed with F4 help.
· Matchcode and help views search utilities.

80.What are the basic objects of the data dictionary?

· Tables
· Domains
· Data elements
· Structures
· Foreign Keys

81.What are the aggregate objects in the data dictionary?

· Views
· Match codes
· Lock objects.

82.Difference between MasterData & Transaction InfoPackage?

5 tabs in Masterdata & 6 tabs in Transaction data, the extra tab in  Transaction data is DATA TARGETS.

83.Types of Updates?

Full Update, Init Delta Update & Delta Update.

84.For Full update possible while loading data from R/3?

InfoPackage â ' Scheduler â ' Repair Request flag (check).
This is only possible when we use MM & SD modules.

85.A field containing quantity amounts (data type QUAN) must be assigned to a reference table and a reference field. Explain?

As a reference table, a system table containing all the valid quantity units is assigned or any other table, which contains a field with the format or quantity units (data type UNIT). This field is called as reference field.
The assignment of the field containing quantity amounts to the reference field is made at runtime. The value in the reference field determines the quantity unit of the amount.

86.What is the significance of Delivery Class?

· The delivery class controls the degree to which the SAP or the customer is responsible for table maintenance.
· Whether SAP provides the table with or without contents.
· Determines the table type.
· Determines how the table behaves when it is first installed, at upgrade, when it is transported, and when a client copy is performed.

87.What are two methods of modifying SAP standard tables?

· Append Structures and
· Customizing Includes.

88.What is the difference between a Substructure and an Append Structure?

· In case of a substructure, the reference originates in the table itself, in the form of a statement include….
· In case of an append structure, the table itself remains unchanged and the reference originates in the append structure.

89.To how many tables can an append structure be assigned.


90.If a table that is to be extended contains a long field, we cannot use append structures why?

Long fields in a table must always be located in the end, as the last field of the table. If a table has an append structure the append line must also be on the last field of the table.

91.Can we include customizing include or an append structure with Pooled or Cluster tables?


92.What are the two ways for restricting the value range for a domain?

· By specifying fixed values.
· By stipulating a value table.

93.Structures can contain data only during the runtime of a program (T/F)


94.What are the aggregate objects in the Dictionary?

· Views
· Match Code.
· Lock Object.

95.What are base tables of an aggregate object?

The tables making up an aggregate object (primary and secondary) are called aggregate object.

96.The data of a view is not physically stored, but derived from one or more tables (t/f)


97.What are the 2 other types of Views, which are not allowed in Release 3.0?

· Structure Views.
· Entity Views.

98.What is a Match Code?

Match code is a tool to help us to search for data records in the system. Match Codes are an efficient and user-friendly search aid where key of a record is unknown.

99.What are the two levels in defining a Match Code?

· Match Code Object.
· Match Code Id.

100.What is the max no of match code Id’s that can be defined for one Match code object?

A match code Id is a one character ID that can be a letter or a number.

101.Can we define our own Match Code ID’s for SAP Matchcodes?

Yes, the number 0 to 9 are reserved for us to create our own Match Code Ids for a SAP defined Matchcode object.

102.What is an Update type with reference to a Match code ID?

If the data in one of the base tables of a matchcode ID changes, the matchcode data has to be updated. The update type stipulates when the matchcode is to be updated and how it is to be done. The update type also specifies which method is to be used for Building matchcodes. You must specify the update type when you define a matchcode ID.

103.What is the function of a data element?

A data element describes the role played by a domain in a technical context. A data element contains semantic information.

104.Can a domain, assigned to a data element be changed?

Yes. We can do so by just overwriting the entry in the field domain.


Post a Comment