How to Create a table in SAP?
In this blog, we will learn how to create tables in SAP. So let’s explore! Tables are used to store data in SAP environment.
So Let’s get started!
- Enter transaction SE11 t-code in the SAP screen and press Enter.
2. You will get the resulted screen. Enter the table name you need to create. Custom Table names should begin with Y or Z only.
3. Click on Create button. You will get below window. Give the short description and delivery class as A.
Delivery class is used to control the transport of the data. Delivery class ‘A’ means the table can be maintained in any system(delivery, quality and production systems).
SE16 tcode is used to view the contents of the table and SM30/SM31 is used to edit/modify/update/change/maintain the table.
There are three options in table view editing :
Display/Maintenance allowed with restrictions — Here display of the table contents is possible but no maintenance is allowed.
Display/Maintenance Allowed — Here display of the table contents as well as maintenance of table/view is allowed.
Display/Maintenance Not Allowed — Here display of the table contents as well as maintenance is not allowed.
4. Click on Save button and save it in your existing package.
5. Add fields into the table. First add MANDT field and make it as primary key and furthermore add the MANDT as a data element. Press Enter.
MANDT is a client field. If we have MANDT field in the table then the table is client dependent and if we don’t have that field that means table is client independent.
Client dependent means if we create table in one client it will be accessible only in that client and it is not accessible in other clients. Client independent means if we create table in one client it will be accessible in that client and other client also.
MANDT is a standard data element which is already created by SAP. Hence, we are reusing it here.
6. Double click on MANDT element. Below window will get open. Here we can see MANDT is a data element and it is already created. Here we can see that MANDT domain is already created by SAP.
7.Creating a data element.
Add Field name as House_id and Data element name as ZDT_HOUSE_ID.
Double click on ZDT_HOUSE_ID data element. The below window will appear. Click on yes and save it in your package. After giving the package name and saving it, it will ask to create a data element. Click on Yes.
8. Double click on ZDT_HOUSE_ID data element. It will show you below window. Click on yes and save it in your package.
9. Give the short description and In Elementary Type, we can specify type by creating domain or using built-in type. Here I am using built-in type. There’s a input list of data types which we can use it.
10. I am using CHAR type here and specifying the length of the value as 10 which we can store in HOUSE_ID field.
11. Click on Field Label tab. It is used to display heading for that particular field in the report.
12. Save it in your package and activate it.
13. Go back. Click on technical settings.
14. Below window will appear and click on Yes.
15. Select Data Class category as APPL0 means transparent table contains master data which is accessed frequently and changed rarely.
Select size category as 0 which determines the initial space required for the table in a database.
Save it and Go back.
16. Click on Extras and select Enhancement category.
17. Select the can be enhanced radiobutton and then click on copy.
18. Save and activate the table.
This is how a table is created.
In the next blog we will check how domains and data elements are created.