When a program is created and need to be transported to prodn 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?
What is the client concept in SAP? What is the meaning of client independent?
Ans In commercial, organizational and technical terms, the client is a self-contained unit in the R3 system, with separate set of Master data and its own set of Tables. When a change is made in one client all other clients are affected in the system - this type of objects are called Client independent objects.
Are programs client dependent?
Ans Yes, group of users can access these programs with a client number.
Name a few system global variables you can use in ABAP programs?
Ans SY-SUBRC, SY-DBCNT, SY-LILLI, SY-DATUM, SY-UZEIT, SY-UCOMM,
SY-LILLI is absolute number of lines from which the event was triggered.
What are internal tables? How do you get the number of lines in an internal table? How to use a specific number occurs statement?
1) It is a standard data type object, which exists only during the runtime of the program. They are used to perform table calculations on subsets of database tables and for re-organizing the contents of database tables according to users need.
2) Using SY-DBCNT.
3) The number of memory allocations the system need to allocate for the next record population.
How do you take care of performance issues in your ABAP programs?
Ans Performance of ABAP programs can be improved by minimizing the amount of data to be transferred. The data set must be transferred through the network to the applications, so reducing the amount of time and also reduces the network traffic.
Some measures that can be taken are:
- Use views defined in the ABAP/4 DDIC (also has the advantage of better reusability).
- Use field list (SELECT clause) rather than SELECT *.
- Range tables should be avoided (IN operator)
- Avoid nested SELECTS.
What are datasets?
Ans The sequential files (ON APPLICATION SERVER) are called datasets. They are used for file handling in SAP.
How to find the return code of an stmt in ABAP programs?
Ans Open SQL has 2 system fields with return codes:
Using function modules
What are Conversion & Interface programs in SAP?
Ans CONVERSION: Legacy system to flat file.
INTERFACE: Flat file to SAP system.
Have you used SAP supplied programs to load master data?
Ans SAP supplied BDC programs
RM06BBI0 (Purchase Requisitions)
RMDATIND (Material Master)
RFBIKR00 (Vendor Masters)
RFBIDE00 (Customer Master)
RVINVB00 (Sales Order)
What are the techniques involved in using SAP supplied programs? Do you prefer to
write your own programs to load master data? Why?
Identify relevant fields
Maintain transfer structure ( Predefined – first one is always session record)
Session record structure, Header Data, Item ( STYPE – record type )
Fields in session structure – STYPE, GROUP , MANDT, USERNAME , NO DATA
Fields in header structure – consists of transaction code also – STYPE, BMM00, TCODE, MATNR and Fields in Item - ITEMS …
Maintain transfer file – sample data set creation
What are logical databases? What are the advantages/disadvantages of logical databases?
Ans To read data from a database tables we use logical database.
A logical database provides read-only access to a group of related tables to an ABAP/4 program.
Advantages: - The programmer need not worry about the primary key for each table. Because Logical database knows how the different tables relate to each other, and can issue the SELECT command with proper where clause to retrieve the data.
1) An easy-to-use standard user interface.
2) Check functions, which check that user input is complete, correct, and plausible.
3) Meaningful data selection.
4) Central authorization checks for database accesses.
5) Good read access performance while retaining the hierarchical data view determined by the application logic.
6) No need of programming for retrieval, meaning for data selection
1) If you do not specify a logical database in the program attributes, the GET events never occur.
2) There is no ENDGET command, so the code block associated with an event ends with the next event statement (such as another GET or an END-OF-SELECTION).
3) Fast in case of lesser no. of tables But if the table is in the lowest level of hierarchy, all upper level tables should be read so performance is slower.
What specific statements do you using when writing a drill down report?
Ans AT LINE-SELECTION
What are different tools to report data in SAP? What all have you used?
What are the advantages and disadvantages of ABAP query tool?
Ans Advantages: No programming knowledge is required.
Disadvantages: Depending on the complexity of the database tables, it may not be easy for the user to select the necessary data correctly.
What are the functional areas? User groups? How does ABAP query work in relation to
Ans Functional Areas - By creating functional areas, we can initially select this data. This ensures that the data is presented to the ABAP Query user in a meaningful way to accomplish the task, and that only the data that the user may use is presented.
User Groups – A user group is a collection of users that work with about the same data and carry out similar tasks. The members of a user group can use all programs (queries) created by any user of the group. Changes to such a program are at once visible to all users. This ensures that all members of a user group use the same evaluation programs.
ABAP Query: It consists of three components – queries, functional areas and user groups. The functional areas provide the user with an initial set of data in accordance with the task to be accomplished. All users must be members of at least one user group. All members of one user group can access the same data as well as the same program (queries) to create lists.
Is a logical database a requirement/must to write an ABAP query?
Ans No, it is not must to use LDB. Apart from it, we have other options:
1) Table join by Basis Table
2) Direct Read of table
3) Data Retrieval by Program
What is the structure of a BDC sessions.
What are Change header and detail tables? Have you used them?
What do you do when the system crashes in the middle of a BDC batch session?
Ans We will look into the error log file (SM35). Check number of records already updated and delete them from input file and run BDC again.
What do you do with errors in BDC batch sessions?
Ans We look into the list of incorrect session and process it again. To correct incorrect session, we analyze the session to determine which screen and value produced the error. For small errors in data we correct them interactively otherwise modify batch input program that has generated the session or many times even the data file.
How do you set up background jobs in SAP? What are the steps? What are the events
driven batch jobs?
Ans Go to SM36 and create background job by giving job name, job class and job steps
Is it possible to run host command from SAP environment? How do you run?
What kind of financial periods exist in SAP? What is the relevant table for that?
Does SAP handle multiple currencies? Multiple languages?
What is a currency factoring technique?
How do you document ABAP programs? Do you use program documentation menu
What is SAP Script and layout set?
Ans The tool, which is used to create layout set is called SAP Script. Layout set is a design, appearance and structure of document.
What are the ABAP commands that link to a layout set?
Ans Control Commands, System Commands
What is output determination?
What is the field length of Packed Number? What is the default decimal of packed