Question Database
Q) What is a table? What is the difference between structure and table?
Answer: Table consists of rows and columns where we store the real world data. Main difference between structure and Table –
When we create table and activate it, it will be created both in ABAP dictionary and under lying physical database. Table can hold data. Where as structure can not hold data. It is created only in the ABAP dictionary. We can declare objects that are of structure type and make use of them to hold data in run time.
Q)Have you ever created custom database tables (Z tables) in any project?
Answer: This is the most common question being asked in any interview. For this you can say YES. I will give you a real time example. There is a report program. You want to maintain the log of execution for that report. That means you want to maintain user details who has executed the report. When they have executed and what time?
For that you will create a custom table with fields like user id, date, time etc. When ever a particular report is executed, the custom table is updated with the details mentioned above. This is the simple scenario. Like this, we can create custom tables to suit our requirements.
Q)What is a logical database?
Answer: This is one of the most commonly asked questions in a SAP technical interview. A logical database is simply an ABAP program that combines the contents of database tables. A logical database is linked to an ABAP report program as one of the program attributes.
It supplies the ABAP report program with a set of hierarchically structured table entries derived from different database tables. This saves the developer from having to program the data retrieval. The logical database term covers both the program and the dataset.
Q). In SAP how can a user view a list of all changed entries in customizing tables?
Answer: For viewing changed entries in a user has to turn on table logging, once this is done, one can view each changed entry to the customizing table. SAP shows information by system, date, time, user, the old entry, and the new entry; a list of all prior modified data is also shown by the system.
No comments:
Post a Comment