Yes.Group of users can access these programs with a client no.
Name a few system global variables you can use in ABAP programs?
SY-SUBRC,SY-DBCNT,SY-LILLI,SY-DATUM,SY-UZEIT,SY-UCOMM,SY-TABIX..... SY-LILLI IS ABSOLUTE NO 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?
i)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-organising the contents of database tables according to users need. ii)using SY-DBCNT. iii)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?
Performance of ABAPs 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.
i)system tools
ii)field symbols and field groups. Field Symbols : Field symbols are placeholders for existing fields. A Field Symbol does not physically reserve space for a field,but points to a field which is not known until runtime of the program. eg:- FIELD-SYMBOL
Field groups : A field group combines several fields under one name.At runtime,the INSERT command is used to define which data fields are assigned to which field group. There should always be a HEADER field group that defines how the extracted data will be sorted,the data is sorted by the fields grouped under the HEADER field group.
What are datasets?
The sequential files(ON APPLICATION SERVER) are called datasets. They are used for file handling in SAP.
How to find the return code of a statement in ABAP programs?
Using function modules.
What are interface/conversion programs in SAP?
CONVERSION : LEGACY SYSTEM TO FLAT FILE. INTERFACE : FLAT FILE TO SAP SYSTEM.
What are logical databases? What are the advantages/disadvantages of logical databases?
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.
adv:- 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. i)An easy-to-use standard user interface. ii)check functions which check that user input is complete,correct,and plausible. iii)meaningful data selection. iv)central authorization checks for database accesses. v)good read access performance while retaining the hierarchical data view determined by the application logic.
disadv:- i)If you donot specify a logical database in the program attributes,the GET events never occur. ii)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).
What specific statements do you using when writing a drill down report?
AT LINE-SELECTION,AT USER-COMMAND,AT PF.
What do you do when the system crashes in the middle of a BDC batch session?
we will look into the error log file (SM35).
