Skip to Content
author's profile photo Former Member
Former Member

R/3 Data dictionary Tables and Database tables

What is Difference between R/3 DDIC tables Definitions and Database Tables ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Aug 14, 2008 at 08:31 PM

    The data dictionary is a representation of the table which resides in the underlying database. This is why it is called a transparent table. You must know that R/3 stands for Real Time, 3 Tiered Architecture, meaning there is a presentation, applicatoin, and database layer. The data dictionary is simply an abstraction of the underlying database. Regardless of what database you use underneath, you still create the tables the same way in the dictionary, and when you create the table in SE11, it is automatically created in the underlying database based on the structure you defined in SE11.

    Regards,

    Rich Heilman

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Jack,

      check this SAP help about enhancement category

      Enhancement Category Selection

      Structures and tables that were defined by SAP in the ABAP Dictionary can be enhanced subsequently by customers using Customizing includes or append structures. The enhancements do not only refer to structures/ tables themselves, but also to dependent structures that adopt the enhancement as an include or referenced structure. Append structures that only take effect at the end of the original structure can also cause shifts - in the case of dependent structures - even within these structures.

      You must select an enhancement category for the following reason: In programs where there is no active Unicode check, enhancements to tables and structures can cause syntax and runtime errors during type checks and particularly in combination with deep structures.

      In programs where there is an active Unicode check, statements, operand checks, and accesses with an offset and length are problematic - for example, if numeric or deep components are inserted into a purely character-type structure and the structure thus loses its character- type nature.

      Depending on the structure definition, the radio buttons allowed in the dialog box are ready for input. Choose one of the possible enhancement categories:

      Cannot be enhanced

      The structure must not be enhanced.

      Can be enhanced or character type

      All structure components and their enhancements must be character-type (C, N, D, or T). The original structure and all enhancements through Customizing includes or through append structures are subject to this limitation.

      Can be enhanced or character-type or numeric

      The structure and its enhancement must not contain any deep data types (tables, references, strings).

      Can be enhanced in any way

      The structure and its enhancement may contain components whose data type can be of any type.

      Not classified

      This category can be chosen, for example, for a transition status; however, it must not be chosen for creating structures.

      The rules for defining the enhancement category result implicitly from the structure setup and the classification of the types used. These rules are as follows:

      If the object contains at least one numeric type or a substructure or component (field has a structure/table/view as its type) that can be enhanced numerically, the object can no longer be enhanced character-type, but is itself, at most, enhanceable character-type or numeric.

      If the object contains a deep component (string, reference, or table type), or it contains a substructure or component that is marked as enhanceable in any way, then the object itself is enhanceable in any way.

      If the object does not contain any substructure or component that is marked as enhanceable, you can select cannot be enhanced. If the structure has not yet been enhanced, you can choose the category cannot be enhanced in any case.

      If you are creating new tables and structures in the ABAP Dictionary, the system proposes the category can be enhanced in any way as standard value for the classification of the enhancement options. If the developer chooses a more restrictive classification than can be enhanced in any way for a particular structure, then only the classification levels that adhere to the rules above are allowed. It is not possible to choose an enhancement option of a structure that is more restrictive than the classification resulting immplicitly from the structure setup and from the classification of the types used. Therefore, only the allowed categories are proposed for selection in the maintenance user interface.

      If a structure depends on one or several other structures, the smallest category is chosen as implicit classification (in the order cannot be enhanced < can be enhanced and character-type < can be enhanced and character-type or numeric < can be enhanced in any way). This classification is greater than or less than the category in the other structures and also greater than or the same as the category that results from the actual setup in the original structure itself.

      Thanks

      Bala Duvvuri

  • author's profile photo Former Member
    Former Member
    Posted on Aug 14, 2008 at 08:30 PM

    ztables---ddic tables

    sap created tables ---data base tables

    but both are ddic.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.