SAP Internal Tables Interview Questions

SAP Internal Tables Interview Questions and Answers asked in Wipro, Infosys, IBM.

In what way is made the client specification regarding data processing?

TABLES SPFLI. SELECT * FROM SPFLI CLIENT SPECIFIED WHERE MANDT BETWEEN ‘001’ and ‘003’.

… END SELECT.

What types of Internal tables exist?

The Internal table type are:

a)      The standard table: for key access to this type of table linear search is used, so the duration needed for a search has a linear connection to how many table entries we have. For accessing standard tables it is best to use index operations.

b)      The hashed table: it is a table that will be handled using an internal hash procedure and it will only be available to access with the generic (key) operations like LOOP, SORT and others, so implicit/explicit index operations are forbidden.

c)      The sorted table: it is a table that is every time sorted in the right way and to access it we need to use binary keys. The index from the lower level is picked up by the system if we don’t have a unique key. The table count determines directly in a logarithmic way the needed runtime for key access.

d)     The index table: is the table which is possible for us to access with the aid of an index. Its solely purpose if to say what kind of generic parameters we will have in a function or form.

How do we describe the “Check” statements and what is their mechanism?

The “Check” statement is used for finishing one loop pass conditionally, when the condition says true the rest of the statements from the actual statement block will be ignored and will begin the next loop.

How can we describe the following commands: MODIFY LINE and READ LINE?

The MODIFY LINE statement is meant for changing the lines of a full list from inside the program and the READ LINE statement is used for reading data found on the lines from the current levels. READ LINE is the same as READ CURRENT LINE and they are both related to HIDE.

How do we describe Activation?

 In the time of activation, the runtime object of aggregate object/tables is being made, it will be buffered for the purpose of faster access from the application program; it contains details regarding the following objects of table: domain, data elements, field definition, table definition.

What is the best way for reading database table lines in an internal table in the form of packs of a known size?

SELECT *FROM SPFLI INTO TABLE ITAB PACKAGE SIZE N (N being the variable). We must give a name to the WILDCARD characters that are meant to be compared with numeric and character strings.

What do we mean by Lock Mechanism?

The Lock Mechanism stops the beginning of a fresh database operation when another has been finished in the right way. At the end of a conversion the lock will be made automatically if the conversion is correct.

Which are the buffering types?

Buffering can be full, generic or single record. In the first case the entire table or nothing will we found in the buffer while in the case of generic buffering the generic locations from the buffer are buffered entirely. Single record buffering is the third case in which the currently accessed records will be loaded into buffers.

What is the meaning of these terms: Switching changes, storing changes and cancelling changes?

The switching changes are the switches from active to revised version, the storing changes mean that active version will be deposited for a limited period of time in versions and cancelling changes will make a reset of the revised versions to be an active versions.

What is the significance of restart adjustment and cancel adjustment?

With restart adjustment will continue the conversion when it is at the finish point and with cancel adjustment the lock entry will be erased from table.

What is the version catalog and what types of versions exist?

The version catalog is the list that contains very version of an object in existence. The version types are:

a)      The active version: is the version made at the program activation.

b)      The revised version: is the version made at the editing of the current project.

c)      The temporary version: is the version made at the temporary copying of the active version in the database that has store version functions.

d)     The historical version: is the version made at the making of the correction and at the release of the correction.

How do we show the internal table contents and how does a program run in background?

We can push F9 from the selection screen but not before we fill the screen, then the display will show a request for the user to print Background Parameters. Then we write the output device, that can be for example HPLI/SAP2. Print has to be unchecked urgently from the spool options then we c also delete then new spool request. After we hit enter a screen will be displayed showing the start time of the heading , we may pres start now and save. In this way we have a background job started for the specific program, for displaying its status we will use this transaction code: SM37. Then from the screen that appears –Job overview then we select our program then Spool in the toolbar of the application the Output Controller and List of Spool Requests. After this-we select our Spool request and we hit the Display icon that we see in the overview. The List should appear. We have to be careful because if the list exceeds 255 columns it will become truncated in background.

What is generic key and generic area?

The generic key is the left part of the first table key. The generic area represents every record that correspond to generic key fields.

How do we separate these terms: invoking a program, transactions with or without return and what is the way to succeed?

When using AND RETURN the data of the invoking executable will be deposited by the system and the system will go back to the invoking once the invoked program was processed. The execution of the invoking program will be retaken when the statement is made. When we don’t add AND RETURN the entire data and the stages of the list that the invoking program has or we can say the whole internal session will be erased. Once the executable program is terminated the control will go back to where that start of the invoking program was. When it comes to transaction we have: 

CALL TRANSACTION [AND SKIP FIRST SCREEN] [USING]. It is a statement that preserves the invoking program data and the transaction begins. When the transaction finishes , the system will go back to the statement from the invoking report that is following the invoking. This statement: LEAVE TO TRANSACTION [AND SKIP FIRST SCREEN] finishes the invoking program and the transaction begins. The invoking stack will be erased (or what we name internal sessions) for all the past programs. When the transaction finishes, the system will go back to the area menu where the original program from the invoking stack begun.

Related Posts