topic create a table with structure in Application Development and Automation Discussions

create a table with structure

Former Member — Fri, 16 May 2008 11:05:09 GMT

Hi all,

How to create a table with this structure.

Language X(3) SAP language code (NED, FRA, GER, ENG,)

Text type X(4) Information type

Text ID 9(4) ID in given information type

Text X(35) Description

Bigtext (occurs 15) X(80) Long description

How to maintain the data into this table.

Regards,

Madhavi

Re: create a table with structure

Former Member — Fri, 16 May 2008 11:12:41 GMT

First create a structure with the required fields:

[Creating Structures|http://help.sap.com/saphelp_erp2005/helpdata/en/90/8d7310b1af11d194f600a0c929b3c3/content.htm]

Then Create Table with mandt field and then include above structure.

[Creating Tables|http://help.sap.com/saphelp_erp2004/helpdata/en/cf/21eb6e446011d189700000e8322d00/frameset.htm]

To maintain Data in it, create table maintenance generator.

Go to SE11, give the table name and click on change. Then Go to utilities> Table maintenance generator.

In the table maintenance generator screen, we should give Authorization Group, Function Group name (Function Group name can be same as table name - You can create this usinf SE80), Maintenance type can be one step or two step, usually we will create with one step. we should give maintenance screen number. After clicking on create button, a table maintenance generator will be created.

To check it go to SM30 . In SM30, we find display, Maintain options.We can view the table contents by choosing Display and we can create table entries by choosing Maintain.

I hope it helps.

Best Regards,

Vibha

Please mark all the helpful answers

Re: create a table with structure

prasanth_kasturi — Fri, 16 May 2008 11:45:01 GMT

hi,

first create astructure in se11 with the required fields

then create a table .

in the fields tab after you enter all the required field,

for including a structure

selcet the line where you want to include the structure

EDIT--~~> INCLUDE~~--->INSERT

give your structure name.

and you have table with a structure.

regards

prasanth

Re: create a table with structure

Former Member — Mon, 19 May 2008 13:30:26 GMT

Hi Madhavi,

you want to create a table with the following fields.

Language X(3) SAP language code (NED, FRA, GER, ENG,)

Text type X(4) Information type

Text ID 9(4) ID in given information type

Text X(35) Description

Bigtext (occurs 15) X(80) Long description.

its not possible to create a table with field

Bigtext (occurs 15) X(80) Long description because you want to use occurs means you want a field which have to work as internal table.

instead you can increase the value from 80 to (upto where you want)X and remove the occurs specification.

reward points if helpful.

Re: create a table with structure

Former Member — Mon, 19 May 2008 14:20:45 GMT

Creating a structure :

Language X(3) SAP language code (NED, FRA, GER, ENG,)

Text type X(4) Information type

Text ID 9(4) ID in given information type

Text X(35) Description

Bigtext (occurs 15) X(80) Long description

First u need to create a table line for bigtext which is like a table in the se11. To create u select data type and in that u select table type and create that field.

Then u create a structure with the remaining fields and call that table type as one of the field in the structure. Generally we use this kind in smartforms.

Hope this info will help u.

Thiru

Re: create a table with structure

Former Member — Wed, 03 Aug 2011 12:04:03 GMT

thanks

Re: create a table with structure

former_member201275 — Wed, 03 Aug 2011 12:50:10 GMT

Why are you posting question after question. Is it easier than having to think and search and do the work yourself?

Re: create a table with structure

Former Member — Sun, 14 Aug 2011 08:34:05 GMT

Madhavi,

U cant directly crt a table wid structure u need to create the structure as table line type in SE11 and then create the table with reference to it.