SAP Database

SAP Certification, Ebooks, PDF’s, Articles, News, Tips and Tricks
Bookmark : Del.icio.us | Digg it | StumbleUpon

Online Resources on Certification, Learning, Ebooks, PDF's, Programs, Articles, Tips & Tricks, CBT's and News on SAP.

SAP Forums
SAP Forums - Get your SAP Issues resolved.
Write on this blog - Showcase your talent and make your ideas reach thousands.

ABAP Data Dictionary

Written by admin on May 20th, 2008 | Filed under: ABAP

Overview

Data definitions also called as meta data are managed and created in ABAP Dictionary. It allows to maintain a huge volume of data without data redundancy. The ABAP Dictionary describes the logical structure of all the dictionary objects used in Application development. It also provides you with the flexibility of accessing the data on the screen and allows you to maintain manage and create without any programmers intervention.

data-dictionary

The data dictionaries can be categorized into the following.

  • Database table
  • Views
  • Data types
  • Domain
  • Search Help
  • Lock Objects

Database tables:

Tables can be defined independently in the database in the ABAP Dictionary. The fields of the table are defined together with their data types and lengths.
A table definition has following components:
Table fields
Foreign keys
Technical settings
Indexes

Views

A View is a logical representation of tables. This is just a way of organizing the data by combining more than one table by comparing the common fields which is called a join.

Data types:

It’s an attribute to tell as to what kind of data is it going to hold like numbers, characters, integers etc. A data type can be an elementary data type or a reference data type.

Domain:

A domain contains the technical attributes of the data type. Like the length, the actual data type ( like char, integer), The output characteristics and the value range which tells us as to what kind of data can be accepted as a valid input.

Search Help:

A search help is simply what you see in SAP when you key in the F4 button. It provides you with the list/range of values.
A search help can be categorised into three types:
Elementary Search help
Collective Search Help
Append Search Help

Lock Object:

A lock object is virtual link of an sap table which is used to synchronize the data when more than one user attempts to write to the Database table. These lock objects are called and handled inside the program based on requirement.

Okay, enough of theory… Lets get into practicals, Here is a step by step guide to teach you in creating Data dictionary and Search help.
Copyright: SAP Database : SAP Certification, Ebooks, PDF, Articles, News
!!!! DO NOT COPY !!!!

Random Posts



One Response to “ABAP Data Dictionary”

  1. Hi,
    This is Balaji. I’m learning SAP(ABAP). For me this is very useful. Thankyou for providing this information.
    Thanks alot.

    -Balaji.

    [Reply]

Leave a Reply

  • Sponsers

  • AMAZON Books


Warning: stristr() [function.stristr]: Empty delimiter in /home/shiras/public_html/wp-content/plugins/wassup/wassup.php on line 2093