Important Table Structures

Use

The pivot interface uses the following data types, which are defined in type group SOI (development class SOFFICEINTEGRATION):

Data Type SOI_NAMETYPE_ITEM

Field

Type

Description

name

C(256)

The name of a field in the data table

type

I

The type that the field should have in the pivot table. The following values are possible

  • i_oi_pivot=>rowfield:

    Each value of the field is a new row in the pivot table

  • i_oi_pivot=>columnfield:

    Each value of the field is a new column in the pivot table

  • i_oi_pivot=>datafield:

    The values of the field appear in the body of the table itself

Data Type SOI_COLTYPE_ITEM

Field

Type

Description

col

I

The position of a field in the data table

type

I

The type that the field should have in the pivot table. The following values are possible

  • i_oi_pivot=>rowfield:

    Each value of the field is a new row in the pivot table

  • i_oi_pivot=>columnfield:

    Each value of the field is a new column in the pivot table

  • i_oi_pivot=>datafield:

    The values of the field appear in the body of the table itself