Wednesday, 25 June 2014

Creating Table in SAP

Creating Table in SAP

+ -
A table can be created in two ways one is top to bottom approach and another one is bottom to top approach.
1.Top to Bottom : In this approach, first table fields are defined and later domain and data element are defined.
2.Bottom to Top : In this approach, first domain and data element are defined and later table will be created .
In this example we are going to learn creating a SAP transparent table using top to bottom approach ( I suggest simplest way ).
Go to SE11 T-code, provide table name to be created ZSTUDENT_TABLE and create.
Creating a table in SAP
Provide short description, delivery class (A), Display Maintenance Allowed and select fields tab.
Creating a table in SAP
Select Fields tab, add a field STUDENT_NO, data element as ZSTUDENT_NO and check Key and Initial Value check boxes.
A table must contain at least one key field, without a key field we can not create a table.
Creating a table in SAP
Double click on data element ZSTUDENT_NO (Not yet created), a pop up will open click yes and one more information message will come press enter.
Now a pop up will come asking to create date element, click yes.
Creating a table in SAP
Provide short description, domain and label
Creating a table in SAP
Creating a table in SAP
Save, double click on domain name ZSTUDENT_NO, click on yes.
Provide short description, data type, no. characters, save and activate.
Creating a table in SAP
Similarly create remaining fields with data elements and domains as below
Creating a table in SAP
Once all fields are created click on technical settings button.
Creating a table in SAP
Provide data class and size category, save and activate.
Creating a table in SAP
You will get a warning message just click on No, table is created.
Now add entries to table.
Add entries to SAP custom table
Adding entries to SAP custom table

No comments:

Post a Comment