Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

steps for creating table

Answer Posted / lokesh

There are two types of creating Table :
1) Top-Down Approach
2) Bottom_Up Approach
In top-Down approach, first we Create Table name in SE11
and we go further by creating Data elements and Domains

In Bottom-Up appraoch 1)first we create the Domains ,how
many fields you want in the Dbase table save and activate.
and 2) next goto sell and select Object type as DATA TYPE
give the domain name and assign the corresponding domain
to this data element ..like this we create as many as you
want.
3) Now we create the table that start with 'Z'.
set frist field as Key fields , Save the table in a package
after that Click 'Technical Setting' set the dataclass as
APPL0 and set the size catagory as 0. save and activate .

II) In Top-Down Approach :

First GOTO SE11 :
and select the Object Type as TABLES and give the
Table name that should start with 'Z' and press the create
Button.
It will goes to the Next Screen , they we give
Delivery Class [A] and select the Maintenannce Status as
Maintenance Is allowed , then save it.
Then goto FIELDS TAB there you give the fields in the
fields column and give Data element in the field type. then
give how many fields as you want .. it will ask to ask for
save ...then press 'YES' u can save it in ur package or
save it as a local object.
now it will ask for the creation of the Data element
press yes.
click on the Field label tab and enter the lengths and
descriptions
then press Definition tab and enter the domain ..and
create the domain and mention the datatype in the
datatype fields and length in no.characters fields as
press enter.
and go back to initial screen.and
Click 'Technical Setting' set the dataclass as 'APPL0'
and set the size catagory as '0'. save and activate .

Is This Answer Correct ?    17 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different methods of passing data?

1149


Hi All , Would be providing online trainings for SAP ABAP , guidance with real time experience examples , guidance in profile prepartion . Any one intrested please contact on 8978890047.

2426


How the Sy-Mandt value gets updated in the table and Is this having any foreign key relationship.

2329


Is it possible to run host command from SAP environment? How do you run?

1081


What is the bitwise operator in the sap abap?

1040


In the MM module for finding out the standard cost what is the view one has to look at?

991


What is the difference between function group and function module?

986


Polymorphism real time scenario

1452


Explain what is sequence of event triggered in report?

967


how to see the tables of 200 in client 100?

1849


What are datasets in abap?

1133


When was the sap abap being created?

1100


What are the different methods of bdc? : abap bdc

1010


What is a collect statement?

988


Hi, I have a requirement for locking the fax field in user master records. As you know user can edit the details using the System>profile>own data (SU3), it is causing some security threat to our model. What i want is users should not be able to change the fax field under communications when they get into su3.I have heard of user Exist functionality but don't know how to implement it. Can you suggest something, it will be greatly appreciated.

1890