SAP Tables Interview Questions asked in top companies.Explain in detail what is the meaning of Data Clusters in ABAP?
Data clusters are nothing but the way in which every type of complex internal data objects from an application in ABAP/4 are grouped. As such, they are also deposited in the memory of BAP/4 for a certain period of time or in databases for a longer duration of time. The databases of this type have the name accordingly, they are named cluster databases and their construction is defined well before.
This type of depositing data clusters is a important feature of ABAP/4. With the help of SQL statements, it becomes possible to enter cluster databases and the data clusters that have been deposited in ABAP/4 can be decoded only by ABAP/4.
In SAP, the application server manages the output /input of ABAP/4 programs and interprets them. Application servers are nothing but a groups of executables. Presentation servers are programs from the workstations of users that are called like this: Sapgui.exe.
What is the difference between SET and GET in SAP?
GET PARAMETER IF FIELD: The value deposited in ID is met in the variable by the statement, if a value is not found in SAP memory, the system configures SY-SUBRC to 4, in a different case is 0.
SET PARAMETER ID FIELD: The field contents from ID are stored in SAP memory in a code with up to 20 characters in length. If a value is found there already it will be overwritten, if there is no ID we have to make a new parameter object by double-clicking the ABAP Editor.
Explain what is the meaning of Field group, Extract data set?
Extract data sets are made of records sequences, we can have various structures for the records, record types are in fact a group of records that have the same structure. Every record type that an extract data-set has can be defined as a field group with the statement FIELD GROUPS.
The FIELD GROUPS statement brings multiple fields together with providing one single name. Normally, we should declare the field groups when the declaration part in a program is finished, which will make everything clearer.
Explain how can we process a sequential file, through what commands and syntax?
READ DATASET INTO
Can you explain how do we separate these statements: assign and move?
Assign: at data object assigning, the data project’s technical attributes are verified by the system for compatibility with every type specifications of the field symbol (ASSIGN TO). General attributes can be taken by the field symbol if they are not found in the field type specifications. If we go with the assignment it shows in the memory.
Move: the MOVE statement in SAP is used for giving data object values directly to variables. It can be found as text symbol, literal, constant but it is not necessary to be found as a variable. Whatever may be the personal configurations, the user has the decimal points always have to be stated with a period (,).
How can we make a separation between these terms: appending, input and output?
By appending, we understand opening a file in order to write at its end. In the case the file is not found we have to make it. Through input we understand the opening a file to read it and through output we mean opening a file for the purpose of writing. The file in which we write will be overwritten if it is already there and made if it doesn't exist already.
How do we proceed for a row in a table when we want to run a report?
In this case we will make use of the Graphics Multiplexer. We will have a procedure that resembles screen capture that allows us to capture just the data. With this data graphs can be designed 2D or 3D, a feature that we can always access from the Menu-generate Graphics. By this way, the required data can be dragged and we can choose the data we need for making a graph. After selection we must hit Graphics and the Graphics Multiplexer will be opened.
What we have to do for configuring the value of an occurs is to make optimizations and for this we have to keep in mind some things like:
- The default declared size will be maintained in the roll area – faster program access.
- The whole data area of the application will be 64 kilobytes.
- The data inserted that is bigger than the default size is deposited in the roll file- the program is accessed slow.
Can you write the syntax and function used for command AUTHORITY CHECK?
Syntax: AUTHORITY=CHECK OBJECT
IF SY-SUBRC NE 0. The verification for authorization from the user part for starting a specific action is made by AUTHORITY CHECK.
Explain the details regarding the debugger screen functions?
Single step or F5: It is an option that can be used to go through a program by every statement, in the function modules and subroutines that will run also step by step. After the processing of every function module or subroutine with the aid of the statements CALL FUNCTION and PERFORM the control can go back at the statement.
Return or F7: When control is going back to the main program, also the debugger will go back there from the subroutine. Return is an option that is good for going back to the invoking program from a subroutine , invoked program or function module.
Execute or F6: It is an option for running a program with every line, so in a single line the statements will be processed all at once. When we use Execute and we are on a line invoking a subroutine , the entire subroutine will be processed and it will go to the line with the subroutine invoking, and we can go from statement to statement inside the subroutine.
Continue or F8: It is an option good for processing the program up to the following dynamic or static breakpoint or the location of the cursor. When the breakpoints don’t exist anymore and there is no cursor, the remaining part of the program will be processed normally and the system will go out of the debugging mode.
Explain in detail the role of the following commands: IMPORT and EXPORT in SAP? When we use the command IMPORT what is the way for passing multiple data groups?
IMPORT: The statement used or reading the data objects from the memory into a program in ABAP/4 has this syntax:
IMPORT … FROM MEMORY ID.
The data objects that are read are found in a memory cluster in the form of a list. Without the option TO the same name will be found at assigning the data object from the memory to the one from the application. In this case the data object will be read in the field from memory and the memory cluster will be seen by the name, which can be of a maximum of 32 characters in length. We don’t really have to read every object that was deposited on a specific name, the object count can be restricted by the names of the objects. When on a specific name in the memory there are no objects then SYSUBRC will be four. In another case when the name from memory has a data cluster then SY-SUBRC will be 0 no matter if there is nor not a data object contained.
EXPORT: The statement and syntax used for reading data objects from the program into memory is cited below.
EXPORT … TO MEMORY ID.
A cluster in the memory is where the data objects are deposited in form of a list, when FROM is not used the data object will be stored in the name of the data object, when FORM is used a name will be used for storage and it will represent the cluster from the memory, 32 maximum characters in length. If we have the same name already EXPORT will overwrite what it finds in the current data cluster.
To achieve this, we will have to make use of these modules: UPLOAD or WS_UPLOAD for the presentation server and OPEN DATASET, READ DATASET, CLOSE DATASET for the application server.