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 |
Define abap/4 layer? : abap data dictionary
Select query optimisation
What is the difference b/w BAPI and Function module
what is the difference between se16 and se17 ??? need urgent ans plz..
What is an abap instance?
Function Module to upload the Excel sheet into SAP Internal Tables. * a) GUI_UPLOAD b) CL_GUI_FRONTEND_SERVICES=>GET_UPLOAD_DOWNLOAD_PATH c) CL_GUI_FRONTEND_SERVICES=>GUI_UPLOAD d) All the above
Hi i am surya, i have faced this questions plz give me the answer. I have requirement like this, i have two internal tbale like itab and itab1 in itab i have 50 records, in itab1 100 records are there. When execute this question what will be the output a]50 b]100 c]150? And how to join two internal tables what is the syntax for that?
12 Answers Satyam, TCS, Wipro,
What are the components of SAP scripts?
What are the modes in which any update tasks work?
22) Very important How to find user Exit for a standard SAP Object(field,screen,menu etc)?
What is append structure?
What is the relationship existing between the various data elements in data dictionary? : abap data dictionary