ABAP Dictionary

SE11-Data Dictionary is a central source for data in data base management system. Its main function is to support the creation and
management of data definitions.

Following are the objects in the data dictionary:
1. Tables
3. Data type (Data Element, Structure, Table Type)
4. Domain
5. Type group
6. Search Help
7. Lock Objects

Data base tables are 3 types.

1. Transparent Tables
2. Pooled Tables
3. Clustered Tables.

1. Transparent Tables
Transparent table has the same name and same no of fields in the Database as well as in the Data dictionary.
For each transparent table in the dictionary there is one associated table in the database.
It has one to one relationship with the table in the Data base.

2. Cluster tables
Cluster table has Many to One relation ship with the data base table. It is nothing but group of fields
from different transparent tables and all are combined base on Primary Key. It follows Binary Search.

3. Pooled tables
Pooled table has Many to one relation ship with the data base table. It is similar to the cluster table ,
the only difference is it cannot maintain the Primary key. It follows Linear Search.

Types of data in DB Tables:

1. Configuration data – It never changed it is permanent. Tables start with ‘T’.
2. Master data. – Has little chance to change data. ex.. MARA,KNA1,LFA1….
3. Transaction data – very frequently change data. ex.. EKKO,EKPO,VBAK,VBAP….

Tables are defined in the ABAP dictionary independently of the database. A table having the same structure is then created from this table definition in the underlying database.

A table definition in the ABAP dictionary contains the following components:

Table fields – define the field names and datatypes of the fields contained in the table

Foreign Keys – Define the relationships between the tables

Technical Settings – Control how the table should be created in the database.

Technical settings will have Local Storage Parameters and Buffering.Local storage parameters consists of Dataclass and size category. Data class is the physical area or table space where the tables has to be stored in database. Size category defines the expected space required for the table in the database.

Dataclass             Description

APPL0                 Master data, Transparent tables

APPL1                 Transaction data, Transparent tables

APPL2                 Organization and customizing data

USER                  Customer data class

USER1                 Same

Size Category     No of data records of table expected

0                           0 to 2,600

1                            2,600 to 10,000

2                            10,000 to 42,000

3                            42,000 to 1,70,000

4                            1,70,000 to 13,00,000

30-03-2014 06-39-20

While creating database table in dictionary we have to fill delivery class,table maintenance and technical settings(explained above).

Delivery class: It defines the type of data that is going to be stored and also it defines the owner of the table and also delivery class controls the transport of table data for installation,upgrade,client copy and when transporting between customer systems.

30-03-2014 07-03-39

30-03-2014 07-05-02

Table maintenance allowed should be given.

Domain: It is used to define technical attributes(datatype and length) and the value ranges(fixed values and intervals).

Dataelement: Information about the meaning(description) of a table field or structure is defined here.

Most used Data types are CHAR(character string),CLNT(client),CUKY(currency key),CURR(currency field),DATS(Date field),INT1(1 byte integer),INT2(2 bytes integer),INT4(4 bytes),LANG(Language key),NUMC(character string with only digits),QUAN(Quantity field),UNIT(unit key for QUAN),TIMS(time field),VARC(Long character string),STRING(character string of variable length)

Hope you understood what is data dictionary and what it contains..now just create a transparent table in DDIC.


Data about an application object is often distributed on several tables. By defining a view, you can define an application-dependent view that combines this data. The structure of such a view is defined by specifying the tables and fields used in the view. Fields that are not required can be hidden, thereby minimizing interfaces. A view can be used in ABAP programs for data selection.


The data of a view is derived from one or more tables, but not stored physically. The simplest form of deriving data is to mask out one or more fields from a base table (projection) or to include only certain entries of a base table in the view (selection). More complicated views can comprise several base tables, the individual tables being linked with a relational join operation.
Four different view types are supported. These differ in the way in which the view is implemented and in the methods permitted for accessing the view data.
Database views are implemented with an equivalent view on the database.
Projection views are used to hide fields of a table (only projection).
Help views can be used as selection method in search helps.
Maintenance views permit you to maintain the data distributed on several tables for one application object at one time.

Database Views
Data about an application object is often distributed on several database tables
A database view is automatically created in the underlying database when it is activated.
Application programs can access the data of a database view using the database interface. You can access the data in ABAP programs with both OPEN SQL and NATIVE SQL. However, the data is actually selected in the database. Since the join operation is executed in the database in this case, you can minimize the number of database accesses in this way. Database views implement an inner join (see Inner and Outer Join).


See how to create databaseview

Projection Views
Projection views are used to hide fields of a table.
A projection view contains exactly one table. There is no corresponding object in the database for a projection view. Access to a projection view is mapped by the SAP System onto the corresponding access to its base table. It is also possible to access pooled tables or cluster tables with a projection view.


See how to create projectionview

Help Views
You have to create a help view if a view with outer join is needed as selection method of a search help.
The selection method of a search help is either a table or a view. If you have to select data from several tables for the search help, you should generally use a database view as selection method. However, a database view always implements an inner join. If you need a view with outer join for the data selection, you have to use a help view as selection method.


All the tables included in a help view must be linked with foreign keys. Only foreign keys that have certain attributes can be used here (see Restrictions for Maintenance and Help Views). The first table to be inserted in the help view is called the primary table of the help view. The tables added to this primary table with foreign keys are called secondary tables.

See how to create helpview

 Maintenance Views
Maintenance views offer easy ways to maintain complex application objects.
Data distributed on several tables often forms a logical unit, for example an application object, for the user. You want to be able to display, modify and create the data of such an application object together. Normally the user is not interested in the technical implementation of the application object, that is in the distribution of the data on several tables.
A maintenance view permits you to maintain the data of an application object together. The data is automatically distributed in the underlying database tables. The maintenance status determines which accesses to the data of the underlying tables are possible with the maintenance view.
All the tables in a maintenance view must be linked with foreign keys, that is the join conditions for maintenance views are always derived from the foreign key. You cannot directly enter the join conditions as for database views.
There are some restrictions for the attributes of the foreign keys with which the tables in a maintenance view can be linked.


A standardized table maintenance transaction is provided (SM30), permitting you to maintain the data from the base tables of a maintenance view together.
Maintenance mechanisms, like screens and processing programs, must be created from the view definition with the transaction Generate Table View (SE54). This makes it possible to create easy-to-use maintenance interfaces in a simple manner.


See table maintenance generator and even try this

what are search helps and how to create it? clickhere

Structures in ABAP

Structure is a skeletal view of a table. It contains the definition of columns and don’t have any contents. Structure is generally a template based on which a table is created. The basic difference between structure and table is that the structure does not exist at the underlying database system level. Structure exists as definition in the dictionary.

Types of Structures

Append Structure:- It will add Fields to the table from last . we can’t use that structure in another table. An append structure is a structure assigned to just one table. When a table is activated, all append structures for the table are found and appended to the table.Append structures are used to add customer fields to SAP tables and Custom tables also.

Include Structure: Include structures can used by us to add fields into any ztables and SAP tables also. Because in a Ztable we can add fields where ever we want. Include structure can be used more than one time in a table. The same include structure can be included to any no of custom tables.

Difference between structure(table type) and table?

A transparent table equates to a database table, you can use SE11 or SE16 to
view the contents of the table.

A structure is just a grouping of data elements (fields). Structures are not database tables so you can’t view the contents of a structure. You
would use structures within an ABAP program to group data elements of an object. Structures defined like a table and can then be addressed from ABAP programs.Structures contain data only during the runtime of a program.

How to create a structure?





Introduction to SAP

Introduction to SAP

ERP: Enterprise Resource Planning. Enterprise means company should have input and output. Resource means man power,furniture etc and Planning is to plan the resource in profitable manner for the enterprise

SAP: System Application and Programming.

ERP is an application can be used to automate the different. Business process like HR,Operations,Finance,Sales and Marketing,Supply chain,Customer Relationship etc.

SAP was founded in 1972 in walldorf,Germany.

R/3 – Realtime 3 tier architecture.

SAP R/3 is SAP’s integrated software solution for client/server and distributed open systems.R/3 architecture is comprised of application and database servers. The application servers house the software and the database servers handle document updates and master file databases.


IDES – the “Internet Demonstration and Evaluation System” in the R/3 System, represents a model company.  IDES contains application data for various business scenarios that can be run in the SAP System. The business processes in the IDES system are designed to reflect real-life business requirements, and have access to many realistic characteristics.

SAP Standard modules


Finanacial Modules: Financial Accounting (FI), Controlling (CO), Investment Management (IM), Treasury (TR), Enterprise Control (EC).

Logistics Modules: Material management (MM), Sales & distribution (SD), Production, Planning & Control (PP), Product Data Management (PDM), Quality Management (QM), Plant maintenance (PM), Service management(SM), Project systems (PS)

Human resource management Module: Personnel Management, Organizational Management, Payroll Accounting, Time Management, Personnel Development, Training & Event Management

Cross Application Module: Workflow (WF), SAP Office.


ABAP – Advanced Business Application Programming


SAP Netweaver (Business process Management)

Information Security Management

SAP Business Suite Definition

SAP Business Suite is a collection of various SAP enterprise software that ensure optimized execution of business strategies.

It consists of the following SAP Systems:

1.SAP Customer Relationship Management (SAP CRM)

2.SAP Enterprise Resource Planning (SAP ERP)

3.SAP Product Lifecycle Management (SAP PLM)

4.SAP Supply Chain Management (SAP SCM)

5.SAP Supplier Relationship Management (SAP SRM).



Install windows 7 from usb drive


This is a very old procedure which i did in 2007/8/9. But i dont hold any blog at that time 😉 hence iam updating today with latest process including with images..its very easy for beginners as i will explain from scratch…


1. Copy of win7 files(DVD/ISO file)

2. Min 4GB pendrive

Lets start the process..

Insert your DVD in your drive and make a note of your CD/DVD drive name and along with your pendrive drive name.

Lets say my DVD drive is D and my USBdrive/pendrive is E

Open the command prompt with admin rights.



this loads the diskpart application we need to proceed

Then type


the image above shows our 32 GB USB drive is listed as DISK 2

so you have to type

SELECT DISK 2 (your USB Drive may have a different number, don’t follow exactly this text it depends on your usb drive)

You will get a successful response “Disk 2 is now the selected disk”


Next we want to clean the USB drive



you will get a successful response ‘DiskPart succeeded in cleaning the disk”.


After the drive is cleaned follow the list in the image above (detailed below in list order) – you can also note the successful text responses from the OS as you enter each command.

SELECT DISK 2 (or what number your USB drive has)





Formatting can take a little time depending on the size of the drive, our 32GB unit took about 10 minutes to format – you will see a percentage readout until it is finished.


Next type:


EXIT (DISK PART will exit)

Type D: CD BOOT (substitute the “D” if necessary with the letter of your Windows 7 DVD drive)

then key



BOOTSECT.EXE /NT60 E: (substitute the “E” if necessary with the letter of your now ready USB drive) – we are telling the system to create a boot sector file on the USB drive.

Now you can exit the command prompt and copy all the files on the Windows 7 DVD to the USB drive.

Once this step is finished you’ll be ready to boot from this drive, all you need to do is configure your motherboard bios setup to boot first from USB rather than hard drive or optical drive. If you don’t know how to do this, refer to your specific motherboard manual or search the internet.

what are search helps in sap abap

Search Helps

The input help (F4 help) is a standard function of the R/3 System. The user can display the list of all possible input values for a screen field with the input help. The possible input values can be enhanced with further information. This is meaningful especially when the field requires the input of a formal key.

Standard Input Help Process

A user calls an input help with the following steps (some steps can be omitted, depending on the definition of the input help):

  1. The user starts the input help to display the possible input values for a field (search field) in a screen template.
  2. The system offers the user a number of possible search paths. The user selects one of these search paths. Each search path offers a number of restrictions to limit the number of possible input values. These values are offered in a Dialog box for value restriction when the search path is selected.
  3. The user enters restrictions if required and then starts the search.
  4. Image351
  5. The system determines the values that satisfy the entered restrictions (hits) and displays them as a list (hit list).
  6. Image352
  7. The user selects the most suitable line from the hit list by double-clicking.
  8. The value of the search field is returned to the screen template (possibly together with other values).

Steps 2 and 3 are omitted if there is only a single search path available. In this case the dialog box for the value selection is offered immediately. You can also output the hit list directly after starting the input help. Steps 2 to 4 are omitted in this case.

There are two types of Search Help

1. Elementary Search Help is created from a single table.

2. Collective Search Help is a collection of more than one Search Helps.

How to create an elementary and secondary search help? clickhere



Learning is my passion..today i learnt basics of numerology and how to apply it. Hence iam posting here..

Basically numerology completely deals with numbers. If you want to test yourname with numerology you should start with counting numbers for each alphabets in your name..

First lets go through alphabets and its desired numbers..

A,I,J,Q,Y – 1
B,K,R – 2
C,G,L,S – 3
D,M,T – 4
E,H,N,X – 5
U,V,W – 6
O,Z – 7
F,P – 8

In Numerology, a number for the purpose of assessing the prospects of the Name means any number between 1 and 9.

In Numerology the numbers are reduced to a single digit.

If the total numerical value of a name by adding the value of all the letters in a name is 54, the numerical value of the number for the purpose of Numerology is 5+4= 9.

If the total numeric value of a name is 67, 6 and 7 are added together and the value we obtain is 13.

Again 1 and 3 are added with each other and the net numerological value of the name carrying a total numeric of 67 is 4.Thus the numerological value of the name or date of birth is reduced to a single digit.This is applied in respect of a name and as well the date of birth.

If the date of birth of a child is 25-11-2009, the total is arrived at adding 2+5+1+1+2+0+0+9=20. The resultant number is 20.

This is again added with one another. 2+0=2.

The net single digit total of the date of birth is thus 2, for the purpose of arriving at the fadic number (being called fate number or birth total number).

The numbers reduced to a single digit will fall between 1 and 9 (both 1 & 9 included).Each one Number from 1 to 9 is assigned to one Graha in the Navagraha family.


Sun(Surya) – 1
Moon(Chandra) – 2
Jupiter(Guru) – 3
Uranus(Rahu) – 4
Mercury(Budha)- 5
Venus(Shukra) – 6
Neptune(Kethu)- 7
Saturn(Shani) – 8
Mars(Mangala) – 9

If your dob or name count result number matches to 3,5,6 then its very good 🙂
if it matches to 1,2 then its good
if 4,7,8 and 9 then its very bad.

As we cant change dob, try to change name and make the count for good numbers.
All the best.