Creating a Sap Abap Maintenance View

I am creating a new View from SE11.

Here I enter my table where I will create a maintanance view. Then I click on the Realationships button.

Here I said bring connected and reference tables.

Then I also linked Country with the text table.

Then I enter the text of the Country code in the View Fields section.

If the key part is empty, you should double click on the field, mark the key part and activate it. I will show how the keyed and keyless versions will be.

I marked the key and initial field here.

Then I delete and recreate this column, you can copy it by pressing CTRL and Y for convenience.

We are creating a maintenance table.

Bakım tablosu yaratıyoruz.

As you can see, my screen is like this.

I want to ask for the country code at the entrance and enter the city codes into it. For this reason, I entered Maintenance Flags S.

Then we open the Expert mode by pressing the Pencil key from the Table Maintanance Generator, select all of them and press the arrow key.

When we go to our table in Sm30, it now brings us a selection parameter. However, if we select 47 and do not enter Country Code Text, we see empty data. Since we have made the text field key, it is forced to select it here.

I close the Key Fields again.

I got such an error while activating.

I say Utilities > Database Object > Database Utility.

Here I said Activate and Adjust Database.

It is now activated without any problems.

Then I delete this line again and add it again and then I generate the database table again from the main database table.

Now it asks me a single country code. And I can see the city codes and texts connected to the country codes.