Important Table Structures 

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

This data type also has a corresponding internal table type called SOI_NAMETYPE_TABLE .

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

This data type also has a corresponding internal table type called SOI_COLTYPE_TABLE .