QUESTION Database

Q) What is ASAP methodology?

Answer. ASAP stands for Accelerated SAP (ASAP). ASAP is a software tool used for project management in SAP implementations. Normally, any SAP implementation involves various phases. ASAP helps in guiding a SAP implementation project. Thus from the initial stages to the "Go Live" stage, ASAP helps in streamlining the entire SAP implementation process.

One of the most asked question in a SAP interview is whether it is possible to have a self defined transaction code in SAP. The answer to the question is simple and if given tactfully can impress the interviewers.

Q) In SAP, is it possible to have a self-defined transaction code?

Answer: To start with, yes, self-defined reports, transactions or functions are possible within SAP. There might be numerous reasons why a company might go in for customized transaction codes or for that matter reports. To cater to this demand, SAP allows creation of user-defined transaction codes.

Creating a transaction code allows the user to speed up access to specific reports/programs as the user no longer needs to use transaction code [SA38]. Thus, instead of using T-Code SA38, then entering the program name or report name and pressing execute, the same can be done directly through a pre-defined T-Code. The user can then simply use a transaction code, which will automatically open the program. In SAP customized T-codes can be created through transaction code [SE93].

Q) What is ABAP data dictionary?

Answer. A data dictionary is central source information for data in a data management system. Its function is creation and management of data definitions.The data dictionary objects are automatically created in the database.

Q) How many types of tables are there in SAP?

Answer. There are three types of tables

1) Transparent tables
2) Pooled tables
3) Cluster tables

Table pools (pools) and table clusters (clusters) are special table types in the ABAP Dictionary. The data from several different tables can be stored together in a table pool or table cluster. Tables assigned to a table pool or table cluster are referred to as pooled tables or cluster tables.

A table pool or table cluster should be used exclusively for storing internal control information (screen sequences, program parameters, temporary data, and continuous texts such as documentation). Data of commercial relevance is usually stored in transparent tables.

Transparent Table: Exists with the same structure both in dictionary as well as in database exactly with the same data and fields. Pooled Table: Pooled tables are logical tables that must be assigned to a table pool when they are defined. Pooled tables are used to store control data. Several pooled tables can be combined in a table pool. The data of these pooled tables are then sorted in a common table in the database.
Cluster Table: Cluster tables are logical tables that must be assigned to a table cluster when they are defined. Cluster tables can be used to store control data. They can also be used to store temporary data or texts, such as documentation.

A transparent table is a table that stores data directly. You can read these tables directly on the database from outside SAP with for instance an SQL statement. I.E you can use Native SQL also to read the tables along with Open SQL. Transparent table is a one to one relation table i.e. When you create one transparent table then exactly same table will create in data base and if is basically used to store transaction data.

A clustered and a pooled table cannot be read from outside SAP because certain data are clustered and pooled in one field. I.E they must be read using OPEN SQL only. You cannot read them using native SQL.

You can create secondary indexes on transparent tables where as secondary indexes can’t be created on pooled and cluster tables.

>>>NEXT>>>