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 is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.

2068


What are the disadvantages of abap query tool?

594


What are the different types of work process?

594


What is an “on input filed” statements?

633


How do you work with semi colon se[arated files in BDC ?

1455






How do you find the information on the current screen? : abap bdc

611


Explain what are the different functions used in sap script?

550


What are pooled tables? : abap data dictionary

667


What is the difference between a dialog program and a report?

561


What are the basic functions of database utility? : abap data dictionary

603


What are the different abap editors? What is the used of different editors in abap?

572


What are the different types of the variable in the sap abap?

587


What are the screen painter and menu painter?

582


I need the coding for BDC program to upload Purchase orders of known vendor (ME21) in Material Management

1767


What is “call mode”?

582