topic Re: regarding database table in Application Development and Automation Discussions

regarding database table

Former Member — Tue, 19 Jun 2007 04:54:11 GMT

hi experts,

i have to develope my own databse tables in which for eg..i have to write:

B',

C. as a data under one column,,,what sud i do for this plz help me what can we do to write the data in the database tables without using modify statement i heard that i have to use SM30 FOR THIS BUT HOW ,,plz give the navigation ......

Re: regarding database table

Former Member — Tue, 19 Jun 2007 05:05:07 GMT

Ravi,

1. To create your table :

Go to SE11, create a table , name starting with Y/Z .

Can you elaborate wht u mean by data under one column ? Instead, you can

create 3 columns !

2. To make entries in the table :

Create table maintenance generator , ( Utilities -> Create table maintenance Generator .

Activate the table, then u shud b able to insert data thru sm30 .

Hope this helps ,

let me know if u face any problem

~ Laxmi

Reward for helpful answers

Re: regarding database table

Former Member — Tue, 19 Jun 2007 05:12:39 GMT

Hi Ravi,

This is a very easy task.

1. First create the Z table in se11 with the required fields and activate the table.

2. Once the table is activated, you will have to create a Table Maintenence Generator, which will help you to enter values/records in the table easily.

3. You can create the table maintenance generator as follows:

a. In SE11, when your table is displayed, goto Utilities and then goto Table Maintenance generator.

b. Enter Authorization group as &NC&. Create a function group in SE37 (just a blank one...need not write anything) and activate it..use this function group here.

c. For Maintenece Screen, keep it as 2 step and press the 'Find screen numbers' button on top to automatically get the screen numbers. Save and activate. Now the table maintenece generator would be created.

4. Goto transaction SM30, enter the tablename and press Maintain. You can enter your required table values here.

This should solve your problem.

PLZ REWARD POINTS IF HELPFUL.

Re: regarding database table

Former Member — Tue, 19 Jun 2007 05:13:04 GMT

hi,

To create your own database table : Go to SE11, create a table , name starting with Y/Z .

2. To make entries in the table : as a

c................

3. define technical settings for the table and activate it.

to nter multiple data items into table in a single time then we should use table maintainance generator [SM30]

Create table maintenance generator : Utilities -> Create table maintenance Generator -> goto SM30 -< give table name -> select single screen -> nter ur data -> activate -> check it in se11 or in se16.

if useful reward some points.

with regards,

suresh.