Advertisement

Wednesday, April 22, 2015

Creating a Cluster View

Overview

We have 3 tables related to each other as shown below. We want to be able to maintain the table in a hierarchical manner. i.e. We create 1 entry in the header table, then we select that entry and create multiple lines underneath the header, then we select one of the lines and add multiple schedules under that…
This way of creating cluster view maintenance screens is very powerful and allows your users to maintain tables with complex relationships rather easily.

Tables Relationships

The following is a depiction of the data model for our example.

And this is the result we are shooting for…

Tables (SE11)

First create the 3 database tables with the fields below. Easy.
1) ZHDR

MANDT -> MANDT

VBELN -> VBELN

AUART -> AUART

ERNAM -> ERNAM

ERDAT -> ERDAT

2) ZLIN

MANDT -> MANDT

VBELN -> VBELN

POSNR -> POSNR

MATNR -> MATNR

3) ZSCH

MANDT -> MANDT

VBELN -> VBELN

POSNR -> POSNR

ETENR -> ETENR

EDATU -> EDATU

WMENG -> WMENG

VRKME -> VRKME

Maintenance Views (SE11)

Next up is creating the Maintenance View for each of the tables. Make sure to put the Maintenance Attribute = S in the fields which you need to have carried over to the next screen. E.g. On the header you select order 100000 and you click the lines. You see 100000 on the lines page as read only (see below). To do this the field VBELN must have an S as it’s maintenance attribute in the Line View.

(S) = Maintenance attribute
1) ZHDR_V

MANDT -> MANDT

VBELN -> VBELN

AUART -> AUART

ERNAM -> ERNAM

ERDAT -> ERDAT

2) ZLIN_V

MANDT -> MANDT

VBELN -> VBELN (S)

POSNR -> POSNR

MATNR -> MATNR

3) ZSCH_V

MANDT -> MANDT

VBELN -> VBELN (S)

POSNR -> POSNR (S)

ETENR -> ETENR

EDATU -> EDATU

WMENG -> WMENG

VRKME -> VRKME

Generate Table Maintenance for Views (SE11)

Now take each of the views and generate your table maintenance as per normal. Easy.