headershadow

Creating your own maintenance view and link it to SPRO Customizing – Part 1

Print Friendly

Some special requirements need the creation of specific customizing points, in order to maintain specific tables via SPRO customizing.

Usually, it is also expected to create a customizing point with a special layout, similar to the ones found in standard, i.e. a customizing point with a list screen and a details screen.

The same concept can be found in standard SPRO customizing. An example is the transaction OMR6, which allows defining tolerance limits for invoice block in MM.

You can access this transaction in SPRO using the following path:

If you execute the transaction, a first screen appears presenting a list of companies and associated tolerance limit keys.

Select now the first entry and click on the detail button

A second detail screen appears, allowing the user to enter the tolerance limits.

We will see now how to implement a similar specific customizing point having a list screen and details screen, and use it to maintain specific tables.

To achieve this job, you have to go through 3 Steps.

  • Step 1: Creation of DDIC Objects In this step, specific tables are created, foreign key relationships are defined between them and finally a maintenance view for these tables is created.
  • Step 2: Modification of Maintenance dialog screens
    In this step, the screens of the view maintenance dialog are modified in order to obtain a list screen and a details screen having the required layout.
  • Step 3: SPRO Customizing extension with the new specific customizing point
    In this third step, a customizing point is added to SPRO which points to the previously created maintenance view.

I will explain the “Step1” in this first part of the blog post and let you check the next steps in parts 2 and 3.

I will just take the example of defining tolerance limits (as do the standard customizing) to explain each step but you can apply the same method for any requirement you have.

  • Create specific tables
    In the next example, we create a table for tolerance limit keys (similar to table T169E), a table for their descriptions (similar to table T169T) and a table for tolerance limits (similar to table T169G)
    (Junior consultants can refer to the blog of Lipin “Table Creation: Minor mistake but Major Problem - Part 1”for more details about table creation.)

    • In SE11, create specific table ZTMM_T169E (Tolerance limit keys)

    • In SE11, create specific table ZTMM_T169T (Tolerance limit keys descriptions)

    • Go to tab “Entry help/check” and add foreign key relations to table ZTMM_T169E using check tables, by selecting field TOLSL and using button
    • Since ZTMM_T169T contains keys descriptions, it has to be defined as text table for ZTMM_T169E. For this purpose, select “Key fields of a text table” under “Foreign key field type” in order to indicate that it is a text key and set the cardinality to 1:CN.

    • Add foreign keys relationships for fields SPRAS (Table T002) and BUKRS (Table T001) using check tables (Again select the field and click on button
    • You should get the following result

    • Activate table ZTMM_T169T then go to table ZTMM_T169E to check text table definition. Choose “GOTO-> Text table”. It should point to table ZTMM_T169T.
    • In SE11, create table ZTMM_T169G (Tolerance limits)

    • Add foreign keys relationships by selecting the field and using the button to enter the check table name. Add check table ZTMM_T169E for field TOLSL and T001 for field BUKRS.

    • You should get the following result

  • Create a maintenance view with a join of the three previously created tables and T001
    • In SE11, enter the view name ZVMM_169 and click on “Create” button.
      Choose the view type “Maintenance View”

    • We will use the foreign keys relationships created previously to define the join conditions of the view.
      In “Tables/Join conditions” tab, add table ZTMM_T169G then click on “Relationships” button to add the next tables via foreign keys relationships.
    • Select referenced tables T001 and ZTMM_T169E

    • The join conditions are then generated automatically

    • Select table ZTMM_T169E and click on “Relationships”. Choose table ZTMM_T169T and confirm.

    • Again the join conditions are generated automatically

    • Add the view fields (In this example, I added the same fields as the maintenance view V_169G)

    • We now have to create a maintenance dialog for this view. Go to “Utilities->Table maintenance generator” and generate a maintenance dialog with two screens for the view using the “create” button. The generated maintenance dialog looks as follows.

Regards

Imen

The SAP University Team


More about

2 thoughts on “Creating your own maintenance view and link it to SPRO Customizing – Part 1

Leave a Reply


*