steps for creating table
Answers were Sorted based on User's Feedback
Answer / siddharth samal
GO TO SE11 THEN GIVE A NAME AND PRESS THE BUTTON CREATE AND
IT WILL TAKE TO A DIFFERENT SCREEN. GIVE THE SHORT TEXT.
GIVE A PREDIFIENED DOMAIN NAME OR IF YOU WANT TO CREATE
GIVE A NEW NAME STARTING WITH Z AND DOUBLE CLICK IT THE
AFTER THAT GIVE THE DATA ELEMENT.
ACTIVATE THE TABLE AND A PHYSICAL TABLE WOULD BE CREATED IN
THE DATABSE SERVER.
Is This Answer Correct ? | 19 Yes | 9 No |
Answer / 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 |
Answer / anjireddy bapathu
GO TO SE11 THEN GIVE A NAME with Starting "Z" letter AND PRESS THE CREATE BUTTON.
It will open new screen is " Maintain Table". then enter the short description and enter the "Delivery Class" and Go to "Fields" tab and enter the fields and click save after click "Technical settings" button and enter the "Data class" and "Size Category" click save.
If you have any modify fields in your table go to "Technical settings" and click delete button on top of left corner and click save. After go to "Utilities" and click "Table Maintenance generator". It will navigate to Generation Environment Screen and Enter the "Authorization Group", "Function Group" and "Maintenance Type" click the Paper Symbol in top left corner and go back and click save and activate table.
Is This Answer Correct ? | 2 Yes | 1 No |
What are advantages and disadvantages of logical data base
How to find out the no of implementations done for a badi
A database table contains 3 fields(Student_no,Section,Total_marks).I want retrieve top 10 students from each section.Note:(Section contains data like A,B,C.Each section contains more than 10 students).
what is the use of functions
performance tuning concepts
What is the function of a data element?
What is the use of abap data dictionary? : abap data dictionary
how top handle error in LSMW?
Tcode for create Basic ALE settings?
Hi, If anyone is interested in SAP ABAP from basics to Expert. Email me your contact details to sap.abap9@gmail.com
What is the use of PROTECT and ENDPROTECT?
which table contains the details of all Tcodes?