Getting Started

Customizing the Heterogeneous Structure Explosion

Add New Use Case

Select System > Structure Browser > Heterogeneous Structures.
The Heterogeneous Structures mask is opened.

Further information on the Heterogeneous Structures mask can be found in the document Heterogeneous Structure Explosion.

Insert a new record in this form.

The existing record can be used as template.

The heterogeneous structure explosion is stored in a temporary table for which an additional view has to be defined. It is recommended to use the prefix T_TMP_ASE_ for the table and the prefix V_ASE_HIE_ for the view. Finally, the used stored procedure with its parameters have to be defined (usually, these values do not need to be changed). In the delivered templates, two different stored procedures are provided:

Select View Configuration from the context menu.
The Entity Data mask is opened. Here, the data dictionary can be defined for the view.


The first 11 fields are necessary for all use cases.

Field Name Description
V_ASE_HIE_002.OPERATIONID OPERATIONID
V_ASE_HIE_002.STRLEVEL Hierarchiy level
V_ASE_HIE_002.ID_FROM C_ID of parent record
V_ASE_HIE_002.ID_FROM_TYPE Name of parent table
V_ASE_HIE_002.ID_TO C_ID of child record
V_ASE_HIE_002.ID_TO_TYPE Name of child table
V_ASE_HIE_002.STRID C_ID of structure record
V_ASE_HIE_002.SORT_NR Name of structure table
V_ASE_HIE_002.PECURSION Sorting number
V_ASE_HIE_002.REL_UP Flas to indicate beginning recursion
V_ASE_HIE_002. View to parent record

 

If the stored procedure EDB_ASE.explode_proe is used, the field POS_NO is mandatory, too.

Additionally, any number of fields can be defined. Usually, the first field is named ASE_ID and the ID fileds of the original records (e.g. T_DOC_DAT.DOCUMENT.ID, T_MASTER_DAT.PART_ID) are mapped this field.

When all fields are defined, click Create List and close the Entity Data mask.
The default list is created.

In the Heterogeneous Structures mask select Create Table/View from the context menu.

Adapt the default list in the Form Data mask.

  1. Add the Post-Mask-Userexit xase_hie_pom to clean-up the temporary table.
  2. Add the Edit-Action-Userexit cch_nop_ins.
  3. Add the Pre-Action-Userexit LIST_A cch_nop_del & xase_pre_act
    cch_nop_del: deletion of records can be avoided
    xase_pre_act: filters entries of the temporary table using the OPERATIONID
  4. If the background color of a record should be set to red when a recursion occurs, add the Post-Action-Userexit EDB_MULTILEVEL/RECURSION.
  5. Replace the Button... and Menu... entries and adapt the form size values.

Reorganize the mask fields in the Field Assignment tab.

  1. Set all system fields to invisible in the Access column. Except for ID_TO_TYPE, STRLEVEL, and RECURSION.
  2. Set all other fields to 'r'ead in the Access column.
  3. Move STRLEVEL and RECURSION to the end of the list.
  4. Move ID_TO_TYPE, which contains the table name of the child record, to the position where the icon should be displayed (a stylesheet definition is necessary to display the icon).
  5. Set the order for SORT_NR to 1 in the Order column. Set all other field names to 0.
  6. For ASE_ID select the appearance Tree Renderer in the Appearance column.
  7. For STRLEVEL select the appearance Tree Structure in the Appearance column.
  8. Add the calculated field ROW_STYLE_DEFINITION at the end of the list and set the width to 0 in the Width column, and the virtual width to 100 in the Wid/vir column. Set it to read in the Access column if row specific styles should be activated (see style sheet definition).
  9. Reconfigure and close the Form Data mask.

On the Heterogeneous Structures mask select Browser Entries from the context menu.
The Browser Configuration mask is opened.

Ever entry has to have the ASE checkbox selected. Mandatory fields for every use case are: Name, Title, Description, and the ASE checkbox.

Define the entity of the top level element and all (refine or aggregate) relations in the Structure tab.


Define the following userexit parameter and its Name:
The following userexits are possible:

For Userexit Parameter Name
Entity or Entity list entity - widget name ASE-NULL
Types entity - type - widget name ASE-NULL
Relations entity1 - entity2 - view - widget name Value of the child entity of the relation
Values for the context menu can also be added here

For Type definitions (e.g. ASE-EDB-DOCUMENT) define which field to be used to distinguish the different types.

Define the field mapping. From the Heterogeneous Structures mask select Field Mapping from the context menu.
The Fields mask is opened. All fields that have been defined for this use case are listed here.

Select the first entry and select Assigned Fields from the context menu.
The Field Mapping mask is opened.

Select the fields to map to the selected one.

Repeat step 13 and 14 for all field entries.

To get an overview of all mapped fields, click on the button of the Hetereogeneous Structures mask. An additional tab is opened in the browser window.

To test the heterogeneous structure explosion with the Java Client, insert the selection EDB-ASE-SHW-HIE-{J} with its parameter /USE=<your_use_case> to the structure explosion menu of your entity list, or add the selection EDB-BOM-ASE-SHW-{J} to the non-select menu. The heterogeneous structure explosion tab should be added to your entity.

Add New Fields to the Heterogeneous Structure Explosion Tab

For example:

Show check name and level indicator of the relation records in the heterogeneous structure explosion list.

Select System > Structure Browser > Heterogeneous Structures.
The Heterogeneous Structures mask is opened.

Search for MULTILEVEL-EDB-PROJECT.

Click on the hyperlink V_ASE_HIE_001 in the View field.
The Entity Data mask is opened.

In the Table Fields tab enter two new entries:

In the Heterogeneous Structures form select Create Table and View from the context menu.

In the Heterogeneous Structures form select Field Mapping from the context menu.

Assign field T_MASTER_STR.CHK_NAME and T_MASTER_DOC.CHK_NAME to field V_ASE_HIE_001.CHK_NAME_STR.

Assign field T_MASTER_STR.LEV_IND and T_MASTER_DOC.LEV_IND to field V_ASE_HIE_001.CHK_NAME_STR.

Add the two new fields to the structure explosion list EDB-ASE-HIE-001-SLI.

The two new fields should be added to the Heterogeneous Structure Explosion tab of the Project mask.