topic Re: CREATE TABLE in Application Development and Automation Discussions

CREATE TABLE

Former Member — Sat, 03 Nov 2007 20:02:17 GMT

HOW TO CREATE Z* TABLE WITH DEFAULT VALUES FOR SOME FIELDS IN THE Z* TABLE

Re: CREATE TABLE

Former Member — Sat, 03 Nov 2007 21:27:39 GMT

Hi,

Go to SE11- Give the table name and press create button.

Check below link for detailed steps

http://sap-img.com/abap/steps-to-creating-domains-data-elements-tables.htm

Regards,

Atish

Re: CREATE TABLE

Former Member — Sat, 03 Nov 2007 21:30:22 GMT

When you create the table, make sure it is with table maintenance allowed. Then you can create entries.

Rob

Re: CREATE TABLE

Former Member — Sun, 04 Nov 2007 02:11:51 GMT

common man..do one thing go to one insttue and pay money they will teach every thing to u ..u cant understand 100% properly with live support..

okcoming to point go to Tcode se11 and gve name starting with give...enter the screen of delivery and maintainace...give app0 and mintancea allllowes..and now enter the scrren of fields..and gve ur any name of fields..and their field values according to ur reuirement..and then click on technical settings and then..gve data class and size category...depending on ur requrement...(i.e. for each field u have f1 help press and see and understand ok) then activate...now it is ready ok..rewrd points if helpfull

Re: CREATE TABLE

Former Member — Sun, 04 Nov 2007 06:27:10 GMT

Hi\

Observe these points carefully . you will get the solution.

To add the Same structure multiple times in the Same Table We have to Assign the Suffix while including the Structure.

How To:

Open the Table in Change mode in SE11

Select the Menu path : EDIT->Include->INSERT.

Enter Structure : <Your Z structure>

Suffix : <any character string Eg: A>

Save .

Now you can see all the Fields from include structure will have Suffix A.

Same way you can include the Structure Several times to the

Table using a different suffix each time.

This ensures that the field names are not duplicated.

Finally Activate your Table.

Now create the entries.

Re: CREATE TABLE

Former Member — Sun, 04 Nov 2007 15:51:06 GMT

If i understood your question and you need predifined values for some fields...

You can use Z_field with Z_domain as original with values filled in Value range

or use values from some table using check table...

Regards

Yossi

Re: CREATE TABLE

former_member195698 — Sun, 04 Nov 2007 16:00:12 GMT

Hi,

I don't think its possible to give some default values to some fields in the ZTABLE.. other than the Data type Defaults. What you can do is to write an Event in your table in the table maintenance. So whenever the user is trying to create a new entry, the Field is populated with some default value.