Create
DescriptionCreating or changing an order group. All the groups from the HierarchyNodes table are created in the system. Any existing groups are overwritten. Information about the nodes of a hierarchy is transferred to the table HierarchyNodes
. This table contains the group names and the description for each node in the hierarchy. The hierarchy structure isportrayed via the order of the nodes in the table and the level of the node in the HIERLEVEL field. If values or value intervals are assigned to a node, then the entry in the VALCOUNT
field shows the number of assigned values or value intervals. These are transfered to the HierarchyValues table in the order in which these appear in the hierarchy. ExampleThe group 'GROUP1' has the following structure:
GROUP1 | |---- GROUP11 | | | |---- GROUP111 | | | |---- VALUE1 | |---- GROUP12 | |---- VALUE2 |---- VALUE3 - VALUE9
The HierarchyNodes table thus contains the following entries: GROUPNAME HIERLEVEL VALCOUNT GROUP1 0 0 GROUP11 1 0 GROUP111 2 1 GROUP12 1 2
Only the nodes GROUP111 and GROUP12 contain values or intervals, the HierarchyValues table therefore contains the following entries: VALFROM VALTO VALUE1 VALUE1 VALUE2 VALUE2 VALUE3 VALUE9
Groups can contain either values or other groups, i.e. only the end nodes of the hierarchy contain values. If the optional parameter TopNodeOnly is set to 'X', only thefirst node in the hierarchy table can be created or changed. In this case the table HierarchyNodes
, in addition to these nodes, may only contain level 1 nodes. These nodes must already exist in thesystem, here they are merely attached to the first node. In this way,for example, an existing large hierarchy can be extended by attaching anew sub-tree without the hierarchy having to be completely recreated.
If an error occurs when you create a group, the error message is issued in the parameter Return. NotesYou need the authorization for the object K_AUFK_SET.
|