Mohan kumar

• Sep 27th, 2005

 

  steps to create database tables

  1.go to se11

  2.give name the database table

  3.give short description for the table

  4.Give delivery class name as A and data browser / table view maint as Display/maintenence allowed 

  5.select fields tab

  6.give field name data type(user defined element type/built-in-type),short text

  7.select technical settings tab ,give  data class as appl0 and size category as 0

  7.save it

  8.go utillities menu click table contents select create and enter the field values then select display in table contents and u can view the table values with field lables 

 

 

sivanagalakshmi

• Oct 3rd, 2006

 

bottom to top approach:

_________________________

step 1:

creating a domain:

*se11,select the object type as domain ,name it ,create,description,enter the datatype and length(size),save ,activate

step2:

creating a dataelement;

se11,select the object type as :date element,name it ,create,desc,assign it with a domain what we created now,save,activate it.

step3:

creating a table;

se11,select the object type as table,name it, create,

enter the field name and assign it with the data element instead of assigning a datatype to it,

like this create req fields:

on behalf of this:

table maintainence:

assign the type of the table ie.,A C G L S

NEXT

maintaince:

allowed,not allowed ,allowed with restricions

______________________________________________

fields of a table:(as descripted above)

___________________________________________

techical settings:

A0

OR

A1

AND

BUFFERED OR NON-BUFFERED