Creating a cluster table using SE54

[Former Member]

Hi Experts,

I need to create a cluster table as per the SAP standard way,

Header( product table)

--- item table level 1

--- item table level 2

There are some validation were we need to take care in the form of events.

could you please giude me in the form of steps how to create a structure to meet this requirement and how to create a event and how to apply that event to the corresponding table.

Thanks,

Rajkumar

[Former Member]

Hi

In the Tcode SE54

1. In the initial screen of the ABAP Dictionary select object type Table, enter a table name and choose This graphic is explained in the accompanying text Create.

The field maintenance screen for the table is displayed. Table type Transparent table is set as default.

2. Make the necessary entries in the Short description and Delivery class fields on the Attributes tab page. Then define the fields of the table.

Proceed as when Structure link creating a transparent table. Save your entries.

3. Choose Extras--> Change table category.

A dialog box appears in which you have to select the table type Pooled table or Cluster table.

4. Choose This graphic is explained in the accompanying textSelect.

You return to the field maintenance screen for the table. Field Pool/cluster name is displayed on the Attributes tab page in addition to the standard fields.

5. Enter the name of the

table pool or table cluster to which you want to assign the pooled table or cluster table in field Pool/cluster name

Note that the total key length of a pooled table may not exceed the key length of the associated table pool. The key of a cluster table must correspond to the key of the associated table cluster.

6. Proceed as when creating a transparent table (see

Structure link Creating Tables). Remember that you cannot create indexes for pooled or cluster tables.

Regards

Pavan

[Former Member]

Hi pavan,

Thanks for your inputs but i am not able to understand with the information that you have given.

we are in 4.6c verison..

let me recap the requirement :

2 transparent tables already created

ztest1 & ztest2

I have to create a cluster zview_clus

with ztest1 as header & ztest2 as item.

in the object structure i am not bale to provide the tables ZTEST1 (level 1- H) and ztest2 (level 2- item)

i am getting a error message "maintanence dialog ztest 1 doesn't exist ".

Please tell me whether we need to link these tables on any other transaction.

Thanks,

Raj

[Former Member]

Hi,

I have created the view cluster in SE54 with the above requirement and it was activated.can anyone tell me how to wirte an event for any validation.

If i fill one of the field in level 1 adn click on save the table at the second level should be visible for the user to create entries.

Thanks,

raj

[Former Member]

HI

While creating the tables, sometimes we may need to update the table fields in the background

Lets take an example, if create a table with 10 fields in those 10 fields there are 2 fields which are User name and the Date, these 2 fields should update automatically when a record Inserted/Updated in the table.

For this, we need to create a table maintenance generator for that table. There in the table maintenance generator we have an option to create EVENTS.

In the table maintenance generator, Environment --> Modifications --> Events then a screen will be appear here,we need to create the Events, for updating the fields create 05(Creating a new entry) and 21(Fill hidden fields) .

In the EVENTS screen, press new Entries, there give 05 and give a name(This will become a PERFORM), then click the Editor pushbutton, this will be there at the right side of the entry, then a popup will be appear, you can create an include program, there inside of the include program write the below code

form CREATE_ENTRY.

TABLE-USERNAME = sy-uname.

TABLE-CHANGED_ON = sy-datum.

endform.

Then in the events screen enter 21 and give the form name as HIDDEN_FIELDS, then press the editor button, then in the editor

form HIDDEN_FIELDS.

TABLE-USERNAME = sy-uname.

TABLE-CHANGED_ON = sy-datum.

update TABLE.

endform.

This CREATE_ENTRY Perform will be triggered for every new entry and the HIDDEN_FIELDS fields will be triggered for every changed value in the table, so the Fields USERNAME and the CHANGED_ON fields will be updated automatically when a new record inserted into the table or an existed record changes through the table maintenance generator.

If you want any more functions, and then look at the events, you can press the F4 and look at the description of the event, then you come to know how to use and where to use.

Check this link

Regards

Pavan

[Former Member]

Hi Pavan,

Thank you very much for your inputs.

As per your reply, i understood that how to create events in the transaction SE54.

could you please help me in the requirement as mentioned below:

Created a cluster zz_clust_view

ZTEST1 (contains 7 fields like product code, 5 normal fields and one status field)

ZTEST 2 (conatins 7 fields like product code, label1 to label 7)

while creating an entry in the table ZTEST1, If the user populate the status field before save, the ztest2 maintanence screen should be popped up (as the user updated the status field- This requiemnt has to be handled in the event )and user should provide the values for the table ZTEST2 and when the user clicks on save all the values should be updated.

It would be greatfull, if you could post some example code for this..

Thanks,

Raj.