topic Re: Error while creating the Ztable in Application Development and Automation Discussions

Error while creating the Ztable

Former Member — Sat, 30 Jun 2007 06:30:16 GMT

Hi,

I am creating the Ztable and everything is fine but iam getting the messages

as 1Enhancement category for table missing

2)Enhancement category for include or subtype missing

when activating the table.

Please provide me the solution.

Thanks in advance.

Re: Error while creating the Ztable

Former Member — Sat, 30 Jun 2007 06:39:18 GMT

to avoid this define Enhancement category for your table

Go to SE11

enter table name

Change

From the menu

Extras-> Enhancement category

define/select second radiobutton can be enhanced

save and activate the table

Since this is a Warning you can simply ignore it

nothing will happen

Reward points for useful Answers

Regards

Anji

Re: Error while creating the Ztable

Former Member — Sat, 30 Jun 2007 12:59:34 GMT

go to se11 transaction and enter table name

Change From the menu

Extras-> Enhancement category

define/select second radiobutton can be enhanced

save and activate the table

Since this is a Warning you can simply ignore it

nothing will happen

Reward points if useful

Re: Error while creating the Ztable

Former Member — Sun, 01 Jul 2007 09:07:30 GMT

Dear Anji Reddy,

i had same problem in my system when ever iam crateing a custom table or enhancing any infotype........thank your for giving me the soultion for this warning.

but i have one more question to you.

I have four fields in my custom table....first field is key field and second one is non key (text descritpion of first field) , third fields is key field and fourth is again

as text field non key..

Field Data element

MANDT MANDT

ZZFAART FACHR (primary key)

FRTXT ZZFRTXT (char50)

ZZORGCODE ZZORGCODE (char10)

ZZORGTXT ZORGTXT (char60)

now when we are enteing from SM30 ... my requirement as per functional is

i have to make zzfaart field as primary key......... i have made it since that is first field.

now he wants zzorgcode as also primary key......... as per the table condtion i cannot

give zzorgcode as primary key as all the key fields should be in order..........but the functional say he wants in third place only............he saying we can see so many place in confiugration's in spro....where

when we enter first field the second field (text ) will be automatically populated.......

(this point iam able to do....) and the third field will be primary key...

however iam not able to do is to make the zzorgcode as primary key ............as he wants that tobe grated out as well once we enter the value and he wants it to make primary key so that no duplicates can be entered.

Please let me know how to do this point....

Regards

Syamala

Re: Error while creating the Ztable

Former Member — Mon, 02 Jul 2007 05:03:17 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.

reward points if it is usefull ....

Girish