INTERVIEW


Q1. What is ERP?

ANS. ERP (Enterprise Resource Planning) is a software solution to automate the business process of very huge organizations to use the resources optimally in order to get more profits.
---------------------------------------------------------------------------------------------------------------------------------------------
Q2. What does SAP stand for?

ANS. "SAP" stands for Systems, Applications, and Products in Data Processing.
---------------------------------------------------------------------------------------------------------------------------------------------
Q3. What are the features of SAP-R/3?

ANS.  Features of SAP-R/3
  1. It supports more than 60 modules.
  2. It supports more than 30 languages.
  3. Tight integration between modules.
  4. It is open.
  5. It provides real time data to enable efficient decision making.
---------------------------------------------------------------------------------------------------------------------------------------------
Q4. What is SAP R/3 Architecture?

ANS. http://abapteacher.blogspot.com/2011/12/sap-r3-architecture.html
---------------------------------------------------------------------------------------------------------------------------------------------
Q5. Explain how Database is associated with SAP?

ANS.http://abapteacher.blogspot.com/2012/01/database-association-with-sap.html
---------------------------------------------------------------------------------------------------------------------------------------------
Q6.  Write a program to display the date, month and year of the current date on separate lines. For example if the current date is March 22, 2004, then the output should be as follows:
Date :    22
Month :    03
Year :    2004
ANS. 
DATA : YEAR(4TYPE C,
        MONTH(2TYPE C,
       
DATE(2TYPE C.

YEAR = sy-datum+
0(4).
MONTH = sy-datum+
4(2).
DATE = sy-datum+6(2).

WRITE : / 'DATE  : ' , DATE,
        /  
'MONTH  : ' , MONTH,
        /  
'YEAR  : '
 , YEAR.
---------------------------------------------------------------------------------------------------------------------------------------------
Q7. In SAP terminology what is meant by Master Data?

ANS. Master Data is a collection of information about a person or an object. Example: A cost object, Vendor, or G/L account. For example a vendor master record contains not only general information such as the vendor's name & address, but also specific information , such as payment terms & delivery instructions. Generally for end users, master data is reference data that you will look up & use but not create or change.
---------------------------------------------------------------------------------------------------------------------------------------------
Q8. In SAP terminology what is meant by Transactional data?

ANS. Transactional data is related to a single business event such as a purchase requisition or a request for payment. when you create a requisition, for example, SAP creates an electronic document for that particular transaction. SAP gives the transaction, a document number & adds the document to the transaction data that is already in the system. whenever you complete a transaction in SAP, that is when you create, change, or print a document in SAP, this document number appears at the bottom of the screen.
---------------------------------------------------------------------------------------------------------------------------------------------
Q9. What are the central interfaces of the R/3 system?

ANS.          1. Presentation Interface.
                  2. Data base Interface.
                  3. Operating System Interface.
---------------------------------------------------------------------------------------------------------------------------------------------
Q10. Which interface controls what is shown on the P.C?

ANS. Presentation Interface.
---------------------------------------------------------------------------------------------------------------------------------------------
Q11.Which interface converts SQL requirements in the SAP development system to those of the Database?

ANS. Data base Interface.
---------------------------------------------------------------------------------------------------------------------------------------------
Q12. What is SAP dispatcher?

ANS. SAP dispatcher is the central agent which manages the resources for the R/3 applications.
---------------------------------------------------------------------------------------------------------------------------------------------
Q13. What are the functions of dispatcher?

ANS.    1. Equal distribution of transaction load to work processes.
             2. Management of buffer areas in main memory.
             3. Integration of the presentation levels.
             4. Organization of communication activities.
---------------------------------------------------------------------------------------------------------------------------------------------
Q14. What is an Internal Table?

ANS. An internal table is a temporary table stored in RAM on the application server. It is created and filled by a program during execution and is discarded when the program ends. Like a database table, an internal table consists of one or more rows with an identical structure, but unlike a database table, it can’t hold data after the program ends. Use it as temporary storage for manipulating data or as a temporary private buffer.
---------------------------------------------------------------------------------------------------------------------------------------------
Q15. How many types of Internal Tables are there?

ANS.      1. Standard Table.
               2. Sorted Table.
               3. Hashed Table.
---------------------------------------------------------------------------------------------------------------------------------------------
Q16. What are the differences between Standard Table, Sorted Table and Hashed Table?

ANS. Standard Tables have an internal linear index. The system can access records either by using the table index or the key. The response time for key access is directly proportional to the number of entries in the table. The key of a standard table is always non-unique. You can't specify a unique key. This means that standard tables can always be filled very quickly, since the system doesn't have to check whether there are already existing entries.
           Sorted Tables are always saved sorted by the key. They also have an internal index. The system can access records either by using the table index or the key. The response time for key access is logarithmically proportional to the number of table entries, since the system uses a binary search. The key of a sorted table can be either unique or non-unique. When you define the table, you must specify whether the key is to be unique or not. Standard tables and sorted tables are
known generically as index tables.
           Hashed Tables have no linear index. You can only access a hashed table using its key. The
response time is independent of the number of table entries, and is constant, since the system
access the table entries using a hash algorithm. The key of a hashed table must be unique.
When you define the table, you must specify the key as unique.
---------------------------------------------------------------------------------------------------------------------------------------------
Q17. A requirement is to display a persons name & address on the screen. The name must start in column 10 & the address must appear directly below it. Which of the following statements allow this?
  1. WRITE : AT POSITION 10 NAME , / ADDRESS.
  2. WRITE : /10 NAME, ADDRESS UNDER NAME.
  3. WRITE : /10 NAME, /ADDRESS.
  4. WRITE : /10 NAME, /ADDRESS UNDER NAME.
ANS. 4

EXPLANATION.                                    
                                                   DATA : NAME(5),
                                                                ADDRESS(8).
                                                                NAME = 'JOHN'.
                                                                ADDRESS = 'CA'. 
                                                   WRITE : /10 NAME, /ADDRESS UNDER NAME.
---------------------------------------------------------------------------------------------------------------------------------------------
Q18. If define statement : DATA A. What will be the type & length of A?

  1. TYPE CHAR LENGTH 1
  2. TYPE P LENGTH 8
  3. TYPE I LENGTH 4
  4. TYPE F LENGTH 8
  5. TYPE N LENGTH 1
ANS. 1
---------------------------------------------------------------------------------------------------------------------------------------------
Q19. Which of the following is true with left-outer join?

  1. Rows on left hand table don't meet join condition don't appear in combined list
  2. Rows on right hand table not meet join condition, not in combined list
  3. All rows of both will be in combined result
  4. rows of both in result only if both have matching rows
ANS. 2
---------------------------------------------------------------------------------------------------------------------------------------------






1 comment: