Skip to Content
0
Former Member
Nov 21, 2008 at 04:53 PM

Table Maintenance & View Clusters

606 Views

Hi,

I am trying to generate table maintenance views and group them using a view cluster. The following is what I have done so far.

I created 2 tables. TAB_A is the primary table with TAB_B the description by language table. They are not linked to each other in any way (even though they probably should).

TAB_A - FLD_A (key, char2)

FLD_B (date)

FLD_C (time)

FLD_D (fltp16)

TAB_B - FLD_E (key, char2, same type as FLD_A)

FLD_F (key, char3, language field)

FLD_G (char50)

FLD_H (date)

FLD_I (time)

FLD_J (fltp16)

I then created 2 maintenance views based on the tables above.

VIEW_A - FLD_A

FLD_B (hidden)

FLD_C (hidden)

FLD_D (hidden)

VIEW_B - FLD_E

FLD_F (hidden)

FLD_G

FLD_H (hidden)

FLD_I (hidden)

FLD_J (hidden)

I've then used the table maintenance generator to create the screens as well as the unique events to populate the hidden fields.

Using SE54, I've created a view cluster. I have added both of my views to the view cluster as follows:

View/table TAB_A TAB_B

Predecess. TAB_A TAB_B

Dep R R

Pos 1 2

Start true

I have clicked the field-dependence button and generated the dependencies successfully.

So far everything is okay.

I now need to change the hierarchy in the cluster, so that TAB_B is dependent on TAB_A.

What I have tried so far is to add a foriegn key to TAB_B (this worked but is not an ideal solution).

I also changed the dependency type in the cluster to 'S' (only worked in conjunction with FK)

The documentation indicates that what I am trying to do is possible, but I'm not sure how.

So do any of you bright people out there have any ideas?

Be gentle I'm new to both the forum and SAP in general (hence being given table maintenance).

Kind regards

Chris