You can import single-dimension CO hierarchies as SAP ECC source definitions. Single-dimension hierarchies have one associated detail table. After you import a hierarchy definition, you can also import the detail table definition and establish a key relationship between the two definitions.

When you import hierarchy definitions, the Designer displays all available business names followed by the SetID in the Import SAP Metadata dialog box. If a business name does not exist, the Designer displays the SetID. You can enter filter criterion for business names only.

After you import a hierarchy definition, the Designer creates the following columns:

For example, you import a uniform hierarchy with a root node, a level 1 node, level 2 node, and leaf nodes. The Designer creates the following columns from the hierarchy structure:

In this example, R300R3000_FLD is the root node. R300R3000_FLD_SetId is the root node SetID. Level 1 and Level 2 are higher nodes. FROM_VALUE and TO_VALUE are leaf nodes.

When you import a hierarchy, the Designer creates all columns with a CHAR datatype. The Designer imports all hierarchy definitions with a precision of 50 for the root and higher nodes, and a precision of 30 for the detail range and the SetIDs.

The Designer also imports the following metadata: