Skip to Content
author's profile photo
Former Member

abap1

1- What is the difference between a pool table and a transparent table and how they are stored at the database level?

2 -How many types of tables exist and what are they in data dictionary?

3- Can you create a table with fields not referring to data elements?

4-What does an extract statement do in the ABAP program?

5- What are the exceptions in function module?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Oct 06, 2005 at 12:39 PM

    1)Difference between transparent tables and pooled tables.- Transparent tables: Transparent tables in the dictionary has a one-to-one relation with the table in database. Its structure corresponds to single database field. Table in the database has the same name as in the dictionary. Transparent table holds application data. Pooled tables. Pooled tables in the dictionary has a many-to-one relation with the table in database. Table in the database has the different name as in the dictionary. Pooled table are stored in table pool at the database level.

    2) 4 types of tables

    i)Transparent tables - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields. Both Opensql and Nativesql can be used.

    ii)Pool tables & iii)Cluster tables -

    These are logical tables that are arranged as records of transparent tables.one cannot use native sql on these tables

    (only opensql).They are not managable directly using database system tools.

    3) Yes, SE11 allows you to do this.

    4) Once you have declared the possible record types as field groups and defined their structure, you can fill the extract dataset using the following statements:

    EXTRACT <fg>.

    When the first EXTRACT statement occurs in a program, the system creates the extract dataset and adds the first extract record to it. In each subsequent EXTRACT statement, the new extract record is added to the dataset

    EXTRACT HEADER.

    When you extract the data, the record is filled with the current values of the corresponding fields.

    As soon as the system has processed the first EXTRACT statement for a field group <fg>, the structure of the corresponding extract record in the extract dataset is fixed. You can no longer insert new fields into the field groups <fg> and HEADER. If you try to modify one of the field groups afterwards and use it in another EXTRACT statement, a runtime error occurs.

    By processing EXTRACT statements several times using different field groups, you fill the extract dataset with records of different length and structure. Since you can modify field groups dynamically up to their first usage in an EXTRACT statement, extract datasets provide the advantage that you need not determine the structure at the beginning of the program.

    5) Exceptions are the errors that can come up when executing the function module. These exceptions should be handled appropriately by the caller.

    When is your interview? 😊

    Please award points for helpfule answers. Thanks.

    Regards,

    Rich Heilman

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 06, 2005 at 12:41 PM

    Hi,

    For Q1:check this link

    http://help.sap.com/saphelp_erp2004/helpdata/en/cf/21f083446011d189700000e8322d00/frameset.htm>

    For Q2: Check this link

    http://www.sap-img.com/abap/what-are-different-types-of-internal-tables-and-their-usage.htm>

    For Q4: Check this link,

    http://help.sap.com/saphelp_erp2004/helpdata/en/9f/db9ed135c111d1829f0000e829fbfe/frameset.htm>

    ForQ5:The exceptions screen only allows you to enter a text with which the exception can be triggered in the function module.

    hope it helps u.

    Thanks&Regards,

    Ruthra

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 06, 2005 at 12:54 PM

    Hi sameer,

    check this links.

    http://web.mit.edu/ist/org/admincomputing/dev/sap_table_types.htm

    regards,

    venu.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 06, 2005 at 01:04 PM

    Sameer,

    In addition to Rich's information here is some more.

    I. Transparent tables (BKPF, VBAK, VBAP, KNA1, COEP)

    Allows secondary indexes (SE11->Display Table->Indexes)

    Can be buffered (SE11->Display Table->technical settings) Heavily updated tables should not be buffered.

    II. Pool Tables (match codes, look up tables)

    Should be accessed via primary key or

    Should be buffered (SE11->Display Table->technical settings)

    No secondary indexes

    Select * is Ok because all columns retrieved anyway

    III. Cluster Tables (BSEG,BSEC)

    Should be accessed via primary key - very fast retrieval otherwise very slow

    No secondary indexes

    Select * is Ok because all columns retrieved anyway. Performing an operation on multiple rows is more efficient than single row operations. Therefore you still want to select into an internal table. If many rows are being selected into the internal table, you might still like to retrieve specific columns to cut down on the memory required.

    Statistical SQL functions (SUM, AVG, MIN, MAX, etc) not supported

    Can not be buffered

    IV. Buffered Tables (includes both Transparent & Pool Tables)

    While buffering database tables in program memory (SELECT into internal table) is generally a good idea for performance, it is not always necessary. Some tables are already buffered in memory. These are mostly configuration tables. If a table is already buffered, then a select statement against it is very fast. To determine if a table is buffered, choose the 'technical settings' soft button from the data dictionary display of a table (SE12). Pool tables should all be buffered.

    And about EXTRACT check this post

    Extracts in ABAP

    And coming to EXCEPTIONS in function modules, they are the errors and you can raise them in the function using the keyword RAISE.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 06, 2005 at 01:27 PM

    Hi,

    Q3- Can you create a table with fields not referring to data elements?

    - you can switch between data elements / direct type

    Andreas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Sameer,

      Please reward points to helpful answers and if you think if any of those answers solved you issue then close the post.

      Regards,