Always start the name with z or y.
Type the table name u want to create and press f5 for create. [ f6 is for change and f7 is for display].
Give a short descriptions of the table.
Select a delivery class. [Mostly it will be a or c. where a is application table for master or transaction data or c for customizing table].
Then give table maintenance [ give either table maintenace with restriction or no restrictions or no maintenance].
Then go to the field tab.
Always the first field is mandt, data elemnt is also mandt.
Then give afield name and give an existing data element name and press enter. If the data element is correct then the details about the element will appear immediately.
u need to mark the mandt and the one other field as key field.
save then execute.
In the top there will be a button for technical settings.
U need to select the data class , u press f4 it will give u options such as master data, transaction data, etc
U need to select the size category, telling it how many record they r likely to have. u press f4, it will give u details.
U need to select an option for buffering. Buffering means the copy of the table gets stored in the RAM for easy access.
buffering is allowed for tables which are standard in nature and which do not gets updated / change often.
the file will also be smaller.
buffering is not allowed for transaction tables as they gets updated very often.
the file will also be bigger.
In the top there will be another button for Index.
From the right 3rd button there will be an icon for creating an index.
click on that and click create.
it will ask for index name. Index name should start with z and usually has 3 character like zsc or z001.
Then give a short descrption of the field.
There are 2 types of index.
First is unique index.The uniqueness of the value combinations for the index fields is checked automatically by the database system. If there is a violation (for example in an INSERT operation) an error message (DUPLICATE RECORD) is given. The database system thus prevents you from inserting duplicate records for the index fields of a unique index. This function requires that you always create a unique index in the database.
It is of no importance for the accessing speed whether or not an index is defined as a unique index
Second it is Nonunique index. It does not matter to sap whether is a duplication of record or not.
Now when u come down there is a Table fields .push button . When u select that then u will be able to select the field from the table which u refer in the index.
Then save and activate.
Type the table name u want to create and press f5 for create. [ f6 is for change and f7 is for display].
Give a short descriptions of the table.
Select a delivery class. [Mostly it will be a or c. where a is application table for master or transaction data or c for customizing table].
Then give table maintenance [ give either table maintenace with restriction or no restrictions or no maintenance].
Then go to the field tab.
Always the first field is mandt, data elemnt is also mandt.
Then give afield name and give an existing data element name and press enter. If the data element is correct then the details about the element will appear immediately.
u need to mark the mandt and the one other field as key field.
save then execute.
In the top there will be a button for technical settings.
U need to select the data class , u press f4 it will give u options such as master data, transaction data, etc
U need to select the size category, telling it how many record they r likely to have. u press f4, it will give u details.
U need to select an option for buffering. Buffering means the copy of the table gets stored in the RAM for easy access.
buffering is allowed for tables which are standard in nature and which do not gets updated / change often.
the file will also be smaller.
buffering is not allowed for transaction tables as they gets updated very often.
the file will also be bigger.
In the top there will be another button for Index.
From the right 3rd button there will be an icon for creating an index.
click on that and click create.
it will ask for index name. Index name should start with z and usually has 3 character like zsc or z001.
Then give a short descrption of the field.
There are 2 types of index.
First is unique index.The uniqueness of the value combinations for the index fields is checked automatically by the database system. If there is a violation (for example in an INSERT operation) an error message (DUPLICATE RECORD) is given. The database system thus prevents you from inserting duplicate records for the index fields of a unique index. This function requires that you always create a unique index in the database.
It is of no importance for the accessing speed whether or not an index is defined as a unique index
Second it is Nonunique index. It does not matter to sap whether is a duplication of record or not.
Now when u come down there is a Table fields .push button . When u select that then u will be able to select the field from the table which u refer in the index.
Then save and activate.
