How to create maintenance generator?

In this tutorial, I will discuss how to create a Maintenance Generator which is an add-on in creating tables. This is important to do if your user asked you that they will maintain that particular table.So the following steps will be undertaken.

Steps:
1. Go to SE11 and open your table. Go to the main menu Utilities-->Table Maintenance Generator


2. This screen below appears. Fill up the following fields:
Authorization group = &NC& (w/o auth group). If your team created an authorization grou, ask them and type it here. But if none, then this option would suffice.

Function Group = name of your function group. If none yet, click here to create your own.

Then select One step maintenance type and input 100 as the screen no.You can also select the button Find Scr  Numbers in the toolbar.Then click the create button on the toolbar. Finally Save it and go back to your table.


3. In the previous step, the maintenance generator is now created and your table is now ready to accept records. So in this step, you will add new records now to your table. Go to tcode SM30 and enter the name of your table like this one below.Then hit the display button.


4. In this screen, click on the button "New Entries" to enter new records and the ALV grid becomes editable.


Enter your records accordingly. Then save afterwards.


5. In order to view if your records are added into your table, go back to SE11 or SE16 and type the name of your table. Finally display the contents. It looks like something like this one.


Happy happy reading.. Enjoy...

How to create standard table?

When I was starting ABAP years ago, I was puzzled how to create tables for storing data. Unlike in my previous programming experiences, I used MySQL for my web developments and MSSQL for my windows application programs. These databases are easily to use in creating tables.Though I have experiences on other databases, I am still baffled how to create tables in SAP (that was years back).

So in this tutorial, I will discuss in my simplest way how to create your first standard table in SAP. I listed the following steps-by-steps.

STEPS:
1.Run tcode SE11 in your command bar. Then type the name of your table. Be sure to start with Z or Y when creating the name of your table. Then hit the create button.
 

 2.In this screen below, fill up the short text for your table. Give a meaningful description. On the delivery class, select "A" for application table. And for the data browser, select "Display/maintenance allowed" option.


3.Next step is click on the "Fields" tab. In this tab, enter all the fields that you needed. As seen in my sample below, I entered four fields. Please take note to add the field MANDT as this is the field that determines if the table becomes a client dependent. In short, this table is only visible to that client. Unlike if this field is not added, the table is visible or accessible to any client.


4.Click the button "Technical Setting" on the toolbar. This screen below appears after. On the data class parameter, select APPL0 for master data. And for the size category, I just choose 0 which is the least among the selection. So in your table creation, the size depends on you. If you think your table needs more space then select 1 or 2 or 3 etc. Afterwhich, click the save button above.


5.For the next step, on the main menu, click Extras->Enhancement Category.

This screen below appears after. Select the second option which you can enhance the table after.


6. Congratulations and your done creating your first table. Activate your table and save it as local object. Please note that no error and warnings must be prompt as you activate your table. If persists, try to solve these issues then activate again.



7. In order to view your table contents, click this button on the toolbar.


And there you are, you will see now this screen, where you can now display the contents of your table. But right now, since this is newly created, no records were stores in your table yet.


Thanks again for reading. Enjoy...