Skip to Content

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.

Table Relationships

And this is the result we are shooting for…

     

Tables (SE11)

First create the 3 database tables with the fields below. Italics are keys. Easy.
1.    ZHDR
  a.    MANDT    MANDT
  b.    VBELN    VBELN

  c.    AUART    AUART
  d.    ERNAM    ERNAM
  e.    ERDAT    ERDAT
2.    ZLIN
  a.    MANDT    MANDT
  b.    VBELN    VBELN
  c.    POSNR    POSNR

  d.    MATNR    MATNR
3.    ZSCH
  a.    MANDT    MANDT
  b.    VBELN    VBELN
  c.    POSNR    POSNR
  d.    ETENR    ETENR

  e.    EDATU    EDATU
  f.    WMENG    WMENG
  g.    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
  a.    MANDT    MANDT
  b.    VBELN    VBELN

  c.    AUART    AUART
  d.    ERNAM    ERNAM
  e.    ERDAT    ERDAT
2.    ZLIN_V
  a.    MANDT    MANDT
  b.    VBELN    VBELN (S)
  c.    POSNR    POSNR

  d.    MATNR    MATNR
3.    ZSCH_V
  a.    MANDT    MANDT
  b.    VBELN    VBELN (S)
  c.    POSNR    POSNR (S)

  d.    ETENR    ETENR
  e.    EDATU    EDATU
  f.    WMENG    WMENG
  g.    VRKME    VRKME

Generate Table Maintenance for Views (SE11)

Now take each of the views and generate your table maintenance as per normal. Easy.
1.    ZHDR_V
2.    ZLIN_V
3.    ZSCH_V

Create View Cluster (SE54)

Now comes the good part. It’s time to create the View Cluster.
•    Transaction SE54
•    Click “Edit View Cluster” Button
•    Create your cluster. Mine is called ZKEVIN

•    Double click “Object Structure”
•    Enter View / Table, Short Text and Predecess., Dep, Pos, Start
  o    R = Header
  o    S = Allowed 1 entry per header

•    Select the first header View line and double click “Field Dependence”
•    Enter View / Table and Predecessor as the Header View and leave the field blank

•    Click Back
•    Select the 2nd line View line and double click “Field Dependence”
•    Enter View / Table and as the Line View and the Predecessor as the Header View.
  o    Complete for both Line View Key fields MANDT and VBELN

•    Click Back
•    Select the 3rd schedule View line and double click “Field Dependence”
•    Enter View / Table and as the Schedule View and the Predecessor as the Line View.
  o    Complete for all 3 Schedule View Key fields MANDT, VBELN and POSNR

•    Save
•    Click Back, Back
•    Click Activate
•    Click Back and Test

That wasn’t too bad. Now your users can easily update your custom customizing tables.

To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

  1. Gregory Misiorek
    beats the simplistic SM30 and Z table direct update and preserves the relations structure between the tables. i’m bagging it into my virtual toolbox (sunt herewith).
    (0) 
  2. Alessandro Guarneri
    I always heard of these view cluster “monsters” but always avoided them (read-only and don’t touch them approach)… 🙂
    Now that I need to build one it’s really good to see that somebody out there took some time to blog it.
    Thanks for this.

    Cheers

    Alex

    (0) 
  3. Shyam Alaparthy
    Nice job. This really is a very good docuemnt which gives a clear idea for guy’s like me – who know what the view culster is but never tried to implement it because of lack of such deatils.

    – Shyam

    (0) 
  4. Kumud Singh
    This is wonderful for beginning work on View Clusters. I had one of the toughest time while developing one of similar kind few months ago.I think the major challenge lies when we have to code to handle errors, calculations,changing contents of tables like extract, total etc.

    Just a quick note: Here there is no mention of cardinality factor on views? Isn’t that required?
    Thanks. Kumud.

    (0) 

Leave a Reply