Creating a Table in SAP

Creating a Table in SAP

Run transaction code SE11 to create table.



Enter the desired table name. Make sure that you follow the naming convention. Name should either start with 'Z' or 'Y'.



Delivery class needs to be entered as shown in the figure below.



Select A application table master and transaction data.





Check the table maintenance box. And click on the Fields Tab.



Enter the Filed names as shown in the figure below. Matnr with data element 'MATNR'
For the 'ADDDESC' field please click on the Data element button as shown in the figure below.



Click on the technical settings button. For data class select APPL0



And For size category select 0



Select buffering not allowed for this table.



Make Material number as the Primary Key.



Activate the table.



Go back to transaction SE11 and select Utilities------> Table maintenance generator.



In the resulting screen for Authorization group select &NC&



Select the one step and standard recording routine



Now we need to create a Function group. For that we need to run transaction SE37.



Select Function group create.



Name the function group as ZMAT_ADD. Give an appropriate description.



Select Generate Objects from the drop down menu and select Create.



We need to activate the function group. To do so run transaction SE80.
Select Function group and type the Function group name.
Right click on the function group and click activate



Once this is done enter the scree number as 1 or select the available screen number by clicking the find screen number button.



Run transaction SM30



Enter the Table name.



To add entries click on New Entries.



Enter the Desired data and save the data.