Welcome to SAP Central
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Creating table in SAP Step by step process

Go down

Creating table in SAP Step by step process Empty Creating table in SAP Step by step process

Post  Admin Sat Mar 24, 2012 1:04 pm

Execute/open the transaction SE11.

Select the radio button Database table and Provide the table name as shown below starting with 'Y' or 'Z'.

Creating table in SAP Step by step process Tab_1

Click on Create button and provide the following details.

Creating table in SAP Step by step process Tab_2

Provide the table fields as shown below. You can create the table with the pre-defined data types or you can use data elements provided by SAP. You can switch between Predefined/data elements using the button "predefined/ data element" on top.


Creating table in SAP Step by step process Tab_3

Click on SAVE and save the table as local object.


Creating table in SAP Step by step process Tab_4

Then, click on Technical settings button on top(Right corner) and provide the following data as shown below.



Creating table in SAP Step by step process Tab_5

Click on SAVE and go back to the previous screen.

Clcik on Check button(cntrl+F2) ignore the warning messages click on Activate(Cntrl+F3)

Now the table successfully created. Click on Create entries path as shown below.


Creating table in SAP Step by step process Tab_6

The following screen will appear Provide the data that you want to store in the table

Creating table in SAP Step by step process Tab_7

click on SAVE

Creating table in SAP Step by step process Tab_8

click on SAVE

To display the table contents Click on display path as shown below.


Creating table in SAP Step by step process Tab_6


The following screen will appear. You can display records base on condition like empid = 1. Click on F8/execute button to display all entries



Creating table in SAP Step by step process Tab_9

Table records will display as shown below.


Creating table in SAP Step by step process Tab_10

You can create new entries or update existing entries or you can delete the entries using the below path


Select one record click on your option.

Creating table in SAP Step by step process Tab_11

Admin
Admin

Posts : 92
Join date : 2012-01-26

https://mysaplab.forumotion.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum