Display Objects in Tree Structure (VBA Tree)

OBJ_SEL_IN_EXCEL

* from Allevo version 3.0 (only available up to Allevo Master 3.5)

Important: the VBA Tree functions are no longer supported from Allevo Master 3.5.

Allevo now offers the Inplace Panel on the side of SAP as an alternative and including extended features. Here, an object hierarchy is i.a. displayed in the ALV tree. See constant OBJ_SEL_IN_PANEL or documentation in the Allevo SAP manual (both constants may not be active simultaneously).

However, you may also call an Allevo Master from previous versions with VBA Tree under reduced compatibility; the constant documentation is therefore still available here.

------------------------------------------------------------------------------------------------------------------------------

Allevo allows for selection of planning objects on the side of Excel by displaying a tree structure containing relevant objects (e.g. cost centers or groups). Constant OBJ_SEL_IN_EXCEL ensures that relevant objects are transferred to Excel in a list, which will then be available for selection in the tree.

This tree display is possible for planning features (Single and MO) as well as in Allevo Reporting: to use it in MO mode, observe the constant MULTI_WITH_GROUPS.

Activate the constant by X in column Value from. Once the constant is active, the Allevo start screen will be extended by a group and multiple selection for objects for Single and MO (for MultiPage application see notes below).

Object selection via the tree contains all elements resulting from a group or multiple selection in SAP. In the standard case, groups assigned to a planning object will not be resolved (via Allevo 1:N function), since this function implies summing up values from subordinate levels anyway. You may change this behavior by an entry in column Value to. The following entries are available:

· X : the complete structure below a 1:N group will be transferred as well

· G : below the 1:N group, only gropus will be transferred (no single values)

· Number between 1 and 9: below 1:N group, all entries will be transferred up to the entered level, no matter if group or single value (so, for 1 the group and single values of the first level, for 2 the next level and so on).

Transfer to Excel is performed no matter if the Allevo planning status is set; for the display in Excel, however, the user may distinguish by a colored selection (green or grey). If an object is called without planning status or authorization, the Allevo Master automatically switches to the Reporting mode.  It is then no longer possible to adopt plan data. Furthermore, no data will be displayed in case that reading authorization is missing.

When switching between objects, the Allevo VBA program code automatically checks if entries have been made in the meantime and displays a warning on unsaved data if necessary (check is performed on the basis of style sheet KERNWRITE).

Note:

Selection via Tree is available in ABC and in the Inplace application (here only in 32 bit version of Excel). To use the tree in Inplace applications, a macro for the tree display must be active in the section “Custom Button“ of the Allevo Master. Corresponding parameters: - SheetName : Name of the Allevo planning sheet (e.g. “Allevo“). - Icon :             “SmartArtOrganizationChartRightHanging” - MacroName:   “ShowTreeview” - Caption:         Name in the ribbon, e.g. “Treeview” These specifications serve to find an additional icon in the Allevo ribbon. When calling the Allevo planning screen, the tree is immediately displayed and may be called again via the ribbon icon at any time. You may adjust texts on the tree interface, e.g. titles and texts of buttons (to be entered in table ZZCustomizingFormsBase).

If the tree display is active, reference should of course only be transferred to Excel after explicit selection of an object in Excel by the user. Constant READ_ON_OPEN should therefore NOT be active, as otherwise the first object or the first group will automatically be read.

Note:

Whenever constant OBJ_SEL_IN_EXCEL is active, the corresponding data will be transferred to the Excel working sheet as CustomXMLPart (e.g. concerning the hierarchy of a group). This information may be used via the tree (as described above). Alternatively, also a customized logic may be stored on the side of Excel to, for example, support the selection of a sheet in MultiPage mode or create additional sheets with information on group level. may be stored.