topic Re: abap dictionary in Application Development and Automation Discussions

abap dictionary

Former Member — Sat, 28 Jul 2007 05:25:16 GMT

i am new learner for sap-abap programming. when i tried to create y or z tables, i can't make record entries. i am facing some problem. it says the system setting are not allowed to do. please give some idea.

Re: abap dictionary

Former Member — Sat, 28 Jul 2007 06:11:53 GMT

welcome to SDN forum.

First up all, do you have DEVELOPER access key to create a Table? have you previously created any object in the system?

Take the developer access key and create the table

Goto SE11 Tcode

enter table name

press create

enter description

enter delivery class as 'A'.

press fields

enter some 3 fields with their data elements or press predefined type

enter the data type as CHAR and length some 10 like that enter some fields and save

press technical settings button on application toolbar

enter data class and size category and save and activate

Database table

Tables can be defined independently of the database in the ABAP Dictionary. The fields of the table are defined together with their (database-independent) data types and lengths.

A table definition in the ABAP Dictionary has the following components:

Table fields: The field names and the data types of the fields contained in the table are defined here.

Foreign keys: The foreign keys define the relationships between this table and other tables.

Technical settings: The technical settings define how the table is created on the database.

Indexes: Indexes can be defined for the table to speed up data selection from the table.

There are three categories of database tables in the ABAP Dictionary.

A physical table definition is created in the database for the table definition stored in the ABAP Dictionary for transparent tables when the table is activated. The table definition is translated from the ABAP Dictionary to a definition of the particular database.

On the other hand, pooled tables and cluster tables are not created in the database. The data of these tables is stored in the corresponding table pool or table cluster. It is not necessary to create indexes and technical settings for pooled and cluster tables

Reward points for useful Answers

Regards

Anji

Re: abap dictionary

Former Member — Sat, 28 Jul 2007 06:52:37 GMT

Hi,

Please make ensure that you have created the Table maintenance Generator....

If you are going for the master table then Client foeld is important without that it wont allow.

After creation of everything goto Table --> Utilities --> Table contents --> create Entries

You can able to see the content of the screen.

Thanks,

Yogesh

Re: abap dictionary

Former Member — Sat, 28 Jul 2007 07:17:37 GMT

Hi,

step 1. Go to transaction se11.

step 2. write a table name prefix with z.

step 3. Give description.

step 4. It comes to delivery and maintainance, In delivery class u have 3 types u can select any of those 3. I have selected as A(master and transaction data).

Along with this u have to mention ur data browser as Display/ maintainance allowed only.

step 5. Go to technical settings, specify ur data class (APPL0) and size.

step 6. Create your fields with data element and domain.

step 7. While u enter ur data element ( the name u give should prefix with z) double click on that.

step 8. Now u have two options either to create domain or data type. After creating this, it will ask for field label, mention the field label.

step 9. Now activate at the same screen and come back u'll come to data element screen then again activate. Finally u'll come to first screen.

step 10. Follow steps 6 to 9 for more fields.

step 11. then activate.

step 12. To create entries in the table. On menu bar u have utilities, in that u have table contents, in that u have create entries.

step 13. After every entry save the data. That will be saved in the databaase.

chk ths

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb6e446011d189700000e8322d00/content.htm

Regards

Re: abap dictionary

Former Member — Sat, 28 Jul 2007 07:38:07 GMT

Hi,

This is a very common problem most beginner encounterd in initial days )

I guess you don't have table maintainence authority.

Go to the attributes of of your Z table. There tick the checkbox table maintennce allowed.

Regards,

A.Singh

Re: abap dictionary

Former Member — Sun, 29 Jul 2007 02:22:35 GMT

Hi,

Use transaction se11 .. enter ztable name.. and fill the mandatory fields in it.. enter the field names u have in the fields tab

else.

TO create a ZTABLE, The steps are as follows:

Go to SE11.

Give ur table name zxxxx.

Press create.

Now Give the short description for ur table.

In the DELIVERY AND MAINTAINENCE TAB,

Specify the delivery class A or C or wat ever depending on ur requirement.(If u ztable is customizing table, Specify C else give A for applic table)

Specify Data Browser/Table View Maint as per ur requirement.

Now in the FIELDS TAB,

Specify the fields u want to display in ur table.

Accord choose in built data element and domain.

IF the data element and domain for ur requirement is not created, then u can create a Z data element and domain and use the same for ur table.

Finally after ur fields are given, Do the TECHNICAL SETTINGS for ur table and also do TABLE MAINTAINENCE GENERATOR (Goto Utilities -->Table maintainence).Only then u'll b able to give new entries in ur ztable.

Then activate ur table and save it in the assigned package.

Re: abap dictionary

Former Member — Mon, 30 Jul 2007 06:40:08 GMT

hi,

I think u forgot to check table maintennce allowed.

Go to the attributes of Z table. check the checkbox table maintennce allowed.

Re: abap dictionary

Former Member — Mon, 30 Jul 2007 09:50:30 GMT

Steps to Creating domains, Data Elements, Tables

To give you the steps for creating table:.

There are two approach in creating a table.

1. Bottom-up approach

2. Top-down approach.

Both are valid and you can choose which approach is suitable for you. I always use the bottom-up approach. Here are the steps to create the tables with this approach.

1. SE11 will take you to the DDIC and enter the name of the new table to be created. Let us say Zname. Click create.

2. Enter the short discription of the table and enter the field of the table. If it is primary key and you have to check the box.

3. Enter the data element and double click it, you will be asked to save and will take you to data element discription page. Enter the short discription of the data element and enter the information of domain like the length of field and type of field.

4. If you wanted to use the existing domain then its fine, or else, you have to create one. Enter the domain name in the data element page and double click it. Page will ask to save and jump to domain creation page.

5. In the domain page, you have to save the information which you have already given in the data elements page and check it. Before going to data element page, you have to activate the domain.

6. Go to data element page and save, check and activate.

7. Go to main table page and save, check, and activate.

8. Also, you have to save the technical settings of the table.

The table is now ready for operation. You can use it in your program or you can use it to enter information.

Check table: It is the table which will have all the information about the Foreign keys which are the primary keys in the check table.

It can be created by creating the foreign key from the main table. Click foreign key in the main table and it will take you to a page which will ask for table name and field to which foreign key relation has to be associated. Enter the information and you can create the check table automatically.

SM30 is used for maintenance of the table, that is to realease the errors occured during the creation of the table.

regards,

srinivas

*reward for useful answers*

Re: abap dictionary

Former Member — Fri, 03 Aug 2007 01:06:40 GMT

i got so many replies from many people. thanks, but still i tried in all the ways that everyone told. still i couldn't solve the problem.