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.

Provide short description, delivery class (A), Display Maintenance Allowed and select fields tab.

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.
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.

Provide short description, domain and label


Save, double click on domain name ZSTUDENT_NO, click on yes.
Provide short description, data type, no. characters, save and activate.

Similarly create remaining fields with data elements and domains as below

Once all fields are created click on technical settings button.

Provide data class and size category, save and activate.

You will get a warning message just click on No, table is created.
Now add entries to table.


No comments:
Post a Comment